… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… that I used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…: ready for connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see…@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
…/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On… to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite difficult….g instead of 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… be able to able to change the logfile size in a 5.0.95 MySQL database running on RHEL 5. I add the following line to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb_log_file_size = 64MB Then: /sbin/service mysqld stop Then…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
… inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… RAM, Inno would hit a memory wall. Given that Memory sizes are perhaps 10 times bigger than they were 4 years… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
….cnf file. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium.cnf to /etc/my… i originally posted, the log files were created with the size i specified. I wonder how many other configuration values have…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL… up to max_packet_size per connection) are all connection buffers and so if you close connection MySQL can clean them up… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… helicopters and other goodies. The expo hall was the same size as last year, but was packed full. We had a… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… MySQL 5.5 While with join_buffer_size set to 6M and read_rnd_buffer_size set to 6M, the query time for MySQL… counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer_size…
