VMWare MySQL very slow
Posted by:
Rich Jones
Date: November 08, 2010 11:01PM
Hi all,
I have Windows 7, VMWare Worstation 7 and Ubunto Hardy 8.04 client (I tried 64 bit client and 32). I have got phpmyadmin running on the host under apache. I have changed the config.inc.php to add multiple hosts and so I can access my MySQL instance running on a VMWare Ubunto Hardy client.
It is terribly slow. It takes 13 seconds to switch from one table to another. I have tried different instances of Ubunto running different instances of MySQL. I have allocated 512Mb and also tried 1Gb memory. Top says the system is doing nothing.
Same problem on all. I tried changing from NAT to Host Network to Bridged Network. They all work but they are all equally as slow. I saw someone saying they had problems with non matching names in /etc/hostname and /etc/hosts so I have checked them. I access the host with hostname:
taer12
I have that in hostname and also in /etc/hosts.
top - 15:52:55 up 30 min, 2 users, load average: 0.00, 0.00, 0.00 Tasks: 55 total, 1 running, 54 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 515432k total, 110748k used, 404684k free, 4980k buffers Swap: 915664k total, 0k used, 915664k free, 64720k cached
Has anyone got any other ideas?
Thanks in advance
Rich