MySQL Forums
Forum List  »  MyISAM

poor create table performance
Posted by: Ronald Van Iwaarden
Date: March 04, 2015 02:29PM

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?

--Ron

Options: ReplyQuote


Subject
Views
Written By
Posted
poor create table performance
2883
March 04, 2015 02:29PM


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.