Hi !
I'm a novice mysql administrator and acording to my Web Hosting Provider, my mysql
daemon is loading the CPU too much. The web has currently two main php scripts
regarding the MySQL daemon.
The first one shows a banner using the PHPAdServer application ( no clicks are
registered, only shows the banner at the moment)
The second one is a poll system of my own, that "draw" a random poll from the database
( there are currently 9 polls) and if the user clicks the Vote button, the vote is
registered at the database.
These two scripts are in the main page of the web, that has received 40,000 hits since
the scripts have been incorporated, 15 days ago more or less... the max_connections
allowed by the mysql at the same time are 28.
What do you think it's the problem, an incorrect mysql configuration, the hosting
machine is a bit junkie or it's normal this CPU usage with these two mysql access ?
Here do you have the system statistics regarding the mysqld task
last pid: 69299; load averages: 9.82, 11.98, 12.69 up 6+20:14:16 19:44:01
602 processes: 13 running, 588 sleeping, 1 zombie
CPU states: 70.8% user, 0.0% nice, 29.2% system, 0.0% interrupt, 0.0% idle
Mem: 355M Active, 45M Inact, 85M Wired, 16M Cache, 61M Buf, 1544K Free
Swap: 1024M Total, 56M Used, 968M Free, 5% Inuse
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
510 gameswor 2 0 13804K 2844K poll 58.7H 39.75% 39.75% mysqld