Connection speed problems
Posted: Thu Feb 01, 2007 2:44 am
Hello, I have a php program on its dedicated server, but it works very slowly even on the localhost. I need your help to find out where the problem is.
The server has 1 GB ram, Ubuntu Edgy, Apache 2.0.55, php 5.1.6, mysql 5.0.24a-9, php-mysql 5.0.24a-9. The program uses Adodb library, but phpMyAdmin is just as slow, so the problem is elsewhere. There is no update to php mysql client for Edgy.
In my.cnf the settings are more than I actually need:
skip-name-resolve
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
query_cache_limit = 2M
query_cache_size = 50M
query_cache_type = 1
I made a query test, medium complicated. On my windows test machine it takes 0.5-1 sec to execute. On linux mysql console 0.26 sec. But from PMA and from the program it's about 13 sec when not cached. So I suspect php-mysql connection problems. But how do I solve this?
TIA
The server has 1 GB ram, Ubuntu Edgy, Apache 2.0.55, php 5.1.6, mysql 5.0.24a-9, php-mysql 5.0.24a-9. The program uses Adodb library, but phpMyAdmin is just as slow, so the problem is elsewhere. There is no update to php mysql client for Edgy.
In my.cnf the settings are more than I actually need:
skip-name-resolve
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
query_cache_limit = 2M
query_cache_size = 50M
query_cache_type = 1
I made a query test, medium complicated. On my windows test machine it takes 0.5-1 sec to execute. On linux mysql console 0.26 sec. But from PMA and from the program it's about 13 sec when not cached. So I suspect php-mysql connection problems. But how do I solve this?
TIA