You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Bug Reports
      » Non Bugs » [NOTABUG] Huge Cached Permission Table Overhead
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
3 registered (Mike L, Iann128, JimUK), 47 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/02/04
Posts: 195
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
Page 3 of 3 < 1 2 3
Topic Options
#179866 - 03/02/07 07:11 AM Re: Huge Cached Permission Table Overhead [Re: Mark S]
Conrad Offline
addict 		Registered: 08/04/04
Posts: 425
So to do it via the root command line I just need to type: ./optimize.sh

No parameters to set? Or is ".sh" one of them?

How can I make sure that it just optimizes the ubb database if I have others on the server that I don't want to optimize simultaneously?
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."
#179868 - 03/02/07 07:21 AM Re: Huge Cached Permission Table Overhead [Re: Conrad]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
You'd need a shell script named optimize.sh; I coded mine from scratch; such scripts don't exist as any standard; you'd have to customize the hell out of an input string to MySQL lol.

On mine, i specify what tables i want optimized, and in what databases; then have it execute it at the beginning of my backup batch.
_________________________
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
#179869 - 03/02/07 07:21 AM Re: Huge Cached Permission Table Overhead [Re: Mark S]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
 Originally Posted By: Mark S
Name yu price : in corn flakes lol...
can I have the one that looks like jefferson?
_________________________
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
#179870 - 03/02/07 07:22 AM Re: Huge Cached Permission Table Overhead [Re: Conrad]
Mark S Offline
Carpal Tunnel 		Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
optermize.sh

is more than likely a script file,
with the commands and refrences to optermize.

I would like to know shell commands.
or where to look to find out.

But i dont \:\(
Hence click on a button, as cave man like it is.
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#179874 - 03/02/07 08:32 AM Re: Huge Cached Permission Table Overhead [Re: Mark S]
Conrad Offline
addict 		Registered: 08/04/04
Posts: 425
Is there a regular command that I can use to optimize a database of my choice?
Top
#179892 - 03/02/07 06:24 PM Re: Huge Cached Permission Table Overhead [Re: Conrad]
David Dreezer Offline

Pooh-Bah 		Registered: 07/21/06
Posts: 2199
you can use the mysql shell to optimize a table or tables, not a database, and there is no bash command for it, if "regular command" means a bash shell.
_________________________
This thread for sale. Click here!
Top
#179895 - 03/02/07 06:38 PM Re: Huge Cached Permission Table Overhead [Re: David Dreezer]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Through custom scripting you could create a script to do it, however this is over the head of 90% of users who run websites.

Generally it's easier to stick to using the MySQL command line for running commands through your server; this would be as easy as:
1. Login to the Server via SSH or Telnet (I very much hope that the later is disabled on your machine for security).
2. Login to the MySQL command line:
 Code:
mysql -hlocalhost -uusername -p

This should first ask you for your password, and then drop you to the MySQL command line.
3. Issue the command to use the table of your choice:
 Code:
use my_database;

4. Issue the command of your choice; for this example, optimizing your UBB7 tables:
 Code:
OPTIMIZE TABLE `ubb7_ADDRESS_BOOK` , `ubb7_ADMIN_SEARCHES` , `ubb7_ANNOUNCEMENTS` , `ubb7_BANNED_EMAILS` , `ubb7_BANNED_HOSTS` , `ubb7_BANNED_USERS` , `ubb7_CACHE` , `ubb7_CACHED_PERMISSIONS` , `ubb7_CALENDAR_EVENTS` , `ubb7_CAPTCHA` , `ubb7_CATEGORIES` , `ubb7_CENSOR_LIST` , `ubb7_DISPLAY_NAMES` , `ubb7_fc_bans` , `ubb7_fc_config` , `ubb7_fc_config_chats` , `ubb7_fc_config_instances` , `ubb7_fc_config_values` , `ubb7_fc_connections` , `ubb7_fc_ignors` , `ubb7_fc_messages` , `ubb7_fc_rooms` , `ubb7_FILES` , `ubb7_FORUMS` , `ubb7_FORUM_LAST_VISIT` , `ubb7_FORUM_PERMISSIONS` , `ubb7_GRAEMLINS` , `ubb7_GROUPS` , `ubb7_IMPORT_MAP` , `ubb7_LANGUAGES` , `ubb7_MAILER` , `ubb7_MEMBER_SEARCHES` , `ubb7_MODERATORS` , `ubb7_MODERATOR_NOTIFICATIONS` , `ubb7_MODERATOR_PERMISSIONS` , `ubb7_ONLINE` , `ubb7_POINTER_DELETE` , `ubb7_POLL_DATA` , `ubb7_POLL_OPTIONS` , `ubb7_POLL_VOTES` , `ubb7_PORTAL_BOXES` , `ubb7_POSTS` , `ubb7_PRIVATE_MESSAGE_POSTS` , `ubb7_PRIVATE_MESSAGE_TOPICS` , `ubb7_PRIVATE_MESSAGE_USERS` , `ubb7_RATINGS` , `ubb7_REGISTRATION_FIELDS` , `ubb7_RESERVED_NAMES` , `ubb7_RSS_FEEDS` , `ubb7_SAVED_QUERIES` , `ubb7_SEARCH_AGENTS` , `ubb7_SEARCH_RESULTS` , `ubb7_SHOUT_BOX` , `ubb7_STYLES` , `ubb7_TOPICS` , `ubb7_TOPIC_VIEWS` , `ubb7_USERS` , `ubb7_USER_DATA` , `ubb7_USER_GROUPS` , `ubb7_USER_NOTES` , `ubb7_USER_PROFILE` , `ubb7_USER_TITLES` , `ubb7_VERSION` , `ubb7_WATCH_LISTS`;

5. When the above query is done, to exit mysql issue:
 Code:
\q
_________________________
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
#179916 - 03/03/07 08:55 AM Re: Huge Cached Permission Table Overhead [Re: Gizmo]
Mark S Offline
Carpal Tunnel 		Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
I will give that a go later tonight on my test database,
and if it works, i'm not a million miles
from making a script \:\)

Cheers for the leader Gizmo, i know you like praise.
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#179937 - 03/03/07 05:12 PM Re: Huge Cached Permission Table Overhead [Re: Mark S]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Praise makes me purr like a kitten.... ;)...
_________________________
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
Page 3 of 3 < 1 2 3



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