… this: innodb_log_file_size = 64M (without the “B” in “MB” string) This works on my site on a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool… Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
Unfortunately that’s not true Henrik. Take for example the InnoDB plugin that has changed frequently throughout a release. http://www… even within MySQL 5.5 GA we’ve gone from InnoDB plugin version 1.1.4->1.1.8. Also, take… client library. (Bug #60061, Bug #11827366)” With Linux distributions like Debian or RedHat, a number of the compiled versions of various…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on DotDeb.org, and I find my qps… across the board to everyone? Have some updates made to INNOdb tables really slowed down mySQL as measured by qps, in…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http://www.percona.com/downloads/Percona-XtraDB-Cluster….1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc=’cecece’;bbc=’3F79D5…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
Are you running MySQL on Debian or Ubuntu with InnoDB? You might want to disable /etc/mysql/debian-start. When you run /etc…. Why is that happening? Look at SHOW INNODB STATUS: ===================================== 090128 8:29:03 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the…
Post: Debian / Ubuntu Percona builds
March 9, 2009 By 8 Comments
… is dead, isn’t it?), and I tested binaries on Debian Lenny system and it seems working fine. So I prepared… feedback is welcome! As for changes for Build13 it contains InnoDB Data Dictionary restriction patch, which I mentioned before (http://www.mysqlperformanceblog.com/2009/02/11/limiting-innodb-data-dictionary/). Speaking of deb binaries I tried to keep…
Comment: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
…:30 debian mysqld: InnoDB: is in the future! Current system log sequence number 0 56436. May 16 14:19:30 debian mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB May 16 14:19:30 debian mysqld: InnoDB: tablespace but not the InnoDB log files. See May 16 14:19:30 debian mysqld: InnoDB…
Comment: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
… Y, Thanks for feedback. > May 16 14:19:30 debian /etc/mysql/debian-start[14967]: Triggering myisam-recover for all MyISAM tables > May 16 14:19:30 debian mysqld: 110516 14:19:30 InnoDB: Error: page 3 log sequence number 20 1214354523 > May 16 14:19:30 debian mysqld: InnoDB…
Comment: How to change innodb_log_file_size safely
November 8, 2011 By 14 Comments
… running MySQL 5.1 on Debian Squeeze 6.0. And I can tell you that changing innodb_log_file_size does NOT… 19:19:58 mysqld: InnoDB: is in the future! Current system log sequence number 0 3177053196. Parameter ‘innodb_fast_shutdown’ has NOT… this will work in every scenario! As this is a Debian hosting server migration I started over the weekend, cheers god…
Post: Percona Server version 10
April 13, 2010 By 3 Comments
… to change InnoDB pages size to 4K or 8K. Also InnoDB log files now can be bigger 4G New patch innodb-fast-checksum. It adds new faster checksum algorithm used in InnoDB tables… i386) CenOS 4 (x86_64 and i386) Debian lenny (x86_64 and i386) Debian etch (x86_64 and i386) Ubuntu Karmic (x86…
