Forum would need a boost - Page 5

**David** · March 10th, 2006, 12:23 AM

You mean you don't optimize yours for fun? And I thought I knew you...

**mr_fern** · March 10th, 2006, 12:26 AM

lol the other week I did an optimize on the private messages table. that took about 30 minutes to complete.

**David** · March 10th, 2006, 12:29 AM

Yeah, all those women trying to get my phone number. I know. I'll tell them stop.

**wildrice** · March 10th, 2006, 12:32 AM

holy lord so you mean i should select all the tables to optimize, how long will that take... and, David whats that puppet..?? Its scarey..

so mr.will smith, can you explain to me exactly what i need to do..?? cuz when im there i feel like im sitting on a bomb..

**David** · March 10th, 2006, 12:37 AM

Yours won't take nearly as long as Fern's does. Fern runs something similar to MySpace but better because it's his and doesn't allow people to make god awful looking pages...well, they still try but don't get as far thankfully.

As for optimizing, all you have to do is go to PHPMyAdmin, choose the database, click Check All and select "Optimize Table". But if you aren't even going to be using the forum, don't worry about it.

And I have no idea what this is. It just amused me one day so I saved it. It's in my collection of 1000+ avatars.

**mr_fern** · March 10th, 2006, 12:38 AM

lmaoo.. notes 30 days old are deleted on a daily basis through a cron job. I used to have it configured to optimize right after, but the problem with that was when the site began to grow, it would render the site useless for 5-15 minutes performing this optimize. So it no longer does the optimize automatically. About 50 MB of notes are cleared out every night when it performs the 30 day old delete.

**mr_fern** · March 10th, 2006, 12:39 AM

Yeah it wouldn't take long for you rice.

The table I'm talking about optimizing is over 1 Gigabyte in filesize.

**David** · March 10th, 2006, 12:47 AM

Great Scotts! 1 gig for just the pm table? Out of curiosity, how big is the entire database?

**mr_fern** · March 10th, 2006, 12:53 AM

Currently, over 5G. The bulk of it is Tagboard, Notes, and Forum Posts, which are about 5G by themselves. And I'm planning on converting most of the tables to InnoDB from MyISAM.

When I had converted the Users table from MyISAM to InnoDB, it was roughly 4 times larger.

March 10th, 2006, 12:26 AM	#38 (permalink)
mr_fern All Ur Base R Belong 2 Us Excelling Contributor Joined in Feb 2005 Lives in Vegas & New York 824 posts Gave thanks: 2 Thanked 6 times	lol the other week I did an optimize on the private messages table. that took about 30 minutes to complete. __________________ Nobody doing nothing

March 10th, 2006, 12:32 AM	#40 (permalink)
wildrice Surpass Fan Super #1 Joined in Feb 2006 1,478 posts Gave thanks: 0 Thanked 0 times	holy lord so you mean i should select all the tables to optimize, how long will that take... and, David whats that puppet..?? Its scarey.. so mr.will smith, can you explain to me exactly what i need to do..?? cuz when im there i feel like im sitting on a bomb.. __________________ Kayla has true class. Helpdesk submit a ticket

March 10th, 2006, 12:38 AM	#42 (permalink)
mr_fern All Ur Base R Belong 2 Us Excelling Contributor Joined in Feb 2005 Lives in Vegas & New York 824 posts Gave thanks: 2 Thanked 6 times	lmaoo.. notes 30 days old are deleted on a daily basis through a cron job. I used to have it configured to optimize right after, but the problem with that was when the site began to grow, it would render the site useless for 5-15 minutes performing this optimize. So it no longer does the optimize automatically. About 50 MB of notes are cleared out every night when it performs the 30 day old delete. __________________ Nobody doing nothing

March 10th, 2006, 12:39 AM	#43 (permalink)
mr_fern All Ur Base R Belong 2 Us Excelling Contributor Joined in Feb 2005 Lives in Vegas & New York 824 posts Gave thanks: 2 Thanked 6 times	Yeah it wouldn't take long for you rice. The table I'm talking about optimizing is over 1 Gigabyte in filesize. __________________ Nobody doing nothing

March 10th, 2006, 12:53 AM	#45 (permalink)
mr_fern All Ur Base R Belong 2 Us Excelling Contributor Joined in Feb 2005 Lives in Vegas & New York 824 posts Gave thanks: 2 Thanked 6 times	Currently, over 5G. The bulk of it is Tagboard, Notes, and Forum Posts, which are about 5G by themselves. And I'm planning on converting most of the tables to InnoDB from MyISAM. When I had converted the Users table from MyISAM to InnoDB, it was roughly 4 times larger. __________________ Nobody doing nothing

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search