goma smile Posted December 16, 2013 Report Share Posted December 16, 2013 Lab lab zinu ka ir pilna google ar atrodamām utilītēm, bet vai tomēr kāds nevar ieteikt labu, ar diagramām utt... programmu kas novero vaicājumus to izpildi noslogojumu utt... kas attiecās uz mysql vaicājumiem. lai pēc tās varētu "meklēt", labot vaicajumu skaitu jo nebūtu tak pareizi $varible sastāv no 100; foreach ($varible as $value){ mysql_query("SELECT * KKO_entās reizes WHERE id=".$value->id); } Quote Link to comment Share on other sites More sharing options...
aaxc Posted December 16, 2013 Report Share Posted December 16, 2013 Šādi neder? "SELECT * FROM `table` WHERE id IN (" . implode( ',', $variable ) . ");" Quote Link to comment Share on other sites More sharing options...
goma smile Posted December 16, 2013 Author Report Share Posted December 16, 2013 Nu jā tāds varētu būt risinājums, bet es domāju par programmām ar grafiskiem novērojumiem, kuri vaicājumi, no kurienes tiek vaicāti viss vairāk to trafiks.... Noslogojums utt.. Quote Link to comment Share on other sites More sharing options...
aaxc Posted December 16, 2013 Report Share Posted December 16, 2013 http://www.google.lv/search?q=MySQL+Monitor Quote Link to comment Share on other sites More sharing options...
AnotherUser Posted December 16, 2013 Report Share Posted December 16, 2013 Uz linuxa, bez grafikiem, ātrais risinājums 'mytop' Quote Link to comment Share on other sites More sharing options...
marrtins Posted December 16, 2013 Report Share Posted December 16, 2013 Diagrammas? Kas lieto diagrammas? :D http://www.percona.com/doc/percona-toolkit/2.2/pt-query-digest.html Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.