[MDEV-6241] MariaDB 10.0.11 (32-bit) Too Slow Create XtraDB Table 2.5x than MariaDB 5.5.37 (32-bit) Created: 2014-05-15  Updated: 2014-07-03  Resolved: 2014-07-03

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.11
Fix Version/s: 10.0.13

Type: Bug Priority: Major
Reporter: CHIN TAT LIM (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

Windows 7 Professional (64-bit)
MariaDB 10.0.11 (32-Bit)
MariaDB 5.5.37 (32-Bit)

Attachments: File sql.sql    
Issue Links:
Relates
relates to MDEV-5838 XtraDB more than x2 slower during cre... Closed

 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



 Comments   
Comment by Elena Stepanova [ 2014-05-15 ]

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.

Comment by CHIN TAT LIM (Inactive) [ 2014-05-15 ]

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

Comment by Axel Schwenke [ 2014-05-16 ]

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).

Comment by Axel Schwenke [ 2014-05-16 ]

might be related

Comment by Jan Lindström (Inactive) [ 2014-07-03 ]

Tested with MariaDB 10.0.13 and win32. I could not reproduce the issue.

Generated at Thu Feb 08 07:10:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.