Skip to main content

How To Optimize MySql Database ?

Many users are asking to optimize their database so today we have to discuss about the optimization. For the beginners handing the MySql is a dangerous work. The size of the database is very important to manage it easily. Optimization can reduce the size of our whole database. Optimization can’t delete the data but it does defragmentation for our database. As the database, getting older it can be deleted or added. This can provide the results in number of empty rows.

Optimization can be used to delete the “Overhead” and to give the results in better arrangement of data in our database. To open the MySql database using myphpadmin link in our hosting panel. Select database from the dropdown menu on the left. Then check for size mentioned under “overhead” column next to every table in the database. Ideally, an optimized database will have ZERO overhead.

Optimizing the database is quite easy but before optimizing, you have to backup your data. Choose one or all tables in your database and check for dropdown with label ‘with selected’ at the bottom. After that selecting, the Optimize Table is enough. So whenever we see the “Overhead” building we have to perform a quick optimization to keep the data intact.

[ ">Thank You ]

Popular posts from this blog

HTC Touch Diamond SmartPhone!

The phones design is an innovative in which the user has the geometric form language to make sure a clutter-free environment for screening content. The San Francisco based studio One & Co collaborated with HTC Taiwan Design team to create Diamond HTC smartphone.

The HTC phone is quite wonderful with design and the rapid development in the smartphone market the HTC has taken innovative steps to capture the SmartPhone market HTC develops these kind of new inventive designs.

New Micro battery, power packed for high performance

For a size of a few millimetres, the new micro-batteries are powerful enough to jump start a car battery and then quickly charge the cell phone. Researchers from the University of Illinois have developed the micro batteries which can be used to drive compact electronic devices and new applications for radio communications. The micro batteries are so good that they can even out power the super capacitors. The results were published in ‘Nature Communications’ in the April 16 issue. The micro batteries have energy and power and with the researchers tweaking the structure of the micro batteries a little bit, its use can be for wide range applications.

The high performance of the micro battery is based on its 3-dimensional micro-structure. Based on the design of fast charging cathode by Professor Paul Braun’s group, researchers developed the matching anode and integrated it with the fast charging cathode at a micro-scale and made a complete battery with high performance. These batteries cou…

Google Microsoft Bidding War Continues!

As we all know that Google and Microsoft both went for Yahoo recently. The both big leaders in IT sector is keen to acquire more companies. As the competition is bigger the big deal also goes bigger. Now their Bidding eye turns to Digg the social book marking site. Techcrunch reports that Google, our source says, will likely bid $200-$225 million, which Digg would likely accept.

image from:

The deal made by Microsoft is lower than that of Google but Microsoft already has 3yrs advertising deal with digg and it also said that the most of the revenue generated from it. This bidding deal story was soon denied by Digg CEO Jay Adelson is calling this post “completely inaccurate”. The interesting thing is that only a few days before Yahoo started the similar Digg site called Yahoo Buzz . Anyway the bidding war between the big giant IT companies is expecting to get more heat….