Repair / Optimize Tables - error.?

[Gamelobby]

My site is slow, very slow from time to time, & when i try to optimize the tables.. it has real issues, & i usually get an Internal Error page.



I can select a few to optimize, & it will work, but the first ones i notice to have problems is the
adv_links
adv_links_banners
etc..


So im wondering what these are..?
My guess is the vBAdvanced Links mod, but i haven't had that installed for a long time, i uninstalled it a long time ago, & i see no traces of it anywhere. (acp or server)

1. Any idea if in fact that is what these are.?
2. Any ideas on what else could be the problem, because even when i dont tick those, it can still give me errors.


Thanks

[Gamelobby]

Ok so even though i'd still like to know why the "Adv_Links" are still in the system, I was able to optimize them.

But I still can't run it on the whole list.. I went through and did each one individually, & had some errors on some, but at one point or another was able to get them all to go through. (i think)

Any idea why i cant run them all at once.?

[Lynne]

Those are from a modification. I would guess it wasn't uninstalled correctly, or there was no uninstall code and so you were supposed to remove them manually. You would have to go read the instructions for that modification to find out what you were supposed to do.

On my old server, I could not run repair/optimize on all the tables - I had to do them in groups. It was a php timeout issue, I believe. Well, and it also would kill my server loads which I didn't like to do.

[Gamelobby]

Thanks lynn, i'll check that out.


Also i just noticed that when i ran a diagnostic i did the System information>Table Status & the ones that were giving me issues were blank under "update time" & "check time" & also under "comments" it said:
InnoDB free: 0 kB

--------------- Added 1312574480 at 1312574480 ---------------

Update..

I found that some of the info in my config file was wrong, so i changed it (corrected it) & now i get this error...

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'NCJB327'@'184.168.193.22' (using password: YES)

/home/content/08/4856008/html/forums/includes/class_core.php on line 314

MySQL Error :
Error Number :
Request Date : Friday, August 5th 2011 @ 12:51:32 PM
Error Date : Friday, August 5th 2011 @ 12:51:33 PM
Script : http://**********.com/forums/admincp/index.php
Referrer : http://**********.com/forums/login.php?do=login
IP Address : 98.255.6.219
Username :
Classname : vB_Database
MySQL Version :

-->

Is it a db name that is wrong, or password, or something else..? (FYI, i'm 99.999999% positive the password is correct.)

--------------- Added 1312580480 at 1312580480 ---------------

Ok so even though i'd still like to know why the "Adv_Links" are still in the system, I was able to optimize them.

But I still can't run it on the whole list.. I went through and did each one individually, & had some errors on some, but at one point or another was able to get them all to go through. (i think)

Any idea why i cant run them all at once.?


Also on these columns that wont update they seem to all be related to search/content..

contenttype
searchcore
searchgroup
searchlog
tag
tagcontent
tagsearch


Any of this raise a flag to anyone..?

[Videx]

Who cares why they're in the system. If you don't have an advertising mod delete them (I assume you're making backups).

And the only reason to get a "access denied" error to your db is if the username or password is wrong. Just restore the config from your last monthly backup if you have to and start over.

[Gamelobby]

Who cares why they're in the system. If you don't have an advertising mod delete them (I assume you're making backups).

And the only reason to get a "access denied" error to your db is if the username or password is wrong. Just restore the config from your last monthly backup if you have to and start over.Appreciate the reply, but... I care why they are in the system. lol
Had i gone by your logic (and my guessing that it is a vBA mod), & deleted them because i dont have an advertising mod, i would have deleted my "links" mod. ;)


1st. I'm only guessing the "adv_links" is from vBAdvanced "Links" mod (maybe they are from an advertising mod. idk?) If i'm not sure what they are for, i dont know for sure if i'm using them or not. know what i mean.?

2nd. Yes access denied, was a username/pw issue that part is fixed.. but..

I'm still not able to run the "Repair / Optimize Tables" from the maintenance/acp. THAT is my main issue that i am trying to figure out.! (why i can't)

[Boofo]

Look at the Advanced links mod and see if it makes those tables on install. You can see in the xml. If it does, then that is where they are from. You have to remember to remove all files when uninstalling any mods (bitfield, as well as any others).

Also, like Lynne said, if you db is big enough, it can time out when try to do all the tables at once.

[Gamelobby]

Yea i am looking into the "adv_links" but they aren't the ones that time-out, (as i previously thought they were the culprit.. after testing i found that they were able to run fine)


It's the others that time-out almost every time by themselves.


contenttype
searchcore
searchgroup
searchlog
tag
tagcontent
tagsearch


If i go to repair/optimize, then select ALL, then un-check those 7 it'll run fine. but if i run any one of those 7 tables individually they time-out (nine out of ten times)
So i can only guess that they are more of an issue than the adv_links.

Sorry to confuse you all, but as always i do appreciate the help. :D

[Boofo]

IIRC, those tables you listed don't handle repair and optimize. I get a message on each one about having to do something else with those tables other than repair and optimize. I will try to capture the message the next time I see it.

How big is your db?

[Gamelobby]

Not sure how big.. I know it is less than 1GB, cuz thats the limit. lol
Where can i find that info.?

[Videx]

Where can i find that info.?When you back it up every day, for one. Though it does compress a lot. My db is 743mb but downloads daily as a .gz at 129mb.

[Gamelobby]

Honestly since they took that option out of the ACP, i haven't backed it up hardly at all.. except once or twice server side.

Here is whats listed in the _db_backups folder..
.sql = 82,030,006
.sql.log = 41