…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…
Post: Logging Deadlock errors
September 19, 2012 By 4 Comments
…monitors the output of SHOW ENGINE INNODB STATUS and log the new deadlocks to a file or to…to run the tool on every node and configure it to store logs on a centralized database. In MySQL 5.6 will be possible to…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL This customer was running Percona Server… the Innodb Table monitor instead, see my next post for how that turned out, but this basically will regurgitate the entire Innodb Data dictionary to…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
…monitoring…to different contention situations which can be handled differently. First situation often corresponds to Innodb spending a lot of CPU time running…to buy a little bit more time while you’re upgrading to Percona Server or newer MySQL…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…InnoDB has other needs that it doesn’t actually promise to fit within innodb… 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@… key. Note how long it took to run these statements…to use a monitoring tool to watch the actual memory usage over time and see how…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… enabling log_slave_updates, setting innodb_flush_log_at_trx_commit=… cause of concern. Remember replication runs as a single thread and…to check the types and frequencies of queries but also how much IO they are causing and how… system which queries mysql. I’ve seen monitoring updates which would add…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…. It continues with an overview of how to install and run FlexCDC, and concludes with a demonstration … was not available for MySQL. Change Data Capture can be used to: Monitor a database table, or …, > c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql> insert into test.demo…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…gave me a chance to run some benchmarks on 24-core (intel cpu based… syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 …virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2…there than InnoDB, but nothing special to be proud of. We definitely we will look how to …
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
…to create open-source tools for monitoring, query analysis, replication management, and other capabilities. If you’re worried about Oracle making MySQL…to how many servers you’re running. Per-unit pricing would also compromise our objectivity — we’d have an incentive to…
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…MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable transactions the log write latency is triple important compared to…
