…MySQL Performance in DBT2 benchmark. Focuses mostly on Innodb but many findings are generally valid. Download MySQL/Innodb Performance: Server and Schema MySQL…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… and when regressions. Practical MySQL Variables Tuning This session takes practical approach to MySQL variable tuning. Instead of giving you …. Transactional Storage Engines Performance We’re looking at performance at Open Source Transactional Storage engine MySQL – Innodb, Falcon, SolidDB, PBXT …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…operations tasks (backups, balancing, performance analyzes) as well as it exercises not so common paths in the MySQL server – in particular Optimizer…% performance improvement but I can perfectly use MyISAM (or Archive) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… deal with balancing – allocating resources to different storage engines and performance tuning becomes more complicated. Now what is interesting for probably 95… could have if we have a version of MySQL Server which drops everything but Innodb Storage engine (it could be NDB, PBXT…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…MySQL is actually badly configured, you can hurt its performance significantly. Correcting these mistakes can correspondingly improve performance…the InnoDB buffer pool size or log file size, and not using InnoDB. If… I prefer to avoid the word “tuning,” because database tuning is an activity that can…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things… write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set… make MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other performance benefits as well. Tuning…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… to note fine tuning Innodb Contention with number of spin locks loops is something i would consider last resort tuning, the performance improvements it… time while you’re upgrading to Percona Server or newer MySQL version or doing application/architecture changes. Reducing number of competing…
Page: Consulting for MySQL
July 31, 2006 By
… workload. Innodb Storage Engine Running transaction applications with MySQL ? Need help with deadlocks, understanding how Innodb locking works or having Innodb performance issues ? … Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search indexing or help you …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…autoextend | | INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE…guess is one of the component of purging fine tuning in MySQL 5.6 innodb_file_per_table is now ON by …
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… performed on Percona’s R900 machine. The scripts and results are on Benchmark Wiki and the relevant my.cnf settings were innodb… by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve… I am sure that next MySQL 5.6 versions will contain a fixed and much better performing implementation, which I am looking…
