Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with innodb
Search options answers only
not deleted
user 1268
InnoDB : MySQL's ACID-compliant Storage Engine
3
votes
Is tuning the innodb_buffer_pool_size important on Solaris ZFS?
In a nutshell, what he is arguing is that you do not need such a large InnoDB buffer pool because ZFS has some fancy caches like a L2 ARC. … While cache misses might be less expensive, each page will still needed to be loaded into InnoDB for modifications to be made, and a smaller buffer pool will mean more churning of what pages are loaded …
- 3,810
3
votes
Accepted
Is there any reason not to use Percona 'innodb_fast_checksum'?
You've got to put it in context - InnoDB only verifies the checksums when it reads a page from the block storage device, and updates it before flushing it back to the storage device. …
- 3,810
1
vote
Add column on huge InnoDB table in MySQL 4.1
You can use statement-based replication and add the column to a slave first. Any pending modifications will queue up on the slave, and apply once the alter has complete. When the slave is fully up t …
- 3,810
0
votes
MySQL TEXT Disk Space
If you are concerned with the size, maybe try using InnoDB page compression, or compress the blobs in your application before storing them? You'll probably find the TEXT column compresses very well. …
- 3,810
1
vote
MySQL buffer pool usage + high load
Here are my suspicions:
mysqld is restarting for some reason, leaving the buffer pool cold on restart. This can be eliminated by SHOW GLOBAL STATUS (uptime column) and looking at the error log for …
- 3,810
4
votes
Accepted
mysql innodb_flush_log_at_trx_commit clarification
What I want to know is, this does not affect the time that the query
is actually committed does it? It only affects its recovery ?
It only affects recovery.
I just want to make sure that wh …
- 3,810
1
vote
UPDATE waits for lock too long after SELECT in MySQL (Innodb)
Useful diagnostics to be able to see these locks:
SHOW CREATE TABLE pics
SHOW ENGINE INNODB STATUS
SELECT * FROM information_schema.innodb_trx
Index structure affects locking (hence SHOW CREATE TABLE … SHOW ENGINE INNODB STATUS and innodb_trx will show information about which row locks are conflicting, and which statements. …
- 3,810
3
votes
Accepted
Where does mysql write temporary tables?
From the MySQL manual for 5.1:
..
On Windows, Netware and OS2, MySQL checks in order the values of the TMPDIR, TEMP, and TMP environment variables. For the first one found to be set, MySQL uses it an …
- 3,810
5
votes
How can I find who holds the lock based on the hex-dumped?
Don't use SHOW ENGINE INNODB STATUS, use information_schema.innodb_locks. …
- 3,810
1
vote
Why ".my.cnf" file is empty?
The ~/.my.cnf file is usually used for client options (for example changing the default port or host).
mysqld will likely start as a different user and will not read your .my.cnf file. It is recomme …
- 3,810
2
votes
Accepted
InnoDB buffer pool active pages
You can kind of do this from MySQL 5.6 and onwards using information_schema. I have an example of finding the ideal buffer pool size on my blog here: http://www.tocker.ca/2013/05/31/estimating-mysqls …
- 3,810
0
votes
Buffer pool above 90% utilized causes MySQL to crash
InnoDB reserves additional memory for buffers and control structures,
so that the total allocated space is approximately 10% greater than the specified size. …
- 3,810
28
votes
Accepted
innodb_file_format Barracuda
So I'm answering this question almost 4 years late:
InnoDB file formats were conceived at a time when InnoDB was independent of the MySQL Server (for example: MySQL 5.1 could run two different versions … of InnoDB). …
- 3,810
7
votes
Can I have create an InnoDB table without a PK? If so, would a secondary index be used as th...
If you have a unique key that is not null, it gets promoted internally to be the clustered key (or if you have more than one that matches this criteria - the first one does.)
If you don't have a uniq …
- 3,810
1
vote
Accepted
String Pooling for MySQL
Small starting clarification: the article you linked to on InnoDB text/blob storage is a little out of date with MySQL 5.5, and the barracuda row format. This article is more up to date. …
- 3,810