database
What Is Virtualization And Cloud Computing?
What Is Virtualization And Cloud Computing? View more documents from Consonus Technology.
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 [...]
Convert timestamp between timezones : CONVERT_TZ() – MySql
Any application targeted for people in different countries or even in different cities requires to handle timezones for the users for application. One main requirement is to show data against user’s timezone e.g. creation date & time of any message to the user. Many applications solve this by asking users their timezone at the time [...]