vb.org Archive - Unwanted tables getting created at mysql.

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

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

- - Unwanted tables getting created at mysql. (https://vborg.vbsupport.ru/showthread.php?t=172625)

donal

03-10-2008 03:19 PM

Unwanted tables getting created at mysql.

1 Attachment(s)

I dont know why unwanted tables get created at mysql. These make my site slow and I have to remove them from time to time.

Sometimes there have been more then 1000 such tables which took me whole day to delete.

How can I get rid of this problem.

Farcaster

03-10-2008 04:30 PM

No, those are tables that he is talking about. And I would imagine that they are probably making his site slow because they are being stored in memory (HEAP). I've never noticed vBulletin creating any temp tables like that. Out of curiosity, does the mySQL login you are using for vBulletin have DROP TABLE permissions? Perhaps these aren't getting cleaned up because vBulletin cannot drop the tables.

Opserty

03-10-2008 04:48 PM

Ah yeah your right.

Anyway I found some info:

http://www.vbulletin.com/forum/showthread.php?t=259558
http://www.vbulletin.com/forum/showthread.php?p=1506511

Check your MySQL login permissions basically.

donal

03-11-2008 12:51 AM

1 Attachment(s)

I checked and found that I have drop table permission.

Dismounted

03-11-2008 05:30 AM

Are your vBulletin scheduled tasks running?

donal

03-11-2008 06:43 AM

Quote:

Originally Posted by Dismounted (Post 1462047)

Are your vBulletin scheduled tasks running?

Yes they are running fine. I tried to run them manually and found no problem.

All times are GMT. The time now is 02:38 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01544 seconds Memory Usage 1,717KB 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 (6)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: