Karanbir Singh - Thinkability

if you insert data using server side metadata like now(), there is a very high possibility that the replica you have running will not get the same information. more »

Running dstat normally gives you something like this :# dstat --nocolor----total-cpu-usage---- -dsk/total- -net/total- ---paging-- ---system--usr sys idl wai hiq siq| read writ| recv send| in out | int csw 3 0 97 0 0 0| 820k… more »

If you need to remove large amounts of data from a table ( specially when you need to remove *all* the data in a table), remember its faster to drop the table, and recreate it rather than doing a 'delete from tablename;'.eg: this is against a postgre… more »