One of my database tables in MySQL that my phpbb forum runs on, is corrupted. It's named "phpbb_posts".
The thing is, when I go into phpmyadmin and do a Check Tables in the database, it keeps saying that the table is corrupted and shows this error message:
Either that, or it times out and produces an error message. When I try to use the Repair Tables function, it also times out and produces an error message too. I tried this many times last night. But the problem is still there.[happier2_HappierAbroad.phpbb_posts] warning: Size of indexfile is: 275487744 Should be: 275486720
Does anyone know what's wrong with that table and how to fix it?
On another issue, sometimes the forum times out and produces this message:
What does that mean? The forum is supposed to be able to handle hundreds of users at once right? So what is maxing out exactly? Is this connected to the corrupt database table problem?"already has more than 'max_user_connections' active connections"
Also, my hosting space was running low and was at 90 percent full. Could that cause the max out connections too? I already freed up some disk space to see if it helps.
One more question. How are those big forums that have thousands of guests and users on at once, able to handle all that? What do they do differently?