[NOTABUG] Huge Cached Permission Table Overhead

You are not logged in. [Log In] UBB.threads Community » Forums » UBB.threads 7 Discussion » Bug Reports
» Non Bugs » [NOTABUG] Huge Cached Permission Table Overhead

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options

Top Posters (30 Days)

Ruben Rocha	154
Rick	129
Gizmo	115
Thelockman	66
driv	55
phoebe	39
ScriptKeeper	38
AllenAyres	35
Ian	31
Mark S	30

Latest Photos

Page 3 of 3

Topic Options

Rate This Topic

#179866 - 03/02/07 04:11 AM Re: Huge Cached Permission Table Overhead [Re: Mark S]
Conrad enthusiast Registered: 08/04/04 Posts: 361	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

#179868 - 03/02/07 04:21 AM Re: Huge Cached Permission Table Overhead [Re: Conrad]
Gizmo Registered: 06/04/06 Posts: 11967 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. _________________________ UGN Security, Elite Web Gamers & VNC Web Design Owner Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic
Top

#179869 - 03/02/07 04:21 AM Re: Huge Cached Permission Table Overhead [Re: Mark S]
Gizmo Registered: 06/04/06 Posts: 11967 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? _________________________ UGN Security, Elite Web Gamers & VNC Web Design Owner Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic
Top

#179870 - 03/02/07 04:22 AM Re: Huge Cached Permission Table Overhead [Re: Conrad]
Mark S Carpal Tunnel Registered: 07/04/06 Posts: 4041 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.2.2 < Threads satisfaction status People who inspire me Rick Gizmo Ian David jgeoff ntdoc To answer the question you must first give a question.
Top

#179874 - 03/02/07 05:32 AM Re: Huge Cached Permission Table Overhead [Re: Mark S]
Conrad enthusiast Registered: 08/04/04 Posts: 361	Is there a regular command that I can use to optimize a database of my choice?
Top

#179892 - 03/02/07 03:24 PM Re: Huge Cached Permission Table Overhead [Re: Conrad]
David Dreezer Pooh-Bah Registered: 07/21/06 Posts: 1781	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. _________________________ What do you mean "You're the bomb, run away?"
Top

#179895 - 03/02/07 03:38 PM

Re: Huge Cached Permission Table Overhead [Re: David Dreezer]

Gizmo

Registered: 06/04/06
Posts: 11967
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

_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top

#179916 - 03/03/07 05:55 AM Re: Huge Cached Permission Table Overhead [Re: Gizmo]
Mark S Carpal Tunnel Registered: 07/04/06 Posts: 4041 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.2.2 < Threads satisfaction status People who inspire me Rick Gizmo Ian David jgeoff ntdoc To answer the question you must first give a question.
Top

#179937 - 03/03/07 02:12 PM Re: Huge Cached Permission Table Overhead [Re: Mark S]
Gizmo Registered: 06/04/06 Posts: 11967 Loc: Portland, OR; USA	Praise makes me purr like a kitten.... ;)... _________________________ UGN Security, Elite Web Gamers & VNC Web Design Owner Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic
Top

Page 3 of 3

Previous Topic

Index

Next Topic

Hop to:

Moderator: AllenAyres, Gizmo, Harold, Ian, Ian Spence, Ron M, Sirdude, usrbingeek

Shout Box

November
Su	M	Tu	W	Th	F	Sa
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30

Today's Birthdays

The Random Avenger