trace in mysql



  • 1. mySQL DB Database to HTML files (automatically create multiple static html files from a database)
    i need automatically create html files from a mysql db can be locally on in the server. any idea? thank for any help
  • 2. merge two table's data with variables
    Hello guys, I'm tying to merge data from one table to another. It's a little bad practice I know but it's like follows; |a|b| |c|d| |a|b|c|d| |e|f| |e|f|c|d| |g|h| |g|h|c|d| |i|j| |i|j|c|d| now I was hoping to use variables eg @v1 = c, @v2 = d but i'm struggling to assign @v1 = select t2.col1, @v2 = select t2.col2 so that I can do a; set t1.col3 = @v1 It's not happy. any ideas?
  • 3. how I copy a column betwen tables mysql?
    I have "tableA" with column "a" and "tableB" with column "b". Column "a"has new material so i need to copy the info from tableA column "a" in to tableB column "b", tableB is empty so i can't say where = waht can i do? please help please help. give examples i am a newbe this is mysql thank you
  • 4. Packen, Senden
    Das hier packt ein tar.gz, schickt das Archiv gleichzeitig er die Pipe an den redpepper und entpackt es dort. tar czf - next_generation/ | ssh XXXX@XXXXX.COM tar xzf - -C /media/xfs_space lgB

trace in mysql

Postby K. » Wed, 31 Oct 2007 23:21:43 GMT


I work on Oracle databases and I use trace list to know what
query is the most costable and why it generate for so long time.
Having such trace list I know which queries from Oracle Forms
are the most costable etc.
I have a web page with mysql database.
I would like to know if such trace list is possible to generate
in Mysql database or maybe TOAD for Mysql or phpmyadmin?

Do you know it?

Thank you in advance for help

Re: trace in mysql

Postby Captain Paralytic » Thu, 01 Nov 2007 01:46:28 GMT

I know it and so does the manual. It is called the slow query log.

Re: trace in mysql

Postby MZ » Thu, 01 Nov 2007 03:01:39 GMT

Uzytkownik "Captain Paralytic" < XXXX@XXXXX.COM > napisal w wiadomosci 

Ok Thank you for information. I have read such web page:


I use hosting domain and I don`t know where I can find my.cnf
file to implement the following parameters:
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1Can you tell me how can I do that?Thank you in advanceMarcin 

Similar Threads:

1.trace in mysql server


Is there any possibility to run trace on xampp server?
If so, how can I do this?
I would like to analyse my web page located on xampp server and see how
quaries are effective and what it is their runtime?

Thank you in advance

2.Trace file in MySQL

In SQL Server there is a handy tool called "SQL Profiler" which allows
the user to run a trace on transactions taking place on a database
server.  This can be configured to capture transactions from particular
databases, or applications, or users etc.

I've been asked to do some work with a MySQL database, and it would be
very helpful if there were a similar tool for MySQL.  I've been asked
to check on which tables are accessed by a particular application,
which would be a snip for a trace program.

I've been given a program called SQLyog Enterprise 5.0 which I believe
is analogous to Enterprise Manager

Thanks for any help.


3.Trace SQL Statements

4.Diagnosing Error 2013, Syslog and Stack Trace

5.MySQL Debug information via Stack Trace.

6. Disabling mysql trace on tomcat 4.1

7. Using stack traces within profileSQL

8. Programming a Trace using sp_trace_create to Trace on a remote Ser

Return to mysql


Who is online

Users browsing this forum: No registered users and 32 guest