…, Selecting something as important as an Operating System or major component like a File System on the basis of ONE fairly small issue… matter look at the bug list or patch list for MySQL/InnoDB at any one point in time. The list will… in a way that is “fussy” in the extreme. The systems I put on-line have ZFS and we rely on…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…_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… x4 of log file size. On my system I set to 128M, which does not 100% accurately reflect log file size x 4…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads 425080 (… fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help…
Post: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
… writing file ‘/tmp/MYK74Kpi’ (Errcode: 28) The gem in all of that mess is this bit: (Errcode: 28). Now, MySQL includes a… device That’s the key to understanding what really happened. MySQL created a temporary table, using the MyISAM storage engine, and…; there is no bug — that error comes from the operating system. Typical causes are things like SELinux or AppArmor interfering. So…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… binary which calculated deltas by scanning data files. Which meant those two feature were mutually … the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there… @ Ballroom D Extending Xtrabackup – A Point-In-Time System, Wednesday 11th April 16:30 – 17:20…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
February 24, 2012 By 28 Comments
FLUSH TABLES WITH READ LOCK; also tries to close open files that obviously takes time too. I did not double check… post http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/mysql_tablecache_informationschema_and_open_files_limit.php says so. However, the things…
Post: Testing Percona XtraDB Cluster with Vagrant
April 12, 2012 By 1 Comment
… these are the prerequisites you need to have on your system: VirtualBox Vagrant A CentOS Vagrant base box (you don’… have one) Then you can find all the necessary files on my github repository: https://github.com/lefred/percona-…howto of XtraDB Cluster will help you testing this great MySQL server.
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
… error message: “mysql_install_db: command not found” I’m not able to find mysql_install_db anywhere on the file system either. I…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…standard de facto filesystem for many modern Linux system, I am getting a lot of question if…point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona…-init=on –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block-size=16384…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
…–innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per-table –target-dir=/mnt/mysql/export…log sequence number 6094071743825 InnoDB: is in the future! Current system log sequence number 6087296438643. InnoDB: Your database may be …
