Help
RSS
API
Feed
Maltego
Contact
Domain > blog.shlomoid.com
×
More information on this domain is in
AlienVault OTX
Is this malicious?
Yes
No
DNS Resolutions
Date
IP Address
2014-07-02
74.125.198.121
(
ClassC
)
2024-07-13
142.251.211.243
(
ClassC
)
Port 80
HTTP/1.1 200 OKContent-Type: text/html; charsetUTF-8Expires: Sat, 13 Jul 2024 10:50:11 GMTDate: Sat, 13 Jul 2024 10:50:11 GMTCache-Control: private, max-age0Last-Modified: Sat, 06 Jul 2024 06:43:20 GMTX-Content-Type-Options: nosniffX-XSS-Protection: 1; modeblockServer: GSEAccept-Ranges: noneVary: Accept-EncodingTransfer-Encoding: chunked !DOCTYPE html>html classv2 dirltr xmlnshttp://www.w3.org/1999/xhtml xmlns:bhttp://www.google.com/2005/gml/b xmlns:datahttp://www.google.com/2005/gml/data xmlns:exprhttp://www.google.com/2005/gml/expr>head>link hrefhttps://www.blogger.com/static/v1/widgets/3566091532-css_bundle_v2.css relstylesheet typetext/css/>meta contentIEEmulateIE7 http-equivX-UA-Compatible/>meta contentwidth1100 nameviewport/>meta contenttext/html; charsetUTF-8 http-equivContent-Type/>meta contentblogger namegenerator/>link hrefhttp://blog.shlomoid.com/favicon.ico relicon typeimage/x-icon/>link hrefhttp://blog.shlomoid.com/ relcanonical/>link relalternate typeapplication/atom+xml titleRational Relational - Atom hrefhttp://blog.shlomoid.com/feeds/posts/default />link relalternate typeapplication/rss+xml titleRational Relational - RSS hrefhttp://blog.shlomoid.com/feeds/posts/default?altrss />link relservice.post typeapplication/atom+xml titleRational Relational - Atom hrefhttps://www.blogger.com/feeds/20434908/posts/default />!--Cant find substitution for tag blog.ieCssRetrofitLinks-->meta contenthttp://blog.shlomoid.com/ propertyog:url/>meta contentRational Relational propertyog:title/>meta content propertyog:description/>title>Rational Relational/title>style typetext/css>@font-face{font-family:Montserrat;font-style:normal;font-weight:400;font-display:swap;src:url(//fonts.gstatic.com/s/montserrat/v26/JTUHjIg1_i6t8kCHKm4532VJOt5-QNFgpCtr6Hw0aXpsog.woff2)format(woff2);unicode-range:U+0460-052F,U+1C80-1C88,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F;}@font-face{font-family:Montserrat;font-style:normal;font-weight:400;font-display:swap;src:url(//fonts.gstatic.com/s/montserrat/v26/JTUHjIg1_i6t8kCHKm4532VJOt5-QNFgpCtr6Hw9aXpsog.woff2)format(woff2);unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116;}@font-face{font-family:Montserrat;font-style:normal;font-weight:400;font-display:swap;src:url(//fonts.gstatic.com/s/montserrat/v26/JTUHjIg1_i6t8kCHKm4532VJOt5-QNFgpCtr6Hw2aXpsog.woff2)format(woff2);unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB;}@font-face{font-family:Montserrat;font-style:normal;font-weight:400;font-display:swap;src:url(//fonts.gstatic.com/s/montserrat/v26/JTUHjIg1_i6t8kCHKm4532VJOt5-QNFgpCtr6Hw3aXpsog.woff2)format(woff2);unicode-range:U+0100-02AF,U+0304,U+0308,U+0329,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20C0,U+2113,U+2C60-2C7F,U+A720-A7FF;}@font-face{font-family:Montserrat;font-style:normal;font-weight:400;font-display:swap;src:url(//fonts.gstatic.com/s/montserrat/v26/JTUHjIg1_i6t8kCHKm4532VJOt5-QNFgpCtr6Hw5aXo.woff2)format(woff2);unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+2074,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD;}/style>style idpage-skin-1 typetext/css>!--/*-----------------------------------------------Blogger Template StyleName: SimpleDesigner: Josh PetersonURL: www.noaesthetic.com----------------------------------------------- */#navbar-iframe {display: none !important;}/* Variable definitionsVariable namekeycolor descriptionMain Color typecolor default#66bbdd/>Group descriptionPage Text selector.content-inner>Variable namebody.font descriptionFont typefontdefaultnormal normal 12px Arial, Tahoma, Helvetica, FreeSans, sans-serif/>Variable namebody.text.color descriptionText Color typecolor default#222222/>/Group>Group descriptionBackgrounds selector.body-fauxcolumns-outer>Variable namebody.background.color descriptionOuter Background typecolor default#66bbdd/>Variable namecontent.background.color descriptionMain Background typecolor default#ffffff/>Variable nameheader.background.color descriptionHeader Background typecolor defaulttransparent/>/Group>Group descriptionLinks selector.main-outer>Variable namelink.color descriptionLink Color typecolor default#2288bb/>Variable namelink.visited.color descriptionVisited Color typecolor default#888888/>Variable namelink.hover.color descriptionHover Color typecolor default#33aaff/>/Group>Group descriptionBlog Title selector.header>Variable nameheader.font descriptionFont typefontdefaultnormal normal 60px Arial, Tahoma, Helvetica, FreeSans, sans-serif/>Variable nameheader.text.color descriptionTitle Color typecolor default#3399bb />Variable namedescription.text.color descriptionDescription Color typecolordefault#777777 />/Group>Group descriptionTabs Text selector.tabs-outer .PageList>Variable nametabs.font descriptionFont typefontdefaultnormal normal 14px Arial, Tahoma, Helvetica, FreeSans, sans-serif/>Variable nametabs.text.color descriptionText Color typecolor default#999999/>Variable nametabs.selected.text.color descriptionSelected Color typecolor default#000000/>/Group>Group descriptionTabs Background selector.tabs-outer .PageList>Variable nametabs.background.color descriptionBackground Color typecolor default#f5f5f5/>Variable nametabs.selected.background.color descriptionSelected Color typecolor default#eeeeee/>/Group>Group descriptionPost Title selector.post>Variable namepost.title.font descriptionFont typefontdefaultnormal normal 22px Arial, Tahoma, Helvetica, FreeSans, sans-serif/>/Group>Group descriptionPost Footer selector.post-footer>Variable namepost.footer.text.color descriptionText Color typecolor default#666666/>Variable namepost.footer.background.color descriptionBackground Color typecolordefault#f9f9f9/>Variable namepost.footer.border.color descriptionShadow Color typecolor default#eeeeee/>/Group>Group descriptionGadgets selector.sidebar .widget>Variable namewidget.title.font descriptionTitle Font typefontdefaultnormal bold 11px Arial, Tahoma, Helvetica, FreeSans, sans-serif/>Variable namewidget.title.text.color descriptionTitle Color typecolor default#000000/>Variable namewidget.alternate.text.color descriptionAlternate Color typecolor default#999999/>/Group>Group descriptionImages selector.main-inner>Variable nameimage.background.color descriptionBackground Color typecolor default#ffffff/>Variable nameimage.border.color descriptionBorder Color typecolor default#eeeeee/>Variable nameimage.text.color descriptionCaption Text Color typecolor default#222222/>/Group>Group descriptionAccents selector.content-inner>Variable namebody.rule.color descriptionSeparator Line Color typecolor default#eeeeee/>/Group>Variable namebody.background descriptionBody Background typebackgroundcolor#66bbdd default$(color) none repeat scroll top left/>Variable namebody.background.override descriptionBody Background Override typestring default/>Variable namebody.background.gradient.cap descriptionBody Gradient Cap typeurldefaulturl(http://www.blogblog.com/1kt/simple/gradients_light.png)/>Variable namebody.background.gradient.tile descriptionBody Gradient Tile typeurldefaulturl(http://www.blogblog.com/1kt/simple/body_gradient_tile_light.png)/>Variable namecontent.background.color.selector descriptionContent Background Color Selector typestring default.content-inner/>Variable namecontent.padding descriptionContent Padding typelength default10px/>Variable namecontent.shadow.spread descriptionContent Shadow Spread typelength default40px/>Variable namecontent.shadow.spread.webkit descriptionContent Shadow Spread (WebKit) typelength default5px/>Variable namecontent.shadow.spread.ie descriptionContent Shadow Spread (IE) typelength default10px/>Variable namemain.border.width descriptionMain Border Width typelength default0/>Variable nameheader.background.gradient descriptionHeader Gradient typeurl defaultnone/>Variable nameheader.shadow.offset.left descriptionHeader Shadow Offset Left typelength default-1px/>Variable nameheader.shadow.offset.top descriptionHeader Shadow Offset Top typelength default-1px/>Variable nameheader.shadow.spread descriptionHeader Shadow Spread typelength default1px/>Variable nameheader.border.size descriptionHeader Border Size typelength default1px/>Variable namedescription.text.size descriptionDescription Text Size typestring default140%/>Variable nametabs.margin.top descriptionTabs Margin Top typelength default0 />Variable nametabs.margin.side descriptionTabs Side Margin typelength default30px />Variable nametabs.background.gradient descriptionTabs Background Gradient typeurldefaulturl(http://www.blogblog.com/1kt/simple/gradients_light.png)/>Variable nametabs.border.width descriptionTabs Border Width typelength default1px/>Variable nametabs.bevel.border.width descriptionTabs Bevel Border Width typelength default1px/>Variable nameimage.border.small.size descriptionImage Border Small Size typelength default2px/>Variable nameimage.border.large.size descriptionImage Border Large Size typelength default5px/>Variable namepage.width.selector descriptionPage Width Selector typestring default.region-inner/>Variable namepage.width descriptionPage Width typestring defaultauto/>Variable namestartSide descriptionSide where text starts in blog language typeautomatic defaultleft/>Variable nameendSide descriptionSide where text ends in blog language typeautomatic defaultright/>*//* Content----------------------------------------------- */body {font: normal normal 14px Montserrat;color: #222222;background: #66bbdd none repeat scroll top left;padding: 0 40px 40px 40px;}body.mobile {padding: 0 5px 5px;}html body .region-inner {min-width: 0;max-width: 100%;width: auto;}a:link {text-decoration:none;color: #2288bb;}a:visited {text-decoration:none;color: #888888;}a:hover {text-decoration:underline;color: #33aaff;}.body-fauxcolumn-outer .fauxcolumn-inner {background: transparent url(http://www.blogblog.com/1kt/simple/body_gradient_tile_light.png) repeat scroll top left;_background-image: none;}.body-fauxcolumn-outer .cap-top {position: absolute;z-index: 1;height: 400px;width: 100%;background: #66bbdd none repeat scroll top left;}.body-fauxcolumn-outer .cap-top .cap-left {width: 100%;background: transparent url(http://www.blogblog.com/1kt/simple/gradients_light.png) repeat-x scroll top left;_background-image: none;}.content-outer {-moz-box-shadow: 0 0 40px rgba(0, 0, 0, .15);-webkit-box-shadow: 0 0 5px rgba(0, 0, 0, .15);-goog-ms-box-shadow: 0 0 10px #333333;box-shadow: 0 0 40px rgba(0, 0, 0, .15);margin-bottom: 1px;}.content-inner {padding: 10px;}.content-inner {background-color: #ffffff;}/* Header----------------------------------------------- */.header-outer {background: transparent none repeat-x scroll 0 -400px;_background-image: none;}.Header h1 {font: normal normal 64px Impact, sans-serif;color: #3399bb;text-shadow: -1px -1px 1px rgba(0, 0, 0, .2);}.Header h1 a {color: #3399bb;}.Header .description {font-size: 140%;color: #777777;}/* Tabs----------------------------------------------- */.tabs-inner .section:first-child {border-top: 1px solid #66bbdd;}.tabs-inner .section:first-child ul {margin-top: -1px;border-top: 1px solid #66bbdd;}.tabs-inner .widget ul {background: #f5f5f5 url(http://www.blogblog.com/1kt/simple/gradients_light.png) repeat-x scroll 0 -800px;_background-image: none;border-bottom: 1px solid #66bbdd;margin-top: 0;margin-left: -30px;margin-right: -30px;}.tabs-inner .widget li a {display: inline-block;padding: .6em 1em;font: normal normal 14px Arial, Tahoma, Helvetica, FreeSans, sans-serif;color: #999999;border-left: 1px solid #ffffff;border-right: 1px solid #66bbdd;}.tabs-inner .widget li:first-child a {border-left: none;}.tabs-inner .widget li.selected a, .tabs-inner .widget li a:hover {color: #000000;background-color: #eeeeee;text-decoration: none;}/* Columns----------------------------------------------- */.main-outer {border-top: 0 solid #66bbdd;}.fauxcolumn-left-outer .fauxcolumn-inner {border-right: 1px solid #66bbdd;}.fauxcolumn-right-outer .fauxcolumn-inner {border-left: 1px solid #66bbdd;}/* Headings----------------------------------------------- */h2 {margin: 0 0 1em 0;font: normal bold 11px Arial, Tahoma, Helvetica, FreeSans, sans-serif;color: #000000;text-transform: uppercase;}/* Widgets----------------------------------------------- */.widget .zippy {color: #999999;text-shadow: 2px 2px 1px rgba(0, 0, 0, .1);}/* Posts----------------------------------------------- */.post {margin: 0 0 25px 0;}h3.post-title, .comments h4 {font: normal normal 22px Arial, Tahoma, Helvetica, FreeSans, sans-serif;margin: .75em 0 0;}.post-body {font-size: 110%;line-height: 1.4;position: relative;}.post-body img, .post-body .tr-caption-container, .Profile img, .Image img,.BlogList .item-thumbnail img {padding: 2px;background: #ffffff;border: 1px solid #eeeeee;-moz-box-shadow: 1px 1px 5px rgba(0, 0, 0, .1);-webkit-box-shadow: 1px 1px 5px rgba(0, 0, 0, .1);box-shadow: 1px 1px 5px rgba(0, 0, 0, .1);}.post-body img, .post-body .tr-caption-container {padding: 5px;}.post-body .tr-caption-container {color: #222222;}.post-body .tr-caption-container img {padding: 0;background: transparent;border: none;-moz-box-shadow: 0 0 0 rgba(0, 0, 0, .1);-webkit-box-shadow: 0 0 0 rgba(0, 0, 0, .1);box-shadow: 0 0 0 rgba(0, 0, 0, .1);}.post-header {margin: 0 0 1.5em;line-height: 1.6;font-size: 90%;}.post-footer {margin: 20px -2px 0;padding: 5px 10px;color: #666666;background-color: #f9f9f9;border-bottom: 1px solid #eeeeee;line-height: 1.6;font-size: 90%;}#comments .comment-author {padding-top: 1.5em;border-top: 1px solid #66bbdd;background-position: 0 1.5em;}#comments .comment-author:first-child {padding-top: 0;border-top: none;}.avatar-image-container {margin: .2em 0 0;}#comments .avatar-image-container img {border: 1px solid #eeeeee;}/* Accents---------------------------------------------- */.section-columns td.columns-cell {border-left: 1px solid #66bbdd;}-->/style>style idtemplate-skin-1 typetext/css>!--body {min-width: 950px;}.content-outer, .content-fauxcolumn-outer, .region-inner {min-width: 950px;max-width: 950px;_width: 950px;}.main-inner .columns {padding-left: 0px;padding-right: 300px;}.main-inner .fauxcolumn-center-outer {left: 0px;right: 300px;/* IE6 does not respect left and right together */_width: expression(this.parentNode.offsetWidth -parseInt(0px) -parseInt(300px) + px);}.main-inner .fauxcolumn-left-outer {width: 0px;}.main-inner .fauxcolumn-right-outer {width: 300px;}.main-inner .column-left-outer {width: 0px;right: 100%;margin-left: -0px;}.main-inner .column-right-outer {width: 300px;margin-right: -300px;}#layout {min-width: 0;}#layout .content-outer {min-width: 0;width: 800px;}#layout .region-inner {min-width: 0;width: auto;}-->/style>script typetext/javascript> var _gaq _gaq || ; _gaq.push(_setAccount, UA-3175484-1); _gaq.push(_trackPageview); (function() { var ga document.createElement(script); ga.type text/javascript; ga.async true; ga.src (https: document.location.protocol ? https://ssl : http://www) + .google-analytics.com/ga.js; var s document.getElementsByTagName(script)0; s.parentNode.insertBefore(ga, s); })();/script>link hrefhttps://www.blogger.com/dyn-css/authorization.css?targetBlogID20434908&zx4ca3f059-ffdf-4179-931a-e690ee63bdbf medianone onloadif(media!'all')media'all' relstylesheet/>noscript>link hrefhttps://www.blogger.com/dyn-css/authorization.css?targetBlogID20434908&zx4ca3f059-ffdf-4179-931a-e690ee63bdbf relstylesheet/>/noscript>meta namegoogle-adsense-platform-account contentca-host-pub-1556223355139109/>meta namegoogle-adsense-platform-domain contentblogspot.com/>script async srchttps://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?clientca-pub-2049392246953619&hostca-host-pub-1556223355139109 crossoriginanonymous>/script>!-- data-ad-clientca-pub-2049392246953619 -->/head>body classloading>div classnavbar no-items section idnavbar>/div>div classbody-fauxcolumns>div classfauxcolumn-outer body-fauxcolumn-outer>div classcap-top>div classcap-left>/div>div classcap-right>/div>/div>div classfauxborder-left>div classfauxborder-right>/div>div classfauxcolumn-inner>/div>/div>div classcap-bottom>div classcap-left>/div>div classcap-right>/div>/div>/div>/div>div classcontent>div classcontent-fauxcolumns>div classfauxcolumn-outer content-fauxcolumn-outer>div classcap-top>div classcap-left>/div>div classcap-right>/div>/div>div classfauxborder-left>div classfauxborder-right>/div>div classfauxcolumn-inner>/div>/div>div classcap-bottom>div classcap-left>/div>div classcap-right>/div>/div>/div>/div>div classcontent-outer>div classcontent-cap-top cap-top>div classcap-left>/div>div classcap-right>/div>/div>div classfauxborder-left content-fauxborder-left>div classfauxborder-right content-fauxborder-right>/div>div classcontent-inner>header>div classheader-outer>div classheader-cap-top cap-top>div classcap-left>/div>div classcap-right>/div>/div>div classfauxborder-left header-fauxborder-left>div classfauxborder-right header-fauxborder-right>/div>div classregion-inner header-inner>div classheader section idheader>div classwidget Header data-version1 idHeader1>div idheader-inner>div classtitlewrapper>h1 classtitle>Rational Relational/h1>/div>div classdescriptionwrapper>p classdescription>span>/span>/p>/div>/div>/div>/div>/div>/div>div classheader-cap-bottom cap-bottom>div classcap-left>/div>div classcap-right>/div>/div>/div>/header>div classtabs-outer>div classtabs-cap-top cap-top>div classcap-left>/div>div classcap-right>/div>/div>div classfauxborder-left tabs-fauxborder-left>div classfauxborder-right tabs-fauxborder-right>/div>div classregion-inner tabs-inner>div classtabs no-items section idcrosscol>/div>div classtabs no-items section idcrosscol-overflow>/div>/div>/div>div classtabs-cap-bottom cap-bottom>div classcap-left>/div>div classcap-right>/div>/div>/div>div classmain-outer>div classmain-cap-top cap-top>div classcap-left>/div>div classcap-right>/div>/div>div classfauxborder-left main-fauxborder-left>div classfauxborder-right main-fauxborder-right>/div>div classregion-inner main-inner>div classcolumns fauxcolumns>div classfauxcolumn-outer fauxcolumn-center-outer>div classcap-top>div classcap-left>/div>div classcap-right>/div>/div>div classfauxborder-left>div classfauxborder-right>/div>div classfauxcolumn-inner>/div>/div>div classcap-bottom>div classcap-left>/div>div classcap-right>/div>/div>/div>div classfauxcolumn-outer fauxcolumn-left-outer>div classcap-top>div classcap-left>/div>div classcap-right>/div>/div>div classfauxborder-left>div classfauxborder-right>/div>div classfauxcolumn-inner>/div>/div>div classcap-bottom>div classcap-left>/div>div classcap-right>/div>/div>/div>div classfauxcolumn-outer fauxcolumn-right-outer>div classcap-top>div classcap-left>/div>div classcap-right>/div>/div>div classfauxborder-left>div classfauxborder-right>/div>div classfauxcolumn-inner>/div>/div>div classcap-bottom>div classcap-left>/div>div classcap-right>/div>/div>/div>!-- corrects IE6 width calculation -->div classcolumns-inner>div classcolumn-center-outer>div classcolumn-center-inner>div classmain section idmain>div classwidget Blog data-version1 idBlog1>div classblog-posts hfeed> div classdate-outer> h2 classdate-header>span>2023-07-03/span>/h2> div classdate-posts> div classpost-outer>div classpost hentry>a name6817802841345948822>/a>h3 classpost-title entry-title>a hrefhttp://blog.shlomoid.com/2023/07/is-blogging-dead.html>Is blogging dead?/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content>p>Its clear to whoever stumbles on this page today, that Ive not touched it in well over a decade. Blogger seems to have not changed much since, it only feels a bit more broken and weathered, like patio furniture left out for a few seasons./p>p>If you wonder why the site is up after all these years, it comes down to a few things. /p>p>Mostly, Ive figured I can keep this page up for the hundreds of people who search for some of the MySQL related posts and are perhaps even finding them usable, so many years after posting. If youre one of those, I hope it helped you. In the case it was one of those search dead ends and I wasted you a browser tab and a click... thats unfortunate. The rest of the content is a trip down memory lane to a time before social media, and its personally amusing to keep around./p>p>Another more subtle reason is the optimism and hope that perhaps Ill get back to publishing things at some point. Its kind of like keeping a motorcycle you dont have time to ride in our garage, just to feel you have your options open and identify yourself as a rider. As they say, hope dies last./p>div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-comment-link>a classcomment-link hrefhttp://blog.shlomoid.com/2023/07/is-blogging-dead.html#comment-form onclick>0comments/a>/span>span classpost-icons>/span>div classpost-share-buttons>a classgoog-inline-block share-button sb-email href&targetemail target_blank titleEmail This>span classshare-button-link-text>Email This/span>/a>a classgoog-inline-block share-button sb-blog href&targetblog onclickwindow.open(this.href, _blank, height270,width475); return false; target_blank titleBlogThis!>span classshare-button-link-text>BlogThis!/span>/a>a classgoog-inline-block share-button sb-twitter href&targettwitter target_blank titleShare to Twitter>span classshare-button-link-text>Share to Twitter/span>/a>a classgoog-inline-block share-button sb-facebook href&targetfacebook onclickwindow.open(this.href, _blank, height430,width640); return false; target_blank titleShare to Facebook>span classshare-button-link-text>Share to Facebook/span>/a>a classgoog-inline-block share-button sb-pinterest href&targetpinterest target_blank titleShare to Pinterest>span classshare-button-link-text>Share to Pinterest/span>/a>/div>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>/span>/div>div classpost-footer-line post-footer-line-3>/div>/div>/div>/div> /div>/div> div classdate-outer> h2 classdate-header>span>2013-10-22/span>/h2> div classdate-posts> div classpost-outer>div classpost hentry>a name8839867855776367151>/a>h3 classpost-title entry-title>a hrefhttp://blog.shlomoid.com/2013/10/under-hood-mysql-pool-scanner-mps.html>Under the Hood at Facebook: MySQL Pool Scanner (MPS)/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content>My a hrefhttps://www.facebook.com/notes/facebook-engineering/under-the-hood-mysql-pool-scanner-mps/10151750529723920>blog post about MPS/a> on the Facebook Engineering blog has been published today!br />br />This is a pretty amazing piece of automation that weve been building at Facebook for the past few years, and Im excited to be able to speak about it in public. br />br />Update: It is now also available at the a hrefhttps://code.facebook.com/posts/180455938822278/under-the-hood-mysql-pool-scanner-mps-/>new Facebook Code site/a>.br />br />div idfb-root>/div>script>(function(d, s, id) { var js, fjs d.getElementsByTagName(s)0; if (d.getElementById(id)) return; js d.createElement(s); js.id id; js.src //connect.facebook.net/en_US/all.js#xfbml1; fjs.parentNode.insertBefore(js, fjs); }(document, script, facebook-jssdk));/script>br />div classfb-post data-hrefhttps://www.facebook.com/notes/facebook-engineering/under-the-hood-mysql-pool-scanner-mps/10151750529723920 data-width550>div classfb-xfbml-parse-ignore>a hrefhttps://www.facebook.com/notes/facebook-engineering/under-the-hood-mysql-pool-scanner-mps/10151750529723920>Post/a> by a hrefhttps://www.facebook.com/Engineering>Facebook Engineering/a>./div>/div>div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-comment-link>a classcomment-link hrefhttp://blog.shlomoid.com/2013/10/under-hood-mysql-pool-scanner-mps.html#comment-form onclick>0comments/a>/span>span classpost-icons>/span>div classpost-share-buttons>a classgoog-inline-block share-button sb-email href&targetemail target_blank titleEmail This>span classshare-button-link-text>Email This/span>/a>a classgoog-inline-block share-button sb-blog href&targetblog onclickwindow.open(this.href, _blank, height270,width475); return false; target_blank titleBlogThis!>span classshare-button-link-text>BlogThis!/span>/a>a classgoog-inline-block share-button sb-twitter href&targettwitter target_blank titleShare to Twitter>span classshare-button-link-text>Share to Twitter/span>/a>a classgoog-inline-block share-button sb-facebook href&targetfacebook onclickwindow.open(this.href, _blank, height430,width640); return false; target_blank titleShare to Facebook>span classshare-button-link-text>Share to Facebook/span>/a>a classgoog-inline-block share-button sb-pinterest href&targetpinterest target_blank titleShare to Pinterest>span classshare-button-link-text>Share to Pinterest/span>/a>/div>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>Labels:a hrefhttp://blog.shlomoid.com/search/label/Facebook reltag>Facebook/a>,a hrefhttp://blog.shlomoid.com/search/label/MySQL reltag>MySQL/a>/span>/div>div classpost-footer-line post-footer-line-3>/div>/div>/div>/div> /div>/div> div classdate-outer> h2 classdate-header>span>2011-08-16/span>/h2> div classdate-posts> div classpost-outer>div classpost hentry>a name7812083108808871042>/a>h3 classpost-title entry-title>a hrefhttp://blog.shlomoid.com/2011/08/how-to-quickly-create-histogram-in.html>How to Quickly Create a Histogram in MySQL/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content>This is a post about a super quick-and-dirty way to create a histogram in MySQL for numeric values.br />div>There are multiple other ways to create histograms that are better and more flexible, using span classApple-style-span stylefont-family: Courier New, Courier, monospace;>CASE/span> statements and other types of complex logic. This method wins me over time and time again since its just so easy to modify for each use case, and so short and concise./div>div>This is how you do it:br />pre>span stylefont-family: Courier New;>span stylecolor: blue;>SELECT/span> span stylecolor: #ff0080;>b>ROUND/b>/span>span stylecolor: maroon;>(/span>span stylecolor: maroon;>numeric_value/span>span stylecolor: silver;>,/span> span stylecolor: silver;>-/span>span stylecolor: black;>2/span>span stylecolor: maroon;>)/span> span stylecolor: blue;>AS/span> span stylecolor: maroon;>bucket/span>span stylecolor: silver;>,/span> span stylecolor: #ff0080;>b>COUNT/b>/span>span stylecolor: maroon;>(/span>span stylecolor: silver;>*/span>span stylecolor: maroon;>)/span> span stylecolor: blue;>AS/span> span stylecolor: blue;>COUNT/span>span stylecolor: silver;>,/span> span stylecolor: #ff0080;>b>RPAD/b>/span>span stylecolor: maroon;>(/span>span stylecolor: red;>/span>span stylecolor: silver;>,/span> span stylecolor: #ff0080;>b>LN/b>/span>span stylecolor: maroon;>(/span>span stylecolor: #ff0080;>b>COUNT/b>/span>span stylecolor: maroon;>(/span>span stylecolor: silver;>*/span>span stylecolor: maroon;>)/span>span stylecolor: maroon;>)/span>span stylecolor: silver;>,/span> span stylecolor: red;>*/span>span stylecolor: maroon;>)/span> span stylecolor: blue;>AS/span> span stylecolor: maroon;>bar/span>span stylecolor: blue;>FROM/span> span stylecolor: maroon;>my_table/span>span stylecolor: blue;>GROUP/span> span stylecolor: blue;>BY/span> span stylecolor: maroon;>bucket/span>span stylecolor: silver;>;/span>/span>/pre>Just change span classApple-style-span stylecolor: maroon; font-family: Courier New; white-space: pre;>numeric_value/span> to whatever your column is, change the rounding increment, and thats it. Ive made the bars to be in logarithmic scale, so that they dont grow too much when you have large values.br />div>This is an example of such query on some random data that looks pretty sweet. Good enough for a quick evaluation of the data./div>div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>+--------+----------+-----------------+/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| bucket | count | bar |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>+--------+----------+-----------------+/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| -500 | 1 | |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| -400 | 2 | * |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| -300 | 2 | * |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| -200 | 9 | ** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| -100 | 52 | **** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 0 | 5310766 | *************** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 100 | 20779 | ********** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 200 | 1865 | ******** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 300 | 527 | ****** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 400 | 170 | ***** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 500 | 79 | **** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 600 | 63 | **** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 700 | 35 | **** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 800 | 14 | *** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 900 | 15 | *** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 1000 | 6 | ** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 1100 | 7 | ** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 1200 | 8 | ** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 1300 | 5 | ** |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 1400 | 2 | * |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>| 1500 | 4 | * |/span>/div>div>span classApple-style-span stylefont-family: Courier New, Courier, monospace;>+--------+----------+-----------------+/span>/div>/div>Some notes:br />Ranges that have no match will not appear in the count - you will not have a zero in the count column. Also, Im using the span classApple-style-span stylefont-family: Courier New, Courier, monospace;>ROUND/span> function here. You can just as easily replace it with span classApple-style-span stylefont-family: Courier New, Courier, monospace;>TRUNCATE/span> if you feel it makes more sense to you./div>div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-comment-link>a classcomment-link hrefhttp://blog.shlomoid.com/2011/08/how-to-quickly-create-histogram-in.html#comment-form onclick>8comments/a>/span>span classpost-icons>/span>div classpost-share-buttons>a classgoog-inline-block share-button sb-email href&targetemail target_blank titleEmail This>span classshare-button-link-text>Email This/span>/a>a classgoog-inline-block share-button sb-blog href&targetblog onclickwindow.open(this.href, _blank, height270,width475); return false; target_blank titleBlogThis!>span classshare-button-link-text>BlogThis!/span>/a>a classgoog-inline-block share-button sb-twitter href&targettwitter target_blank titleShare to Twitter>span classshare-button-link-text>Share to Twitter/span>/a>a classgoog-inline-block share-button sb-facebook href&targetfacebook onclickwindow.open(this.href, _blank, height430,width640); return false; target_blank titleShare to Facebook>span classshare-button-link-text>Share to Facebook/span>/a>a classgoog-inline-block share-button sb-pinterest href&targetpinterest target_blank titleShare to Pinterest>span classshare-button-link-text>Share to Pinterest/span>/a>/div>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>Labels:a hrefhttp://blog.shlomoid.com/search/label/MySQL reltag>MySQL/a>/span>/div>div classpost-footer-line post-footer-line-3>/div>/div>/div>/div> /div>/div> div classdate-outer> h2 classdate-header>span>2011-08-10/span>/h2> div classdate-posts> div classpost-outer>div classpost hentry>a name5727009011358620291>/a>h3 classpost-title entry-title>a hrefhttp://blog.shlomoid.com/2011/08/how-to-kill-all-connections-to-mongodb.html>How to Kill All Connections to MongoDB/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content>This post is similar to the previous one I have a hrefhttp://blog.shlomoid.com/2008/06/how-to-perform-connection-massacre.html>posted before for MySQL/a>. Only this time, its for MongoDB. br />Whats so nice about MongoDB is that the command line is actually a fully fledged javascript console. So you can do i>this/i>:br />script srchttp://gist-it.appspot.com/github/shlomoid/mongodb-snippets/raw/master/killall.js>/script>(the embedded script is not visible from the RSS feed though, so click through to the post itself)br />The function accepts two variables, both optional. br />The first one is the namespace for which youd like the connections to be working with. Its optional, but youd usually want to specify it. If you dont, youll kill all the connections, including the ones that perform replication duties.br />The second one is a wet run parameter, that if set to true actually does the killing. The default is false, thus not doing anything but print the connections to be killed to your console.br />br />The whole thing is a work in progress, plus my javascript skills are i>far/i> from perfect, so comments here or on a hrefhttps://github.com/shlomoid/mongodb-snippets>github/a> are welcome.br />A potential issue Ive already noticed is that when some operations are in a i>yeild/i> state, the namespaces first letter is a hrefhttp://www.mongodb.org/display/DOCS/Viewing+and+Terminating+Current+Operation>prefixed with a question mark/a> ?. In that case, the simple namespace filter will probably miss it. But, I didnt want to make the function any more complex than it already is.div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-comment-link>a classcomment-link hrefhttp://blog.shlomoid.com/2011/08/how-to-kill-all-connections-to-mongodb.html#comment-form onclick>3comments/a>/span>span classpost-icons>/span>div classpost-share-buttons>a classgoog-inline-block share-button sb-email href&targetemail target_blank titleEmail This>span classshare-button-link-text>Email This/span>/a>a classgoog-inline-block share-button sb-blog href&targetblog onclickwindow.open(this.href, _blank, height270,width475); return false; target_blank titleBlogThis!>span classshare-button-link-text>BlogThis!/span>/a>a classgoog-inline-block share-button sb-twitter href&targettwitter target_blank titleShare to Twitter>span classshare-button-link-text>Share to Twitter/span>/a>a classgoog-inline-block share-button sb-facebook href&targetfacebook onclickwindow.open(this.href, _blank, height430,width640); return false; target_blank titleShare to Facebook>span classshare-button-link-text>Share to Facebook/span>/a>a classgoog-inline-block share-button sb-pinterest href&targetpinterest target_blank titleShare to Pinterest>span classshare-button-link-text>Share to Pinterest/span>/a>/div>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>Labels:a hrefhttp://blog.shlomoid.com/search/label/MongoDB reltag>MongoDB/a>/span>/div>div classpost-footer-line post-footer-line-3>/div>/div>/div>/div> /div>/div> div classdate-outer> h2 classdate-header>span>2011-08-08/span>/h2> div classdate-posts> div classpost-outer>div classpost hentry>a name6380654001866472003>/a>h3 classpost-title entry-title>a hrefhttp://blog.shlomoid.com/2011/08/how-to-easily-see-whos-connected-to.html>How to Easily See Whos Connected to Your MySQL Server/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content>Im posting this here since it has been useful for me, and the blog is a nice place to keep public notes.br />If you have servers which have multiple application servers connected to them, you often need to see things like whos connected, how many connections they have, and which users. Using span classApple-style-span stylefont-family: Courier New; font-size: 13px;>span stylecolor: blue;>SHOW/span> span stylecolor: maroon;>PROCESSLIST/span>/span> doesnt work that well, since it gives you a row for each server.br />div>br />/div>What we want is an output similar to this:br />blockquote>pre>+-----------------+-----------------+----------+| host_short | users | count(*) |+-----------------+-----------------+----------+| slave1 | repl | 1 || slave2 | repl | 1 || localhost | event_scheduler | 1 || 111.111.222.111 | root, foo | 2 || 111.111.222.222 | appuser, bar | 3 || 111.111.222.333 | appuser, moshe | 9 |+-----------------+-----------------+----------+/pre>/blockquote>And it is achieved using a simple query such as this one:br />div>span stylefont-family: Courier New; font-size: 10pt;>br />span classApple-style-span stylecolor: blue;>span classApple-style-span stylecolor: black;>span stylecolor: blue;>SELECT/span> span stylecolor: #ff0080; font-weight: bold;>SUBSTRING_INDEX/span>span stylecolor: maroon;>(/span>span stylecolor: maroon;>host/span>span stylecolor: silver;>,/span> span stylecolor: red;>:/span>span stylecolor: silver;>,/span> span stylecolor: black;>1/span>span stylecolor: maroon;>)/span> span stylecolor: blue;>AS/span> span stylecolor: maroon;>host_short/span>span stylecolor: silver;>,/span>br /> span stylecolor: #ff0080; font-weight: bold;>GROUP_CONCAT/span>span stylecolor: maroon;>(/span>span stylecolor: blue;>DISTINCT/span> span stylecolor: blue;>USER/span>span stylecolor: maroon;>)/span> span stylecolor: blue;>AS/span> span stylecolor: maroon;>users/span>span stylecolor: silver;>,/span>br /> span stylecolor: #ff0080; font-weight: bold;>COUNT/span>span stylecolor: maroon;>(/span>span stylecolor: silver;>*/span>span stylecolor: maroon;>)/span>br />span stylecolor: blue;>FROM/span> span stylecolor: maroon;>information_schema/span>span stylecolor: silver;>./span>span stylecolor: maroon;>processlist/span>br />span stylecolor: blue;>GROUP/span> span stylecolor: blue;>BY/span> span stylecolor: maroon;>host_short/span>br />span stylecolor: blue;>ORDER/span> span stylecolor: blue;>BY/span> span stylecolor: #ff0080; font-weight: bold;>COUNT/span>span stylecolor: maroon;>(/span>span stylecolor: silver;>*/span>span stylecolor: maroon;>)/span>span stylecolor: silver;>,/span>br /> span stylecolor: maroon;>host_short/span>span stylecolor: silver;>;br />/span>/span>/span>/span>br />A final note: Im not sure what version of MySQL this query needs to function, but it works great on MySQL 5.5, and should work just as well on MySQL 5.1./div>div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-comment-link>a classcomment-link hrefhttp://blog.shlomoid.com/2011/08/how-to-easily-see-whos-connected-to.html#comment-form onclick>7comments/a>/span>span classpost-icons>/span>div classpost-share-buttons>a classgoog-inline-block share-button sb-email href&targetemail target_blank titleEmail This>span classshare-button-link-text>Email This/span>/a>a classgoog-inline-block share-button sb-blog href&targetblog onclickwindow.open(this.href, _blank, height270,width475); return false; target_blank titleBlogThis!>span classshare-button-link-text>BlogThis!/span>/a>a classgoog-inline-block share-button sb-twitter href&targettwitter target_blank titleShare to Twitter>span classshare-button-link-text>Share to Twitter/span>/a>a classgoog-inline-block share-button sb-facebook href&targetfacebook onclickwindow.open(this.href, _blank, height430,width640); return false; target_blank titleShare to Facebook>span classshare-button-link-text>Share to Facebook/span>/a>a classgoog-inline-block share-button sb-pinterest href&targetpinterest target_blank titleShare to Pinterest>span classshare-button-link-text>Share to Pinterest/span>/a>/div>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>Labels:a hrefhttp://blog.shlomoid.com/search/label/MySQL reltag>MySQL/a>/span>/div>div classpost-footer-line post-footer-line-3>/div>/div>/div>/div> /div>/div> div classdate-outer> h2 classdate-header>span>2011-08-06/span>/h2> div classdate-posts> div classpost-outer>div classpost hentry>a name5090980712239845212>/a>h3 classpost-title entry-title>a hrefhttp://blog.shlomoid.com/2011/08/how-to-move-mongodb-collection-between.html>How to Move a MongoDB Collection Between Databases/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content>If you need to move a collection between two MongoDB databases, there is no need to dump and restore your data using span classApple-style-span stylefont-family: monospace; white-space: pre;>mongodump / mongorestore./span>br />br />In a way, its pretty similar to what we can do with MySQLs a hrefhttp://dev.mysql.com/doc/refman/5.5/en/rename-table.html>RENAME TABLE/a> command:br />blockquote>pre>db.runCommand({renameCollection:b>sourcedb/b>.mycol,to:b>targetdb/b>.mycol})/pre>/blockquote>In the background, MongoDB will dump and restore it automatically. There is no metadata magic for such a rename since databases reside in different files on disk. It just saves a bit of work, and its worth knowing about.div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-comment-link>a classcomment-link hrefhttp://blog.shlomoid.com/2011/08/how-to-move-mongodb-collection-between.html#comment-form onclick>8comments/a>/span>span classpost-icons>/span>div classpost-share-buttons>a classgoog-inline-block share-button sb-email href&targetemail target_blank titleEmail This>span classshare-button-link-text>Email This/span>/a>a classgoog-inline-block share-button sb-blog href&targetblog onclickwindow.open(this.href, _blank, height270,width475); return false; target_blank titleBlogThis!>span classshare-button-link-text>BlogThis!/span>/a>a classgoog-inline-block share-button sb-twitter href&targettwitter target_blank titleShare to Twitter>span classshare-button-link-text>Share to Twitter/span>/a>a classgoog-inline-block share-button sb-facebook href&targetfacebook onclickwindow.open(this.href, _blank, height430,width640); return false; target_blank titleShare to Facebook>span classshare-button-link-text>Share to Facebook/span>/a>a classgoog-inline-block share-button sb-pinterest href&targetpinterest target_blank titleShare to Pinterest>span classshare-button-link-text>Share to Pinterest/span>/a>/div>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>Labels:a hrefhttp://blog.shlomoid.com/search/label/MongoDB reltag>MongoDB/a>/span>/div>div classpost-footer-line post-footer-line-3>/div>/div>/div>/div>div classpost-outer>div classpost hentry>a name2042922432025257382>/a>h3 classpost-title entry-title>a hrefhttp://blog.shlomoid.com/2011/08/how-to-fix-erroneously-named-mongodb.html>How to Fix Erroneously Named MongoDB Collections/a>/h3>div classpost-header>div classpost-header-line-1>/div>/div>div classpost-body entry-content>In MongoDB, collections are not supposed to include certain characters like, for example, a hyphen - or a slash /. The manual a hrefhttp://www.mongodb.org/display/DOCS/Collections>has this to say/a> on the matter:br />blockquote>Collection names b>should/b> begin with letters or an underscore and may include numbers; $ is reserved. Collections can be organized in namespaces; these are named groups of collections defined using a dot notation./blockquote>The keyword here is should. br />It is possible to create collations with names that do not adhere to these rules. This is not enforced at all. When you try to access such a collection from the shell, things dont quite work as expected:br />blockquote>pre>>db.test-col.find()Sat Aug 6 14:54:06 ReferenceError: col is not defined (shell):1/pre>/blockquote>This is because the javascript console tries to subtract col from test. Ive tried different escaping methods for the rogue hyphen, but couldnt find one that works.br />Eventually, Ive reverted to using the more internal renameCollection command, to rename the collection into something manageable:br />blockquote>pre>>db.runCommand({renameCollection:test.test-col,to:test.test_col})/pre>/blockquote>i>Which solves the problem completely./i>br />br />Now you might be wondering: how was this created in the first place? Because if you cant read from this collection, you cant save into it from the shell as well.br />We have a nice list of commands a hrefhttp://www.mongodb.org/display/DOCS/List+of+Database+Commands>here/a> which I recommend to anyone whos working with MongoDB to be familiar with. One of these commands is the aptly named create, which will obediently create a collection with such a name:br />blockquote>pre>>db.runCommand({create:test-col});{ ok : 1 }/pre>/blockquote>I can only assume drivers use this same command to create the collections, which was how it was created in the first place.div styleclear: both;>/div>/div>div classpost-footer>div classpost-footer-line post-footer-line-1>span classpost-comment-link>a classcomment-link hrefhttp://blog.shlomoid.com/2011/08/how-to-fix-erroneously-named-mongodb.html#comment-form onclick>5comments/a>/span>span classpost-icons>/span>div classpost-share-buttons>a classgoog-inline-block share-button sb-email href&targetemail target_blank titleEmail This>span classshare-button-link-text>Email This/span>/a>a classgoog-inline-block share-button sb-blog href&targetblog onclickwindow.open(this.href, _blank, height270,width475); return false; target_blank titleBlogThis!>span classshare-button-link-text>BlogThis!/span>/a>a classgoog-inline-block share-button sb-twitter href&targettwitter target_blank titleShare to Twitter>span classshare-button-link-text>Share to Twitter/span>/a>a classgoog-inline-block share-button sb-facebook href&targetfacebook onclickwindow.open(this.href, _blank, height430,width640); return false; target_blank titleShare to Facebook>span classshare-button-link-text>Share to Facebook/span>/a>a classgoog-inline-block share-button sb-pinterest href&targetpinterest target_blank titleShare to Pinterest>span classshare-button-link-text>Share to Pinterest/span>/a>/div>/div>div classpost-footer-line post-footer-line-2>span classpost-labels>Labels:a hrefhttp://blog.shlomoid.com/search/label/MongoDB reltag>MongoDB/a>/span>/div>div classpost-footer-line post-footer-line-3>/div>/div>/div>/div> /div>/div> /div>div classblog-pager idblog-pager>span idblog-pager-older-link>a classblog-pager-older-link hrefhttp://blog.shlomoid.com/search?updated-max2011-08-06T05:15:00-07:00&max-results7 idBlog1_blog-pager-older-link titleOlder Posts>Older Posts/a>/span>a classhome-link hrefhttp://blog.shlomoid.com/>Home/a>/div>div classclear>/div>div classblog-feeds>div classfeed-links>Subscribe to:a classfeed-link hrefhttp://blog.shlomoid.com/feeds/posts/default target_blank typeapplication/atom+xml>Posts (Atom)/a>/div>/div>/div>/div>/div>/div>div classcolumn-left-outer>div classcolumn-left-inner>aside>/aside>/div>/div>div classcolumn-right-outer>div classcolumn-right-inner>aside>div classsidebar section idsidebar-right-1>div classwidget HTML data-version1 idHTML1>div classwidget-content>script srchttps://platform.linkedin.com/badges/js/profile.js async defer typetext/javascript>/script>div classbadge-base LI-profile-badge data-localeen_US data-sizesmall data-themelight data-typeVERTICAL data-vanityshlomoid data-versionv1>a classbadge-base__link LI-simple-link hrefhttps://www.linkedin.com/in/shlomoid?trkprofile-badge>/a>/div>/div>div classclear>/div>/div>div classwidget PopularPosts data-version1 idPopularPosts1>h2>Popular Posts/h2>div classwidget-content popular-posts>ul>li>div classitem-content>div classitem-title>a hrefhttp://blog.shlomoid.com/2008/11/emulating-mysqls-groupconcat-function.html>Emulating MySQL’s GROUP_CONCAT() Function in SQL Server 2005/a>/div>div classitem-snippet>Sometimes, the small things make all the difference. Last month, a friend of mine that works at Intel asked me how to do something seeming e.../div>/div>div styleclear: both;>/div>/li>li>div classitem-content>div classitem-title>a hrefhttp://blog.shlomoid.com/2009/08/free-text-editor-for-very-large-huge.html>A Free Text Editor for Very Large / Huge Files on Windows/a>/div>div classitem-snippet>Every once in a while a programmer finds himself in need of a tool that allows him to edit very large text files. By large, I mean several g.../div>/div>div styleclear: both;>/div>/li>li>div classitem-content>div classitem-title>a hrefhttp://blog.shlomoid.com/2008/06/how-to-truncate-all-or-some-of-tables.html>How to Truncate All or Some of the Tables in a MySQL Database/a>/div>div classitem-snippet>Truncating all tables in a database is a common problem which arises a lot during testing or debugging. One of the most common answers to th.../div>/div>div styleclear: both;>/div>/li>li>div classitem-content>div classitem-title>a hrefhttp://blog.shlomoid.com/2011/08/how-to-easily-see-whos-connected-to.html>How to Easily See Whos Connected to Your MySQL Server/a>/div>div classitem-snippet>I'm posting this here since it has been useful for me, and the blog is a nice place to keep public notes. If you have servers which hav.../div>/div>div styleclear: both;>/div>/li>li>div classitem-content>div classitem-title>a hrefhttp://blog.shlomoid.com/2011/08/how-to-quickly-create-histogram-in.html>How to Quickly Create a Histogram in MySQL/a>/div>div classitem-snippet>This is a post about a super quick-and-dirty way to create a histogram in MySQL for numeric values. There are multiple other ways to creat.../div>/div>div styleclear: both;>/div>/li>/ul>div classclear>/div>/div>/div>div classwidget Label data-version1 idLabel1>h2>Labels/h2>div classwidget-content cloud-label-widget-content>span classlabel-size label-size-5>a dirltr hrefhttp://blog.shlomoid.com/search/label/MySQL>MySQL/a>span classlabel-count dirltr>(26)/span>/span>span classlabel-size label-size-4>a dirltr hrefhttp://blog.shlomoid.com/search/label/Databases>Databases/a>span classlabel-count dirltr>(10)/span>/span>span classlabel-size label-size-3>a dirltr hrefhttp://blog.shlomoid.com/search/label/Misc>Misc/a>span classlabel-count dirltr>(6)/span>/span>span classlabel-size label-size-3>a dirltr hrefhttp://blog.shlomoid.com/search/label/Linux>Linux/a>span classlabel-count dirltr>(5)/span>/span>span classlabel-size label-size-3>a dirltr hrefhttp://blog.shlomoid.com/search/label/Mac>Mac/a>span classlabel-count dirltr>(4)/span>/span>span classlabel-size label-size-2>a dirltr hrefhttp://blog.shlomoid.com/search/label/MongoDB>MongoDB/a>span classlabel-count dirltr>(3)/span>/span>span classlabel-size label-size-2>a dirltr hrefhttp://blog.shlomoid.com/search/label/Windows>Windows/a>span classlabel-count dirltr>(3)/span>/span>span classlabel-size label-size-2>a dirltr hrefhttp://blog.shlomoid.com/search/label/Delver>Delver/a>span classlabel-count dirltr>(2)/span>/span>span classlabel-size label-size-2>a dirltr hrefhttp://blog.shlomoid.com/search/label/SQL%20Server>SQL Server/a>span classlabel-count dirltr>(2)/span>/span>span classlabel-size label-size-1>a dirltr hrefhttp://blog.shlomoid.com/search/label/Chrome>Chrome/a>span classlabel-count dirltr>(1)/span>/span>span classlabel-size label-size-1>a dirltr hrefhttp://blog.shlomoid.com/search/label/Facebook>Facebook/a>span classlabel-count dirltr>(1)/span>/span>span classlabel-size label-size-1>a dirltr hrefhttp://blog.shlomoid.com/search/label/Google>Google/a>span classlabel-count dirltr>(1)/span>/span>span classlabel-size label-size-1>a dirltr hrefhttp://blog.shlomoid.com/search/label/InnoDB>InnoDB/a>span classlabel-count dirltr>(1)/span>/span>span classlabel-size label-size-1>a dirltr hrefhttp://blog.shlomoid.com/search/label/MySQL%20Connector>MySQL Connector/a>span classlabel-count dirltr>(1)/span>/span>span classlabel-size label-size-1>a dirltr hrefhttp://blog.shlomoid.com/search/label/Vista>Vista/a>span classlabel-count dirltr>(1)/span>/span>div classclear>/div>/div>/div>div classwidget BlogArchive data-version1 idBlogArchive1>h2>Archive/h2>div classwidget-content>div idArchiveList>div idBlogArchive1_ArchiveList>ul classhierarchy>li classarchivedate expanded>a classtoggle hrefjavascript:void(0)>span classzippy toggle-open> ▼ /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2023/>2023/a>span classpost-count dirltr>(1)/span>ul classhierarchy>li classarchivedate expanded>a classtoggle hrefjavascript:void(0)>span classzippy toggle-open> ▼ /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2023/07/>July/a>span classpost-count dirltr>(1)/span>ul classposts>li>a hrefhttp://blog.shlomoid.com/2023/07/is-blogging-dead.html>Is blogging dead?/a>/li>/ul>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2013/>2013/a>span classpost-count dirltr>(1)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2013/10/>October/a>span classpost-count dirltr>(1)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2011/>2011/a>span classpost-count dirltr>(6)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2011/08/>August/a>span classpost-count dirltr>(5)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2011/01/>January/a>span classpost-count dirltr>(1)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2010/>2010/a>span classpost-count dirltr>(5)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2010/11/>November/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2010/07/>July/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2010/02/>February/a>span classpost-count dirltr>(1)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2009/>2009/a>span classpost-count dirltr>(1)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2009/08/>August/a>span classpost-count dirltr>(1)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2008/>2008/a>span classpost-count dirltr>(23)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2008/11/>November/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2008/10/>October/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2008/07/>July/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2008/06/>June/a>span classpost-count dirltr>(2)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2008/05/>May/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2008/04/>April/a>span classpost-count dirltr>(1)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2008/03/>March/a>span classpost-count dirltr>(4)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2008/02/>February/a>span classpost-count dirltr>(6)/span>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2008/01/>January/a>span classpost-count dirltr>(6)/span>/li>/ul>/li>/ul>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2007/>2007/a>span classpost-count dirltr>(7)/span>ul classhierarchy>li classarchivedate collapsed>a classtoggle hrefjavascript:void(0)>span classzippy> ► /span>/a>a classpost-count-link hrefhttp://blog.shlomoid.com/2007/12/>December/a>span classpost-count dirltr>(7)/span>/li>/ul>/li>/ul>/div>/div>div classclear>/div>/div>/div>/div>/aside>/div>/div>/div>div styleclear: both>/div>!-- columns -->/div>!-- main -->/div>/div>div classmain-cap-bottom cap-bottom>div classcap-left>/div>div classcap-right>/div>/div>/div>footer>div classfooter-outer>div classfooter-cap-top cap-top>div classcap-left>/div>div classcap-right>/div>/div>div classfauxborder-left footer-fauxborder-left>div classfauxborder-right footer-fauxborder-right>/div>div classregion-inner footer-inner>div classfoot no-items section idfooter-1>/div>table border0 cellpadding0 cellspacing0 classsection-columns columns-2>tbody>tr>td classfirst columns-cell>div classfoot no-items section idfooter-2-1>/div>/td>td classcolumns-cell>div classfoot no-items section idfooter-2-2>/div>/td>/tr>/tbody>/table>!-- outside of the include in order to lock Attribution widget -->div classfoot no-items section idfooter-3>/div>/div>/div>div classfooter-cap-bottom cap-bottom>div classcap-left>/div>div classcap-right>/div>/div>/div>/footer>!-- content -->/div>/div>div classcontent-cap-bottom cap-bottom>div classcap-left>/div>div classcap-right>/div>/div>/div>/div>script typetext/javascript> window.setTimeout(function() { document.body.className document.body.className.replace(loading, ); }, 10); /script>script typetext/javascript srchttps://www.blogger.com/static/v1/widgets/3298326339-widgets.js>/script>script typetext/javascript>window__wavt AOuZoY7sy6rhP4kEtCbEevONyDzf8eOi1g:1720809316134;_WidgetManager._Init(//www.blogger.com/rearrange?blogID\x3d20434908,//blog.shlomoid.com/,20434908);_WidgetManager._SetDataContext({name: blog, data: {blogId: 20434908, title: Rational Relational, url: http://blog.shlomoid.com/, canonicalUrl: http://blog.shlomoid.com/, homepageUrl: http://blog.shlomoid.com/, searchUrl: http://blog.shlomoid.com/search, canonicalHomepageUrl: http://blog.shlomoid.com/, blogspotFaviconUrl: http://blog.shlomoid.com/favicon.ico, bloggerUrl: https://www.blogger.com, hasCustomDomain: true, httpsEnabled: false, enabledCommentProfileImages: true, gPlusViewType: FILTERED_POSTMOD, adultContent: false, analyticsAccountNumber: G-JWMV22YRTG, analytics4: true, encoding: UTF-8, locale: en, localeUnderscoreDelimited: en, languageDirection: ltr, isPrivate: false, isMobile: false, isMobileRequest: false, mobileClass: , isPrivateBlog: false, isDynamicViewsAvailable: true, feedLinks: \x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Rational Relational - Atom\x22 href\x3d\x22http://blog.shlomoid.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Rational Relational - RSS\x22 href\x3d\x22http://blog.shlomoid.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Rational Relational - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/20434908/posts/default\x22 /\x3e\n, meTag: , adsenseClientId: ca-pub-2049392246953619, adsenseHostId: ca-host-pub-1556223355139109, adsenseHasAds: true, adsenseAutoAds: true, boqCommentIframeForm: true, loginRedirectParam: , view: , dynamicViewsCommentsSrc: //www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js, dynamicViewsScriptSrc: //www.blogblog.com/dynamicviews/a6ed991e7ca0d194, plusOneApiSrc: https://apis.google.com/js/platform.js, disableGComments: true, interstitialAccepted: false, sharing: {platforms: {name: Get link, key: link, shareMessage: Get link, target: }, {name: Facebook, key: facebook, shareMessage: Share to Facebook, target: facebook}, {name: BlogThis!, key: blogThis, shareMessage: BlogThis!, target: blog}, {name: Twitter, key: twitter, shareMessage: Share to Twitter, target: twitter}, {name: Pinterest, key: pinterest, shareMessage: Share to Pinterest, target: pinterest}, {name: Email, key: email, shareMessage: Email, target: email}, disableGooglePlus: true, googlePlusShareButtonWidth: 0, googlePlusBootstrap: \x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e}, hasCustomJumpLinkMessage: false, jumpLinkMessage: Read more, pageType: index, pageName: , pageTitle: Rational Relational, metaDescription: }}, {name: features, data: {}}, {name: messages, data: {edit: Edit, linkCopiedToClipboard: Link copied to clipboard!, ok: Ok, postLink: Post Link}}, {name: template, data: {name: custom, localizedName: Custom, isResponsive: false, isAlternateRendering: false, isCustom: true}}, {name: view, data: {classic: {name: classic, url: ?view\x3dclassic}, flipcard: {name: flipcard, url: ?view\x3dflipcard}, magazine: {name: magazine, url: ?view\x3dmagazine}, mosaic: {name: mosaic, url: ?view\x3dmosaic}, sidebar: {name: sidebar, url: ?view\x3dsidebar}, snapshot: {name: snapshot, url: ?view\x3dsnapshot}, timeslide: {name: timeslide, url: ?view\x3dtimeslide}, isMobile: false, title: Rational Relational, description: , url: http://blog.shlomoid.com/, type: feed, isSingleItem: false, isMultipleItems: true, isError: false, isPage: false, isPost: false, isHomepage: true, isArchive: false, isLabelSearch: false}});_WidgetManager._RegisterWidget(_HeaderView, new _WidgetInfo(Header1, header, document.getElementById(Header1), {}, displayModeFull));_WidgetManager._RegisterWidget(_BlogView, new _WidgetInfo(Blog1, main, document.getElementById(Blog1), {cmtInteractionsEnabled: false, lightboxEnabled: true, lightboxModuleUrl: https://www.blogger.com/static/v1/jsbin/2877410179-lbx.js, lightboxCssUrl: https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle.css}, displayModeFull));_WidgetManager._RegisterWidget(_HTMLView, new _WidgetInfo(HTML1, sidebar-right-1, document.getElementById(HTML1), {}, displayModeFull));_WidgetManager._RegisterWidget(_PopularPostsView, new _WidgetInfo(PopularPosts1, sidebar-right-1, document.getElementById(PopularPosts1), {}, displayModeFull));_WidgetManager._RegisterWidget(_LabelView, new _WidgetInfo(Label1, sidebar-right-1, document.getElementById(Label1), {}, displayModeFull));_WidgetManager._RegisterWidget(_BlogArchiveView, new _WidgetInfo(BlogArchive1, sidebar-right-1, document.getElementById(BlogArchive1), {languageDirection: ltr, loadingMessage: Loading\x26hellip;}, displayModeFull));/script>/body>/html>
View on OTX
|
View on ThreatMiner
Please enable JavaScript to view the
comments powered by Disqus.
Data with thanks to
AlienVault OTX
,
VirusTotal
,
Malwr
and
others
. [
Sitemap
]