|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
30/10/2007, 15h21
|
#1 |
Messages: n/a
Hébergeur: |
trace in mysql
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 Marcin |
|
|
30/10/2007, 17h46
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: trace in mysql
On 30 Oct, 14:21, "K." <halinaciern...@poczta.onet.pl> wrote:
> 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 > Marcin I know it and so does the manual. It is called the slow query log. |
|
|
|
30/10/2007, 19h01
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: trace in mysql
Uzytkownik "Captain Paralytic" <paul_lautman@yahoo.com> napisal w wiadomosci news:1193762788.091731.16080@v3g2000hsg.googlegrou ps.com... > On 30 Oct, 14:21, "K." <halinaciern...@poczta.onet.pl> wrote: >> 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 >> Marcin > > I know it and so does the manual. It is called the slow query log. > Ok Thank you for information. I have read such web page: http://www.petefreitag.com/item/233.cfm 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 |
|
|
 |
| Outils de la discussion | |
|
|
