One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons… to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite difficult to…). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to work if you…
Post: Percona Server 5.5.21-25.1 released!
March 29, 2012 By 8 Comments
… available. Bugs Fixed: Fixed a memory corruption regression introduced in 5.5.18-23.0. Bug fixed #915814 (Alexey Kopytov). Fixed InnoDB compilation warnings on CentOS 5. Bug fixed #962940 (Laurynas Biveinis). Fixed MySQL upstream bug #64160 that…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global buffers, such as innodb… can be found and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…on the table. mysql> show processlist; +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ | Id | User | Host | db |…see this problem fixed. There is no …’re just using Innodb tables and you’…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… commit fix, and MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL 5…, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be… years back I told Monty, “fix subqueries and you will change the world for a lot of MySQL users.” Well, that dream…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
Kristian – this is worth fixing if that is a bug in InnoDB. Can you file one at bugs.mysql.com with details from the mysqld error log? AFAIK, InnoDB is snapshot… filesystem. But MySQL/InnoDB is not snapshot safe if DDL operations are in flight because DDL between MySQL (frm files) and InnoDB is not…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… pointed that ext4 has an option dioread_nolock, which supposedly fixes that, but that option is not available on my CentOS…. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous… another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
Kristian, This is different issue. In many versions Innodb would print wrong position for current binary log (especially if ….mysqlperformanceblog.com/2008/01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed it in Percona Server. Also if…
Post: Looking for InnoDB/XtraDB hacker
October 25, 2011 By 3 Comments
… InnoDB/XtraDB code we invite you to join our development team to work on the following (but not limited to) problems: Fix InnoDB flushing problems, e.g: http://www.mysqlperformanceblog.com/2011/09/18/disaster-mysql-5-5-flushing/ Fix InnoDB index locking Figure out InnoDB adaptive…
