I was still new to the server, I have a hosting server, the specification DUAL CORE CPU, 4GB RAM, 500GB HDD.
I use OS Centos 5 64bit, Kloxo Panel, Apache Web Server & MySQL sevrer.
I have a problem, MySQL service I often suddenly die alone, especially when I try to do as much as 10-20 times the mysql_query command simultaneously, but I see only the status of unused RAM Memory <512MB, 3GB left over. How do I optimize my MySQL server to be able to do a lot of queries and sequential, 100 a query for example. Please help. Thank you