Hi everyboy,
I have weird MySQL performance on my fresh Proxmox 4 installation / new server.
https://www.hetzner.de/us/hosting/produkte_rootserver/ex41
The creation of the database schema (InnoDb with ForeignKeys) is very slow.
The SQL file (40kb) only contains the structure and some foreign keys without any data.
Attached some measurements without any other load, fresh debian, no my.ini modifications:
Proxmox LXC Container:
root@lxc1:/root# time mysql test -u root -p < initialdb.sql
real 0m31.521s
user 0m0.012s
sys 0m0.004s
dd if=/dev/zero of=/tmp/test bs=1M count=1000 oflag=direct
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 0.386445 s, 2.7 GB/s
Proxmox VM :
root@vm1:~# time mysql -u root -p test < initialdb.sql
real 0m12.456s
user 0m0.004s
sys 0m0.000s
dd if=/dev/zero of=/tmp/test bs=1M count=1000 oflag=direct
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 0.405222 s, 2.6 GB/s
Desktop (Windows, older Hardware, VirtualBox)
root@jessie:/root# time mysql -u root -p test < initialdb.sql
real 0m2.195s
user 0m0.000s
sys 0m0.004s
dd if=/dev/zero of=/tmp/test bs=1M count=1000 oflag=direct
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 2.357 s, 445 MB/s
Any ideas about this big difference?
Thanks a lot for any tipps or help!
I have weird MySQL performance on my fresh Proxmox 4 installation / new server.
https://www.hetzner.de/us/hosting/produkte_rootserver/ex41
The creation of the database schema (InnoDb with ForeignKeys) is very slow.
The SQL file (40kb) only contains the structure and some foreign keys without any data.
Attached some measurements without any other load, fresh debian, no my.ini modifications:
Proxmox LXC Container:
root@lxc1:/root# time mysql test -u root -p < initialdb.sql
real 0m31.521s
user 0m0.012s
sys 0m0.004s
dd if=/dev/zero of=/tmp/test bs=1M count=1000 oflag=direct
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 0.386445 s, 2.7 GB/s
Proxmox VM :
root@vm1:~# time mysql -u root -p test < initialdb.sql
real 0m12.456s
user 0m0.004s
sys 0m0.000s
dd if=/dev/zero of=/tmp/test bs=1M count=1000 oflag=direct
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 0.405222 s, 2.6 GB/s
Desktop (Windows, older Hardware, VirtualBox)
root@jessie:/root# time mysql -u root -p test < initialdb.sql
real 0m2.195s
user 0m0.000s
sys 0m0.004s
dd if=/dev/zero of=/tmp/test bs=1M count=1000 oflag=direct
1000+0 records in
1000+0 records out
1048576000 bytes (1.0 GB) copied, 2.357 s, 445 MB/s
Any ideas about this big difference?
Thanks a lot for any tipps or help!
Last edited: