> -----Original Message-----
> From: Rafael Martinez [mailto:[EMAIL PROTECTED]]
> Sent: martes, 27 de marzo de 2001 15:28
> To: [EMAIL PROTECTED]
> Subject: Mysql in a 4-way / 2 GByte server / raid 5
>
>
> Hello
>
> I am thinking to install our DB server in a 4-way machine with
> Intel Xeon processors/1MB cache. I can see in the mysql
> documentation that mysql
> works OK in a 2-way machine but that in a 4-way system has to
> be tested.
>
> Is this true? Or the documentation is not updated?
>
> Anybody out there with a 4-way machine that runs mysql
> without problems?
> (kernel 2.4.x glibc 2.2.12)
>
> Our DB has around 120.000.000 "questions" per week and our
> 2-way/1Gb system works OK,
> but the trafic is growing very fast and I would like to have a backup
> plan incase I need it.
>
> Thanks for your help.
> Rafael Martinez
I've had MySQL running on a 12 CPU 16 GB machine running Tru64. Runs OK.
I normally run it on a 4 CPU 4 GB machine and another one with 3 CPUs and
only 512 MB. Both Tru64 Alpha.
In recent (3.23) versions there are some my.cnf parameters related to SMP
machines. You might want to take a look at them :
set-variable = thread_cache=8
set-variable = thread_concurrency=8 # Try number of CPU's*2
The only problem I have is that there appears to be a problem with memory
allocation when running MySQL on Tru64. I haven't found out exactly what the
problem is, but the result is a crashed MySQL with a "Out of memory" error.
Which is rather misleading since there is plenty of free memory and no
ulimit or any other limiting kernel parameters.
l8r/Jspr
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php