… after MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full… MySQL versions to MySQL 5.6, and other issues. Our MySQL Remote DBA Team is ready to monitor, maintain, and fine tune our customers’ MySQL 5.6 test and production environments, and address any performance issues that might arise. Our MySQL Training team…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… Seppo (Codership) before. MySQL Query Anti-Patterns that can be moved to Sphinx - (Vladimir Fedorkov, PalominoDB) Now that Innodb supports Full-text… Xtrabackup feature sets. Internals of new InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my job…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… is not worth tradeoff. Even more if you’re running Innodb chances are you will not buy you more “up time” either as Innodb is very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb it will assert and restart. Now lets look at couple of other options you might want to tune with…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… to switch back and forth between galera and built-in mysql replication (asynchronous) for a given node, it’s not possible… built-in mysql replication are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb), do you have a recommended configuration? A: We don’t have any specific recommandations for Zabbix, but general InnoDB tuning recommendations…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
…hour tutorial focusing on indexing within MyISAM and Innodb with a side of Partitioning. I’d expect…Rick’s talk might be: Advanced query optimizer tuning and analysis This 3 hour session is …was not the case at a MySQL conference. There are several MySQL HA related tutorials: Using Tungsten …
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so it is lockless… can use same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances hashed by query… be done by external script which can have application-specific tunings to prioritize which queries are more important to refresh for…
Post: What would you like to hear about on MySQL Users Conference 2008 ?
October 22, 2007 By 2 Comments
… Grand Jury which will make elite selection of sessions for MySQL Users Conference and we plan to submit few more. Our experience in MySQL is rather broad – we can prepare talks in areas of… about general MySQL Performance Optimization or Innodb Tuning. Anyway we would like to hear what would you like to hear about on MySQL Users…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty…: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in… serialization. MySQL‘s binlog and InnoDB‘s log must have the transactions in the same order, for a recovery based on MySQL‘s…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…: (mysql-5.1.39 + XtraDB-1.0.4-current) innodb_io_capacity = 4000 innodb_support_xa = false innodb_file_per_table = true innodb… general settings) innodb_ibuf_active_contract = 1 innodb_adaptive_flushing = false innodb_adaptive_checkpoint = estimate <tuning peak performance> At first, tuning the peak…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… of MySQL like my-large.cnf, my-innodb-heavy-4G.cnf and so on have the thread_concurrency enabled with a tune advice…. If you really want to tune the number of threads that runs concurrently you should read about innodb_thread_concurrency: http://www…/05/24/tuning-innodb-concurrency-tickets/ innodb_thread_concurrency places a limit on the number of threads that can be running inside InnoDB. The…
