EmergencyEMERGENCY? Get 24/7 Help Now!

Copying InnoDB tables between servers

 | July 31, 2009 |  Posted In: Percona Software

The feature I announced some time ago https://www.percona.com/blog/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now I am going to show how to use it (the video will be also available on percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we want to copy order_line […]

Read More

Autoincrement Semantics

 | July 29, 2009 |  Posted In: Tokutek, TokuView

In this post I’m going to talk about how TokuDB’s implementation of auto increment works, and contrast it to the behavior of MyISAM and InnoDB. We feel that the TokuDB behavior is easier to understand, more standard-compliant and offers higher performance (especially when implemented with Fractal Tree indexes). In TokuDB, each table can have an […]

Read More

5.0.83-build17 Percona binaries

 | July 28, 2009 |  Posted In: Percona Software

Dear Community, The build 17 of MySQL with Percona patches is available. New features in the release: MySQL-5.0.83 is taken as the basis The new patch innodb_use_sys_malloc.patch is added The new patch innodb_split_buf_pool_mutex.patch is added This patch splits the single global InnoDB buffer pool mutex into several mutexes for different purposes. This reduces mutex contention. […]

Read More

Maatkit Now Supports Memcached

 | July 24, 2009 |  Posted In: Insight for Developers

Have you ever wondered how optimized your Memcached installation is? There is a common misconception that one doesn’t have to think too deeply about Memcached performance, but that is not true. If your setup is inefficient, you could: Burn Memory Waste Network Round-Trips Store Keys That Never Get Retrieved Have a Low Cache Hit Ratio […]

Read More

XtraDB storage engine release 1.0.3-6

 | July 20, 2009 |  Posted In: Percona Software

Dear community, Today we are pleased to announce release 6 of XtraDB – the result of 2 months hard work. The release includes following new features: MySQL 5.1.36 as a base release New patch

Experimental adaptive checkpoint method estimate innodb_stats – the implementation of the fix forMySQL Bug#30423 expand-import Support of import InnoDB / […]

Read More

Recovery after DROP [ TABLE | DATABASE ]

 | July 19, 2009 |  Posted In: Insight for DBAs

In your recovery practice we often face the problem when data lost by execution DROP TABLE or DROP DATABASE statement. In this case even our InnoDB Data Recovery tool can’t help, as table / directory with files was deleted (if you have innodb-file-per-table). And the same for MyISAM, all .MYD / .MYI / .frm – […]

Read More

Crashes while using MyISAM with multiple key caches

 | July 18, 2009 |  Posted In: Insight for DBAs

Over last couple of years I have ran into random MySQL crashes in production when multiple key caches were used. Unfortunately this never was frequent or critical enough issue so I could spend time creating repeatable test case and search of the bug in the MySQL database did not find anything. Recently we had this […]

Read More

Percona BOFs at OSCON

 | July 18, 2009 |  Posted In: Events and Announcements

Talks are great. I however very much like discussion and opinion share atmosphere of the Birds of a Feather sessions so we host/co-host number of BOFs at the comming OSCON conference. Future of MySQL Forks, Branches and Patches I guess is the topic a lot of us are interested in. Monty was going to Show […]

Read More

Percona talks at OSCON

 | July 16, 2009 |  Posted In: Events and Announcements

The OSCON 2009 is taking place next week and we have bunch of talks we’re presenting. I am presenting Full Text Search with Sphinx, MySQL Community Patches and Extensions and Goal Driven Performance Optimization. Vadim and Ryan have a talk XTraDB OpenSource Storage Engine for MySQL. This month OSCON is taking place in Silicon Valley […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.