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
MaFai wrote:
>Dear ALL:
>
>Some time the slave would crushed by I/O error.It happen at the server with the lower
>CPU.( per 45 days )
>All of the slave database has block the binary log,it reduce the CPU loading.
>The database would replicate text,int,varchar but no blob.
>Network connection ha
Dear ALL:
Some time the slave would crushed by I/O error.It happen at the server with the lower
CPU.( per 45 days )
All of the slave database has block the binary log,it reduce the CPU loading.
The database would replicate text,int,varchar but no blob.
Network connection hasn't drop frequently,it
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 Perfor
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
14 matches
Mail list logo
