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

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 help
> Marcin

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

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 help
>> 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