Tags » Innodb

Lock wait timeout exceeded error in MySQL

The lock wait timeout exceeded error comes up occasionally in MySQL and is frequently followed by a request to the DBA to raise the innodb_lock_wait_timeout setting. 840 more words

InnoDB

How much memory should we assign to MariaDB?

How much memory should we assign to MariaDB?

Before answering, I’ll show you a procedure I use to get the amount of memory I’m using. See the comments to make it work on Oracle MySQL. 447 more words

SQL