Hey there. I have a Wordpres website and imported about 30.000 listings with WP All Import plugin. Listings only contain text and small images which are no longer than 50 KB.
However, after the import is completed, I received an e-mail saying that MySQL database(s) on my account exceed the maximum allowed size of 750 per database and I need reduce them. I checked and see that my wp_postmeta table grown to 1.3 GB and that seems to be the problems as all other tables seem fine. I found that most of the information stored in the wp_postmeta table is related to the Yoast WP SEO plugin installed on my site but I dont know how to delete rows related to it.
Also my website is very very slow now. So I need someone to take a detailed look into my tables (especially wp_postmeta table) and reduce the size without causing an problem with website.
A sample listing can be seen here; [url removed, login to view]
freelancer จำนวน 74 คน กำลังประมูลอยู่ที่ราคาเฉลี่ย $13/ชั่วโมง สำหรับงานนี้
Hi CinceTercume. What is your website? I am very familiar with Yoast plugin so I think i can help you. I'll help you to optimize your website as well. Please contact for further discussion. Thank you. M
Hi postmeta table can not handle a large amount of data. We need to create a separate table for your lists. And then customize the theme to display/search them. I can do that. Let us discuss. Regards Rasel
Dear Client, I can do this very easily even i have done this many a times. Kindly initiate chat ones so i can discuss the problem clearly, and help you out surely. Thanks for ur consideration Mithu