Re: [gentoo-user] horrible mysql performance on gentoo (SOLVED - myisamchk to the rescue!)
On Wed, Feb 04, 2004 at 01:34:47PM +, Mike Williams wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Wednesday 04 February 2004 03:59, Alan wrote: > > > *sigh* > > Never mind, still sucks. Turns out I forgot to restart the mysql server > > after running the above command, and ab and wget happily returned pages, > > just ones that had no data on them. > > > > Oh well, back to looking > > I'd go for a nice vanilla kernel next. > Then check for query logging, the extra IO could be hurting it. Same problem with 2.4.24 vanilla, and I've also tried using the precompiled binary from mysql.com. I don't think it's query logging either, as this performance hit can be seen in a single query. Any other ideas? -- Alan <[EMAIL PROTECTED]> - http://arcterex.net "There are only 3 real sports: bull-fighting, car racing and mountain climbing. All the others are mere games."-- Hemingway -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] horrible mysql performance on gentoo (SOLVED - myisamchk to the rescue!)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 04 February 2004 03:59, Alan wrote: > *sigh* > Never mind, still sucks. Turns out I forgot to restart the mysql server > after running the above command, and ab and wget happily returned pages, > just ones that had no data on them. > > Oh well, back to looking I'd go for a nice vanilla kernel next. Then check for query logging, the extra IO could be hurting it. - -- Mike Williams -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAIPT3InuLMrk7bIwRAhNZAJ9ETV/Hc4ohTYH8hgfj1W24TRfp9ACeMPW6 N2dwSK8acbis01JZSNLiqbg= =TZqz -END PGP SIGNATURE- -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] horrible mysql performance on gentoo (SOLVED - myisamchk to the rescue!)
On Tue, Feb 03, 2004 at 07:20:12PM -0800, Alan wrote: > On Tue, Feb 03, 2004 at 03:25:11PM -0800, Alan wrote: > > Hi guys... still in the middle of getting a server cut over from debian > > to gentoo and I just found some serious performance problems with mysql. > > Figured it out as soon as I got home today from work. I'm not sure if > it was due to it never being done, or moving tables from one server to > another, or swapping mysql versions, but running > > # myisamchk -r -S -n *.MYI *sigh* Never mind, still sucks. Turns out I forgot to restart the mysql server after running the above command, and ab and wget happily returned pages, just ones that had no data on them. Oh well, back to looking -- Alan <[EMAIL PROTECTED]> - http://arcterex.net "There are only 3 real sports: bull-fighting, car racing and mountain climbing. All the others are mere games."-- Hemingway -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] horrible mysql performance on gentoo (SOLVED - myisamchk to the rescue!)
On Tue, Feb 03, 2004 at 03:25:11PM -0800, Alan wrote: > Hi guys... still in the middle of getting a server cut over from debian > to gentoo and I just found some serious performance problems with mysql. Figured it out as soon as I got home today from work. I'm not sure if it was due to it never being done, or moving tables from one server to another, or swapping mysql versions, but running # myisamchk -r -S -n *.MYI in the /var/lib/mysql/ directory and now all the speed has returned. alan -- Alan <[EMAIL PROTECTED]> - http://arcterex.net "There are only 3 real sports: bull-fighting, car racing and mountain climbing. All the others are mere games."-- Hemingway -- [EMAIL PROTECTED] mailing list
