Mysql profiler does not work on my computer
What I have done is as follows: mysql show profile; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'profile' at line 1 mysql show profiles; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'profiles' at line 1 mysql set profiling=1; ERROR 1193 (HY000): Unknown system variable 'profiling' mysql select version(); +-+ | version() | +-+ | 5.1.21-beta | +-+ 1 row in set (0.00 sec) Why my profile doesn't work at all,anybody can help me.
Query Profiler
Hi, I am looking for a tool for mysql. A query Profiler tool. If anybody used MSSQL they know that, there is a tool SQL Profiler. You can connect to a remote server and watch queries LIVE. I can't find a tool like this for mySQL. Is it impossible to write a software like this? How can i listen queries from a remote mysql server? Is there an API or something like that? Thanks Nesim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Profiler
I would like to know if the MySQL has any command where I get the queries requested by the application. SQL Server has Profiler. Oracle has any command that I don´t know With Delphi I run SQLMonitor. Regards Alexander sql,query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Profiler
Hi Alexander. If you specify option log in section mysqld of my.cnf configuration file you get a log file of all queries and sql operations (inserts, updates, deletes) executed in the MySQL server. This log file is created by default at $DATADIR/$HOSTNAME.log. Iago. -Mensaje original- De: Alexander Burbello [mailto:burbello;yahoo.com.br] Enviado el: jueves, 07 de noviembre de 2002 21:30 Para: [EMAIL PROTECTED] Asunto: Profiler I would like to know if the MySQL has any command where I get the queries requested by the application. SQL Server has Profiler. Oracle has any command that I don´t know With Delphi I run SQLMonitor. Regards Alexander sql,query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Profiler for windows
there is a Profiler similar to SQL server Profiler ,only for windows i wrote it myself , availiable at http://amr.activechannel.net/myprofiler.htm so sorry its not free :( Amr Salah --- Iago Sineiro [EMAIL PROTECTED] wrote: Hi Alexander. If you specify option log in section mysqld of my.cnf configuration file you get a log file of all queries and sql operations (inserts, updates, deletes) executed in the MySQL server. This log file is created by default at $DATADIR/$HOSTNAME.log. Iago. -Mensaje original- De: Alexander Burbello [mailto:burbello;yahoo.com.br] Enviado el: jueves, 07 de noviembre de 2002 21:30 Para: [EMAIL PROTECTED] Asunto: Profiler I would like to know if the MySQL has any command where I get the queries requested by the application. SQL Server has Profiler. Oracle has any command that I don´t know With Delphi I run SQLMonitor. Regards Alexander sql,query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, POP more! http://www.everyone.net/selectmail?campaign=tag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
profiler...
Does anyone know if there is a good profiler to use on MySql, for example, in SQL Server, you can start the 'profiler' and it will tell you everything that is happening on the server. Thanks, Eddie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php