…, Selecting something as important as an Operating System or major component like a File System on the basis of ONE fairly small issue… in a way that is “fussy” in the extreme. The systems I put on-line have ZFS and we rely on… 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
…_log_file_size = 64M (without the “B” in “MB” string) This works on my site on a Debian Squeeze system where I… x4 of log file size. On my system I set to 128M, which does not 100% accurately reflect log file size x 4… to import all the data into a clean/fresh innodb system! Good luck! Thomas
Comment: FlashCache: first experiments
May 3, 2012 By 18 Comments
You said “* InnoDB files layout: ibdata1 and ib_logfile* are placed on separate RAID … ? I think flashcache is good place to store ibdata(innodb system tablespace). And, Is Xtrabackup compatible with Flashcache ? Thanks.
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… 127499384 Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads 425080 (406936… any more as Innodb has moved allocating memory from operation system directly not from addition memory pool (hence 0). Such allocations…
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
… not able to find mysql_install_db anywhere on the file system either. I tried this with both Amazon’s default as…
Comment: ext4 vs xfs on SSD
March 19, 2012 By 23 Comments
…: sysbench OLTP RW benchmark on spinning (non-SS) disks. The file systems on this “inherited” machine default to ext4, but I had…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
February 24, 2012 By 37 Comments
Hi. After choosing a distribution, are there specific settings that should be chosen for an OLTP DB? – file system? chunks? sizes? ext4 or xfs? – schedulers?
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… is a standard de facto filesystem for many modern Linux system, I am getting a lot of question if this is… in 100 do cd /mnt/stec sysbench –test=fileio –file-num=1 –file-total-size=${size}G prepare sync echo 3 > /proc…=$numthreads –rand-init=on –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block-size=16384 –report-interval…
Post: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
…:56:45 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file ‘/tmp/MYK74Kpi’ (Errcode: 28) The gem in all of that… examples are error 13 (permission denied) or 2 (No such file or directory). The typical reaction is “but it certainly has…; there is no bug — that error comes from the operating system. Typical causes are things like SELinux or AppArmor interfering. So…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… like to recover a single table # xtrabackup_55 –backup –innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per-table –target-dir=/mnt/mysql/export ALTER TABLE data… log sequence number 6094071743825 InnoDB: is in the future! Current system log sequence number 6087296438643. InnoDB: Your database may be corrupt…
