I setup a linux ubuntu machine with mysql 5.1.37, php 5.2.10 and apache 2.2.12.
So the problem is: in developing with phprunner no problem with query etc. All is fast etc.
When I put the page on the server instead, the login process go well, also the administration pages (who take users from mysql), but at time I want to view the record in the other database tables (it's the same how much record they has, 100, 1000 or 100000 nothing change), mysql process goes to 100% cpu and php page stop to work. The browser continue to loading the page but nothing happen.
The apache don't hang because I have some other virtual domain and all is well.
If I close the browser tab and try to reopen, nothing happen. The browser try to load the login page, but nothing happen.
The login page has new access only if I restart the mysql server.
Any hints?
Regards.