Afternoon
Somebody knows how can I log or measure the index use ?
Thanks
Carlos
I want to count how many time one index was used during a day, do you now how
to log it to count?
Date: Mon, 15 Oct 2012 17:27:54 +0200
From: h.rei...@thelounge.net
To: mysql@lists.mysql.com
Subject: Re: Can I measure the use of index?
Am 15.10.2012 17:24, schrieb Carlos Eduardo
.
(I wrote it.)
- Baron
On Tue, Aug 17, 2010 at 8:50 AM, Carlos Eduardo Caldi
ce_ca...@hotmail.com wrote:
If sombody can help me I'll be gratefull
I have a problem with mytop1.6 on Mandriva 2010.1, when I install it on a
Slave server mytop works,
but when I install
If sombody can help me I'll be gratefull
I have a problem with mytop1.6 on Mandriva 2010.1, when I install it on a Slave
server mytop works,
but when I install it on a Master Server don't works, don't display the queries.
I use mysql version 5.0.77
and linux mandriva 2010.1
Very Thanks
Hi
You can use on shell, connect at the client mysq -h (host or IP) -p(password)
and run the query:
SELECT a, b, c INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY '\n'
FROM test_table
more info see the link
John
I think you can do this way on shell:
mysql -h db_server -u user -pPASSWORD DATABASE -e truncate table
table1
Carlos Eduardo Caldi
Date: Tue, 16 Mar 2010 14:12:42 -0700
From: joli...@john-oliver.net
To: mysql@lists.mysql.com
Subject: Trancate table from command
Hi friends
I have a proble with Copying to tmp table with large tables, table have more
than 3 million rows
EXPLAIN da Query :
Table : log0904
Type : ref
Possible_keys :