innodb Archives - IT Nursery

WordPress

IT Nursery

Is it safe to convert tables from MyISAM to InnoDB?

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 ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

Is there a REAL performance difference between INT and VARCHAR primary keys?

Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I’d like to use VARCHAR as ...

May 31, 2022
0 Comments

If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?

I found a superb post here about optimising WordPress for large installs. One of the steps refers to lighthttpd which sounds excellent but ...

May 22, 2022
0 Comments

Large database causes slow load

I have a 2GB WordPress database (using InnoDB Storage Engine) and I noticed my site loads slow when I press the publish button ...

May 21, 2022
0 Comments

What’s the difference between MyISAM and InnoDB? [duplicate]

This question already has answers here: MyISAM versus InnoDB [closed] (25 answers) Closed 9 years ago. I understand that this question has been ...

May 19, 2022
0 Comments

How to debug Lock wait timeout exceeded on MySQL?

In my production error logs I occasionally see: SQLSTATE...

May 17, 2022
0 Comments

How to convert all tables from MyISAM into InnoDB?

I know I can issue an alter table individually to change the table storage from MyISAM to InnoDB. I am wondering if there ...

May 17, 2022
0 Comments

Can I explicitly specify ENGINE=InnoDB in WordPress?

I converted all my tables to InnoDB, but the MySQL server (which I can’t access, as I’m on shared hosting) has MyISAM as ...

May 16, 2022
0 Comments

How can I check MySQL engine type for a specific table?

My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using ...

May 5, 2022
0 Comments

Performance Gains of Relational DB Setup

Our team is working on the 3rd of large WP sites for a client, and contrary to most “typical” WordPress setups, our projects ...

May 4, 2022
0 Comments