Hi..
I'm using cache queries with MySQL 4.0.13 during three days and I get
a little better speed.
Value of Query_cache_size = 20 Mb.
I have two questions.
1.- Is there any way to see which queries are being stored ??
2.- How can I delay qcache_lowmen_pruenes ?? In three day values of it
is
Is there any problem executing rsync /var/lib/mysql/data/ from one host to
another host and therefore having same file in obth machines??
Is it unsafe this method ??
Could be crashed meanwhile transferring ??
Thanks !!!
- Original Message -
From: Christensen, Dave [EMAIL PROTECTED]
data?
Simon
-Original Message-
From: Paco Martinez [mailto:[EMAIL PROTECTED]
Sent: 18 November 2003 10:00
To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED]
Subject: Re: Backup question.
Is there any problem executing rsync /var/lib/mysql/data/ from one host
to
another host
Hi
My server www has Suse 8.2, apache-1.3.27, mod_php4-4.3.1,
and my server mysql has Suse 8.2, and mysql.4.0.12-Max-log
Sometimes, not always, it appears an error in www.
Warning: mysql_pconnect() [function.mysql-pconnect]: Link to server lost,
unable to reconnect in db_mysql.inc on line 73
Estimated gurus.
My PC has RH 6.2, 510 Mb RAM, 812 MB swap, Kernel 2.2.23 and Mysql
3.23.55-log.
Normaly my CPU is about 2 % , but sometimes increases until 65 %.
And memory free swings from 45 Mb to 2 Mb.
Web pages creates many temporary tables.
Environment variables are.
back_log 50
|
Estimated gurus.
I've got a MyISAM table with 3000 rows.
Two days ago, it showed an error Got error 127 from table
handler.Therefore, I made OPTIMIZE TABLE tabla and it was solutioned.
But today, table has 3200 rows, and it shows another error Found link that
points at
2325343242342323
Estimated gurus.
I'd like to know if is it essential to upgrade from 3.23.34 to 3.23.37 or changes are
not very important.
In case of necessary, how can I do this upgrading?? Downloading binary file or RPM
file??
Is there any process to upgrade MySQL automaticaly??
Thank you very much
