You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » General Assistance (How Do I?) » Optimzation
Register User    Portal Page     Forum List        Calendar     Active Topics     Search     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
4 registered (Dj Aero, capnbob, Morgan, id242), 46 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/12/04
Posts: 154
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 18
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#177391 - 02/03/07 08:52 PM Optimzation
Stan Offline

old hand 		Registered: 06/05/06
Posts: 708
When does the mysql get optimize?

Is that just 'done' or is it something we have to do manually now?
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#177392 - 02/03/07 09:29 PM Re: Optimzation [Re: Stan]
Gizmo Online cat

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
You have to do it manually.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#177400 - 02/03/07 09:49 PM Re: Optimzation [Re: Gizmo]
Stan Offline

old hand 		Registered: 06/05/06
Posts: 708
Oh Oh..

What is the command for that...
Top
#177401 - 02/03/07 09:49 PM Re: Optimzation [Re: Stan]
Stan Offline

old hand 		Registered: 06/05/06
Posts: 708
p l e a s e
Top
#177402 - 02/03/07 10:06 PM Re: Optimzation [Re: Stan]
gliderdad Offline
Registered: 06/08/06
Posts: 1466
Loc: NY
Do you have phpMyAdmin? If so select all the tables, at the bottom is a drop down menu and in there is an option to optimize
Top
#177404 - 02/03/07 10:21 PM Re: Optimzation [Re: gliderdad]
Gizmo Online cat

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
go to database tools in your ubb and click sql query, and save these:

Analyze:
 Code:
ANALYZE TABLE `forums_ADDRESS_BOOK` , `forums_ADMIN_SEARCHES` , `forums_ANNOUNCEMENTS` , `forums_BANNED_EMAILS` , `forums_BANNED_HOSTS` , `forums_CACHE` , `forums_CACHED_PERMISSIONS` , `forums_CALENDAR_EVENTS` , `forums_CATEGORIES` , `forums_CENSOR_LIST` , `forums_DISPLAY_NAMES` , `forums_FILES` , `forums_FORUMS` , `forums_FORUM_LAST_VISIT` , `forums_FORUM_PERMISSIONS` , `forums_GRAEMLINS` , `forums_GROUPS` , `forums_IMPORT_MAP` , `forums_LANGUAGES` , `forums_MAILER` , `forums_MEMBER_SEARCHES` , `forums_MODERATORS` , `forums_MODERATOR_NOTIFICATIONS` , `forums_MODERATOR_PERMISSIONS` , `forums_ONLINE` , `forums_POLL_DATA` , `forums_POLL_OPTIONS` , `forums_POLL_VOTES` , `forums_PORTAL_BOXES` , `forums_POSTS` , `forums_PRIVATE_MESSAGE_POSTS` , `forums_PRIVATE_MESSAGE_TOPICS` , `forums_PRIVATE_MESSAGE_USERS` , `forums_RATINGS` , `forums_REGISTRATION_FIELDS` , `forums_RESERVED_NAMES` , `forums_RSS_FEEDS` , `forums_SAVED_QUERIES` , `forums_SEARCH_RESULTS` , `forums_SHOUT_BOX` , `forums_STYLES` , `forums_TOPICS` , `forums_TOPIC_VIEWS` , `forums_USERS` , `forums_USER_DATA` , `forums_USER_GROUPS` , `forums_USER_NOTES` , `forums_USER_PROFILE` , `forums_USER_TITLES` , `forums_VERSION` , `forums_WATCH_LISTS`


Repair:
 Code:
