MySql Enable Logs for Queries , Expert Way!

show variables like 'general_log%'


+------------------+------------------------------------------------------------
| Variable_name    | Value
+------------------+------------------------------------------------------------
| general_log      | OFF
| general_log_file | C:\ProgramData\MySQL\MySQL Server 5.5\Data\pixomachine.log
+------------------+------------------------------------------------------------



 set GLOBAL general_log='ON';


C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld, Version: 5.5.25a (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: MySQL
Time                 Id Command    Argument
130310  1:09:40    1 Query select * from users

Comments

Post a Comment

Popular posts from this blog

Hibernate queries are slow ! SQL Server's are not my type ? - Here is what you need to know!

Image
  " Hibernate is one of most  cited culprit for slower queries ! ", though I am kind of victim of this thought for sometime until I "understood" the true wisdom of lame excuses :) http://imgs.xkcd.com/comics/estimation.png Though sometimes this epic comic reflects my mental turbulence during the performance improvement katas... I learned not to go by hunches, but on real hard facts and truths. One interesting problem I found recently pretty annoying me for days (actually months sparingly) was slow query performance of the total application I was working on. Though the problem is itself is pretty basics, but the process of tuning and troubleshooting is what I thought is interesting. To give a background, I was running Hibernate/Java/Spring Stack SQL Server 2008 as my DB (it's out of choice unquestionably) but I don't mind and stick to one technology so opportunity to try new / old things are always good.   Here is the graph of the actu
Read more

IFTTT Service descriptions with Google Search

Disclaimer:  pure hack,  don't judge on my coding skills ;) I have been trying to make use of some channels in IFTTT, and obviously the channel doesn't say what each logo means, just wrote some code to pull up all the service names in IFTTT and came up with google search for each descriptions IFTTT service listing in chrome console: https://ifttt.com/channels var sm=new Array();$.each($('.channel-grid-item__title'),function(){sm.push($(this).html());}) They have IFTTT may be useful feed https://ifttt.com/feed, but as I said pure hack this is. Gist to generate your own: https://gist.github.com/mehmoodz/d7e777f78a837d36fc53 Here is the list, Amazon Echo: Always Ready, Connected, and Fast. :Echo connects to Alexa , a cloud-based voice service, to provide information, answer questions, play music, read the news, check sports scores or the weather,  ... 11 Tips to Boost Your Android Phone's Battery Life | PCMag.com :May 1, 2014 ... But
Read more

Detecting browser event closing in Javascript

I've been working on a feature where the user must be prompted to take up certain action when he leaves a page by closing the browser window or by clicking an external URL,though I searched for the best possible solution but unfortunately couldn't find one. The first thing that got my attention is the browser's "onbeforeunload" event and here is the implementation of it, window.onbeforeunload=confirmExit; function confirmExit(){ return "Do u want to close this page?" } So here the user will be prompted when he clicks the close button of the browser and when the user clicks "cancel" in prompt, it stays the same page.So far works fine. When testing is on the way , suddenly problems getting piled up and I need to reconsider the solution above, since the requirement is to "prompt the user only when he leaves the current domain (website)" and here for the above code, the user is prompted whenever
Read more