List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:January 4 2000 1:31am
Subject:Re: I need more speed...
View as plain text  
Hi!

>>>>> "Sasha" == Sasha Pachev <sasha@stripped> writes:

Sasha> Rick Moore wrote:
>> 
>> Hi Sasha!
>> 
>> <snip>
>> 
>> > A few  comments in addition to what Tonu has said:
>> >
>> >  - Adding RAM is not that expensive (256 -> 512), and will speed things
> up
>> quite
>> > a bit
>> 
>> I have no issue adding more RAM, but in regards to a large key buffer Tonu
>> said:  "This can be bad because memory gets fragmented. Usually symptoms are
>> like this: System is fast after start-up but will be slower and slower and
>> Slooooowwwer until next restart. Try to reduce it."
>> 
>> Did you have something in mind that the RAM should be applied to?  OS
>> Caching?  I don't see any other MySQL params that would help me-- am I'm
>> missing something?

Sasha> OS caching would be the most important factor, as your chances of having to
Sasha> touch the disk on an insert are much smaller. Large key buffer could still be
Sasha> better in your situation -- memory fragmentation is not as bad as having to
Sasha> touch the disk. I imagine Monty would have some  enlightening things to say on
Sasha> this subject if he is not completely swamped with other things :-)

The key cache usually gives a lot of extra speed for writes but not
that much for reads;  Check with mysqladmin extended-status how many
key-reads MySQL really has to do. You can safely make the key-cache
smaller if the 'key_reads' value doesn't go up much.

<cut>

Regards,
Monty
Thread
I need more speed...Rick Moore3 Jan
  • Re: I need more speed...Tonu Samuel3 Jan
  • Re: I need more speed...Rick Moore3 Jan
  • Re: I need more speed...Tonu Samuel3 Jan
  • Re: I need more speed...Rick Moore3 Jan
    • Re: I need more speed...Dan Nelson3 Jan
    • Re: I need more speed...Benjamin Pflugmann3 Jan
    • Re: I need more speed...Michael Widenius4 Jan
      • RE: I need more speed...Steven Roussey5 Jan
        • Re: I need more speed...Benjamin Pflugmann5 Jan
          • RE: I need more speed...Steven Roussey5 Jan
            • Re: I need more speed...Benjamin Pflugmann5 Jan
          • RE: I need more speed...Steven Roussey5 Jan
            • Re: I need more speed...Benjamin Pflugmann5 Jan
            • RE: I need more speed...Michael Widenius5 Jan
              • RE: I need more speed...Steven Roussey6 Jan
                • OT: IP to Geographic areaCheng-Wei Cheng6 Jan
                  • RE: IP to Geographic areaJohn Zook6 Jan
  • Re: I need more speed...Sasha Pachev3 Jan
  • Re: I need more speed...Rick Moore3 Jan
  • Re: I need more speed...Tonu Samuel3 Jan
  • Re: I need more speed...Tonu Samuel3 Jan
    • LDAP package with mysql backendClickAgents4 Jan
      • Re: LDAP package with mysql backendRob McMillin4 Jan
      • LDAP package with mysql backendMichael Widenius4 Jan
        • Re: LDAP package with mysql backendChristopher E. Brown4 Jan
          • RE: LDAP package with mysql backendClickAgents4 Jan
            • RE: LDAP package with mysql backendChristopher E. Brown4 Jan
  • Re: I need more speed...Sasha Pachev4 Jan
    • Re: I need more speed...Michael Widenius4 Jan
      • how to..ClickAgents4 Jan
        • Re: how to..Benjamin Pflugmann4 Jan
  • Re: I need more speed...Rick Moore4 Jan
    • Re: I need more speed...Michael Widenius4 Jan
  • Re: As per your request; Re: I need more speed...Tonu Samuel5 Jan
  • Re: As per your request; Re: I need more speed...Rick Moore5 Jan
  • Re: As per your request; Re: I need more speed...Tonu Samuel5 Jan
    • FULL Text Indexjpabuyer5 Jan
      • Re: FULL Text IndexMark Zieg5 Jan
        • Re: FULL Text Indexjpabuyer5 Jan
      • RE: FULL Text IndexDan Ray5 Jan
        • RE: FULL Text Indexjpabuyer5 Jan
Re: I need more speed...Andy4 Jan
  • Re: I need more speed...Christopher E. Brown5 Jan
  • Re: I need more speed...Tonu Samuel5 Jan
Re: I need more speed...Andy4 Jan
  • Re: I need more speed...Michael Widenius4 Jan
    • Error: 2002 Can't connect to mysql using socket (111)Cheng-Wei Cheng5 Jan
      • Re: Error: 2002 Can't connect to mysql using socket (111)Sasha Pachev5 Jan