REPAIR TABLE `forums_ADDRESS_BOOK` , `forums_ADMIN_SEARCHES` , `forums_ANNOUNCEMENTS` , `forums_BANNED_EMAILS` , `forums_BANNED_HOSTS` , `forums_CACHE` , `forums_CACHED_PERMISSIONS` , `forums_CALENDAR_EVENTS` , `forums_CATEGORIES` , `forums_CENSOR_LIST` , `forums_DISPLAY_NAMES` , `forums_FILES` , `forums_FORUMS` , `forums_FORUM_LAST_VISIT` , `forums_FORUM_PERMISSIONS` , `forums_GRAEMLINS` , `forums_GROUPS` , `forums_IMPORT_MAP` , `forums_LANGUAGES` , `forums_MAILER` , `forums_MEMBER_SEARCHES` , `forums_MODERATORS` , `forums_MODERATOR_NOTIFICATIONS` , `forums_MODERATOR_PERMISSIONS` , `forums_ONLINE` , `forums_POLL_DATA` , `forums_POLL_OPTIONS` , `forums_POLL_VOTES` , `forums_PORTAL_BOXES` , `forums_POSTS` , `forums_PRIVATE_MESSAGE_POSTS` , `forums_PRIVATE_MESSAGE_TOPICS` , `forums_PRIVATE_MESSAGE_USERS` , `forums_RATINGS` , `forums_REGISTRATION_FIELDS` , `forums_RESERVED_NAMES` , `forums_RSS_FEEDS` , `forums_SAVED_QUERIES` , `forums_SEARCH_RESULTS` , `forums_SHOUT_BOX` , `forums_STYLES` , `forums_TOPICS` , `forums_TOPIC_VIEWS` , `forums_USERS` , `forums_USER_DATA` , `forums_USER_GROUPS` , `forums_USER_NOTES` , `forums_USER_PROFILE` , `forums_USER_TITLES` , `forums_VERSION` , `forums_WATCH_LISTS`


Optimize:
 Code:
OPTIMIZE TABLE `forums_ADDRESS_BOOK` , `forums_ADMIN_SEARCHES` , `forums_ANNOUNCEMENTS` , `forums_BANNED_EMAILS` , `forums_BANNED_HOSTS` , `forums_CACHE` , `forums_CACHED_PERMISSIONS` , `forums_CALENDAR_EVENTS` , `forums_CATEGORIES` , `forums_CENSOR_LIST` , `forums_DISPLAY_NAMES` , `forums_FILES` , `forums_FORUMS` , `forums_FORUM_LAST_VISIT` , `forums_FORUM_PERMISSIONS` , `forums_GRAEMLINS` , `forums_GROUPS` , `forums_IMPORT_MAP` , `forums_LANGUAGES` , `forums_MAILER` , `forums_MEMBER_SEARCHES` , `forums_MODERATORS` , `forums_MODERATOR_NOTIFICATIONS` , `forums_MODERATOR_PERMISSIONS` , `forums_ONLINE` , `forums_POLL_DATA` , `forums_POLL_OPTIONS` , `forums_POLL_VOTES` , `forums_PORTAL_BOXES` , `forums_POSTS` , `forums_PRIVATE_MESSAGE_POSTS` , `forums_PRIVATE_MESSAGE_TOPICS` , `forums_PRIVATE_MESSAGE_USERS` , `forums_RATINGS` , `forums_REGISTRATION_FIELDS` , `forums_RESERVED_NAMES` , `forums_RSS_FEEDS` , `forums_SAVED_QUERIES` , `forums_SEARCH_RESULTS` , `forums_SHOUT_BOX` , `forums_STYLES` , `forums_TOPICS` , `forums_TOPIC_VIEWS` , `forums_USERS` , `forums_USER_DATA` , `forums_USER_GROUPS` , `forums_USER_NOTES` , `forums_USER_PROFILE` , `forums_USER_TITLES` , `forums_VERSION` , `forums_WATCH_LISTS`


these are of 7.0, haven't checked for any changes to 7.1 yet though.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#177405 - 02/03/07 10:47 PM Re: Optimzation [Re: Gizmo]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
And be prepared for some browser time-outs ;\)
Top
#177406 - 02/03/07 11:59 PM Re: Optimzation [Re: ntdoc]
Gizmo Online cat

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
lol yeh, i much advise against using a script (UBB, PHPMyAdmin, etc) to do maintenance on your databases, it's much MUCH faster to do it through the MySQL Command Line
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181698 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image
Board Rules · Mark all read
Contact Us · UBBCentral · Top