Skip to main content
  1. Tags/

database

2007


Convert MyISAM tables to InnoDB

·170 words·1 min
If you want to convert a MyISAM table to InnoDB, the process is fairly easy, but you can do something extra to speed things up.

MySQL binary log rotation

·71 words·1 min
If you’ve run MySQL in a replication environment, or if you’ve enabled binary logging for transactional integrity, you know that the binary logs can grow rather quickly.

MySQLTuner minor update

·54 words·1 min
I rolled out a new MySQLTuner update tonight and made the following changes:

MySQL couldn’t find log file

·239 words·2 mins
This error will pop up when binary logging is enabled, and someone thought it was a good idea to remove binary logs from the filesystem:

MySQL: Errcode: 24 when using LOCK TABLES

·158 words·1 min
While running into MySQL’s open files limit will manifest itself into various error messages, this is the standard one that you’ll receive during a mysqldump:

Huge MySQLTuner overhaul

·69 words·1 min
I’ve been flooded with requests for MySQLTuner and I’ve answered them this weekend.

MySQL: Missing *.ibd files

·403 words·2 mins
Using the InnoDB engine can be tricky due to the ibdata files’ rather untraditional behavior.

Obscure MySQL variable explained: max_seeks_for_key

·539 words·3 mins
MySQL documentation can be awfully flaky - extremely verbose on issues that don’t require such verbosity, and then extremely terse on issues that need a lot of explanation.

Postgres process listing

·94 words·1 min
If you’re used to SHOW PROCESSLIST; or mysqladmin processlist in MySQL, you might be searching for this same functionality in postgresql.

Speeding up MySQL

·588 words·3 mins
If there’s one question I get a lot, it would be “Hey, how can I speed up MySQL?

MySQL connections in sleep state

·426 words·2 mins
On some servers, you may notice that MySQL is consuming CPU and memory resources when it’s not processing any queries.

Reset MySQL root password

·92 words·1 min
If you’ve forgotten the root password for a MySQL server, but you know the system root, you can reset the MySQL root password pretty easily.

Securing MySQL

·419 words·2 mins
If you work on enough servers, you discover that a lot of people put the security of their MySQL server on the back burner.

MySQL Row & Data Limits

·197 words·1 min
As most folks know, by default, MySQL limits the size of a MyISAM table at 4GB.