The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

Web Buzz Forum
MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Angsuman Chakraborty

Posts: 19816
Nickname: angsuman
Registered: Dec, 2003

Angsuman Chakraborty is the CEO and Chief Architect at Taragana
MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases Posted: Apr 20, 2008 5:48 AM
Reply to this message Reply

This post originated from an RSS feed registered with Web Buzz by Angsuman Chakraborty.
Original Post: MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases
Feed Title: Simple Thoughts on Web Technologies
Feed URL: http://tech.gaeatimes.com/index.php/search/internet/feed/
Feed Description: News and views as a Software Architect and Entrepreneur on Web Technologies. 		Latest Web Buzz Posts
Latest Web Buzz Posts by Angsuman Chakraborty
Latest Posts From Simple Thoughts on Web Technologies

Advertisement
Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server: mysqlcheck -u root -p --auto-repair --check --optimize --all-databases mysqlcheck is available in MySQL 3.23.38 and later. mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the [...]

Read: MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases

Topic: Hackergotchi Previous Topic   Next Topic Topic: Internet Explorer's Maximum URL Length
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use