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