Linux in Supercomputers and Robotics

90% of the world's most powerful supercomputers using an operating system GNU / Linux, in fact, the top ten of supercomputers use Linux. In fact, the penetration of Linux in data centers is very high, 33.8% of the world runs on Linux servers compared to 7.3% does so in a Microsoft operating system. For example, Google's servers run on Linux, like the server hosting the website of the White House.

Linux Earlier Years

The first commercial distribution GNU / Linux was Yggdrasil was launched Lice-CD format in 1992. Red Hat was one of the first distributions to settle within companies and data centers in 1999. Debian was one of the first GNU / Linux that was constituted and organized as a community of developers.

Linux OS used in Major Applications / Services

Linux is present in highly critical applications such as Japan's bullet trains, traffic control, San Francisco, the New York Stock Exchange, CERN, many air traffic control systems or control of nuclear reactors of submarines and ships many nuclear war.

Expanding Everyday

Linux has more than 9.2 million lines of code and this amount grows 10% each year. Of the 9.2 million lines, the kernel itself accounts for 5% and 55% drivers. Add lines 4500, 1800 and 1500 are removed are changed every day.

Widely Used

Linux is now one of the most widely ported operating system kernels, running on a diverse range of systems from handheld computers to mainframe servers.

Showing posts with label Repair corrupted database. Show all posts
Showing posts with label Repair corrupted database. Show all posts

Tuesday, March 20, 2012

Repairing Database and Tables

10:46 AM Unknown No comments

MyISAM was the default storage engine for the MySQL. It is based on the older ISAM code but has many useful extensions. The major deficiency of MyISAM is the absence of transactions support. Versions of MySQL 5.5 and greater have switched to the InnoDB engine to ensure referential integrity constraints, and higher concurrency.

Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. MySQL uses a .frm file to store the definition of the table, but this file is not a part of the MyISAM engine; instead it is a part of the server. The data file has a .MYD (MYData) extension. The index file has a .MYI (MYIndex) extension.

I will now show how to repair the corrupted databases and tables. Usually the mysql files are stored in /var/lib/mysql. Hence navigate your way to the this location.


$ cd /var/lib/mysql
You can find all the databases in the server as folders in this location and enter the folder of the corrupted database.
$ cd db_name
To check and automatically repair all tables
$  myisamchk --silent --force --fast --update-state *.MYI.

If you only want to repair a specific table give the command below:
$ myisamchk -r table_name.MYI
Read more »

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Affiliate Network Reviews