vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Crazy MySQL overheads?! (https://vborg.vbsupport.ru/showthread.php?t=257241)

BaussDesigns 01-16-2011 04:34 PM
Crazy MySQL overheads?!
 
Lately, my forum has started lagging hard and loading times have significantly increased (Well, in most cases it doesn't load the page at all). While other sites ran fine, I looked at my mysql DB figures and saw that:

http://www.upload.ee/image/1056559/overhead.png


I've tried repairing-fixing those tables, but it does nothing, the figures stay and for all those tables with 53mb overhead, it says "Note: Table does not support optimize, doing recreate + analyze instead".



Can anyone please assist me?

snakes1100 01-17-2011 09:11 PM
Those be INNODB tables, anal-ize those to rebuild/opt them.

benstillman 01-19-2011 06:20 PM
Quote:
Originally Posted by snakes1100 (Post 2150682)
Those be INNODB tables, anal-ize those to rebuild/opt them.
LOL

I'm slipping that into my next project report.


All times are GMT. The time now is 06:56 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00973 seconds
  • Memory Usage 1,711KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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