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? That
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 the
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('\', data, '\')
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
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 from
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:
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
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
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
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
master database
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 Performance
Dear, [EMAIL
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
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 to
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
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
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
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 bytes per
18 matches
Mail list logo