vb.org Archive - mysql database repair

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - mysql database repair (https://vborg.vbsupport.ru/showthread.php?t=294334)

Chadi

01-24-2013 02:27 PM

mysql database repair

I've used the repair / optimize database feature in vbulletin admin panel but these below tables remain at the same size. Is this normal?

Last column is "overhead" which always remain at those values even if I do a repair/optimize

Code:

searchcore        14.52 MB        34.08 MB        4.00 MB

searchgroup         3.52 MB          4.52 MB         4.00 MB

searchlog          5.02 MB          48.0 KB         22.00 MB

tagcontent        18.55 MB        34.58 MB        7.00 MB

snakes1100

01-24-2013 05:30 PM

Those tables are innodb or should be unless you changed them from the default vb places on them, a repair/optimize doesnt work on innodb tables, so yes, there would be no change.

Chadi

01-24-2013 07:38 PM

How can I convert them to MyISAM safely and do a repair/optimize on them?

snakes1100

01-24-2013 08:12 PM

You dont need to repair/optimize them, you can do an analyse though, which will report any issues.

If your using the default vb search, i would not run them as myisam tables either, especially if you have a large amount of posts, as they are going to lock.

All times are GMT. The time now is 09:25 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01208 seconds Memory Usage 1,716KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: