Results 1 to 9 of 9
-
28th Feb 2011, 10:34 AM #1OPBannedWebsite's:
SKDown.Net WarezGuru.Org RARdownload.netmysql auto repair table upon crash
many times, i see my forum down due to corrupted table, mostly the session table.
is there anyway to automatically repair tables when they are detected/marked as corrupted?tdsii Reviewed by tdsii on . mysql auto repair table upon crash many times, i see my forum down due to corrupted table, mostly the session table. is there anyway to automatically repair tables when they are detected/marked as corrupted? Rating: 5
-
28th Feb 2011, 12:44 PM #2Member
What forum script are u using
-
28th Feb 2011, 12:49 PM #3OPBannedWebsite's:
SKDown.Net WarezGuru.Org RARdownload.netproblem happened in both ipb and vb and both in session table. remember session table is memory and on vps we always have memory issues.
-
28th Feb 2011, 01:00 PM #4Respected DeveloperWebsite's:
wrzc.orgSounds to me like your looking for a pump to remove water from a leak. Would the obvious thing not be to fix the leak and cause of the problem?
Remove some memory heavy functions or upgrade your server. Relying on a script to repair corrupted tables is a bad idea.Tutorial How to SEO your Warez Site a guide to help you increase your organic traffic
Huge list of Warez Sites and free Multiposter Templates
-
28th Feb 2011, 02:39 PM #5OPBannedWebsite's:
SKDown.Net WarezGuru.Org RARdownload.netyour correct, but nothing much i can do with 512ram of memory on a heavy site
-
28th Feb 2011, 05:58 PM #6Respected Member
I would suggest putting the sessions back to MyIsam from memory. That works well if you have a lot of memory and a large number online.
But it will crash a lot on a vps with minimal memory. That is why IPB made it using MyIsam in the first place.
-
28th Feb 2011, 06:03 PM #7
-
28th Feb 2011, 11:53 PM #8Member
an loop
CHECK TABLE foreach table msg !=ok repair, optimize
or
PHP Code:$alltables = mysql_query("SHOW TABLES");
while ($table = mysql_fetch_assoc($alltables))
{
foreach ($table as $db => $tablename)
{
mysql_query("OPTIMIZE TABLE '".$tablename."'")
or die(mysql_error());
echo $tablename." Opmizide<br />";
}
foreach ($table as $db => $tablename)
{
mysql_query("REPAIR TABLE '".$tablename."'")
or die(mysql_error());
echo $tablename." Repaired<br />";
}
}
-
1st Mar 2011, 12:00 AM #9OPBannedWebsite's:
SKDown.Net WarezGuru.Org RARdownload.netjomasaco thanks for the code
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
How to repair all MySQL databases on a server in one go
By Albert.Nawaro in forum Tutorials and GuidesReplies: 0Last Post: 9th Feb 2012, 12:02 PM -
mySQL Memory Table problems.
By TechPro in forum Technical Help Desk SupportReplies: 2Last Post: 31st Oct 2011, 09:11 AM -
"-" sign on mySQL table value , Information needed!
By TechPro in forum Webmaster DiscussionReplies: 0Last Post: 26th Sep 2011, 06:47 AM -
mysql table corrupted vb4
By themude in forum vBulletinReplies: 17Last Post: 21st Sep 2010, 12:42 PM -
HINT: Visually view a mysql table
By litewarez in forum Tutorials and GuidesReplies: 1Last Post: 22nd May 2009, 02:30 PM
themaCreator - create posts from...
Version 3.17 released. Open older version (or...