…MySQL 5.6 virtually eliminates contention on the mutex protecting the list of transactions, its applicability is quite limited… cow and throw some data updates into the mix, limitations of read-only transactions … innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… if the server was hitting its capacity, or if there was another limiting factor in the workload that…. Granted, this means there is no run time data available, but at least you get a nice…If you regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do more …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… to the amazing MySQL manual, especially the option and variable reference table…data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… moment. The amount of resources system has will place a limit on amount of queries system can ran, for example if… by Cary Millsap. So how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO… estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… product is about beating data processing limitations of current systems. This raises valid question how fast can MySQL process (filter) data using it current… rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE test_read(pl INT) -> BEGIN -> DECLARE t…/sec which is surely small fraction of what memory bus capacity of this system can deliver.
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… or potential data loss you may run into 
Reckless approach is safest if you’re running application which uses simple MySQL functionality… data ? In this case you may need to take it much slower checking your progress along the way. There is no limit… measuring its capacity) Setting up the Slave(s) If you want to minimize downtime it is best to use MySQL Replication for…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS… I/O Capacity.” I used sysbench’s oltp benchmark, with 400,000,000 rows. This creates a table+index data size approximately… seconds instead of every minute, and some samples of more data such as SHOW INNODB STATUS. But I was on the…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…_max_dirty_pages_pct and innodb_io_capacity parameters to get stable throughput in MySQL 5.5.8. Let’s see what…_pool_size to data. For the initial tests, I used MySQL 5.5.8 (the tar.gz binary from dev.mysql.com), and… maintain the 50% level; in the second we are limited by the capacity of REDO logs. So, what do we get if…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… pretty much inevitable: if you do this kind of data processing in MySQL, you’re going to end up heavily I/O… have to work on I/O capacity. What does this have to do with InnoDB? Data clustering. InnoDB’s primary keys… do you have? And the gains are simply limited by some of MySQL‘s weaknesses in some cases. Not only that…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… the limit rather than number of IOs it can handle. Imagine for example data archive storage. On BoardReader for example we’re limited by space and how much data we can comfortably put in MySQL Instance… not always the case. Another mistake is to measure IO capacity in spindles – So your hard drive can do 200 random…
