-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 2011年10月21日 16:05, 王科选 wrote:
Hi,
Is there any way to dynamically create database and tables on mysql?
For example, if I want to create 100 databases(dbname is unknown
until run time), with 100 predefined tables in it, how to achieve
Fellow DBAs and MySQL Users
[apologies for eventual duplicates - I've posted this to
percona-discuss...@googlegroups.com also]
I've been hunting an issue with my database cluster for several months now
without much success. Maybe I'm overlooking something here.
I've been observing the
Luis,
How large is your database? Have you checked for an increase in write
activity on the master leading up to this? Are you running a backup against
the replica?
Thank you,
Tyler
Sent from my Droid Bionic
On Oct 23, 2011 5:40 AM, Luis Motta Campos luismottacam...@yahoo.co.uk
wrote:
Fellow
Luis,
Very hard to tackle.
In my experience, excluding external(to mysql) bottlenecks, like hardware,
o.s. etc, 'suspects' are the shared resources 'guarded' by unique mutexes,
like on the query cache or key cache.
Since you do not use MySQL it cannot be the key cache. Since you use percona
the
One cause of heavy replication lag we noticed was due to a misbehaving
application blasting updates (and commits) onto the master InnoDB tables from
multiple clients. Since slave replication is single-threaded, it couldn't keep
up I/O-wise, while the master seemed to show reasonably low load