… rate at which insert buffer pages are flushed to disk (innodb_ibuf_accel_rate) which might be interesting to tweak during…
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 15, 2012 By 9 Comments
… if a feature that will permit to skip some bases (innodb or myisam) in the cluster will be announced soon ? Because…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…:51:16 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4… Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it…). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to work if you…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and recently I… IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and… random write case (8 async IO threads): It seems that InnoDB is not alone with its flashing problems. You can see…
Post: Load management Techniques for MySQL
May 6, 2012 By 2 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading the system causing user experience to …
Comment: FlashCache: first experiments
May 3, 2012 By 18 Comments
You said “* InnoDB files layout: ibdata1 and ib_logfile* are placed on separate … flashcache ? I think flashcache is good place to store ibdata(innodb system tablespace). And, Is Xtrabackup compatible with Flashcache ? Thanks.
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… the following line to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb_log_file_size = 64MB Then: /sbin/service…
Comment: Version 1.0 of Percona Monitoring Plugins Released
April 27, 2012 By 7 Comments
Hi Baron, I see that the pmp-check-mysql-innodb plugin for Nagios leaves a lot of files (e.g. pmp-check-mysql-innodb.1196) in /tmp. Is that a desired feature? Thanks Daysen
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and recently I… IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and…
