Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Cannot Reproduce
-
Affects Version/s: 10.0.11
-
Fix Version/s: 10.0.13
-
Component/s: None
-
Labels:None
-
Environment:Windows 7 Professional (64-bit)
MariaDB 10.0.11 (32-Bit)
MariaDB 5.5.37 (32-Bit)
Description
(MariaDB 5.5.37 32-bit)
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 16 Server version: 5.5.37-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> Drop Database If Exists `acc-001`; Query OK, 0 rows affected (0.01 sec) MariaDB [(none)]> Create Database `acc-001`; Query OK, 1 row affected (0.00 sec) c:\Users\chin\tmp>mysql -h localhost -P 3309 -u root -p -B acc-001 < sql.sql Enter password: ********** StartProcess 2014-05-15 10:05:13 EndProcess 2014-05-15 10:05:28 ProcessTotalTime 00:00:16
(MariaDB 10.0.11 32-bit)
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 5 Server version: 10.0.11-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> Drop Database If Exists `acc-001`; Query OK, 0 rows affected, 1 warning (0.00 sec) MariaDB [(none)]> Create Database `acc-001`; Query OK, 1 row affected (0.00 sec) c:\Users\chin\tmp>mysql -h localhost -P 3310 -u root -p -B acc-001 < sql.sql Enter password: ********** StartProcess 2014-05-15 10:08:20 EndProcess 2014-05-15 10:09:03 ProcessTotalTime 00:00:43
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
-
- Open
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Hi,
I turn off the performance schema and restart mariaDB 10.0.11 (32-bit).
Test result is same.
Enter password: ********** Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 10.0.11-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@performance_schema; +----------------------+ | @@performance_schema | +----------------------+ | 0 | +----------------------+ 1 row in set (0.00 sec) MariaDB [(none)]> Drop Database If Exists `acc-001`; Query OK, 415 rows affected (58.43 sec) MariaDB [(none)]> Create Database `acc-001`; Query OK, 1 row affected (0.00 sec)
Setting environment for MariaDB 10.0
C:\windows\system32>cd c:\users\chin\tmp c:\Users\chin\tmp>mysql -h localhost -P 3310 -u root -p -B acc-001 < sql.sql Enter password: ********** StartProcess 2014-05-15 21:11:23 EndProcess 2014-05-15 21:12:08 ProcessTotalTime 00:00:45
Reproducible with MariaDB-10.0.10, but not with 10.0.11. MySQL-5.6.17 is also fast. Does not depend on performance_schema, InnoDB/XtraDB or --innodb-file-per-table.
The provided SQL script creates 415 tables. Sometimes a single CREATE TABLE statement needs several seconds, but this is not consistent. A "slow" MariaDB sever uses significantly less cpu; in top this shows as 12% vs. 2% (fast vs. slow version).
might be related
Tested with MariaDB 10.0.13 and win32. I could not reproduce the issue.
Hi,
Do you have performance schema enabled in your 10.0 instance? (It is ON by default; you can check it by running SELECT @@performance_schema).
If it is ON, could you please turn it OFF in your ini file, restart the server, and try your SQL again?
Thanks.