Archive for October, 2009
MySql optimizations – Tips and Tricks
MySQL Optimization View more presentations from Dyn Inc.
Database page corruption on disk or a failed file read – Mysql
We got stuck into a situation last week and problem seemed unrecoverable. Here I am trying to state the problem and then will describe about the solution which we applied to save us. We realized in the mid-night, that our server is not functioning and the reason was the main application which is a web [...]
Difference between DELETE and TRUNCATE — MySql
1. For an InnoDB table before version 5.0.3, InnoDB processes TRUNCATE TABLE by deleting rows one by one. As of MySQL 5.0.3, row by row deletion is used only if there are any FOREIGN KEY constraints that reference the table. If there are no FOREIGN KEY constraints, InnoDB performs fast truncation by dropping the original [...]
Firefox Addons – Recommended
Some of the useful Firefox add-on and themes described here: Part -1 : Part -2 :
Online Car Servicing Booking – www.mericar.com
In the big cities like Noida and Delhi, almost every one , who can afford, maintain his own car for commuting and in the busy schedule of big cities allows us very less time for things like maintenance of your vehicle. www.mericar.com provides little help related to this. You can search and book for servicing [...]