Re: What are the effects of key_buffer on a dedicated slave [also]
On Tue, Sep 30, 2003 at 02:47:35PM -0700, William R. Mussatto wrote: > > Have you tried mytop with debian and 3.23.49 <-- version in Debian stable? > we keep getting core dumps. Does it have to be run as root? Sorry if OT The only Debian Stable box I have is powered off most of the time anymore. But I can give it a shot. You might try running it under the Perl debugger to see where it cores. I suspect that it's a mysql client library problem, since that's what tends to bite people. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 591,294,229 queries (403/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What are the effects of key_buffer on a dedicated slave [also]
Jeremy Zawodny said: > On Tue, Sep 30, 2003 at 01:11:23PM -0700, Dathan Vance Pattishall wrote: >> -->-Original Message- >> -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] >> -->Sent: Tuesday, September 30, 2003 11:51 AM >> -->To: Dathan Vance Pattishall >> -->Cc: [EMAIL PROTECTED] >> -->Subject: Re: What are the effects of key_buffer on a dedicated >> slave -->[also] >> --> >> -->On Tue, Sep 30, 2003 at 11:36:30AM -0700, Dathan Vance Pattishall >> wrote: >> -->> >> -->> Yes, I use a custom mytop (sent my patches in to you). In fact >> I'm -->> making a signed java applet to simulate mytop, just to be >> fancy ;) as >> -->> well as not having to ssh into a central box that can reach all >> my -->> servers. >> --> >> -->Really? Which patch? Have I integrated it yet? :-) >> >> Patch Contained SLAVE / Master Positions as well as which databases >> are ignored or slaved, and a full list of possible keys Command (E). I >> can resend another patch; I've made some changes since. > > Please do, it sounds useful. I'd like to roll it into version 1.5 > before I release it. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 590,020,855 queries > (404/sec. avg) > Have you tried mytop with debian and 3.23.49 <-- version in Debian stable? we keep getting core dumps. Does it have to be run as root? Sorry if OT William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What are the effects of key_buffer on a dedicated slave [also]
On Tue, Sep 30, 2003 at 01:11:23PM -0700, Dathan Vance Pattishall wrote: > -->-Original Message- > -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > -->Sent: Tuesday, September 30, 2003 11:51 AM > -->To: Dathan Vance Pattishall > -->Cc: [EMAIL PROTECTED] > -->Subject: Re: What are the effects of key_buffer on a dedicated slave > -->[also] > --> > -->On Tue, Sep 30, 2003 at 11:36:30AM -0700, Dathan Vance Pattishall > wrote: > -->> > -->> Yes, I use a custom mytop (sent my patches in to you). In fact I'm > -->> making a signed java applet to simulate mytop, just to be fancy ;) > as > -->> well as not having to ssh into a central box that can reach all my > -->> servers. > --> > -->Really? Which patch? Have I integrated it yet? :-) > > Patch Contained SLAVE / Master Positions as well as which databases are > ignored or slaved, and a full list of possible keys Command (E). I can > resend another patch; I've made some changes since. Please do, it sounds useful. I'd like to roll it into version 1.5 before I release it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 590,020,855 queries (404/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What are the effects of key_buffer on a dedicated slave [also]
-->-Original Message- -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, September 30, 2003 11:51 AM -->To: Dathan Vance Pattishall -->Cc: [EMAIL PROTECTED] -->Subject: Re: What are the effects of key_buffer on a dedicated slave -->[also] --> -->On Tue, Sep 30, 2003 at 11:36:30AM -0700, Dathan Vance Pattishall wrote: -->> -->> Yes, I use a custom mytop (sent my patches in to you). In fact I'm -->> making a signed java applet to simulate mytop, just to be fancy ;) as -->> well as not having to ssh into a central box that can reach all my -->> servers. --> -->Really? Which patch? Have I integrated it yet? :-) Patch Contained SLAVE / Master Positions as well as which databases are ignored or slaved, and a full list of possible keys Command (E). I can resend another patch; I've made some changes since. --> -->This helps no matter how many readers/writers you have. It's a cache. Cool, makes sense now. The key_buffer was to low. The RAID drives where being hit nearly on every SELECT and reducing resources for the dirty buffer from being flushed as often as it needed to be. Thanks Dathan --> -->Jeremy -->-- -->Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! --><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ --> -->MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 586,742,904 queries -->(404/sec. avg) --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What are the effects of key_buffer on a dedicated slave [also]
On Tue, Sep 30, 2003 at 11:36:30AM -0700, Dathan Vance Pattishall wrote: > > Yes, I use a custom mytop (sent my patches in to you). In fact I'm > making a signed java applet to simulate mytop, just to be fancy ;) as > well as not having to ssh into a central box that can reach all my > servers. Really? Which patch? Have I integrated it yet? :-) > I figured that but does it really matter on a dedicated slave handling > some reads, since there can never be parallel writes? I may be missing > the concept. Yes, you're missing something, I think. The key_buffer is part of what makes indexes fast for MyISAM tables. By keeping recently used index blocks in RAM, it doesn't need to hit the disk. This helps no matter how many readers/writers you have. It's a cache. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 586,742,904 queries (404/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What are the effects of key_buffer on a dedicated slave [also]
-->-Original Message- -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, September 30, 2003 11:24 AM -->To: Dathan Vance Pattishall -->Cc: [EMAIL PROTECTED] -->Subject: Re: What are the effects of key_buffer on a dedicated slave -->[also] --> -->On Tue, Sep 30, 2003 at 11:07:59AM -0700, Dathan Vance Pattishall wrote: -->> -->> -->-Original Message- -->> -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] -->> -->Sent: Tuesday, September 30, 2003 10:23 AM -->> -->To: Dathan Vance Pattishall -->> -->Cc: [EMAIL PROTECTED] -->> -->Subject: Re: What are the effects of key_buffer on a dedicated slave -->> -->> -->> -->Is that all your slave is doing? Replicating from the master? Are -->> there -->> -->no other queries being run against it? -->> --> -->> -->> It takes 50% of all reads from the application the db supports. --> -->The first thing I'd do is figure how how well utilized the key buffer -->is today. Either grab a copy of mytop (it does it for you), or look -->at SHOW STATUS to compute the percentage based on the ratio of -->key_read_requests to key_reads. Yes, I use a custom mytop (sent my patches in to you). In fact I'm making a signed java applet to simulate mytop, just to be fancy ;) as well as not having to ssh into a central box that can reach all my servers. --> -->If you're already hitting the buffer 99% of the time, there's little -->point in increasing the size. I figured that but does it really matter on a dedicated slave handling some reads, since there can never be parallel writes? I may be missing the concept. My Goal is to speed up replication (3.23.57) so I can upgrade to 4.0.15 once the master / slave is in-sync and find out if the var key_buffer on a dedicated slave helps out significantly. --> -->Jeremy -->-- -->Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! --><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ --> -->MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 586,536,970 queries -->(405/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What are the effects of key_buffer on a dedicated slave [also]
On Tue, Sep 30, 2003 at 11:07:59AM -0700, Dathan Vance Pattishall wrote: > > -->-Original Message- > -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > -->Sent: Tuesday, September 30, 2003 10:23 AM > -->To: Dathan Vance Pattishall > -->Cc: [EMAIL PROTECTED] > -->Subject: Re: What are the effects of key_buffer on a dedicated slave > > > -->Is that all your slave is doing? Replicating from the master? Are > there > -->no other queries being run against it? > --> > > It takes 50% of all reads from the application the db supports. The first thing I'd do is figure how how well utilized the key buffer is today. Either grab a copy of mytop (it does it for you), or look at SHOW STATUS to compute the percentage based on the ratio of key_read_requests to key_reads. If you're already hitting the buffer 99% of the time, there's little point in increasing the size. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 586,536,970 queries (405/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What are the effects of key_buffer on a dedicated slave [also]
-->-Original Message- -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, September 30, 2003 10:23 AM -->To: Dathan Vance Pattishall -->Cc: [EMAIL PROTECTED] -->Subject: Re: What are the effects of key_buffer on a dedicated slave -->Is that all your slave is doing? Replicating from the master? Are there -->no other queries being run against it? --> It takes 50% of all reads from the application the db supports. -->Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! --><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ --> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]