I've a self hosted wordpress blog. The server showing internal (500) server error and usually the system admins ask me to optimize my database. The database is relatively small in size and fits in few MBs. The error usually displaying is Fast CGI process.
The usual reply from admins are as below
As we have checked and found that you are using Mysql database and fetching database through php code from database server which is at remote location and in this process when queries are being more then PHP fast cgi application get hanged and that's why you are getting this issue, For this you should check code or database optimization
How can I optimize my database? I've installed a wordpress plugin to optimize my tables. Or is it a server problem?