Re: Memory Use

tently using 150% memory, or 50% paging space. Once it gets to 150%, it tends to stay at this limit consistently. I am trying to find a tool to tell me what it is using, and some documentation about how to control MySQL memory use. Would some kind member help me find these? Regards, Ben C

Memory Use

documentation about how to control MySQL memory use. Would some kind member help me find these? Regards, Ben Clewett. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Recommendations for memory use with 16GB

I'm moving from 32-bit intel to the brave new world of AMD64. Our new servers are dual Opterons with 16GB of RAM. We will be running mysql 4.1.14-standard on redhat enterprise linux 4 x86_64. Since I'm new to this, what's my best bang-for-buck in setting up mysql's memory usage? -jsd- --

Re: Per-thread memory use question

he memory as soon as they're done with it or hold onto it for (probable) future use. If I had to guess from reading that page, I'd say they probably free it, but if I had to guess from the memory use of our db server, I'd say they don't. --Pete > Pete Harlan <[EMAIL PROTE

Re: Per-thread memory use question

Hello. Have a look here: http://dev.mysql.com/doc/mysql/en/memory-use.html Pete Harlan <[EMAIL PROTECTED]> wrote: > Hi, > > This formula shows up in a few places (this is from > ): > >min_memory_needed = global_buffer

Per-thread memory use question

Hi, This formula shows up in a few places (this is from ): min_memory_needed = global_buffers + (thread_buffers * max_connections) where thread_buffers includes the following: sort_buffer myis

Innodb Memory use for a Benchmark in MySQL...

> We are developing a benchmark (only querying) between > MySQL, SQLServer2000, and Access 2000 > We are using as base, the Database propose by TPC.org (www.tpc.org)... > With the records they propose and the indexes they proposed > > But for the testing we are using INNODB tables, with t

Innodb Memory use for a Benchmark...

We are developing a benchmark (only querying) between MySQL, SQLServer2000, and Access 2000 We are using as base, the Database propose by TPC.org (www.tpc.org)... With the records they propose and the indexes they proposed But for the testing we are using INNODB tables, with the appropia