by Justin Swanhart | May 22, 2013 | Benchmarks, MySQL
This blog post is part two in what is now a continuing series on the Star Schema Benchmark.In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered... by Peter Zaitsev | Dec 1, 2010 | MySQL, Percona Events
We had some technical difficulties with Webex today which prevented from all registered attendees to be able to join webinar. I personally would be very upset having booked my time to attend event, pre-registered to ensure there is a space available and when unable to... by Peter Zaitsev | Nov 22, 2010 | MySQL, Percona Events
I do not know if it is because we’re hosting a free webinar on migrating MyISAM to Innodb or some other reason but recently I see a lot of questions about migration from MyISAM to Innodb. Webinar will cover the process in a lot more details though I would like... by Baron Schwartz | Nov 8, 2010 | MySQL, Percona Events
Register now for a free Percona webinar about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 at 9:00 AM PST (California) time.Update: the date was originally listed as December 2nd, but that was a mistake. It’s December 1st.We know that... by Peter Zaitsev | Jan 12, 2009 | Insight for DBAs
There is significant portion of customers which are still using MyISAM when they come to us, so one of the big questions is when it is feasible to move to Innodb and when staying on MyISAM is preferred ?I generally prefer to see Innodb as the main storage engine... by Peter Zaitsev | Sep 3, 2008 | Insight for DBAs
Following up on my Previous Post I decided to do little test to see how accurate stats we can get for for Index Stats created by ANALYZE TABLE for MyISAM and Innodb.But before we go into that I wanted to highlight about using ANALYZE TABLE in production as some people... by Vadim Tkachenko | Oct 12, 2007 | Uncategorized
We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not escalate MyISAM scalability question. This time working on... by Vadim Tkachenko | Jan 8, 2007 | Benchmarks
Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM... by Peter Zaitsev | May 29, 2006 | Benchmarks
We had discussion today which involved benchmarks of Join speed for MyISAM and Innodb storage engines for CPU bound workload, this is when data size is small enough to fit in memory and so buffer pool. I tested very simple table, having with about 20.000 rows in it on... by Peter Zaitsev | Feb 25, 2020 | MySQL, Storage Engine
Sometimes, you may experience “ERROR 1034: Incorrect key file” while running the ALTER TABLE or CREATE INDEX command: Shell mysql> alter table ontime add key(FlightDate); ERROR 1034 (HY000): Incorrect key file for table 'ontime'; try to repair it 12... by Carlos Tutte | Dec 26, 2019 | MySQL, Storage Engine
One of our support customers approached us with the following problem the other day: Shell mysql> CREATE TABLE child_table ( `id` int unsigned auto_increment, `column1` varchar(64) NOT NULL, parent_id int unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT FOREIGN... by Sveta Smirnova | Jun 17, 2016 | MySQL
What is the difference between InnoDB locks and transaction isolation level? We’ll discuss it in this post.Recently I received a question from a user about one of my earlier blog posts. Since it wasn’t sent as a comment, I will answer it here.... by Peter Zaitsev | Mar 22, 2016 | MySQL
This blog discusses how TokuDB impacts InnoDB performance when the two run in the same environment.You would think MySQL storage engines are fairly independent of each other, even in the same environment. Enabling one, or changing its configuration, logically should... by Peter Zaitsev | Jan 19, 2015 | Benchmarks, MySQL, Percona Software
A few days ago I wrote about MySQL performance implications of InnoDB isolation modes and I touched briefly upon the bizarre performance regression I found with InnoDB handling a large amount of versions for a single row. Today I wanted to look a bit deeper into... by Fernando Laudares Camargos | Aug 22, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
In my last post, “ by Frederic Descamps | May 28, 2014 | Insight for DBAs, MySQL
There is one new feature in MySQL 5.6 that didn’t get the attention it deserved (at least from me 😉 ) : “DATA DIRECTORY” for InnoDB tables.This is implemented since MySQL 5.6.6 and can be used only at the creation of the table. It’s not... by Yves Trudeau | May 23, 2014 | Benchmarks, Hardware and Storage, Insight for DBAs, MySQL, Percona Live
Update: do not do this, this has been proven to corrupt data! During April’s Percona Live MySQL Conference and Expo 2014, I attended a talk on MySQL 5.7 performance an scalability given by Dimitri Kravtchuk, the Oracle MySQL benchmark specialist. He mentioned at... by Muhammad Irfan | Sep 20, 2013 | MySQL
I recently stumbled upon a post that Peter Zaitsev published back in 2007 titled “Innodb Performance Optimization Basics.” It’s a great post and reading it inspired me to examine what’s changed in the nearly six years that have followed in... by Nickolay Ihalainen | Sep 11, 2013 | Insight for DBAs, MySQL
This post focuses on the problem of the InnoDB log sequence number being in the future. Preface: What is an InnoDB log sequence number? The log sequence number (LSN) is an important database parameter used by InnoDB in many places. The most important use is for... by Vadim Tkachenko | Sep 5, 2013 | Benchmarks, MySQL
This post is a continuation of my research of TokuDB’s storage engine to understand if it is suitable for timeseries workloads.While inserting LOAD DATA INFILE into an empty table shows great results for TokuDB, what’s more interesting is seeing some...