… do that I’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and…_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC… I guess is one of the component of purging fine tuning in MySQL 5.6 innodb_file_per_table is now ON…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
…, configure, tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL…
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… be done by external script which can have application-specific tunings to prioritize which queries are more important to refresh for… make it cool again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… market is now great for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing and Sales departments and…. It may be as simple as adding few indexes and tuning MySQL Server settings. It is more the question of knowing there… – it is very hard to find people with good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching for…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
… Server for MySQL is an enhanced drop-in replacement for MySQL, offering breakthrough performance, scalability, features, and instrumentation. Self-tuning algorithms and support… demand excellent performance and reliability from their MySQL database server. Compare Percona Server to MySQL. Performance Percona Server’s performance is exceptional…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… sets. Internals of new InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my job… instruction about what some migration strategies might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – I… me, this seems compelling. Managing data and data archiving using MySQL 5.6 new features of Portable Tablespace and EXCHANGE PARTITION…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
… up to Rick’s talk might be: Advanced query optimizer tuning and analysis This 3 hour session is being given by… when this was not the case at a MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to solve replication problems (3 hr) Ramp-up tutorial for MySQL Cluster – Scaling with continuous availability (6 hr) Percona XtraDB Cluster…
Post: Announcing Percona Live MySQL Conference and Expo 2012
August 9, 2011 By 11 Comments
… are a vitally important part of the MySQL ecosystem, they cannot — cannot — replace the traditional MySQL conference and expo. The “and expo” is crucial here — the O’Reilly MySQL conference has occupied the crossroads of open-source, MySQL, community, and business. Emphasis on business… when we see you in Santa Clara in April. Stay tuned.
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… LISTEN socket is overflow – MySQL is not accepting connections as quickly as it needs. There are 2 tuning places you need to… problem and do some Math. First lets look into how MySQL accepts connection. There is single main thread which is accepting… one out of the thread cache. From this point on MySQL processes network communication in multiple threads and can benefit from…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… published Intel Woodcrest preview benchmarks which have some numbers for MySQL as well. From these numbers performance looks great and it… article also has very interesting observation on MySQL Multiple CPU scalability . As you can see MySQL could be slower on Linux with… I was working with article authors advising them how to tune MySQL and what is the reason for negative scalability etc.
