I have 145,000,000 rows in my wp_postmeta table. I know a great deal of these are orphaned, and I would like to clean them out.
I ran the usual SQL query, but it keeps timing out on me - I'm assuming due to the sheer volume of the table.
Is there a way to process these in batches? Any way to clean this table out?
14 freelanceri licitează în medie 45$ pentru acest proiect
Hello, As an expert in SQL, I can delete the orphaned records from the table. Looking forward to have a positive response from you. Thanks
Can I get access to the table and phpmyadmin? Can you share the query which is timingout? I will try my best to do it ASAP
Hi! Orphaned how - posts no longer existing or plugins/theme no longer existing? For the latter there's no easy way of doing this. What do you call "the usual SQL", please provide the SQL statmenets, to make sure yo Mai multe
I can implement required data processing in a most qualitative way because I am highly qualified database developer with more than 10 years length of time professionally worked in database design and implementation.
Hello Client, I can clean the specified no. of rows from table wp_postmeta table as per your requirement. I can start work now. Thanks! Satyajeet
Hello i am expertise in sql server and sql queries ping me for more information. yes it would be possible with batches. i have a solution to do this. ifyou are interested please let me know
Hello there, honestly to clean the orphaned data is the kind of cleaning data and stardardization. Within MySQL there's timeout configuration we can set it up but cleansing all the data orphaned from 145M rows is not a Mai multe
Hello, I’m senior DBA , working for large international bank. Freelancer is just my part time so I can work on other interesting projects, time to time. Based on your project description, I know where the problem i Mai multe
Greetings!. I checked your Database Design requirements. Your work is one of the tasks that can be done very perfectly by us. I am good in MySQL , MS ACCESS, MS SQL, Oracle , No SQL and other DBMS software, Queries, Mai multe
Hey there! Have you tried deleting a smaller number of them? That can probably work unless there's something off with the server settings. Lets talk
Hello Sir. I'v just read your job description carefully and understood requirement exactly. I'm working in Back-End field for 6 years, especially DB management&DB programming. so I've made good success and many good fr Mai multe
I deal with such big table on daily basis, so can help you here, please share the details and we can work on it to clean out those records
I have more than 13 years of experience on this SQL server development and administration, it will easy for me to take up this task.