30, August 2008

Checking tables that need OPTIMIZE - webmaster forum

 
Webdigity webmaster forums
This forum shares its ad revenue with its members!
[ Home | Help | Search | Forum's Shop | Archive | Login | Register | Webmaster Directory ]
Webdigity Webmaster Forums  >  Web Development  >  Databases  >  MySQL
Topic: Checking tables that need OPTIMIZE		 « previous next »
Pages: [1] Print

Author Topic: Checking tables that need OPTIMIZE  (Read 796 times)
OMG!I am geek
**
Gender: Male
Posts: 56
374 credits
Members referred : 0
« on: Jan 30, 2006, 06:50:45 PM »
I would like to ask, how can I query the database and know if a table needs to be optimized( OPTIMIZE table;)

Thanks
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 8029
41131 credits
Members referred : 3
« Reply #1 on: Jan 30, 2006, 07:50:33 PM »
You can use the statement SHOW TABLE STATUS

The row Data_free gives the overhead of the table.

http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html Visit through proxy
Trial and Error my two best teachers Cool
Join us @ facebook Visit through proxy

Last blog : MIA - Where Nick and Tim
Global Moderator
Internet Junkie
*****
Gender: Male
Posts: 1523
6847 credits
Members referred : 8


Gimme all your cookies!!!
« Reply #2 on: Jan 30, 2006, 08:07:08 PM »
I like this one, it give such great stats!
SEO Voter Visit through proxy | web directory Visit through proxy | Health Directory Visit through proxy | Web Directory Lens Visit through proxy

Last blog : Site of the Month - August 2007
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 8029
41131 credits
Members referred : 3
« Reply #3 on: Jan 30, 2006, 08:08:23 PM »
Wait a sec, I will publish a script that I've made, that checks the overhead, and optimizes only the tables that have problem.
Trial and Error my two best teachers Cool
Join us @ facebook Visit through proxy

Last blog : MIA - Where Nick and Tim
I am a metal monkey!
Administrator
Community Supporter ?
Jedai Sword Master
*****
Gender: Male
Posts: 8029
41131 credits
Members referred : 3
« Reply #4 on: Jan 30, 2006, 08:24:03 PM »
Trial and Error my two best teachers Cool
Join us @ facebook Visit through proxy

Last blog : MIA - Where Nick and Tim
Trackback URI for this entry : http://www.webdigity.com/trackback.php?topic=1366
Tags : databases Bookmark this thread : Digg Del.icio.us Dzone more....

Topic sponsors:
Get a permanent link here for $1.99!


Pages: [1] Print 
Webdigity Webmaster Forums  >  Web Development  >  Databases  >  MySQL
Topic: Checking tables that need OPTIMIZE		 « previous next »
Jump to:
User Area
Welcome, Guest. Please login or register.
Did you miss your activation email?
Aug 30, 2008, 02:26:46 AM





Login with username, password and session length

Donate to our community, and get a permanent link back to your site!

Donate to our community, and get a permanent link back to your site!


Forum Statistics
Total Posts: 36.176
Total Topics: 7.461
Total Members: 3.861
Tutorials : 56
Resources : 143
Designs : 220
Latest Member: matsolof

21 Guests, 3 Users online :

17 users online today:

Recent topics
affiliate + Make Money From...
Re: The army thread
Re: Fun hypothetical questi...
Re: I finally got StarCraft...
Re: Eye problems with monit...
Re: Looking to Buy a Websit...
Re: Review Young Mom and da...
Re: Some good reasons to jo...

HumanWorks Network
Technology news
Webmaster articles
Sublime web directory
RSS Feed directory and viewer

Readers

Web Design Gallery · Whois Lookup · Pagerank · Tag Browsing · Lo-fi version · Syndication · Webmaster forum history · Advertise
Developed by HumanWorks © 2005 - 2008 Webdigity webmaster community · sublime directory
Webdigity Webmaster Forums | Powered by SMF 1.0.12. © 2001-2005, Lewis Media. All Rights Reserved.