performance
Server Not Found – DNS resolution failing
I have been facing this problem from some time. When ever I try to open a website, mostly for the first time I get Server not found (Firefox, IE and Chrome) on all browsers. And with a refresh second or third time successfully get the home page opened on my browser. This is bearable couple [...]
Loading data file into MySql Database
Loading data into mysql tables can be done using simple insert statements but to get achieve better speed and performance it requires a special tool and LOAD DATA INFILE command is provided for this purpose in MySql. Used it recently and worked really fast, remember to drop indexes before this and rebuild them in case [...]
How to speed up delete from large tables – MySql (InnoDB engine)
Deleting data some times take very large amount of time when you are doing it on big tables have millions of rows and deletion of data is more important for them as growing tables will again create problems while querying it and updating it etc. Here are some techniques which i used/learnt while handling large [...]
MySQL Schema Maintenance
MySQL Schema Maintenance View more documents from Giuseppe Maxia.
Calculate Table size, Index Size – MySql
Keep check on mysql tables sizes as it may affect performance of overall application. You can use the query below for checking the size of table and its indexes. Some tables which store each and every activity related to your business can grow very fast and as your users will grow, possibility of increased data [...]