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