…_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…
Comment: ext4 vs xfs on SSD
April 24, 2012 By 23 Comments
…, 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…
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…
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 …
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… systems like XFS will not continue if consistency problems are discovered. So how can you check what error behavior mode your file system… filesystem data structures which may be affects one file will take out whole file system. I do not think these concerns are valid… very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb it will assert and restart. Now…
