I'm getting an occasional error from one of my slaves running
community mysql 5.5.16:
'Got an error writing communication packets' on query. Query: 'flush tables'
Which halts replication on this slave until I issue a 'SET GLOBAL
sql_slave_skip_counter=1' com
Cc: 'Gabriel PREDA'; mysql@lists.mysql.com
Subject: RE: mysterious speedup after doing "FLUSH TABLES"
Hi,
What about your table_cache setting ?
Is show status reporting a high number for Opened_tables ?
---
Regards,
Jocelyn Fournier
www.mesdiscussions.net
> I wil
cking issue, will grab the output of INNODB
STATUS the next time it happens.
Moritz
-Original Message-
From: Gabriel PREDA [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 12, 2006 11:22 AM
To: Moritz Möller
Subject: Re: mysterious speedup after doing "FLUSH TABLES"
See http://
speedup after doing "FLUSH TABLES"
What value do you have innodb_thread_concurency ?
There is a bug with that on 64bit machines !
--
Gabriel PREDA
Senior Web Developer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
Hello list,
we use MySQL 4.1.13 / InnoDB on Xeon em64t running Debian, kernel 2.6.8.
After a while, queries run slower and slower, although the CPU is >70% idle
and diskio is nearly zero. A simple select by primary key takes up to one
second. After doing a FLUSH TABLES the speed is up again.
ND_refresh (to await any thread that is waiting for all instances of
a table to be closed)."
-Sheeri
On 5/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi,
If you "open" a table using,
HANDLER tablename OPEN;
and then (in another MySQL command windows), execute,
fl
Hi,
If you "open" a table using,
HANDLER tablename OPEN;
and then (in another MySQL command windows), execute,
flush tables with read lock;
The flush tables "hangs" until you execute a
HANDLER tablename CLOSE;
command.
Is this a bug? Can anyone explain this?
Many
> to flush tables, you're right :
>
> flush table TOTO <= flushes only toto
> flush table TOTO,TITI<= flushes only toto and titi
> flush tables <= flushes ALL
OK, that's good news.
> Have'nt
> 1) Reading TFM (http://dev.mysql.com/doc/mysql/en/flush.html) it appears
> that I do not have to 'FLUSH TABLES WITH READ LOCK' for each individual
> database. This statement flushes and locks all simultaneously. Am I
> correct?
HI,
to flush tables, you'r
Hi,
Our MySQL 4.1.10 environment runs on Solaris 8 and the data is stored on
a NetApp filer. The schemas contain a mix of MyISAM and InnoDB tables.
To make a backup we lock all tables in all databases (USE database;
FLUSH TABLES WITH READ LOCK), and then tell NetApp to make a snapshot.
We have
In the " 4.0.20-standard-log" version of mysql, will the " FLUSH TABLES WITH READ
LOCK" statement work to quiesce a database consisting of Innodb tables?
Thanks,
---
Kato D. Haws
Arizona State Un
ith a query?
If you are uploading the raw files, that is not a good practice.
If you are updating/inserting it with a query, you shouldn't need to flush
tables anyway.
G. Jensen
- Original Message -
From: "starofframe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTE
Hi,
I have problem with Mysql 3.23.58 on Linux
Mysql can't auto Flush-Tables
I work with Mysql 3.23.58 windows version on my local computer...
Then I upload to web-hosting that working with Mysql 3.23.58 on Linux..
Everytime I add some record on my local computer then upload t
Hello,
Still on this database consistency problem with FLUSH TABLES WITH
READ LOCK... I've tried upgrading to MySQL 4.0.5a binary distribution
(instead of source), but the problem does not disappear.
So I've made a little test. I open too shells.
-> Shell 1:
I launch the MySQL
Hello Victoria,
> You need to do it with 2 sessions.
>
> According MySQL manual:
>
> If you are using a Veritas filesystem, you can do:
>
>1. From a client (or Perl), execute: FLUSH TABLES WITH READ LOCK.
>2. From another shell, execute: mount vxfs snapshot.
>
Antoine,
Thursday, November 28, 2002, 4:17:48 PM, you wrote:
A> Sorry to insist, but nobody has any clues about this ?
A> I can supply further info if needed.
A> Is the "FLUSH TABLES WITH READ LOCK" functionality well tested ?
A> Having corrupted backups is annoying, and
Sorry to insist, but nobody has any clues about this ?
I can supply further info if needed.
Is the "FLUSH TABLES WITH READ LOCK" functionality well tested ?
Having corrupted backups is annoying, and I can't really
take the system down for a 4-hour tape backup... ;(
M
Hi,
I am using FLUSH TABLES WITH READ LOCK to get consistent
snapshots of my database without shutting it down.
The setup is :
- bi-P4 Xeon with Redhat 7.3
- 2.4.19 kernel with properly patched LVM (compiled from source)
- MySQL server 4.0.4 (compiled from source)
- ext3 filesystem on a 44 GB
For folks that are having trouble with clean shutdown on OS X, try using
mysqladmin -u root -ppw flush-tables
before shutting down mysql.
I hadn't had a shutdown problem in a week then this evening I got the
dreaded pid file hang at shutdown and had to use kill -9.
The only thing
If I use a FLUSH TABLES command, what will happen to others that might be in
the middle of using a table?
I have a PHP application running on PHP 4.0.3 that doesn't seem to close
tables properly, and I am constantly having trouble with the mySQL server
crashing on me.
I shut down the s
20 matches
Mail list logo
