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

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

The beginning: Some people are strangers to themselves

   May be not a new thing but certain things in life feels new and rejuvenating like rain, flowers, morning sun . They are always there, we have seen them million times but still we feel good everytime. So certain things in life always keeps us lively. New made goals, new perception about life, a new job,  a day before wedding always keep us excited and we are on the toe to start the new thing.  As days pass by, we see ourselves in confusion as our new made goals or job or a wedding don't contribute what exactly we wanted to do. So this is when the reality strikes, the reality can be good about learning our own self, and yet we don't see our weekness inside, instead we blame it in our colleagues, company, spouse, children etc.,   Ego is the supremacy which breaks / builds a person, the fear of failure and the fear of the inner-self make ourselves to out grow our fear temprorarily, but this w...
Read more