I've just set up a dediacted database server for my forums, and I'm very disapointed with the performance of it. Excript execution occasionally still occasionally takes up to 10 seconds and more. Both server load, and memory usage ob both the web and the database server is not unreasonable high at all. So I'm clueless what is the bottle neck here. The web server is a rather slow machine (AMD K6 500 CPU), but since server load is never above 1, I don't think the web server is bottle neck here. Both the web and the database server are located in the same rack. What I noticed when I ran "SHOW FULL PROCESSLIST" in mysql, that the state of nearly all querries always is "State: login". Could this be the reason? Here's an example: +-----+----------------------+-----------------------+---------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+----------------------+-----------------------+---------+---------+------+-------+-----------------------+ | 461 | ext | xxx.xxx.xxx.xxx:45180 | databse | Sleep | 0 | | NULL | | 463 | unauthenticated user | xxx.xxx.xxx.xxx::45183 | NULL | Connect | NULL | login | NULL | | 464 | unauthenticated user | xxx.xxx.xxx.xxx:45184 | NULL | Connect | NULL | login | NULL | | 465 | unauthenticated user | xxx.xxx.xxx.xxx:45185 | NULL | Connect | NULL | login | NULL | | 466 | unauthenticated user | xxx.xxx.xxx.xxx:45186 | NULL | Connect | NULL | login | NULL | | 467 | unauthenticated user | xxx.xxx.xxx.xxx:45188 | NULL | Connect | NULL | login | NULL | | 468 | unauthenticated user | xxx.xxx.xxx.xxx:45189 | NULL | Connect | NULL | login | NULL | | 469 | unauthenticated user | xxx.xxx.xxx.xxx:45190 | NULL | Connect | NULL | login | NULL | | 470 | unauthenticated user | xxx.xxx.xxx.xxx:45191 | NULL | Connect | NULL | login | NULL | | 471 | unauthenticated user | xxx.xxx.xxx.xxx:45192 | NULL | Connect | NULL | login | NULL | | 472 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST | +-----+----------------------+-----------------------+---------+---------+------+-------+-----------------------+ 11 rows in set (0.00 sec) Any ideas what to do?
Okay, for those who care, I found out what the problem was, mysql didn't knew what the web server was, so I had to add IP and name to /etc/hosts (FreeBSD).