…, Selecting something as important as an Operating System or major component like a File System on the basis of ONE fairly small issue… — the list is quite long. For that matter look at the bug list or patch list for MySQL/InnoDB at any one point… find your comments rather disingenuous. Do you pay license fees for your operating system?
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system I set to 128M, which…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… done Check for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory for table cache, … Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads 425080 (…
Post: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
…:56:45 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘/tmp/#sql_21b2_0.MYI’; try to…file ‘/tmp/MYK74Kpi’ (Errcode: 28) The gem in all of that mess is this bit: (Errcode: 28). Now, MySQL… no bug — that error comes from the operating system. Typical causes are things like SELinux or AppArmor …
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… which calculated deltas by scanning data files. Which meant those two feature were mutually…for very advanced users. The new features in Percona XtraBackup will be part of the topics at the upcoming Percona Live MySQL… D Extending Xtrabackup – A Point-In-Time System, Wednesday 11th April 16:30 – 17:…
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
Hi, thanks for your notes and the setup script. I had a quick … error message: “mysql_install_db: command not found” I’m not able to find mysql_install_db anywhere on the file system either. I… stock AMI images (I had to modify the script slightly for the Amazon image) but it didn’t work on either…
Post: Testing Percona XtraDB Cluster with Vagrant
April 12, 2012 By 1 Comment
For those wanting to become more familiar …are the prerequisites you need to have on your system: VirtualBox Vagrant A CentOS Vagrant base box (you … one) Then you can find all the necessary files on my github repository: https://github.com/lefred… XtraDB Cluster will help you testing this great MySQL …
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…filesystem for many modern Linux system, I am getting a lot of question if this is good for SSD,…point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally …-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 corrupt… the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… 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… it has to check file systems. I believe it is much better to disable both these auto check functions for your data partition…
