#1 (permalink)  
Old 05-31-2006, 10:55 AM
Active Member
 
Join Date: Feb 2004
Posts: 439
aladdin1 is on a distinguished road
Default idx_session

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:

Code:
Content visible to License Owner only.
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.
  #2 (permalink)  
Old 06-16-2006, 03:05 PM
Active Member
 
Join Date: Feb 2004
Posts: 439
aladdin1 is on a distinguished road
Default

Code:
Content visible to License Owner only.
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?
  #3 (permalink)  
Old 06-17-2006, 06:45 PM
dody's Avatar
Nicecoder Team
 
Join Date: Aug 2001
Location: Indonesia
Posts: 3,292
dody is a name known to alldody is a name known to alldody is a name known to alldody is a name known to alldody is a name known to alldody is a name known to all
Default

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

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

HACKER SAFE certified sites prevent over 99.9% of hacker crime.

All times are GMT -5. The time now is 03:31 PM.


Powered by vBulletin®
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO
SSL Certificate