Shared: УкраинÑкие Cheerleaders: Давно у Ð½Ð°Ñ Ð½Ðµ было девушек Ñ Ð·Ð°Ð³Ð°Ð´ÐºÐ¾Ð¹. Ð’ÑÑ‘ больше раÑкорÑки на веÑÑŒ Ñкран.ПоÑÑ‚… http://t.co/uOVsGdS #
Tweets on 2011-09-03
Shared: Android 2.3.6 rolling out to some Nexus S owners – Fixes voice search, breaks tethering: Some Samsung N… http://t.co/O2oMJSz #
How to get size of Mysql tables
In the previous post I wrote about a way to get a Mysql database size from Mysql shell. Now I’d like to share a way to get size of each Mysql table: SELECT table_name,`engine` ,ROUND(data_length/1024/1024/1024,2) total_size_gb, ROUND(index_length/1024/1024/1024,2) total_index_size_gb, table_rows FROM information_schema.TABLES WHERE table_schema = ‘rt3′; It’s useful if you need to know what you should clean in your huge database. [via Techie-Gyan]
Tweets on 2011-09-02
Shared: Sound Blaster Recon 3D improves sound and voice clarity for gamers on console and computers: I just ment… http://t.co/tyX2ZZC # Shared: Creative ZEN X-Fi3 media player is packed with cool features for under $100: Creative has trotted out it… http://t.co/FfSwa3p # Shared: ViewSonic ViewPad 7e Android Tablet Hands-On [Video]: This week we’ve been getting a look at a whole han… http://t.co/9moyJJw # Acer Aspire […]
How to check Mysql database size
Recently I needed to know the size of our RT3 database. So, I found this SQL to do that from Mysql shell: SELECT table_schema “rt3”, sum( data_length + index_length ) / 1024 / 1024 / 1024 “Data Base Size in GB” FROM information_schema.TABLES GROUP BY table_schema; The result is 360GB! We have to cleanup before upgrade to RT4. Otherwise the upgrade procedure will take ages. […]
Tweets on 2011-09-01
Shared: Spy Shots: Sacha Baron Cohen's gold-plated Dartz spied: Filed under: Etc., Celebrities Sacha Baron Cohen… http://t.co/2oSre7Q # Nokia's N950 demos MeeGo Harmattan in marathon video http://t.co/VUInPMq via @engadget #
Tweets on 2011-08-31
Shared: ComScore: Android and iOS near 70 percent of US smartphone market share: ComScore has issued a new repor… http://t.co/cs4uSpl # Shared: Ford announces EVOS Concept at IFA 2011 ahead of Frankfurt Motor Show: Ford is announcing its EVOS Conce… http://t.co/iXdHAtg # Shared: tmux – Linux terminal multiplexer: I stumbled upon a very useful tool – tmux.  It is a terminal multiple… http://t.co/FXHudH2 #