List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:January 5 2000 2:05am
Subject:RE: I need more speed...
View as plain text  
Hi!

>>>>> "Steven" == Steven Roussey <sroussey@stripped> writes:

Steven> | Key_blocks_used          | 15641   |
Steven> | Key_read_requests        | 5281821 |
Steven> | Key_reads                | 23716   |

Note that when tables are closed (because they don't fit the table
cache or someone does a 'flush tables'),
the key cache will of course be flushed for all entries belonging to
this table.

Steven> I upped the key_buffer to 12MB and after a couple of hours, I have the
Steven> above. Should be keep increasing the key_buffer? It seems to me that we
Steven> could increase it to 80MB and it would still all be used! I don't think we
Steven> have the memory to try that however... Also the ratio you mentioned dropped
Steven> changed to about 226. This may be worse due the fact that the server has not
Steven> been running as long this time, but I don't know...

The above doesn't look that bad. Just keep an eye on it from time to
time that the ratio doesn't change too much ...

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