… to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4… 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: Load management Techniques for MySQL
May 6, 2012 By 2 Comments
… problem with your MySQL configuration, queries and hardware, even though fixing these does help in many cases. Whatever powerful and well…
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…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… the real solution I’d love to see this problem fixed. There is no reason (other than code design) for read… gridlock one way or another. If you’re just using Innodb tables and you’re not actively changing users, stored procedures…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: my ENGINE: InnoDB NAME: #sql516_1c42_2 TABLE_ROWS: 0 AVG_ROW_LENGTH… *************************** SESSION_ID: 7231 TABLE_SCHEMA: test TABLE_NAME: z ENGINE: InnoDB NAME: #sql516_1c3f_0 TABLE_ROWS: 0 AVG_ROW_LENGTH… illustrate memory leak and when it can be found and fixed. This is where your MySQL Support contract can be handy…
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 safe as long as database files and log… are in flight because DDL between MySQL (frm files) and InnoDB is not atomic and some failures are not recoverable (which…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… list. For example, Percona Server has the same group commit fix, and MySQL 5.6 offers microsecond timestamp support, as well…, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be…. I remember that a couple years back I told Monty, “fix subqueries and you will change the world for a lot…
Comment: Troubleshooting MySQL Memory Usage
March 22, 2012 By 3 Comments
I think it’s worth to say here that the InnoDB team has already made some effort to address memory usage problems: http://blogs.innodb.com/wp/2011/12/improving-innodb-memory-usage-continued/ . Results seem very promising, and also maybe these fixes will allow more precise memory usage monitoring.
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… one more point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server… asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems it is…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… too bad setting server read only…. When we speak about Innodb tables and backup with Xtrabackup or LVM we do not… flushed and read only so they can be copied and Innodb tables can be written to but we do not want…. But indeed this might go beyond flush tables with readlock fixes.
