Optimzation

Print Thread

Hop To

Optimzation #177391 02/03/2007 9:52 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan 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? http://clubadventist.com/forums No longer following the carrot

Re: Optimzation Stan #177392 02/03/2007 10:29 PM
Joined: Jun 2006 Posts: 16,532 Likes: 150 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,532 Likes: 150 Portland, OR; USA	You have to do it manually. I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums. Do you need Forum Install or Upgrade Services? Forums: A Gardeners Forum UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps Longtime Supporter & Resident Post-A-Holic VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Re: Optimzation Gizmo #177400 02/03/2007 10:49 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	Oh Oh.. What is the command for that... http://clubadventist.com/forums No longer following the carrot

Re: Optimzation Stan #177401 02/03/2007 10:49 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	p l e a s e http://clubadventist.com/forums No longer following the carrot

Re: Optimzation Stan #177402 02/03/2007 11:06 PM
Joined: Jun 2006 Posts: 1,344 NY G gliderdad veteran
gliderdad veteran G Joined: Jun 2006 Posts: 1,344 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

Re: Optimzation

gliderdad #177404 02/03/2007 11:21 PM

Joined: Jun 2006

Posts: 16,532

Likes: 150

Portland, OR; USA

Gizmo

Gizmo

Joined: Jun 2006

Posts: 16,532

Likes: 150

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.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Re: Optimzation Gizmo #177405 02/03/2007 11:47 PM
Joined: Nov 2006 Posts: 3,097 Likes: 1 CA ntdoc Carpal Tunnel
ntdoc Carpal Tunnel Joined: Nov 2006 Posts: 3,097 Likes: 1 CA	And be prepared for some browser time-outs

Re: Optimzation ntdoc #177406 02/04/2007 12:59 AM
Joined: Jun 2006 Posts: 16,532 Likes: 150 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,532 Likes: 150 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 I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums. Do you need Forum Install or Upgrade Services? Forums: A Gardeners Forum UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps Longtime Supporter & Resident Post-A-Holic VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard

ShoutChat

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Optimzation