MySQL Forums
Forum List  »  Performance

Exceedingly slow create table performance
Posted by: Ronald Van Iwaarden
Date: March 06, 2015 10:51AM

I tried this question in the MyISAM area since that is the engine we are using but am not getting much response there.

We are running MySQL version 5.1.73 on Redhat Linux 6.5 and are currently upgrading machines to RedHat 6.6 with the same version of MySQL. The current machine with RedHat 6.5 has perfectly acceptable performance for creating tables:

mysql> create table table1111 (id int);
Query OK, 0 rows affected (0.00 sec)

mysql>

The new machines are behaving exceptionally odd:

mysql> create table table1111 (id int);
Query OK, 0 rows affected (0.50 sec)

mysql>


Both machines are using ext4 with journaling enabled. Both have roughly identical hard drives, CPUs and memory. my.conf files are identical between the machines and inserts seem to have similar performance between the machines. In almost all other ways, compiling and running a large simulation package, the computers behave similarly and we are quite perplexed.

Does anyone have any suggestion as to what to do to determine why the behavior of these two machines is so dramatically different for creating tables within a database?

As a work around, I tried creating all the tables in parallel, using separate threads. It turned out to be slower with all the creates appearing to be serialized.

Our standard use pattern for MySQL is to create a very large database (8m rows) in a very short period of time (less than 2 minutes) and then execute a small number of queries against that database. The database is then cleaned and filled again, possibly with different tables or rows.

--Ron

Options: ReplyQuote


Subject
Views
Written By
Posted
Exceedingly slow create table performance
4061
March 06, 2015 10:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.