Page 1 of 1
View MySQL queries in real time (DOS)
Posted: Sat Jun 06, 2009 12:26 pm
by JAB Creations
In my previous travels I've seen a setup where a second screen in DOS was displaying all incoming MySQL queries. How can I set this up myself?
Re: View MySQL queries in real time (DOS)
Posted: Mon Jun 08, 2009 3:43 am
by VladSun
http://www.howtogeek.com/howto/database ... -in-mysql/
http://tailforwin32.sourceforge.net/
PS: Be aware that using the word "DOS" in this context is a little bit strange - I thought you wanted to show us a DoS (denial of service) issue when logging is turned on. It's better to use the word "console" instead:
View MySQL queries in real time (console)
Re: View MySQL queries in real time (DOS)
Posted: Mon Jun 08, 2009 8:05 pm
by JAB Creations
I'm on XP, we have DOS.

Kidding aside ok yeah technically once you authenticate in to MySQL DOS turns in to the console.
I've been having trouble figuring out how to enable MySQL logging though somehow I came across MySQL GUI Tools. I downloaded, installed, and ran the MySQL Administrator program. There was a log tab and I set the log files...nothing even after restarting Apache and MySQL. So I added the full paths (e.g. C:/example/mysql/mysql_query.log) and it worked!
I went back to Tail and got that working!
So thank you very very much! Granted manually editing the MySQL configuration file (which is some sort of scripting extension in Windows, lame

) is not something I could have done unless I had a well thought out tutorial the MySQL GUI Tools really helped me out in that regard. I can now look at the original and updated copy of the my.cnf configuration file and learn the syntax using a program like WinMerge.
Thanks again!

Re: View MySQL queries in real time (DOS)
Posted: Tue Jun 09, 2009 12:00 pm
by Benjamin
When are you going to jump into the cold water and start using linux JAB?
Re: View MySQL queries in real time (DOS)
Posted: Tue Jun 09, 2009 3:08 pm
by JAB Creations
My primary medium of interacting with my work is the OS though eventually the platform I'm working on (which is less R and more D of late) will change that to a browser. Vista blows and 7 is nothing more then Vista++. 64-bit versions of XP only come in OEM flavors and there isn't any way I will pay $100 for a license that will die with a motherboard. 32-bit versions are burdened by the 32-bit X86 memory limit and I play games on occasion and emulate operating systems to test browsers (Linux, OS X, and XP) so eventually I'll hit a ceiling (I use up 1.8GB though have been more liberal with emulating OS's with my spring upgrade) and you will never find a page file on my hard drive. Hard drives are limited to 2TB in XP and my largest drive is a 1.5TB. So in terms of milking XP's I'd say on those terms alone I could go a few more years. However I do flirt with Linux although usually in an emulator and have occasionally tried it on some of my smaller spare drives. I recently discovered that *.deb files are *.rpm equivalents which means installing Opera without the need for the console.
Ultimately I need to make my efforts profitable and that comes before trying to replace XP with Linux for my end-all OS. In about half a year or so things are finally going to come together if not sooner. I've made a lot of mistakes though I try to remember the lessons I've learned along the way. For now I'm going to keep working towards my goals because that's all I can do. At this moment in time I'm trying to get a slick feature finished so I have another impressive module to show off at a job interview I'm trying to land locally. However I'm downloading Ubuntu 9.04 and I'll run it in VirtualBox and see how much I can do since that would be the quickest way to see what changes have happened since I tried Ubuntu 8. I think that is what I'd like to do though I'd like Linux to eventually replace XP in the sense that I'm able to do everything in XP...including testing in thirty-something versions of browsers (the ones I don't need emulators for) and play the few games I play (I know this will somehow require using something like Wine). It'll happen eventually and obviously not in an emulator. Productivity simply dominates my mind right now because I'm not financially stable due to a lot of circumstances outside of my control in life. I'm going to check out Ubuntu in VirtualBox now and at least see if I can get Opera installed and working alongside Firefox...maybe see later tonight if I can figure out how to install a nightly build.