… — it just shows the absolute values of the reads, writes, and creates per second, stacked on top of each other. The person was… of that, some systems ought to have more reads than writes, and vice versa. So if you’re looking at your…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
…, we’re getting a couple megabytes per second of reads, and generally less than a megabyte per second of writes, but the performance (latency) is… a megabyte per second from each volume, and got read latencies varying from the teens to the seventies of milliseconds, and write latencies…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… to look forward to. Q: What about write splitting (updates,inserts) on multiple MySQL servers? Or is it possible to split only… multi-writing by keeping all the instances in sync continuously. Q: If a slave is slow because of bandwidth issues, the seconds…, which inserts the system timestamp into a dummy table once per second on the master. As these timestamp values replicate to a…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… serializing them would make MySQL unable to keep up. Disks can do 80-150 single page fsyncs per second to get you an… of log writes and fsyncs per second which matches your hard drive capacity. Plus you would normally see single outstanding log write all the… dramatically raises number of update transactions per second needed to trigger the problem. Without BBU 200 per sec may be well enough with…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
… writes” from SHOW INNODB STATUS for Innodb tables. In MySQL 5.0+ you can also use Innodb_data_reads, and Innodb_data_writes…/sec and you see Innodb_data_reads incremented by 10 per second (mysqladmin extended -i10 -r is your friend in computing this… is it is unlikely the problem for MySQL Performance. If it is however 120 per second it well could be. It is still…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have… random read (and write) benchmark with 8 threads and total size of 256G. While the number of operations per second was slightly lower…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… log at all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB…_at_trx_commit = 2 /* Write log buffer to log and flush about once per second */ (About once a second is related to the fact… a background thread that gives no guarantee it will be per second) NB: Percona Server with XtraDB actually allow you to control…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… really solid # of hits in memcached, but the # of writes in MySQL coupled with the still large # of reads takes its toll… fits ): Here you can see that our “transactionsâ€Â per second for this app increased almost 10Xby using memcached. The… dataset fits ): Here you can see that our “transactions†per second for this app increased almost 10Xby using memcached. The TPS…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…or whatever other data I need, and write something instructional to the client about it…. is pinging the server about 1200 times per second. Often this is from some ORM system,…
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
… from the fact it is the only MySQL storage engine which defaults to HASH index …deletes per second while converting table to MyISAM I get about 600 deletes per second and about 4000 deletes per second for… was also disabled, meaning Innodb could delay writes and do all the changes directly in memory…
