23 April 2014

The Ruby Reflector

Topic

Vadim

  Source Favicon
Email

A couple of weeks ago, shortly after Vadim wrote about Percona Cloud Tools and using Slow Query Log to capture the data, Mark Leith asked why don't we just use Performance Schema instead? This is an interesting question and I think it deserves its own blog post to talk about.

First, I would say main reason for using Slow Query Log is compatibility. Basic Slow query log with microsecond query time precision is available starting in MySQL 5.1, while …

mysqlperformanceblog.com Read
  Source Favicon
Email

ClusterControl for Percona XtraDB Cluster is now available in three different versions thanks to our partnership with Severalnines. ClusterControl will make it simpler to manage and monitor Percona XtraDB Cluster, MySQL Cluster, MySQL Replication, or MySQL Galera.

I am very excited about our GA release of Percona XtraDB Cluster 5.6 last week. As Vadim described in his blog post announcing the release , we have brought together the benefits of Percona Server

mysqlperformanceblog.com Read
  Source Favicon
By Dr Nic of Dr Nic 2 years ago.
Email

CloudFoundry folk who wrote BOSH and also helped me figure out how to set it up: Oleg, Vadim, skaar, Martin. Also to Mark, Dave, Matt and Jason for sharing and caring when I visited the team.

What's next? How do I use BOSH?

Once you get a BOSH created, I've started some other tutorials for how to use BOSH as I figure it out. Perhaps it could become a handbook or guide in the future. If you find any bugs, or have suggestions, please drop a ticket in the Issues. …

drnicwilliams.com Read
  Source Favicon
Email

…will raffle five (5) 60-minute MySQL query consulting sessions with Vadim to analyze your Percona Cloud Tools Query Analytics data and provide feedback and performance suggestions. Register now to attend this free webinar!

The post Percona Cloud Tools January 2014 status update appeared first on MySQL Performance Blog .

mysqlperformanceblog.com Read
  Source Favicon
Email

To address this issue we can use a parallel query execution. Vadim wrote about the PHP asynchronous calls for MySQL . Another way to increase the parallelism will be to use "sharding" approach, for example with Shard Query . I've decided to test out the parallel (asynchronous) query execution with relatively large table: I've used the US Flights Ontime performance database , which was originally used by Vadim in the old post Analyzing air …

mysqlperformanceblog.com Read
  Source Favicon
Email

One of the routine tasks for a DBA is renaming database schemas, and as such MySQL added a command to carry out that purpose called "RENAME DATABASE <database_name>". However this command just made it through a few minor releases before being discontinued (from MySQL 5.1.7 to 5.1.23) . Here's a link to the reference manual regarding the command http://dev.mysql.com/doc/refman/5.1/en/rename-database.html . Vadim wrote a MySQL Performance Blog post about this …

mysqlperformanceblog.com Read
  Source Favicon
Email

TokuDB features the fractal tree and compression. Vadim blogged about using TokuDB for storing timeseries data and it looks promising. Tim Callaghan of Tokutek will talk about Fractal Tree Indexes .

MariaDB contains the CONNECT engine (to join data between Oracle and Cassandra for example) and SPIDER storage engine (for automatic " sharding"). Colin Charles from Monty Program Ab will talk about new MariaDB features

Percona Live London

mysqlperformanceblog.com Read
  Source Favicon
By Baron Schwartz of MySQL Performance Blog over 2 years ago.
Email

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 questions that won't be addressed in a general survey talk on HA solutions.

mysqlperformanceblog.com Read
  Source Favicon
By Peter Zaitsev of MySQL Performance Blog over 2 years ago.
Email

…powerful storage) - Is quite limited with single thread replication as well as other restrictions. As Vadim points out in this and this whitepapers you can get a lot better performance with multiple MySQL instances on powerful storage. When you move to multiple instances and you have to "shard" your data in some way anyway there is no difference whenever you run these instances on single Server or many and as such you can use less powerful servers if only …

mysqlperformanceblog.com Read
  Source Favicon
By Baron Schwartz of MySQL Performance Blog over 2 years ago.
Email

Not to be outdone by Vadim's announcement, I also have one: Percona Toolkit's manual is now available as PDF (requires registration). You can get it here: http://www.percona.com/software/percona-toolkit/

Thanks to Mauricio Stekl, who did all the hard work to create the PDF of the manual — and did it fast, too.

mysqlperformanceblog.com Read