Re: Replicating queries to testing server

2006-06-14 Thread Dan Trainor
Atle Veka wrote: Replicating a live setup, especially one running on the web is extremely difficult if not near impossible. Assuming you don't have the freedom to stop/start your mysqld for tuning/tweaking, here are some things you can do: - Enable slow-query-log - Enable query log - Query proces

Re: Replicating queries to testing server

2006-06-14 Thread Atle Veka
Replicating a live setup, especially one running on the web is extremely difficult if not near impossible. Assuming you don't have the freedom to stop/start your mysqld for tuning/tweaking, here are some things you can do: - Enable slow-query-log - Enable query log - Query processlist periodically

Re: Replicating queries to testing server

2006-06-13 Thread Scott Tanner
On Tue, 2006-06-13 at 19:04, Dan Trainor wrote: > Jake Peavy wrote: > > On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] > > > wrote: > > > > Hi - > > > > I would like to be able to replicate all queries from a live MySQL > > server, to a testing server at the o

Re: Replicating queries to testing server

2006-06-13 Thread Dan Trainor
Jake Peavy wrote: On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] > wrote: Hi - I would like to be able to replicate all queries from a live MySQL server, to a testing server at the office. The reason for doing this is to test load under [semi]real-world

Re: Replicating queries to testing server

2006-06-13 Thread Jake Peavy
On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote: Hi - I would like to be able to replicate all queries from a live MySQL server, to a testing server at the office. The reason for doing this is to test load under [semi]real-world conditions with the new server. I think that by doing somethin

Re: Replicating queries to testing server

2006-06-13 Thread Dan Trainor
nigel wood wrote: Dan Trainor wrote: Dan Trainor wrote: Hi - I would like to be able to replicate all queries from a live MySQL server, to a testing server at the office. The reason for doing this is to test load under [semi]real-world conditions with the new server. Hi - So I was th

Re: Replicating queries to testing server

2006-05-24 Thread Dan Trainor
nigel wood wrote: Dan Trainor wrote: Dan Trainor wrote: Hi - I would like to be able to replicate all queries from a live MySQL server, to a testing server at the office. The reason for doing this is to test load under [semi]real-world conditions with the new server. Hi - So I was t

Re: Replicating queries to testing server

2006-05-24 Thread nigel wood
Dan Trainor wrote: Dan Trainor wrote: Hi - I would like to be able to replicate all queries from a live MySQL server, to a testing server at the office. The reason for doing this is to test load under [semi]real-world conditions with the new server. Hi - So I was thinking about this m

Re: Replicating queries to testing server

2006-05-24 Thread Dan Trainor
Dan Trainor wrote: Hi - I would like to be able to replicate all queries from a live MySQL server, to a testing server at the office. The reason for doing this is to test load under [semi]real-world conditions with the new server. I think that by doing something like this, I would be able

Replicating queries to testing server

2006-05-24 Thread Dan Trainor
Hi - I would like to be able to replicate all queries from a live MySQL server, to a testing server at the office. The reason for doing this is to test load under [semi]real-world conditions with the new server. I think that by doing something like this, I would be able to fine-tune the new