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.
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
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
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
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,
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
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
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:
>
