One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… the IO configuration I chose 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB options innodb_buffer…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL takes much more…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… mysql database using the innobackupex-1.5.1 command. I have the innodb_file_per_table directive set in the my.cnf configuration… my /var/lib/mysql folder. But I am able to view/access ONLY MYISAM table – but none of the InnoDB tables. Is… any directive in the my.cnf file to access the InnoDB table? Please help. Thanks in advance. Abhilasj
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… new mysqld, which finds a crashed innodb, recovers this, and then it is being configured to become a new slave to the… machine. Every once in a while the recovery of the innodb in the target location fails, though, even though it has… have been experiencing this with many versions of MySQL. We are now using ‘service mysql stop’ instead of FLUSH TABLES WITH READ…
Comment: InnoDB in self-compiled MySQL 5.1
March 2, 2012 By 9 Comments
I tried this: ./configure \ –with-plugins=innobase \ –prefix=/home/stephane/programs/install \ –localstatedir=/home/stephane/programs/mysql/data on MySql 5.1.61 But I still get stephane@stephane-ThinkPad-X60:install> mysqladmin variables | grep have_innodb | have_innodb | NO
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…which can cause serve performance degradation. Configuration Changes Have you changed MySQL configuration ? OS Configuration or Hardware configuration or could have anyone changed it …include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at_trx_commit=1. Also note there …
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
… if InnoDB cannot log at all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log. You can request that InnoDB force its REDO…
Post: How to change innodb_log_file_size safely
July 9, 2011 By 14 Comments
If you need to change MySQL’s innodb_log_file_size parameter (see How to calculate a good InnoDB log file size), you…. If you do, InnoDB will refuse to start because the existing log files don’t match the configured size. You need to…… That really means that InnoDB hasn’t started, and MySQL is trying to access a table with the InnoDB storage engine, which is…
