Does your query use proper indexes.
Does your query scan less number blocks/rows
can you share the explain plan of the sql
On Tue, Apr 16, 2013 at 2:23 PM, Ilya Kazakevich
ilya.kazakev...@jetbrains.com wrote:
Hello,
I have 12Gb DB and 1Gb InnoDB pool. My query takes 50 seconds when it reads
Hello,
I have 12Gb DB and 1Gb InnoDB pool. My query takes 50 seconds when it reads
data from disk and about 2 seconds when data already exists in pool. And it
may take 10 seconds when _some_ pages are on disk and some are in pool.
So, what is the best way to test query performance? I have
Run your query twice; take the second time. For most queries the first run
brings everything into cache, then the second gives you a repeatable, though
cached, timing.
Please provide EXPLAIN SELECT, SHOW CREATE TABLE, and we will critique your
indexes and query plan.
Handler* is another way
Swapping is really bad. Shrink buffer_pool as needed to avoid swapping. The
70-80% 'rule' works for 'most' machines today, because most machines have a lot
more than 2GB 'available' to MySQL. As you observed, 2GB box would probably
swap if buffer_pool were 1.4GB, so 800-900M is better.
Larry,
Nothing in the mysql startup files ever removes any directories of any kind.
At a guess: only my clients who work on Macs ever report this king of
'disappearing folder' behaviour. And every time it turn out to be Time
Machine. Ask around on those lists.
On Tue, Apr 16, 2013 at 12:34
On Tue, Apr 16, 2013 at 10:50 AM, Michael Dykman mdyk...@gmail.com wrote:
Larry,
Nothing in the mysql startup files ever removes any directories of any kind.
At a guess: only my clients who work on Macs ever report this king of
'disappearing folder' behaviour. And every time it turn out to
Am 16.04.2013 18:34, schrieb Larry Martell:
I just set up mysql on Mac OS 10.8. Each time after the machine is
rebooted the server fails to start with:
2013-04-13 14:09:54 1 [ERROR] /usr/local/mysql/bin/mysqld: Can't
create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 - No
Hi Rick,
I thought you have to dedicate 70-80% of available RAM not a total RAM.
Saying if I have 2 gig of RAM on my exclusively innodb box, and I
dedicate 1.4Gig to innodb pool, my 64-bit linux machine will start
swapping heavily.
If I set it to 800-900M, it just fine and I have like 100M of