ÿØÿà JFIF    ÿÛ „ !.%+&8&+/1555$;@;4?.451 4,$,44444444444414444444444444444444444444444444444444ÿÀ  á á" ÿÄ     ÿÄ ?    !1AQaq"2‘¡±ÁðBRbrÑá#‚’¢²3S CñÿÄ   ÿÄ !    !1QAa‘2ÿÚ   ? 5˜Z¯V¦cø)›t/? z¨±>Õ5€¶‹Á¤·¼z¼Ü¬+ñ®v¤¨_ˆR­BFn©—˜ý®ç̝P8gýt·ÉSTŦˆìät?þé¼íìN/Þa)ì–í6ô… Ï¿øÃj´¿KÇü]ÿ ªô¹-eKànëÕHTx}ýSÜ›ÿ ”7Ø×&µ<¦  ¥ÑO¶[Ù¯ä¨ÞÃÿ PZ-¬;#õ|•oaÿ ©CìÞz3˜öː/¤­ñTûIØ}š^ mÓ%ªxˆ¥ÉŸu=Z+ISe¿45™¼u;ú&WØ÷€æßQ™®{|íx*TC“#ZŠìZ§²‹ 6pv…³¿¡äª*áZÐ%ÒOáˆo"x«OHk w±æ+¬V(kMúŸ5Vö«$ ÁrÏbàb57/luR ¸ÑÛj Òµì`Ðœq­û žICÀÊ•©4€Âcà¨Ï€O´<èÐ:›ù(Ë^L8þ‘ÍÌ#¸Ð_Ì©ÙK(Öz 4¬û+¸;ü’V’84‘¬ÃŽ:[â‡ÔÌáõp¢~§ªlæ£ö{®G>J¼"°‡7¯ÆÉèßû ‹É‹§ÁòÃýâßî ^ƾÙõ‹×óH#«LP½ïX=xÑÍ$|W?•~• îëÔ©ª‹ {ÝT…Kÿ ”hûâá)J*ö˜–ÔU;iÇ€/ ÆþjóZ\ýwØ=Ìm ºèËL9 ýèÆð/¨’¥öo=nË.%Îì ŽÕ¯È|{Oj²ƒE6e/ßdÄõ²Ìâ1O®ò×TsəԸhOMýíMˆ¿¼H˜l²,7Â¥#MF/Úf°Ö½± ¸–dr‹NýÊ íjqx{œÉ ä-È ¦ øÄër¨q°ð †nцýÑÄÆ’mä…n<0È™;ÁÝá¯ÁZƒ7FÀmì­ É&9ˆîéi¶ùN§Y• ÃZãAâ?•‡©‰ , ó¾IŸŠc1 4â&y­&pŠ­6;M À 0¹qç»p.á …ŸÅáK@%6·y6ƒ‰3?”úºŽ‰éX5ªPT §µ!=Mž«Ú½‹ÅgÂSâÉaþÓoö–¯ÁÔìR>5éÿ üs¶ÆUcÌ kÇR ]ÿ ù¬¼«VŽ;Â|‡~¢¦”ÏÅ°æ {L™Õ°Óv¹ò¸írŽ¡×¢CÃ!íVÕ {¶»sŒNPg/ "uÕbkm²“$ďå¿é¹§°½æz¯6 †s¿!s–wÚÝ“™Œ °.ûj>·+™Òa…©Œ&rÝÎtÛë긪Ît’LAVp%c Úý[ÄzJ¾ÇàXXç@˜ó<êL]·T˜¾¥1Ó©V‡g´æ½¦Ý@¹óø!_@´ÞâSÁ —S3™•& ]@JHÚý©ZŽ €×æÔr»Áf!‡yÞ4Mv*èÓã_{‘åóUuљØ«Oïé*®EvÑ Œ÷‡U \"㪒ÍK+À 4“M¡ï:0¥5í!'<@î´”>Ç»&Z–ïCCV˜Ì5Šo&îhè.žû |ÓK©h$s6KìŒëã)¹hI¦GïOåóI;ììü#É$Š0…Ææ¥TØ.5­¾gn´ “ÂÖ\:hœ89G)J@„}œ:’Ò{/Š"¦_Æ×7Æ3VÇŠÊa]ÚŒÙ€Ä–=®uÁßâACZƒ§§£ Qnâ:«,×{tyø¬iÛcœÜÄ€H½ÄÍCk´÷šß .W'b¤Íåh]÷€=,Žv×cÚEÚHXJX¶îo¨FÒtèöŸ>ªª6[J®Fµ£sGÁeqõfe\íjÒÐïÄÐGˆe1Ø‹.Ø”‘Ëuø Y­ˆÜ ŽG|zùªüMpDnQWÄ”%JŠ™)â*p@Örš«ÕT2Ð%ˆG#ª„ ·¤!°ŸOTÂT¸aÚ%4&h™LµšØüÐ.F¿²ÐÞ_Ç‚¾ÅÃaÜ÷09Æ q€öy˜v‡85õN÷]¬äѼóS{°_MŽ¬úÔ#°Ç¸0åÞè2ëôPcvÆw9®ií1Ä8F™˜à‰´+‰Ik1òÝ7“Ñ×ÒsÝ\x‚h`ÞÑ`ó"|µEcý£n˜h`}GÞ !±ù²Ápü²ß6 0ïi󜵩SÈÇ7˜-ÕURO˜¦´f$ªž-Í6(œ}<„ éc øs]ŽŽ„*—¾ ìdŽ„)méª\¿êÎIg¾ØÞ~I#C/¼¼´EÁÈŽi8“©õådô·>euä ƒ'Ê×लR1ÉJE1ÐAát`t;ÇР%Ý<‡¥„ÍÆ`×Oyó)õiI€ñQaŸ4Ûù\áàaÃÔ¹HÃu¹*k€¦<„e S‡&õÏ B!ŽhüÞ`yj}mªf×\¿ Ç~æ­9‡û\՞Ǖg²1Žû5V7 !àöšm° c`ܬøÇìµÒ'P"?…´Ö,"§^•õŽ¨sÔ)6˜sæéÍR¼ ò|Sl”‹7 nPW Gòú÷½§O¯‡„l¡kSÞŒr½PÊ@æ¢pŽ-mÿ #Ÿ˜Àº¶Áä¦;ïÔæ$1££`“Õ>„—·ž)ßð³ñ#Ï Ô$¶œ‰ÊE‹À;÷º ¯«P:Ñ”8–IÊtpÞ3ª“>ê“þës4ò2OÏÕ­±zô†Õ§‰.÷ä¸;¿˜“'œ›žª}«Œ{ª±Ì 9ÔóÞÕ‡0 $íWV3Üì¬ —@kÝ4@¿r¼±½¬™›?øØæ´'Áé®CË3-g$˜ö‡×auÚi´Žp/êÛ æF›Ú2v‹ã¿¿,nB1̨ƃqÞa5͝@&Æû“él÷ \C²½UÍc ¯k×¢U ÖéQå™—-r wô ÞÏ<Ò=&=ÿ Ôê Òêˈt,i—;LîÜ á¸*ÚÃ1$êL•LÍ <É)ýÐà’ ;F™{ƒ™˜€&'}‚ãÄK`¡ÞT@I;®žZóè‚s’7®°›+§O­Åq©é»²9<Ô J ¼9O’HL»Ùïì¸rk¼Ž_ý‘TŸu[²ßÚŒ·ü÷B%¯E ŸÔX5êO´ Ç•€’I0 ÉJX` ñ¹õ%;µŸD‘«´€àwÒ™U ûئžÖö\×®×´8 ½‡ºÐÆÓ§?Àkmœ=;d5*@-ì0F Rªýš[Ü6âö̃ڸr*KA9· u*µæ£?U¸Âêí†8@¦X4 e-ò„0s{ HâUpU?¼mñRa°®a%Ð'tÉ×’\¾ÊÉ]t›h>·(Ë@R¼¡Ãt h}’O÷au<+nT…Ö…MӐ??Óe95 q>í/;&JSû °¯ÊéÞ øƒ*Ã2½Ài&:nôUl=¾¿5eˆ3”ñc|Ú2V”>„»&eE;«ÚäC p¢Û úy 9š[ŒÌx¼擼A&DåÒ¯ˆ¤ÀÌ;"˜ ÏQä¸åhÊ}Ûq«Û0WžÒ|»€ø®öCm5•\ÇÀ§Pe3£]0ÃàLDÉ‰1øªxjgwT‚÷¿LΨK‹›ùs—xˆÜ±µ kæ¸f‰‰ÜGk/LÛØ6d9ò¶ùA{ƒA3š/¬D¬khÓk‰`˜"㯒r¿±Óã jx‡°e}<Ñø\3y:'À•/h½Í€Ç4~g ?Û(¼]v‘ªlKÎâ~?O‚W%{Ì:“'©úNq¾›úo(X’¥¯ˆ nFê{Ç€ü?º'ë ø‹ì Þ09ŒÌç9Æ —ËC`j@ÓÄ(+a‹un¸#ÂꟋ{K`‘ÑÍÍ'à´»/Û,KW;Þ4²þð ï Nm|~fGÏ(…³Ã)«1ö­Õ ¥‡¨©ƒÃ™ü-s=à=U66Ï«Ýc蓦W¹íž®›nÔ%êÇìŒ<#Ü×84ån®Ð ÒåOC` ñânÑs‡¢ç 1õ%Îhì½Ã½® e:ݼUZo™`  ÅZŸŒÊ«ê1ÏÄo$q¹Þ€©ˆhÐÉä¯ñ[!…Ú˜àJ:x2$Íß&PåT£6ç— ‡Í*4Ýšçjÿ ‰É nófÐ ó(L5C•åÆ\rMÒ@ò }y-W}™üýVù—ú¢=Ù”c®‘< M ž ´Phr ¦©TD ‘ù.$´÷O‡‘V2Æò.=IUŒ=ž‡â¬i™aþÓåÙ?òUø'ØÖ•.~* šTŒ!•-×áºTâ®ä#õü'´ eýlYÅÓeÕKÂrT"CÚ@u!Óxƒ{š3€}1¿(r}%«nËamjÑ%ÑNEò v ˜à  σöK³,*º.àzù¨™Ó ÚçâU¦*¿ 9{%Ö¹ njûdaXöb) kÛƱûÓ\°M7ˆÂ=û›ç¿Ã‚­V»Cg–8ÙêE- j)k$º`Ã-ùEýeBÆÇ]c¡°ñty&Òd0nõ'¡W+ƒ*|–øµFa\GQªEAÔp5\Ǽ·¼Ç8·õ -â§Ú[ ‡ uZeÖ 3}×d'+¹:ð+K†Û®s!Ï$úe€<Û”x)1»a­¡LC]¸µík…ÚàA»AYº{†ªS[¦5HÒ7ù --,ísòDØ€èk ÞÀîÜ ò@â( ËNˆë›4ô½•/¦o‡€Û7 ê•ÆêòðÜy'Án½µ á˜ݦ ndeo…[ì¶Ê,¥R³Ä=À±—–ß;£™´ñSâ*g§”ïaið‘Jå~™ÓÞ ß³Õ¢»8x埒²52>AÊb&-÷\7´éÄù€T˜,w;3{ï˜k…à¹ÄqÀ«œ{€\ ˆ¾[´¨јr &Úé„Ívˆ±8†¿]|¬ņ4I×pÞS1ÈÖz‰#Ìv‡G!YNògñ:màTz¢Ý1ô©^O=~ë|5Bã™ç•¼µõ•bÆ@úÕS¬ÈŒ#¬zünrŸ û” Z²•ï›èðV"ÁHÚý©wÝ €7¼Ìu1hÑa3Éä û f$o¿É ™Ú›ÝçnpÒ3äÌ3†Í§,Äï]$‰/pê †«À¼¸e9­Æê_C]žƒ·ý·frÁN«, E=›Çq -‰öŒ:aÏ¿±í&£Í:-} 84‘ÿ eƒQÑeëSsuiA ³g㟥ú£?ÿ ʼn*”“÷aühe:ÊWa@ÒÞk±eØ] F Ô—r.åä˜ @ö¥ªZoÐýYL·¥S²G/‡ñ <~*ZÆ´è>JlòàÛƽÿ 窘ìGN¢:I®KšJp/`íIÁÀõ#Ä-€ö­šµŒoF4|ÆQØÆ@Ì|£Ô…¢À{9˜è½Üó›€ôYÒÎYsið;ís¤€à²ˆ‚4qÉVŒI$ ‰"° æµ8cXGjœˏ¡Aâý•ËÜ¢ûï e·çLx']á"oÅÎê3¯Ç—¹”ó0nå‚âg{Œñ> S´˜îè°g238‚ãköÝfÚd´6Ò€;ò÷±¢™¼›º ¢Æ'¥Ðx'e¬ç ]bÈÆV¢ó‹kýBO ðÊâ$Ÿ!×T 3Mýמ žìٍàÌü‘8÷€àæØ8æ©6‰©L´«…oãpð„~Çk‰!ñ;‹”ÛžÍ àž±z Ÿôû øŸÝužÏ;ÿ #|u6™Þ¬ÚˆÐõA4¶â|ôl|Ê2ŽÇ¤ÝÅÇY.<#Aí.k§hóF‚”Y; M½Ö4hŸ4&›­¿tès´%FìL¥£Ãk‰ÇT¤haÁ¤ÚxfÉ`ÑìË›>i 3t‚:,–+^÷´–{Û–Nxi"x‘Ûg î¨>¥Õ܁ùZH,2Û“:8xÊ¢Çí9.É-Ìâã-=çjwµS˜dütžçwýGòú®®ûº_ˆýx$–¡ãøO EÚÛÏ÷R„×w+3£Á£öUMyR²¹âŒ°š›¸Ñãò9§Ó_Dl+Ùßc›úšGÅÌc†Ž!Ko=¶.‘Îÿ c²(2®V mª.ÿ ¹B›¹å ù„öŸSV>™ü¯$y:G¢Z×àøúdî¹û­·ýÇ´:•c LÍõi_‹ö+ÎæGÊè>OŠ•äž´§Þ{X}¨1ÚTc›»Qþ•êô°t¿OP?eæ~É{5]•ÙR£r5†nZ\ã@ &îJõ ¾àC°þV>fé¥/ü5ñÊIº_é5 ;e­h<@ Ä&æÃëE%;X,ÒãÆÞ`Oò¦kŸm#˜!ÀyÄ¢| óLšò¥Ä` ¶R=|ÈCâh5ò3DˆïF†ðÒ#ÅìÛœ?¸yhBãœí ZxßÎÄhºRK„`Þödvײ™ÀÈÑÒgŒuY w³%†ƒÓzõ ÖÏp‚dH®¦A´ù§»ÓÇMæ~)ˆð‡û:ù&Ä •vGD´À n ݇¼Ö8Fö óáà£~Ë¥x`oK|Ä?fxiØü%pìR>éò+Û±éÎ>núlFŤ'tq8LZÏvÃ?„¡ß±È⽆¯³íü@x|PöUäèØã¡ð‚ŒAìÏ"vÍwóŸÍ{ ý0.z È•Ö{,N¡£¡ŸKÕÙž>Ýœþ ÍÀ°<×EA!Å‚D™IúOÍ¡>ôG}Â` ÍßkÜL™Ž Þð™ {IøF²¹òQ3&!ÃÂÞz.d&Ï-sH¸,Ôõ˜ŽP€ 77ˆÝ¼ÊëÜw =cÕ Ú,ØÐ5ÎYÐ)ì´öœgŒ[¤ßv㙑8心>h]§µháYš£²ºÑ.{Ï7Sð•?´~×SÃKýJÛ˜ ™Íäiúu<µX¶1õ^kâçIÑ£sZ4h>j*ÔšD:4­¿_ ÷¸ Õxæÿ ¸?Mù _•­ÊÐ ä ÷ý ÑwL œ­ïnTkÛUÍN©ë:¦fV ¶ÜÔÜMªÅâA½–¿R×TXš-%iTÊT•‡Ù‚JôϐZxWÑè‰f‰òG º ×Õû2aZ7OU3[“×AT–ÞŒ…-‘¤”Ì ì&(ˆ¿­•ƒkï’:ðY¦W‘ Å)“†‘˜³Åtcø˜ñTÂwÚÇ4|üLÇªí–v- qˆèU qPE.†â‘˜µ Æ,ÐÅs]8¾„oúÑ i>ÜxxÈó)ƒ ´æÁâØ$À‰vžŸf$Ž |ãw;ÀÁIJ»b` {¦Ó¤Ú$©YÀ‘n@Óïž«9J¼êG m¤ ܯ¹ÌW4€ÐÒÅÛ‡#褕Ÿn-?í|с¥÷Ú¹¬'´ÞÜ9ÓK `hê£SÄSà?7—Wí_´…óB›»:=Ãïq`<8ñÓŒÑlú2d¬ê³£hÖ[l|$vÝro~'R®‰§°ñmY ͧäP |PUª¹·:3Œ[Û{Xÿ ºâ@‚W–Äé u‚ ¯´*=íή.pûÒdt @G‰¬ s¸ ëÉücr ÞæѨÊ@>¤¢Ö±. Þ'¯°ÌME[YéïĵÂCå½ Ué©Áû'Ê9%eÔðNU”ë‘ÌsD3/®+UI˜9h.WC”빓$#:pz:YÓ ¿xž* ³$Í +$kñAŠ‹†¢ Uê>¸)_š¬÷©ßAÂÔb9ÇU ¯¾á•9¯ÏÏ÷O÷¼¼Fähal1‰3Ì[Ïr•´UCksNÐ] R‘¸¥H+§Šé†c©vÖÞ0iÓ76s†î!§=ß ¼~Ô'°Ãmäoäš³ªøi1úÉ)³yV8 CLÄØÁ‘WYïi€H6ÖÑiámø^ÈY´°Ñ7¥Û*—Ñ©L«Qƒï—Ùrÿ ›£Ð*š¸ˆL©ˆ$ˆ ÷¾D§9È®«qbqC)–ˆïv´çñsÑVT­Ø, <àïºÀO«Jý·õ àfPìð .wFšir´þ’2_Y *Æ€x\« ì€9š@ Ž|F⇥ˆkZ@hÖÄ0t¿-<“‹qµ¾*ZL¤Ú)&BJpÓF5=$„at*Zš$’ÑtdûÝRI1 2Ž‰$€$I$#‰SÞ’Hë¬ï;Á$¡t$’`<(ñÇt)$‡Ð.Êf¢X’Kt=Éé$‚ˆªè¢oÝëòI%Rgcª÷ŠyI%¡‰ÿ !ñ)´õ $¤ Ô’IIGÿÙimport agent_util import csv import sys if sys.version[0] == "3": from io import StringIO else: from StringIO import StringIO from agent_util import float def execute_query(config, query): cmd = agent_util.which("mysql", exc=True) if "host" in config: cmd += " -h %s" % config["host"] if "port" in config: cmd += " -P %s" % config["port"] if "username" in config: cmd += " -u %s" % config["username"] if "password" in config and config["password"].strip(): cmd += " --password='%s'" % config["password"].strip() cmd += " -Be %r" % str(query) if "database" in config: cmd += " %s" % config["database"].strip() status, output = agent_util.execute_command(cmd) if status != 0: raise Exception(output) output = StringIO(output) parsed_output = list(csv.reader(output, delimiter="\t")) matcher = "mysql: [Warning] Using a password on the command line interface can be insecure." for i in parsed_output: if matcher in parsed_output[0]: del parsed_output[0] return parsed_output def parse_instance_configs(config): """ Parse the configuration info for multiple instances from the MySQL config block that gets passed in from the agent. """ instance_configs = {} extended_metrics = None for key, values in config.items(): if key == "extended_metrics": extended_metrics = values else: for i, value in enumerate(str(values).split(",")): if i not in instance_configs: instance_configs[i] = {} if len(value) > 0: instance_configs[i][key] = value # We assume that the extended metrics option # applies to all instances, so if it was found in the # config, apply it to all instances if extended_metrics is not None: for i, config in instance_configs.items(): config["extended_metrics"] = extended_metrics return instance_configs.values() def resource_name(instance_config): """ Returns the resource name for a given instance_config """ host = instance_config.get("host", "127.0.0.1") port = instance_config.get("port", "3306") db = instance_config.get("database", None) resource = "%s:%s" % (host, port) if db: resource += "-%s" % db return resource def get_instance_config(resource, all_configs): """ Search for an instance config in 'all_configs' that has a resource name equal to 'resource' """ for config in all_configs: if resource_name(config) == resource: return config return all_configs[0] def metadata_options(instance_configs): """ Given a set of instance configs, generate the 'option' field for the agent metadata payload. """ options = [] for config in instance_configs: d = { "host": config.get("host", "127.0.0.1"), "port": config.get("port", "3306"), "resource": resource_name(config), } if "database" in config and config["database"]: d["database"] = config["database"] options.append(d) return options READ_COMMANDS = { "com_selects_per_second": "Com_select", "com_writes_per_second": "Com_insert", "com_updates_per_second": "Com_update", "com_deletes_per_second": "Com_delete", } class MySQLPlugin(agent_util.Plugin): textkey = "mysql" label = "MySQL" @classmethod def get_metadata(self, config): status = agent_util.SUPPORTED msg = None instance_configs = parse_instance_configs(config) options = metadata_options(instance_configs) # check if mysql is even installed client_installed = agent_util.which("mysql") if not client_installed: msg = "MySQL client was not found. Please install the client or add it to the default path." self.log.info(msg) status = agent_util.MISCONFIGURED if status == agent_util.SUPPORTED and not config: msg = "The [mysql] config block was not found in the agent config file." self.log.info(msg) status = agent_util.MISCONFIGURED if status == agent_util.SUPPORTED: for cfg in instance_configs: if not "username" in cfg or not "password" in cfg: msg = "The username and password entries were not found in the [mysql] block of the agent config file." self.log.info(msg) status = agent_util.MISCONFIGURED if status == agent_util.SUPPORTED: for cfg in instance_configs: try: output = execute_query(cfg, "SHOW DATABASES") if cfg.get("debug", False): self.log.debug( "#####################################################" ) self.log.debug("Mysql command 'SHOW DATABASES' output:") self.log.debug(str(output)) self.log.debug( "#####################################################" ) except: self.log.exception("error running mysql query") status = agent_util.MISCONFIGURED msg = "Unable to authenticate with MySQL, please double-check the credentials in the agent config file." data = { # basic "queries_per_second": { "label": "Average queries per second", "options": options, "status": status, "error_message": msg, "unit": "queries/s", }, "slow_queries_per_minute": { "label": "Average number of slow queries per minute", "options": options, "status": status, "error_message": msg, "unit": "queries/minute", }, "query_cache.percent_free": { "label": "MySQL query cache percent free", "options": options, "status": status, "error_message": msg, "unit": "percent", }, "query_cache.kb_free": { "label": "MySQL query cache amount free (kB)", "options": options, "status": status, "error_message": msg, "unit": "kB", }, "connections": { "label": "MySQL connections", "options": options, "status": status, "error_message": msg, "unit": "connections", }, "com_selects_per_second": { "label": "SELECT rate", "options": options, "status": status, "error_message": msg, "unit": "transactions/s", }, "com_writes_per_second": { "label": "INSERT rate", "options": options, "status": status, "error_message": msg, "unit": "transactions/s", }, "com_updates_per_second": { "label": "UPDATE rate", "options": options, "status": status, "error_message": msg, "unit": "transactions/s", }, "com_deletes_per_second": { "label": "DELETE rate", "options": options, "status": status, "error_message": msg, "unit": "transactions/s", }, # replication "slave.running": { "label": "MySQL Slave server is replicating", "options": options, "status": status, "error_message": msg, }, "slave.io_running": { "label": "MySQL Slave server is connected to the Master", "options": options, "status": status, "error_message": msg, }, "slave.latency": { "label": "MySQL Slave server latency (seconds)", "options": options, "status": status, "error_message": msg, "unit": "seconds", }, "extended_metric.innodb_row_lock_current_waits": { "label": "Innodb current row lock waits", "options": options, "status": status, "error_message": msg, "unit": "waits", }, "extended_metric.innodb_row_lock_time_avg": { "label": "Innodb row lock time avg", "options": options, "status": status, "error_message": msg, "unit": "ms", }, "extended_metric.threads_connected": { "label": "Threads connected", "options": options, "status": status, "error_message": msg, "unit": "threads", }, "extended_metric.threads_created": { "label": "Threads Created", "options": options, "status": status, "error_message": msg, "unit": "threads", }, "extended_metric.threads_running": { "label": "Threads Running", "options": options, "status": status, "error_message": msg, "unit": "threads", }, "extended_metric.questions": { "label": "MySQL Questions - count of statements executed from the client", "options": options, "status": status, "error_message": msg, "unit": "questions", }, "extended_metric.innodb_buffer_pool_pages_total": { "label": "Total pages in the buffer pool", "options": options, "status": status, "error_message": msg, "unit": "pages", }, "extended_metric.innodb_buffer_pool_read_requests": { "label": "Requests made to the buffer pool", "options": options, "status": status, "error_message": msg, "unit": "requests/s", }, "extended_metric.innodb_buffer_pool_reads": { "label": "Requests unfulfilled by the buffer pool", "options": options, "status": status, "error_message": msg, "unit": "reads/s", }, } extended_metrics = [] for cfg in instance_configs: if "extended_metrics" in cfg: extended_metrics = [ m.strip().lower() for m in cfg["extended_metrics"].split(",") ] for m in extended_metrics: data["extended_metric.%s" % m] = { "label": "MySQL %s" % m.replace("_", " "), "options": options, "status": status, "error_message": msg, } # galera cluster metrics if status == agent_util.SUPPORTED: galera_instance_configs = [] for cfg in instance_configs: if "wsrep" in str( execute_query(cfg, "SHOW GLOBAL STATUS LIKE 'wsrep%'") ): galera_instance_configs.append(cfg) if len(galera_instance_configs) > 0: galera_options = metadata_options(galera_instance_configs) data["galera_cluster_size"] = { "label": "Galera Cluster Size", "options": galera_options, "status": status, "error_message": msg, } data["galera_local_send_queue_avg"] = { "label": "Galera Send Queue Length", "options": galera_options, "status": status, "error_message": msg, } data["galera_local_rcv_queue_avg"] = { "label": "Galera Average size of Local Received Queue", "options": galera_options, "status": status, "error_message": msg, } return data @classmethod def get_metadata_docker(self, container, config): if "host" not in config: try: ip = agent_util.get_container_ip(container) config["host"] = ip except Exception: self.log.exception("get_metadata_docker error") return self.get_metadata(config) def check(self, textkey, data, config): instance_configs = parse_instance_configs(config) instance_config = get_instance_config(data, instance_configs) return self.check_instance(textkey, data, instance_config) def check_instance(self, textkey, resource, config): if textkey == "queries_per_second": col, res = execute_query( config, "SHOW GLOBAL STATUS where Variable_name='Queries';" ) if not res: return None curr_reqs = float(res[1]) delta, previous_reqs = self.get_mysql_cache(resource, textkey, curr_reqs) if not previous_reqs or curr_reqs < previous_reqs: return None return int((curr_reqs - previous_reqs) / float(delta)) if textkey == "slow_queries_per_second": col, res = execute_query( config, "SHOW GLOBAL STATUS where Variable_name='Slow_queries';" ) if not res: return None curr_reqs = float(res[1]) delta, previous_reqs = self.get_mysql_cache(resource, textkey, curr_reqs) if previous_reqs is None or curr_reqs < previous_reqs: return None return (curr_reqs - previous_reqs) / float(delta) if textkey == "slow_queries_per_minute": col, res = execute_query( config, "SHOW GLOBAL STATUS where Variable_name='Slow_queries';" ) if not res: return None curr_reqs = float(res[1]) delta, previous_reqs = self.get_mysql_cache(resource, textkey, curr_reqs) if previous_reqs is None or curr_reqs < previous_reqs: return None return (curr_reqs - previous_reqs) / float(delta / 60.0) if textkey in ( "com_selects_per_second", "com_writes_per_second", "com_updates_per_second", "com_deletes_per_second", ): column_name = READ_COMMANDS.get(textkey) _, data = execute_query( config, "SHOW GLOBAL STATUS WHERE Variable_name='%s';" % column_name ) if not data: return None curr_data = float(data[1]) delta, previous_data = self.get_mysql_cache(resource, textkey, curr_data) if previous_data is None or curr_data < previous_data: return None return (curr_data - previous_data) / float(delta) if "query_cache" in textkey: res = execute_query(config, "SHOW GLOBAL STATUS LIKE 'Qcache_free_memory';") if not res: return None row = res[1] free = int(row[1]) self.log.debug("cache_free_memory: %d" % free) res = execute_query(config, "SHOW VARIABLES LIKE 'query_cache_size';") row = res[1] total = int(row[1]) self.log.debug("query_cache_size: %d" % total) if "percent_free" in textkey: if not total: return 0 return_val = int(float(free) / total * 100) self.log.debug("Percent free: %d" % return_val) return return_val else: return free elif textkey == "connections": res = execute_query(config, "SHOW GLOBAL STATUS LIKE 'Threads_connected';") if not res: return None row = res[1] self.log.debug("Threads connected: %s" % str(row[1])) return int(row[1]) # galera if textkey == "galera_cluster_size": res = execute_query(config, "SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';") if not res: return None row = res[1] free = int(row[1]) self.log.debug("galera_cluster_size: %d" % free) return int(row[1]) if textkey == "galera_local_send_queue_avg": res = execute_query( config, "SHOW GLOBAL STATUS LIKE 'wsrep_local_send_queue';" ) if not res: return None row = res[1] free = int(row[1]) self.log.debug("galera_local_send_queue_avg: %d" % free) return int(row[1]) if textkey == "galera_local_rcv_queue_avg": res = execute_query( config, "SHOW GLOBAL STATUS LIKE 'wsrep_local_recv_queue';" ) if not res: return None row = res[1] free = int(row[1]) self.log.debug("galera_local_rcv_queue_avg: %d" % free) return int(row[1]) # extended_metrics elif "extended_metric" in textkey: metric_name = textkey.replace("extended_metric.", "") res = execute_query( config, "SHOW GLOBAL STATUS LIKE '" + metric_name + "';" ) try: row = res[1] result = int(row[1]) except: result = 0 if metric_name in ( "innodb_buffer_pool_read_requests", "innodb_buffer_pool_reads", ): curr_data = result delta, previous_data = self.get_mysql_cache( resource, textkey, curr_data ) if previous_data is None or curr_data < previous_data: result = None else: result = (curr_data - previous_data) / float(delta) self.log.debug( "%s: %s" % (textkey.replace("extended_metric.", "").title(), str(result)) ) return result # replication action = textkey.split(".")[-1] query_map = { "running": ("Slave_SQL_Running", lambda c: int(c == "Yes")), "io_running": ("Slave_IO_Running", lambda c: int(c == "Yes")), "latency": ("Seconds_Behind_Master", lambda c: int(c)), } column, fn = query_map[action] try: keys, values = execute_query(config, "SHOW SLAVE STATUS") except: self.log.info("Replication metrics not available") return None row = values[keys.index(column)] # apparently some mysql modules return an integer # and some a string.... normalize it row = str(row) if action == "latency" and not row: return 999999 elif not row: return False return fn(row) def check_docker(self, container, textkey, data, config): if "host" not in config: try: ip = agent_util.get_container_ip(container) config["host"] = ip except Exception as e: self.log.exception(e) return self.check(textkey, data, config) # USING THIS FOR 'D.R.Y.' and just because we may add cached results of other types in the future def get_mysql_cache(self, resource, textkey, curr_reqs): cache = self.get_cache_results("mysql:%s:%s" % (resource, textkey), None) if not cache: self.log.info("Empty mySQL cache! Building for the first time.") self.cache_result( "mysql:%s:%s" % (resource, textkey), None, curr_reqs, replace=True ) return None, None delta, previous_reqs = cache[0] self.cache_result( "mysql:%s:%s" % (resource, textkey), None, curr_reqs, replace=True ) return delta, float(previous_reqs)