by Tim.Callaghan | Jan 11, 2012 | MySQL
Thanks again to Sheeri Cabral for having me at the Boston MySQL Meetup on Monday for the talk on “Fractal Tree® Indexes – Theoretical Overview and Customer Use Cases.” The crowd was very interactive, and I appreciated that over 50 people signed up for the...
by Baron Schwartz | Jan 9, 2012 | Insight for DBAs, MySQL, Percona Events, Percona Software
You probably saw that Vadim blogged about the first alpha release of Percona XtraDB Cluster. Just in time: now I can talk about it at my High Availability talk in Percona Live DC! If you’re coming, be sure to catch us in the hallway and ask those specific...
by Vadim Tkachenko | Jan 9, 2012 | MySQL, Percona Software
I am happy to announce the availability of alpha release of our new product Percona XtraDB Cluster. Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users and based on Percona Server 5.5.17 Percona XtraDB Cluster provides: Synchronous...
by Peter Zaitsev | Jan 8, 2012 | Hardware and Storage, Insight for DBAs, MySQL
Preparing Choosing Storage Systems for MySQL talk for Percona Live in Washington,DC I ran into great paper called Sane SAN 2010 by James Morle from Scale Abilities – and Oracle consulting company. It is worth to read for variety of reason yet for this post I...
by Peter Zaitsev | Jan 8, 2012 | MySQL
Preparing Optimizing MySQL Configuration talk for Percona Live in Washington,DC I noticed how many Variables did MySQL get over years – it is pushing 400 these days even if we do not count variables/options which do not have matching SHOW VARIABLES value, and...
by Ryan Lowe | Jan 6, 2012 | Insight for DBAs, MySQL
One thing I noticed during the observation was that there were roughly 2,000 new connections to MySQL per second during peak times. This is a high number by any account. When a new connection to MySQL is made, it can go into the back_log, which effectively serves as a...
by Peter Zaitsev | Jan 5, 2012 | Insight for DBAs, MySQL
A lot have been written about Battery Learning Cycle problems and its impact to MySQL Performance. Here are couple of links (1,2). It is good to see though there are some controllers coming out which solve this problem, namely Adaptec 5Z series controllers (Z stands...
by Tokutek | Jan 3, 2012 | MySQL
FictionPress Issues addressed: Support complex and efficient indexes at 100+ million rows. Predicable and consistent performance regardless of data size growth. Fast recovery. Ensuring Predictable Performance at Scale The Company: FictionPress operates both...
by Baron Schwartz | Jan 3, 2012 | MySQL, Percona Events, Percona Software
I’m happy to announce that we’ve released Percona Toolkit 2.0.1, a major new version of our essential DBA toolkit, as well as a minor bugfix update to the old 1.0.x series. You can download it from the project homepage, or install it through our RPM and...
by Peter Zaitsev | Jan 2, 2012 | Insight for DBAs, MySQL
I guess I’m first to post in 2012 so Happy New Year all blog readers ! Now back to HardCore MySQL business – foreign Keys. MySQL supported Foreign Keys for Innodb for many years, yet rudimentary support initially added in MySQL 3.23.44 have not been...
