… know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd … the settings and status pretty quickly. Analyzing MySQL‘s workload and data After I’m done …to meet their demands for some period of time. We also frequently bring the discussion to topics such as monitoring…
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
…impressive, but how many years it corresponds to ? Of course it depends on your workload, and mainly how write… card statistic to get an exact written bytes. For Virident FlashMAX it is vgc-monitor -d /dev… lifetime we can expect under a tpcc-mysql workload. I put 32 users threads against 5000W …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…only to check the types and frequencies of queries but also how much IO they are causing and how… data you have the more IO bound workload is likely to be and also it is possible queries…In could be even system which queries mysql. I’ve seen monitoring updates which would add excessively expensive and…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
…been implemented in Percona Server and MySQL 5.5, there are still workloads in which case mutex (…itself in the different form from the system monitoring standpoint. In many cases as heavy contention … is better not to look at the absolute number but at how it changes compared to your normal situation…
Page: Consulting for MySQL
July 31, 2006 By
…monitor server to avoid downtime. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to work with large data sets in MySQL or how to… with MySQL. We’re also ready to help with competitive benchmarks comparing MySQL and other databases for your application workload….
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…MySQL web MySQL installations using Sharding or replication IO needs are typically rather predictable. There are also often nice monitoring tools available to…to drive number of outstanding request significantly. For write intensive workload…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… SHOW INNODB STATUS output and how to use this info to improve MySQL Performance. To start with basics SHOW …to 100% hit rate. It is hard to tell what buffer pool hit rate is good enough – it is very workload… values. This is also very good values to monitor and graph – row operations is very good …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… my workload has a hi amount of concurrent writes to about 6 tables, what version of Innodb/MySQL … HT: InnoDB writes the checkpoint information to the first file. Q31: How often or what is the …running (monitoring, backup, cron, syslog, etc). But the ratio of RAM used for these non-mysql processes …
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… * 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | +—————–+ …s far better to use a monitoring tool to watch the actual memory usage over time and see how it varies. … needs; and see what happens. The results are workload-…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…nx lm constant_tsc pni monitor ds_cpl vmx est … bits virtual power management: I tested MySQL-5.1.30 with InnoDB… special to be proud of. We definitely we will look how to fix…to rw_locks and to buffer_pool mutex (in rel2). Conclusion: As read-only workload seems fine, read-write cases is something to…
