wpmhweb
Forum Replies Created
-
Forum: Plugins
In reply to: [Taxonomy Images] What db table does Taxonomy Images uses to save imagesThank you for the info. I’ll have to go manual on this one.
Doesn’t the export takes a lot of resource for about 200 tables? I’m asking because I’m transferring the site because of some mysql performance issue, and I’m trying not poke the db too hard.
Thanks,Thanks,
Thanks.
Due to some of the options, such as featured images not transferring correctly and possible timeouts when exporting a large amount of posts using the WordPress tool, I’m starting with a new new clean installation of WordPress, but I’m importing the some of the tables to the new database, such as:
wp_posts
wp_comments
wp_terms
wp_commentmeta
wp_postmeta
wp_term_relationships
wp_term_taxonomy
wp_termmetaAnd then I’m reconfiguring the rest from scratch.
So, I’m bringing these tables to the new database, the only thing left would be configuring the general options with TablePress, correct?
Thanks,
How can export only “ad_inserter” from the “wp_options” table, and the restore only “ad_inserter” to another database?
Thanks,
Forum: Fixing WordPress
In reply to: How to fix Invalid default value mysql error on WordPress database@corrinarusso @sterndata I don’t exactly which version of mysql, but newer versions don’t accept anymore
0000-00-00 00:00:00for dates because they now enforce higher levels of strictness, so it’s going an issue for older sites transfering to a new server.I had to change the sql_mode to disable
NO_ZERO_IN_DATE, NO_ZERO_DATEto make it work.I’m using Ubuntu 18.04 and mysql 8.0.19.
Forum: Fixing WordPress
In reply to: WordPress still using MyISAM, is changing to InnoDB necessary?Thanks,
Forum: Fixing WordPress
In reply to: WordPress still using MyISAM, is changing to InnoDB necessary?@sterndata I do get a lot of people recommending me to mysql-tuner.pl, but my question is why do I need to use it? I mean old server everything was working great, and immediately after changing server issues started appearing with the same traffic and load.
Forum: Fixing WordPress
In reply to: WordPress still using MyISAM, is changing to InnoDB necessary?Do you know how can I change from MyISAM to InnoDB for a WordPress server? And, I have access to the dedicated VPS.
Thanks,
- This reply was modified 6 years, 2 months ago by wpmhweb.
Forum: Plugins
In reply to: [W3 Total Cache] W3TC + CDN take long time to upload imagesThanks for the clarification.
Forum: Plugins
In reply to: [W3 Total Cache] W3TC + CDN spikes RAM usage and slower image uploads@bcvcbhqyxcgakhh during the upload by the user or after the post is saved or published.
thanks,Forum: Fixing WordPress
In reply to: Help fixing theme code causing database problemsCan someone point out what I did wrong in the functions?
Thank you very much.Forum: Plugins
In reply to: [W3 Total Cache] W3TC + CDN spikes RAM usage and slower image uploads@bcvcbhqyxcgakhh Although swap is important, vps companies advise you against swap on SSDs as it’ll cause performance issue over time.
Also, I don’t know what’s the buffers/cache reference means. I don’t know if they’re talking about the w3tc or something on the server. In addition, I don’t understand innodb_buffer_pool_size…
It’s early to tell, but I think I MIGHT have found the memory problem. It might be a piece of code in the theme, I’m trying to fix it. However, images still take a long time about 7 to 10 seconds to upload, when without the plugin upload in 1 or 2 seconds.
Does w3tc sends the images to the cdn as they’re uploaded? Or after it’s published and it gets cached?
Thanks for the response, I think I found part of the problem. I think is some code in theme. However, the problem appeared immediately after running Optimize Database after Deleting Revisions plugin.
Thanks,
Actually, now I’m seeing many SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.
Please help.