12 17:24, schrieb Carlos Eduardo Caldi:
> >
> > Afternoon
> >
> > Somebody knows how can I log or measure the index use ?
>
> explain select whatever from table where bla=value
>
Afternoon
Somebody knows how can I log or measure the index use ?
Thanks
Carlos
t's a better replacement for mytop.
> (I wrote it.)
>
> - Baron
>
> On Tue, Aug 17, 2010 at 8:50 AM, Carlos Eduardo Caldi
> wrote:
> >
> >
> > If sombody can help me I'll be gratefull
> >
> > I have a problem with mytop1.6 on Mandriva 2010.
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
Carlo
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
http://dev.mysql.com/doc/r
John
I think you can do this way on shell:
mysql -h db_server -u user -pPASSWORD -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 t
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 :
data_login_tplig,emp_grp_login_dtlig,grp_tiporeg_tipolig_dtlig,grp_dtlig_tplig,dtlig_num,grp_equipe_emp_d
