I have Windows 7, VMware Worstation 7, and Ubuntu Hardy 8.04 client (I tried 64 bit client and 32). I have gotten phpmyadmin running on the host under Apache. I have changed the config.inc.php to add multiple hosts so I can access my MySQL instance running on a VMware Ubuntu Hardy client.
It is terribly slow. It takes 13 seconds to switch from one table to another. I have tried different instances of Ubuntu running different instances of MySQL. I have allocated 512 MB and also tried 1 GB 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 idea?
Best Answer
I fixed it, well Google fixed it, it's always Google or Stackoverflow that fix it!
I added
skip-name-resolve
to my.cnf in the [mysqld] section and thank goodness it worked! It now flies. It has taken me all day to get this development environment up and running, hopefully it will help someone else.
Cheers
Rich