Linked Questions
11 questions linked to/from I am using the MEMORY storage engine but MySQL still writes to my disk...Why?
34
votes
7
answers
50k
views
What are reasons **NOT** to use the MEMORY storage engine in MySQL?
I recently discovered that MySQL has a "memory" engine that I wasn't aware of (most of my database work is for hobby projects so I learn what I need as I go). It seems like this option should give me ...
- 759
5
votes
2
answers
20k
views
Is InnoDB Engine up to speed against Memory Engine?
I am exploring the efficiency of different database engines in MySQL version 5.5.18 to see which is best suited for use with a range query on a dataset of 5 million rows:
SELECT P.col1, P.col2, P....
4
votes
1
answer
7k
views
Mysql Memory table getting many locks
On my site I log every pageview (date, ip, referrer, page, etc) in a simple mysql table.
This table has the following activity:
1 SELECT per minute
1 DELETE per minute
no UPDATE queries
Lots of ...
- 205
2
votes
1
answer
6k
views
MySQL: sysbench test - InnoDB vs Memory tables
I've done some tests in order to investigate performance issue on the new HP Gen8 server (Intel(R) Xeon(R) CPU E5-2630 0 @ 2.30GHz)
I've created two tables, first one is using InnoDB storage engine ...
- 441
1
vote
2
answers
5k
views
Is there a way to enable MariaDB MEMORY storage engine for every table?
I am new to MariaDB and interested in using it because I want to use MEMORY storage engine for every table. I read MEMORY storage engine on mariadb.com and it seems like I had to specify storage ...
- 161
1
vote
1
answer
2k
views
What is the fastest way to insert data into MySQL memory table?
I need to insert 10M+ records into a MySQL memory table.
A naive approach was to pipe records using shell, e.g.
$ tail -10 ~/Desktop/test.sql
INSERT INTO `test` (`a`, `b`) VALUES (4, 5);
INSERT INTO ...
- 896
3
votes
2
answers
1k
views
MySQL lock on MEMORY storage engine, when does it apply?
I want to use MySQL MEMORY storage engine to handle my PHP session variables (actually I already implemented it but since all my tests are being done by a single user, me, I am unable to notice this).
...
- 31
2
votes
2
answers
197
views
Why MySQL performs so poor on SHOW PROCEDURE STATUS?
I've installed MySQL server with many databases that use the InnoDB engine. With lots of procedures in each DB, mysql.proc table contains more than 250,000 rows and it becomes ultimately slow when I ...
- 139
2
votes
1
answer
789
views
Is the Memory engine adequate for a read intensive/lookup table?
I have an InnoDB table with just two columns, a VARCHAR(20) and a DATETIME, and around 4M rows. This table serves as a blacklist for other tables, and is truncated and recreated from a csv file from ...
- 288
1
vote
1
answer
293
views
How Much Resources Does the BLACKHOLE Storage Engine Consume？
I'm going to add a MySQL Relay Slave which use BLACKHOLE Storage Engine.
The relay slave will just filter some databases binlog to downstream slave.
Our MySQL Master generates about 15G a day in ...
- 113
1
vote
2
answers
160
views
Why is table opened every time a query is executed against it?
I execute this SQL command twice and profile
select * from sbtest.sbtest2 limit 100;
The first time profile result is
mysql> show profile for query 1;
+----------------------+----------+
| ...
- 321