tag:blogger.com,1999:blog-5986956595908624882.post8001632894011443722..comments2023-10-31T08:16:41.769-07:00Comments on Glynn's Thoughts on Databases: SQL from SQLGlynnhttp://www.blogger.com/profile/13474827028438980648noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5986956595908624882.post-62141463525544836602010-12-01T06:51:18.972-08:002010-12-01T06:51:18.972-08:00Many thanks for your themed, a good post for me.
N...<strong>Many thanks for your themed, a good post for me.</strong><br />Now it will be very cold in winter, in order to keep warm yourself, <a href="http://www.itmoncler.com/" rel="nofollow">Moncler</a> company has provide jackets for you, so it is better to own <a href="http://www.itmoncler.com/" rel="nofollow">Moncler Jackets</a> yourselif as soon as possible. Eeveryone love fashion clothing, <a href="http://www.ralphlaurenpoloshirt.com/" rel="nofollow">Polo Ralph Lauren</a> is very popular all over world, that is my dream to get <a href="http://www.ralphlaurenpoloshirt.com/" rel="nofollow">Ralph Lauren</a>.We know Ray Ban by America soldier, all of them wear <a href="http://www.usrayban.com/" rel="nofollow">Ray Ban Sunglasses</a> when they walk on the road, it is fashionable for you. Most of people like to wear jeans, it is very modern when wearing <a href="http://www.buytruereligion.com/" rel="nofollow">True Religion Jeans</a> in the street.CHEAPSOCCERUNIFORMhttps://www.blogger.com/profile/13954812815709285591noreply@blogger.comtag:blogger.com,1999:blog-5986956595908624882.post-30630627702638223292009-09-08T20:07:00.808-07:002009-09-08T20:07:00.808-07:00Glynn, great to see you joining the blogging world...Glynn, great to see you joining the blogging world!<br /><br />The coolest thing about SQL from SQL is that it is easy to do things with concurrency, when MySQL has no support:<br /><br />shell> mysql -NB -e "select concat('SELECT SLEEP(100) FROM ', table_name, ';') from information_schema.tables where table_schema = 'world'" | xargs -P 16 -I % mysql world -e '%'<br /><br />Replace SLEEP with a REPAIR or OPTIMIZE command ;) I just did this as a demo so you can see it in your processlist.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5986956595908624882.post-7132120327086914242009-09-06T11:42:43.367-07:002009-09-06T11:42:43.367-07:00Nice trick!Nice trick!Sarahhttps://www.blogger.com/profile/15336146699240103888noreply@blogger.com