June 19, 2013

Post: Is Synchronous Replication right for your app?

May 14, 2013 By 18 Comments

….  I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial.  This is fine as long as…

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With: , , , , , ,

Post: Virident tachIOn: New player on Flash PCI-E cards market

June 15, 2010 By 19 Comments

… recommends to have space reservation to get sustainable write performance (Tuning Techniques for Writes). I took FusionIO ioDrive 160GB SLC card… fine tuned by Virident engineers, while FusionIO card was tuned only by me and I may not have all knowledge needed for FusionIO tuning…

Filed Under: Benchmarks, MySQL Tagged With: , ,

Post: Economics of Performance Optimization

March 13, 2008 By 9 Comments

… low hanging fruits are fixed you end up with either fine tuning which gives little improvement or more application changes such as… less time than moving the application. On reasonably tuned applications when further tunings are expensive you may well upgrade hardware instead but…

Filed Under: Insight for Developers Tagged With:

Post: How Innodb Contention may manifest itself

July 28, 2011 By 1 Comment

…_loops to a higher number. It is worth to note fine tuning Innodb Contention with number of spin locks loops is something i would consider last resort tuning, the performance improvements it provides is typically rather limited and… well as adjusting innodb_thread_concurrency and doing other server tuning should be first on your list. I also wanted to…

Filed Under: Insight for DBAs, MySQL

Comment: Pitfalls of converting to InnoDB

March 8, 2007 By 16 Comments

… SQL statement, and completes with a “$mysqli->commit()”. It works fine…….. …… until PHP bombs mid-way due to a coding bug… is able to invoke the rollback(). This seems to work fine. public function begin_transaction() { $ret = self::$mysqli->autocommit(false); $this…-out – I’m assuming that’s standard (I haven’t tuned anything). So your script could loop for 5000 seconds. Perhaps…

Filed Under: Insight for DBAs Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception that I’ll explain below) – the… as two separate ALTER statements, and it appears to work fine. But here’s where things start to get even weirder… initial states, run some queries, and compare the output. Stay tuned, it gets rather curious.

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Percona Welcomes MySQL 5.6!

February 25, 2013 By Leave a Comment

… your current system; assess how to re-architect, develop, and tune your application to take advantage of MySQL 5.6′s… MySQL Remote DBA Team is ready to monitor, maintain, and fine tune our customers’ MySQL 5.6 test and production environments, and…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software, Percona Toolkit

Post: Is MySQL 5.6 slower than MySQL 5.5?

February 18, 2013 By 23 Comments

… best performance possible. At Percona we surely will be doing fine tuning for our Percona Server for MySQL version 5.6 release… phase should not increase with contention. Granted I have not tuned MySQL 5.6 for best performance going with defaults outside…

Filed Under: MySQL Tagged With: , , ,

Comment: MySQL 5.5.8 - in search of stability

January 7, 2011 By 11 Comments

Dmitri, Yes I agree with you. We should have found the combination offering best performance for MySQL 5.5.8 for given workload. At the same time if it requires “fine tuning” to get these numbers it is a downside as it is not always possible to achieve such tuning.

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: Moving from MyISAM to Innodb or XtraDB. Basics

November 22, 2010 By 2 Comments

… to run Innodb or XtraDB with them. Second Innodb is tuned to be ACID by default – if you’re moving from…_log_file_size. There are a lot more options for fine tuning but make sure at least these are right.

Filed Under: Events and Announcements, MySQL Tagged With: , ,
« Older Posts