September 16, 2014

Network at the Percona Live MySQL Conference and Expo

We’re very pleased with the speaker lineup for the Percona Live MySQL Conference and Expo. We have outstanding MySQL experts speaking on a variety of topics during the breakout sessions and tutorials. And the keynote speakers are all top notch, MySQL technology and industry experts who will share their views of the ecosystem. Beyond the […]

MySQL Backup tools used by Percona Remote DBA for MySQL

As part of Percona Remote DBA for MySQL service we recognize that reliable backups are one of the most important things we can bring to the table. In my experience handling emergencies, the single worst thing that can happen is finding out you don’t have backups available when some sort of data loss or catastrophic […]

Thank You Percona Live London 2012 Attendees!

Percona Live London wrapped up last week to very positive reviews from attendees and sponsors like those from Johan De Meersman. Percona was pleased to provide an engaging event for MySQL community members that featured engaging tutorials, highly rated breakout sessions, a very well-attended Tuesday community networking reception sponsored by Clustrix, and keynotes from a […]

Percona Live MySQL Conference and Expo 2013 – News from the Committee – Part 1

I was honored to be asked to be a member of the committee for the “big” MySQL conference: Percona Live MySQL Conference and Expo 2013 in Santa Clara, CA.  Personally, I’ve been attending this conference for 6 or 7 years and missing it only when my wife was pregnant with a due date in April […]

Percona Live London 2012 talks you do not want to miss

Percona Live, London 2012 continues streak of “not to be missed” events in London, following the footsteps of Royal Wedding, Diamond Jubilee and Summer Olympics. We have prepared great set of Tutorials and Sessions for these two day event. Here is my personal selection of the talks I’d love to attend, though I rarely have […]

Can we improve MySQL variable handling ?

MySQL Settings (also known as Server Variables) have interesting property. When you set variable in running server this change is not persisted in any way and server will be back to old value upon restart. MySQL also does not have option to re-read config file without restarting as some other software so approach to change […]

MySQL opening .frm even when table is in table definition cache

or… “the case of Stewart recognizing parameters to the read() system call in strace output”. Last week, a colleague asked a question: I have an instance of MySQL with 100 tables and the table_definition_cache set to 1000. My understanding of this is that MySQL won’t revert to opening the FRM files to read the table […]

Flexviews is a working scalable database transactional memory example

http://Flexvie.ws fully implements a method for creating materialized views for MySQL data sets. The tool is for MySQL, but the methods are database agnostic. A materialized view is an analogue of software transactional memory. You can think of this as database transactional memory, or as database state distributed over time, but in an easy way […]

MySQL caching methods and tips

“The least expensive query is the query you never run.” Data access is expensive for your application. It often requires CPU, network and disk access, all of which can take a lot of time. Using less computing resources, particularly in the cloud, results in decreased overall operational costs, so caches provide real value by avoiding […]

Flexviews – part 3 – improving query performance using materialized views

Combating “data drift” In my first post in this series, I described materialized views (MVs). An MV is essentially a cached result set at one point in time. The contents of the MV will become incorrect (out of sync) when the underlying data changes. This loss of synchronization is sometimes called drift. This is conceptually […]