… in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used… I used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group…why I have chosen to show “millions of rows” on the x-axis so that we can see the impact of growth in…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…in MySQL mode (that is, using adaptive_flushing from InnoDB and with the adaptive_checkpoint algorithm disabled), but with giant log files. I used a log file…are the results: Success! With a big log file, we are getting stable throughput. Checkpoint … to 77%. I am not sure why it is more than 75%. …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…we trying to solve with these plugins? Why yet another set of MySQL…MySQL‘s log or data files from disk. The database server will continue to function, however, because the file isn’t really deleted. The MySQL…MySQL on the same files in the data directory, and refusing to shut down MySQL…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…log_file_size = 1900M innodb_log_files_in_group = 2 In my benchmark I measure results each 10 sec, and when we…use Percona Server with XtraDB. If we were using SSD as storage, then I would recommend it. Vanilla MySQL…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
…we can get using MySQL and XtraDB / InnoDB storage engine if we…we use binary logs ( I used ROW based replication for 5.1) – do we have sync_binlog options. So why…log files, innodb system table space and binary logs. And I used Percon-XtraDB-5.1.43-9.1 for benchmarks. All used…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…we recommend to run MySQL on. What is important I used…in MySQL) For benchmarks I used scripts that emulate TPCC load and datasize 40W (about 4GB in size), 20 client connections. Please note I used…log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 256M innodb_log_files_in… why …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…we‘re limited by space and how much data we can comfortably put in MySQL Instance without getting in…files (and whole datadir) and log files on the same partition as well because this makes it very easy to use… need to understand what is happening and why. A lot of pieces – filesystem, disk scheduling…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…file and tell it your definition of “abnormal” — by default it has some vanilla settings that aren’t useful…log into MySQL (if necessary, put a password into .my.cnf, or in…in MySQL…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…in MySQL you might be better of using several queries than doing complicated ones. Of course you would rather use IN…in slow query log. If you have trouble understanding EXPLAIN or optimizing your queries remember we…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…use “tuning” in a generic way here — we focus on far more than my.cnf files. In fact my.cnf files…log_file_size. I won’t give you a full rundown over every option in the file… paste in mysql> show global variables like ‘%table_size%’; …We explain how to interpret what we‘re showing, and why…
