by kuszmaul | Jul 9, 2012 | MySQL
Solving the Challenges of Big Databases with MySQL When you’re using MySQL for big data (more than ten times as large as main memory), these challenges often arise: loading data fast; maintaining indexes under insertions deletions, and updates; adding and removing...
by Tokutek | Jul 5, 2012 | MySQL
… Ya se que estás piantao, piantao, piantao… For my lastest blog, a review of the MySQL, NoSQL and Cloud Conference, I’ll continue to use the tango metaphor. Balada para un loco (ballad for a crazy one) is a Piazzola classic and explains what I think of Santiago...
by Alexey Stroganov | Jul 5, 2012 | Benchmarks, MySQL
MySQL server intensively uses dynamic memory allocation so a good choice of memory allocator is quite important for the proper utilization of CPU/RAM resources. Efficient memory allocator should help to improve scalability, increase throughput and keep memory...
by Zardosht.Kasheff | Jul 3, 2012 | MySQL
In my last post, I wrote that I observed many similarities between TokuDB and MySQL Cluster. Many features that benefit TokuDB also benefit MySQL Cluster, and vice versa, with Hot Column Addition and Deletion (HCAD) being an example. Over my next few posts, I expand...
by Stewart Smith | Jul 1, 2012 | Insight for DBAs, MySQL
When executing an ALTER TABLE, InnoDB (and XtraDB) will create two InnoDB transactions: One transaction is created when the table being ALTERed is locked by the server. This will show up as something like “TABLE LOCK table schema.table_name trx id XXXX lock mode...
by Miguel Angel Nieto | Jun 30, 2012 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
I wrote one week ago about how to find duplicate indexes. This time we’ll learn how to find unused indexes to continue improving our schema and the overall performance. There are different possibilites and we’ll explore the two most common here. User...
by Stewart Smith | Jun 28, 2012 | Percona Software
Due to a bug in upstream MySQL ( http://bugs.mysql.com/bug.php?id=65745 ), we’ve decided to delay the release of the next Percona Server release until it is resolved. We had originally expected to release Percona Server 5.5.25-27.0 today and instead I’m...
by Rich.Prohaska | Jun 28, 2012 | MySQL
Table optimization is a necessary evil; tables sometimes need to be optimized to reclaim space or to improve query performance. Unfortunately, MySQL blocks writes to a table while it is being optimized. Because optimization time is proportional to the table size,...
by Peter Zaitsev | Jun 28, 2012 | Insight for DBAs, MySQL
I did a Webinar about MySQL Upgrade – Best Practices Yesterday and there were some questions we could not answer during Webinar, following Jay’s Lead I decided to post them as a Blog Post. Q: Can you go directly MySQL 5.0 to 5.5 for MyISAM tables? MyISAM...
by Peter Zaitsev | Jun 27, 2012 | Insight for DBAs, MySQL
Today I was looking at the ALTER TABLE performance with fast index creation and without it with different buffer pool sizes. Results are pretty interesting. I used modified Sysbench table for these tests because original table as initially created only has index on...
by Bill Karwin | Jun 27, 2012 | MySQL, Percona Events
Looking for a great opportunity to share your MySQL knowledge with the MySQL community? Here is your chance. Percona is happy to announce that the dates of the Percona Live MySQL London Conference have been set for Dec. 3-4, 2012. Call for speakers is underway and...
by Tokutek | Jun 25, 2012 | MySQL
Volver, con la frente marchita, las nieves del tiempo platearon mi sien… Martin’s blog (Mi Buenos Aires Querido) was named after a tango, so I decided to follow his lead. The 4 lines of the refrain make reference to someone returning to Buenos Aires after...
by Hrvoje Matijakovic | Jun 25, 2012 | MySQL
Percona is glad to announce the release of Percona XtraBackup 2.0.1 on June 25th, 2012. Downloads are available from our download site and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.0 series. This...
by Stewart Smith | Jun 24, 2012 | Percona Software
Where does software go while it’s waiting for release? The answer is: our experimental repository! For anywhere from a few days to a week before we release them, we stage our software releases in the TESTING download area and in separate software repositories...
by Ovais Tariq | Jun 22, 2012 | Benchmarks, Insight for DBAs, MySQL
Suppose you have turned on innodb_file_per_table (which means that each table has its own tablespace), and you have to drop tables in a background every hour or every day. If its once every day then you can probably schedule the table dropping process to run during...
by Zardosht.Kasheff | Jun 21, 2012 | MySQL
As a TokuDB storage engine developer, numerous times I’ve been struck by the similarities between MySQL Cluster and TokuDB. Namely, many times where I find myself thinking, “TokuDB would benefit from this feature”, I also end up thinking “MySQL...
by Ernie Souhrada | Jun 21, 2012 | Insight for DBAs, MySQL
The MySQL manual tells us that regardless of whether or not we use “SET FOREIGN_KEY_CHECKS=0” before making schema changes, InnoDB will not allow a column referenced by a foreign key constraint to be modified in such a way that the foreign key will...
by Peter Zaitsev | Jun 21, 2012 | Insight for DBAs, MySQL
When I’m doing conventional ALTER TABLE in MySQL I can ignore default value and it will be assigned based on the column type. For example this alter table sbtest add column v varchar(100) not null would work even though we do not specify default value. MySQL...
by Miguel Angel Nieto | Jun 20, 2012 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Having duplicate keys in our schemas can hurt the performance of our database: They make the optimizer phase slower because MySQL needs to examine more query plans. The storage engine needs to maintain, calculate and update more index statistics DML and even read...
by Peter Boros | Jun 20, 2012 | MySQL, Percona Software
This post is a step-by-step guide to set up Percona XtraDB Cluster (PXC) in a virtualized test sandbox. I used Amazon EC2 micro instances, but the content here is applicable for any kind of virtualization technology (for example VirtualBox). The goal is to give step...
