Out of curiosity, how many queries/sec are you able to push from each
slave? If I may ask.. :)
Atle
On Mon, 5 Mar 2007, Ross Vandegrift wrote:
> On Fri, Mar 02, 2007 at 12:57:25AM -0800, Gary W. Smith wrote:
> > Pdns?
>
> Close! bind-dlz
>
> > Anyway, did you enable the slow query logging? Th
On Fri, Mar 02, 2007 at 12:57:25AM -0800, Gary W. Smith wrote:
> Pdns?
Close! bind-dlz
> Anyway, did you enable the slow query logging? That still might give
> you an idea if something is running slow. But I also forgot to ask
> earlier, what is running slow, the inserts or the selects during
> Inserts are of the form (updates are analogous):
>
> insert into dns_records (zone, host, data, ... )
> values ('domain.com', 'www', '1.2.3.4', ... );
>
> Queries are of the form:
>
> select ttl, type, mx_priority, case
> when lower(type)='txt' then
> concat('\"', dat
On Thu, Mar 01, 2007 at 08:29:09PM -0800, Gary W. Smith wrote:
> > The table is MyISAM. I searched on google a bit for info on slow
> > updates with MyISAM and didn't really hit it on the nose. Can I ask
> > you to elaborate?
> >
>
> In /etc/my.cnf try adding:
>
> long_query_time = 1
> log-slo
> The table is MyISAM. I searched on google a bit for info on slow
> updates with MyISAM and didn't really hit it on the nose. Can I ask
> you to elaborate?
>
In /etc/my.cnf try adding:
long_query_time = 1
log-slow-queries=/var/lib/mysql/mysql-slow.log
Restart and then watch the file. If a a
On Thu, Mar 01, 2007 at 03:46:56PM -0800, Gary W. Smith wrote:
> > 1) Does increasing the number of replication slaves increase query
> > latency on the master? We're considering tiering the replication if
> > it might help - replicate the master to two slaves, each of which
> > replicates to ten
> Also, what type of database are you using? INNODB? MyISAM? If you
> are
> running MyISAM then things can get slow on updates.
Sorry, I missed where you said you were using MyISAM.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
I could be wrong BUT...
> 1) Does increasing the number of replication slaves increase query
> latency on the master? We're considering tiering the replication if
> it might help - replicate the master to two slaves, each of which
> replicates to ten clients.
The slaves should only be pulling fr
Hi guys,
We have a MySQL database that we replicate to about a dozen clients
and we hope to be increasing that number to about 15-20. The database
has two tables. One is negligably small and changes maybe once a
month. The second is about 1.3 million rows and grows at the rate of
about 800-1000
t;
> At 2004-07-01, 22:06:24 you wrote:
>
>What does the network setup look like? What type of data is being replicated
>varchar, text, blob? Is the network connection being dropped or are there
>any errors being logged anywhere?
>
>-Original Message--
ing logged anywhere?
-Original Message-
From: MaFai
To: [EMAIL PROTECTED]
Sent: 6/30/04 10:34 PM
Subject: Replication Performance
Dear, [EMAIL PROTECTED],
We have set up 1 master and 4 slave as replication.
Sometime,the slave need 4~10 minutes to synchronize the data with
maste
On Thu, Jul 01, 2004 at 11:34:29AM +0800, MaFai wrote:
> Dear, [EMAIL PROTECTED],
>
> We have set up 1 master and 4 slave as replication.
> Sometime,the slave need 4~10 minutes to synchronize the data with master
> database.
> Do any way to tune the performance?
> Or any other way
What does the network setup look like? What type of data is being replicated
varchar, text, blob? Is the network connection being dropped or are there
any errors being logged anywhere?
-Original Message-
From: MaFai
To: [EMAIL PROTECTED]
Sent: 6/30/04 10:34 PM
Subject: Replication
Dear, [EMAIL PROTECTED],
We have set up 1 master and 4 slave as replication.
Sometime,the slave need 4~10 minutes to synchronize the data with master database.
Do any way to tune the performance?
Or any other way to reduce the time to replicate?
Best regards.
Hi,
I have gone through the MySQL documentation and FAQs. But
still I have a few questions -
1. Is there a performance comparison between MySQL Pro and MaxDB?
Is MaxDB much better than MySQL?
2. Does MaxDB also has a C/C++ interface?
3. Is replication supported by MaxD
Todd Burke wrote:
Hello
1/ I have a search engine which crawls auction sites and returns
information which is inserted into a mysql database. This activity
represents on average about 3 inserts per second with a combined payload
of 450 bytes per second added to the database. This updating occurs
On Tue, Jun 24, 2003 at 03:34:48PM -0500, Todd Burke wrote:
>
> Hello
>
> 1/ I have a search engine which crawls auction sites and returns
> information which is inserted into a mysql database. This activity
> represents on average about 3 inserts per second with a combined payload
> of 450 byte
Hello
1/ I have a search engine which crawls auction sites and returns
information which is inserted into a mysql database. This activity
represents on average about 3 inserts per second with a combined payload
of 450 bytes per second added to the database. This updating occurs
continuously thr
18 matches
Mail list logo
