Wednesday, 28 October 2015

Defrag MYSQL database

Over a period of time, "mysql" tables usually get fragmented. It degrades the performance of "mysql-server" significantly.

You may also find it worth your while to defragment your database tables regularly if you are using VARCHAR fields: these variable-length columns are particularly prone to fragmentation.

To defragment tables manually from command-line using mysqlcheck
Run the following command by replacing USER & PASS values:

mysqlcheck -Aos -u <user> -p <password>

Parallelise your build using make

If you're running a multiprocessor system (SMP) with a moderate amount of RAM, you can usually see significant benefits by performing a parallel make when building code. Compared to doing serial builds when running make (as is the default), a parallel build is a vast improvement. To tell make to allow more than one child at a time while building, use the -j switch:


make -j4; make -j4 modules

Total Pageviews

Popular Posts