idx_session

[aladdin1]

Hello,

I have a problem with idx_session table, it crash, and when it does happen I can not reach my database to delete and rebuild the table using phpMyAdmin, I also got the following error message:

Warning: mysql_connect(): User eguncom_indexu has already more than 'max_user_connections' active connections in /home/eguncom/public_html/lib/adodb/adodb-mysql.inc.php on line 76

I need to delete and rebuild that table using a php script but I do not know how to do it, your assistance would be appreciate.

[aladdin1]

Hello,

I have a problem with idx_session table, it crash, and when it does happen I can not reach my database to delete and rebuild the table using phpMyAdmin, I also got the following error message:



I need to delete and rebuild that table using a php script but I do not know how to do it, your assistance would be appreciate.

Hello,

I am still having some problems with my idx_session table for some reason I accumulate a lots of "overhead" and I think that is why that table malfunction every so often, I optimize that table few days ago and I already have almost 200,000 byte overhead, is there a solution to this problem? If not how could a create a cron job to optimize that table every so often?

[dody]

Try not to use persistent connection. If you have dedicated/vds, you may increase the number of allowed connection in mysql setting.