|
|
Joined: Jun 2006
Posts: 869
old hand
|
|
old hand
Joined: Jun 2006
Posts: 869 |
When does the mysql get optimize?
Is that just 'done' or is it something we have to do manually now?
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
You have to do it manually.
|
|
|
|
|
Joined: Jun 2006
Posts: 869
old hand
|
|
old hand
Joined: Jun 2006
Posts: 869 |
Oh Oh..
What is the command for that...
|
|
|
|
|
Joined: Jun 2006
Posts: 869
old hand
|
|
old hand
Joined: Jun 2006
Posts: 869 |
|
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
|
veteran
Joined: Jun 2006
Posts: 1,344 |
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
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
go to database tools in your ubb and click sql query, and save these: Analyze: 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: 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: 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.
|
|
|
|
|
Joined: Nov 2006
Posts: 3,097 Likes: 1
Carpal Tunnel
|
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,097 Likes: 1 |
And be prepared for some browser time-outs 
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
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
|
|
|
|
0 members (),
168
guests, and
171
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|