Search results

Hmm, i tried different innodb options 'innodb_flush_log_at_trx_commit' and 'innodb_flush_method' but LXC still takes more than 30secs to create the database. So the solution for me is to switch from LXC to VM, this will speed up from 30sec to 15sec (12sec with writeback). I think 12-15sec is...

I did some further tests with cache modes and the VM none: 15sec writeback: 12sec writeback (unsafe): 2sec write through: 17sec directsync: 15sec Hmm, writeback (unsafe) has sweet results :-) I'll check some InnoDb/MySQL options for LXC....

Sorry, the cache options are only available for VMs. Is there also some option for LXC?

Ahh, I found the cache options for the LXC containers hard drives. On my use case it's important to quickly create the database (this is done multiple times) - a "small" data lose is acceptable. What caching option do you suggest for LXC and the MySQL use case? Thank you so much!

root@prox4m2 / # qm config 100 Configuration file 'nodes/prox4m2/qemu-server/100.conf' does not exist root@prox4m2 / # pct config 100 arch: amd64 cpulimit: 6 cpuunits: 1024 hostname: testing1 memory: 8192 net0...

Here a test of another vhost provider (jiffybox). The DB creation tooks about 3 secs. There *should be* no SSD. root@f2:~# dd if=/dev/urandom of=/root/random.txt bs=1048576 count=200 200+0 records in 200+0 records out 209715200 bytes (210 MB) copied, 19.4171 s, 10.8 MB/s root@f2:~# dd...

Thank you so much for your help! Attached the results with direct,dsync options: Proxmox VM root@vm:~# dd if=/mnt/ram/random.txt of=/root/test.txt bs=1M oflag=direct,dsync 200+0 records in 200+0 records out 209715200 bytes (210 MB) copied, 12.2254 s, 17.2 MB/s Proxmox LXC root@f10:~# dd...

Here are the missing tests on the host: root@prox4m2 ~ # mkdir /mnt/ram; mount -t ramfs ramfs /mnt/ram root@prox4m2 ~ # free -m total used free shared buffers cached Mem: 32003 14503 17500 71 190 11027 -/+ buffers/cache...

I created a random (200 MB) ram file using: mkdir /mnt/ram; mount -t ramfs ramfs /mnt/ram dd if=/dev/urandom of=/mnt/ram/random.txt bs=1048576 count=200 And copied it with via dd dd if=/mnt/ram/random.txt of=/root/test.txt Hope thats ok. Results: LXC (without ramdisk - not possible in LXC?)...

Hi Wolfgang, thanks for your reply! It's a vanilla debian jessie installation on the host and guest(s). The host system is using ext4 and software raid 1. I used this tutorial to setup the host: https://pve.proxmox.com/wiki/Install_Proxmox_VE_on_Debian_Jessie root@prox4m2 ~ # df Filesystem...

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

Hallo Zusammen, ich habe gerade auf einem neuen Hetzner Server (EX41) Proxmox 4 frisch installiert. Irgendwie ist das Anlegen der Datenbank Struktur (InnoDb mit ForeignKeys) extrem langsam. Die SQL Datei (40kb) enthält nur die Datenbank Struktur keine Daten. Anbei ein paar Vergleichswerte...