Hello! 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 Marcin
trace in mysql
3 posts
• Page 1 of 1
- Windows XP
- cad
- dreamweaver
- ASP.NET
- FoxPro
- MS Office Access
- xml
- Computer architecture
- MS OFFICE OUTLOOK
- Windows XP
Jump to:
- 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 tableA.id = TableB.id 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
Next
trace in mysql
by K. » Wed, 31 Oct 2007 23:21:43 GMT
Re: trace in mysql
by 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
by 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: http://www.**--****.com/ I use home.pl 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:
Hello! 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 heyoo
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. Edward
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
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 32 guest