I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…
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… async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and… it seems suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards…
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: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive…
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…@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M [root@tstlx1 mysql]#
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons… 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…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… MySQL database running on RHEL 5. I add the following line to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… ENGINE INNODB STATUS information as follow: —TRANSACTION 0 27638, ACTIVE 1207 sec, process no 2909, OS thread id 1100101952 inserting mysql tables… lock struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929, query id 484616 localhost root update insert…
Comment: How to calculate a good InnoDB log file size
May 1, 2012 By 33 Comments
Hi! I come from Viet Nam. Now i want to check capacity (free space & used space) of datafile on InnoDB (MySQL). How to command? I just research for MySQL, hope you help me. Big thanks!
