Search Results for: how do mysql views work

More on MySQL transaction descriptors optimization

Since my first post on MySQL transaction descriptors optimization introduced in Percona Server 5.5.30-30.2 and a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark results in both posts look rather different. We were curious as well, so we tried to answer that question by retrying benchmarks on […]

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 […]

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 […]

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 […]