Tech4Him – Technology with Integrity

A Christian technology chaos wrangler and his thoughts

MySQLCheck For Quick Repair

Posted by Tom On February - 15 - 2010

Thanks to this tip on the Taragana blog, I was introduced to the mysqlcheck command. In a pinch, the following command will check, repair and optimize all tables in all databases on your MySQL server instance.

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

mysqlcheck is available in MySQL 3.23.38 and later.

The official documentation for mysqlcheck says: “The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables.” Now, this must be run on a MySQL instance that is currently running, unlike the myisamchk tool. So, you may want to stop all access to your instance. If you are using it for websites, perhaps kill HTTPD for a few minutes some other means.

Popularity: 3% [?]

Articles

MySQL Stopped Starting Upon Reboot – Ubuntu

Posted by Tom On September - 22 - 2009

Okay, so here is a quick tip. After making some system changes on an Ubuntu 8.04 LTS box with MySQL 5, a problem occurred. Upon starting the system up, MySQL failed to automatically start as it had been doing.

Read the rest of this entry »

Popularity: 1% [?]

Articles

Don’t leave your MySQL hanging (check your my.cnf)

Posted by Tom On August - 19 - 2009

2380021517_b526fbfc98_mAdmit it! Have you ever made a change to your my.cnf file, restarted mysqld only to have the restart fail because of an error in the configuration file? Come on, you don’t have to hide anything here.

Read the rest of this entry »

Popularity: 3% [?]

Articles, Featured

Web Roundup – 2/18/2009

Posted by admin On February - 19 - 2009

2006-3-29 6-21-30_0104Here are a few interesting links and articles from around the web.

Read the rest of this entry »

Popularity: 12% [?]

Links/Resources

How will Sun Make Up the Price for Acquiring MySQL

Posted by admin On January - 25 - 2008
I am sure you have heard the news by now. Yup, Mysql was acquired by Sun. Can someone say $1 billion? Wow. Sounds like an NPV, is it wise? Well, the open source community seems to be mostly "for" the acquisition and some business analyst seem to be leaning toward "what are they thinking".
Jeff Gould has an interesting take on what this all might look like. He might be right on target.
Oh yeah, you can hear the spin directly from Jonathan and his writers in a few places.
I guess the rest of will just have to wait to find out exactly what all of this will mean for our web centric development. You know, I winder if this acquisition has anything to do with the four (4) calls in six(6) months that I’ve gotten from MySQL about how we use the product.
The last email I received from a sales person included:
"…I would still like to find
out how you are using our software. Many clients using our software in
an enterprise environment take advantage of our MySQL Enterprise offering. MySQL Enterprise includes the most comprehensive offering of MySQL
database software, services and production support to ensure your
business achieves the highest levels of reliability, security and
uptime. Depending on your MySQL usage you may also be in need of licensing."
Hmmmm….makes you think a bit but certainly we will continue using MySQL where it makes sense for the forseeable future.

Popularity: 5% [?]

General, Links/Resources

Popular Posts

Most Commented

Recent Posts

Recent Comments