innodb

Add question

Username* Please type your username .

E-Mail* Please type your E-Mail .

Question Title* Please choose an appropriate title for the question to answer it even easier .

Category Please choose the appropriate category so others can easily search your question.

Tags Please choose suitable Keywords Ex : question , poll .

Poll This question is a poll ? If you want to be doing a poll click here .

Featured image

Browse

Details*

Ask Anonymously Anonymous asks

Video description Do you need a video to description the problem better ?

Video type Choose from here the video type .

Video ID Put here the video id : https://www.youtube.com/watch?v=sdUUx5FdySs EX : 'sdUUx5FdySs'.

Notified Notified by e-mail at incoming answers.

Terms* By asking your question, you agree to the Terms of Service and Privacy Policy.

Captcha*

Is it safe to convert tables from MyISAM to InnoDB?

Question

I have inherited a WP site (with WP5.1 and WooCommerce 2.6.14, LearnDash 2.5.4 and few other smaller plugins). From screenshot you can see that it is a mix and match of MyISAM and InnoDB tables. We are experiencing table locking related problems (which essentially slow site down

database, innodb, mysql Dimitry K 3 years 0 Answers 79 views

Trying to change database tables storage engine to innodb gives error “invalid default value for ‘post_date'”

Question

I have a live WordPress website. Most of the tables are using MyISAM storage engine with UTF-8 encoding. I need to switch their storage engine to innodb. But when I try to change the engine, I get errors like invalid default value for 'post_date'

database, date-time, innodb Yazan W Yusuf 4 years 0 Answers 106 views

WordPress UPDATE queries on MySQL database stuck

Question

I have an Amazon 24XL server 96 Cores 378 GB RAM Database size 5.7G Debian GNU/Linux 9 (stretch) PHP 7.3.16 mysql Ver 15.1 Distrib 10.3.22-MariaDB I have only one WordPress site where users read articles, the

innodb, mysql, optimization, plugin-development, plugins Naqi 4 years 0 Answers 114 views

3K update queries on sinlge database stalls

Question

I have a Amazon 24XL server of 82 Cores, 378 GB RAM. I have only one WordPress site where users read articles, there are 4-5 smal plugins One plugins is used to add the points and rewards in my subscribers profile. When there are around 2500 Users on my site there are around 3000+ UPDATE queries

innodb, mysql, optimization, plugin-development, plugins Naqi 4 years 0 Answers 85 views

Which engine is better for WordPress: InnoDB or MyISAM?

Question

After I migrate to InnoDB engine my database swiftly grow in size from 300 Mb to 3 Gb. Is it normally? Still I use MyISAM?

database, innodb, phpmyadmin Bogdan 4 years 0 Answers 85 views

Register Now

Login

Lost Password

Add question

Login

Register Now