Perhaps the best thing to do is get another server, one that is only for
testing, hook it up as a slave to your master and then experiment on your
own.
On Sun, Dec 21, 2008 at 2:25 PM, Sergio Belkin wrote:
> 2008/12/21 Baron Schwartz :
> > On Wed, Dec 17, 2008 at 7:17 AM, Sergio Belkin wrote:
>
Hi Shuly,
you can use the method suggested by Shuly or you cook up your
query logs if you need more accurate information. May be you can write a
small script to do the job.
Regards,
Chandru
forums.mafiree.com
On Mon, Dec 22, 2008 at 7:34 AM, mos wrote:
> At 02:32 PM 12/21/2008, y
If you don't mind keeping the general log, you can periodically parse it. I
read that MySQL 5.1 (or some later version) will have an option to keep the
general log in a table - that will be very handy.
On Sun, Dec 21, 2008 at 2:32 PM, Avraham, Shuly wrote:
>
> Hi,
>
> Is there any way to figure
At 02:32 PM 12/21/2008, you wrote:
Hi,
Is there any way to figure out how many, if any, people are accessing and
using our MySQL server?
I am aware of the SHOW PROCESSLIST command, but this one only shows how
many processes are currently running. I would like to register this
information,
Hi,
Is there any way to figure out how many, if any, people are accessing and using
our MySQL server?
I am aware of the SHOW PROCESSLIST command, but this one only shows how many
processes are currently running. I would like to register this information, and
be able to analyze it later.
Than
2008/12/21 Baron Schwartz :
> On Wed, Dec 17, 2008 at 7:17 AM, Sergio Belkin wrote:
>> Hi,
>>
>> I use mysql 5.0 (Centos 5.2) , I have a database, say called opfilter
>> with 2 tables (say aliases and hosts) and I want that slave only
>> replicate tabla aliases and only records from table hosts t
On Wed, Dec 17, 2008 at 7:17 AM, Sergio Belkin wrote:
> Hi,
>
> I use mysql 5.0 (Centos 5.2) , I have a database, say called opfilter
> with 2 tables (say aliases and hosts) and I want that slave only
> replicate tabla aliases and only records from table hosts that match a
> given criteria, how c
Hi Bryan,
On Wed, Dec 17, 2008 at 5:35 PM, Bryan Irvine wrote:
> I've got a master-master set up and I'm trying to figure out the best
> way to add new databases to the cluster. I've not set anything for
> the replica-do-db which my understanding means it will sync everything
> correct?
Right.
