RE: MySQL Thread Pool Plugin + Percona Server?

2012-11-02 Thread Rick James
(I'm not using such.) Would you explain what your application is doing that would push the limits of thread concurrency? > -Original Message- > From: Singer Wang [mailto:w...@singerwang.com] > Sent: Wednesday, October 31, 2012 2:08 PM > To: mysql@lists.mysql.com > Subject: MySQL Thread P

Re: Mysql backup for large databases

2012-11-02 Thread Karen Abgarian
Hi... Quite often, they create a replica for the purposes of switching to it immediately if the master completely fails. I like the idea of taking backups on that replica, and not create another replica just for doing backups. One reason why I like it is that if I am to recover a database,

Re: Mysql backup for large databases

2012-11-02 Thread Manuel Arostegui
Hello, Just one more suggestion to do full backups in large databases: - Dedicated slave (either physical machine, a disk cabinet using iscsi connections from a machine just with a bunch of RAM etc) - Get the slave delayed a certain time (ie: 1 hour, 2 hours...depends on your workload) using Perc