On Fri, 2006-05-12 at 10:59 -0400, RV Tec wrote:
> Yeah, I'm aware of that. Since glibc 2.4 has only NPTL, I was
> wondering if it
> is possible to MySQL use a threading system of its own. However, what
> I want to
> know, is a way to confirm that it has been compiled against NPTL.
>
> This appe
I'll add "make sure logs and data are on separate partitions" so
you're not doing excessive seeking back and forth.
-Sheeri
On 5/12/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
Hope it is useful.
I agree, you may want to look at adding another card and disks, for
speed and to segregate the vari
Hope it is useful.
I agree, you may want to look at adding another card and disks, for
speed and to segregate the various operations (temp, logging, data).
Splitting up your MYD and MYI files may help, though if you have enough
RAM to keep indexes in memory, maybe you don't need to do that.
On 5/12/06, RV Tec <[EMAIL PROTECTED]> wrote:
Buettner,
First of all, thanks a lot for your reply!
This server has 4 disks to MySQL usage, in two pairs of RAID-1, connected
to a single channel (ok, I realize now this means a bottleneck) LSI
PCIe card.
One RAID1 for MySQL logging and temp space
Good morning RV -
On your 3rd question, about how to make things faster:
More RAM should help by allowing the server to keep more/all of the
indexes in memory, enabling much faster access. Be sure to adjust the
cache settings in your my.cnf file after adding RAM. (Keep in mind -
some my.cnf
1) Is there a way to see MySQL using both processors? Is SMP helpful in
this case? (This server is dedicated to MySQL, only one instance).
PS (*nix) should tell you how your processors are used.
PS does show me about the CPU usage, but it doesnt tell me which
processor, or if they're being use
Buettner,
First of all, thanks a lot for your reply!
This server has 4 disks to MySQL usage, in two pairs of RAID-1, connected
to a single channel (ok, I realize now this means a bottleneck) LSI
PCIe card.
One RAID1 for MySQL logging and temp space, and the other pair for the
database files
RV Tec schrieb:
Folks,
I had some recommendations about operating system last time I posted,
and decided to follow it. It's been a couple of weeks running Gentoo
Linux 2006.0 SMP 2.6.15-gentoo-r5, with glibc 2.4 (NPTL), gcc 3.4.4, XFS
as my FS, deadline scheduler and this has proven to be rea
