MySQL, linux, ia32, >4GB RAM

2003-07-10 Thread Andy Stubbs
anything other than a big disk cache? If anybody is familiar with this scenario, I'd be very grateful for your insights. Regards, Andy -- Andy Stubbs, B.A. (Hons.), Ph.D. Network Manager, Active Hotels Ltd. +44 1223 578106 -- MySQL General Mailing List For list archives: http://lists.mysq

clustering mysql, e.g., EMIC software

2003-06-26 Thread Andy Stubbs
Hi, I've seen this question once already on this list, but no answer - has anybody here used or otherwise have any experience of the cluster software from www.emicnetworks.com ? What other clustering packages exist? Andy -- Andy Stubbs, B.A., Ph.D. Network Manager, Active Hotels Ltd

Re: user@"%" vs user@"localhost" question

2003-06-25 Thread Andy Stubbs
supplied > > for the user to logon. > > Does the ?%? domain not include the localhost domain? > > If not, what is the use of the ?%? domain? When should > > I use ?%? and when ?localhost? ? > > I believe "%" doesn't include "localhost", but I coul

Re: upgrading, tuning and performance

2003-06-16 Thread Andy Stubbs
-sz avgqu-sz await svctm %util /dev/sdb12.74 4.63 8.58 7.10 90.54 94.5845.2747.2911.81 0.054.73 4.10 0.64 I'd say the 95-percentile for load is rather more like 1.4 than 2. Thanks for the input, A On Mon, 16 Jun 2003, walt wrote: > Andy Stub

upgrading, tuning and performance

2003-06-16 Thread Andy Stubbs
rvous about turning off atime on mounting the disks - is it really not used by the database anywhere? what kind of performance boost does it give? Regards, Andy -- Andy Stubbs, B.A., Ph.D. Network Manager, Active Hotels Ltd. +44 1223 578106 -- MySQL General Mailing List For lis