Linked Questions
24 questions linked to/from How do you tune MySQL for a heavy InnoDB workload?
29
votes
1
answer
34k
views
MySQL transaction size - how big is too big?
I have an import process that runs every so often and I want it to be an 'all or nothing' kind of deal, aka: a transaction.
There are many aspects, and the imports may yield anywhere between 100k-...
- 413
9
votes
3
answers
14k
views
Optimizing InnoDB default settings
I looked into my.ini and saw various default settings. My database is running on a single stand-alone PC. I want to optimize the performance of InnoDB and MySQL in general for performance. There is no ...
- 1,425
11
votes
1
answer
10k
views
Capabilities of InnoDB INSERT Performance
Hi I am running the most recent version of Percona Server.
Server version: 5.5.24-55 Percona Server (GPL), Release 26.0
I have a 10 cpu box of these characteristics.
processor : 0
vendor_id ...
- 339
2
votes
4
answers
20k
views
which mysql version to use - 5.1 or 5.5?
I am designing a new database. There are going to be around 1000 write queries per second. There may be as much as 10000 read per second.
Which MySQL version is recommended?
I came across a post on ...
- 87
7
votes
3
answers
12k
views
MySQL buffer pool usage + high load
We've got a quite powerful server: HP ProLiant DL360p Gen8, 2xIntel Xeon E5-2630 2.30GHz, 128GB of RAM.
The whole data set should fit in memory:
mysql> SELECT FLOOR(SUM(DATA_LENGTH+INDEX_LENGTH)/...
- 459
7
votes
1
answer
8k
views
When to switch from MyISAM to InnoDB?
We have a MySQL 5.0 server running all tables as MyISAM. We have two slaves that, in the last month, we have upgraded to MySQL 5.5. Their tables are also still MyISAM.
My original plan was to upgrade ...
- 642
3
votes
2
answers
15k
views
MySQL 5.5 High CPU Usage
I have been working with a client with high traffic website(500k visitors and 600-800 active users at any given time). This uses wordpress and the DB is using MyISAM engine. The problem we had was ...
- 63
6
votes
2
answers
3k
views
How to optimize the my.cnf of a MySQL server that mixes InnoDB and MyISAM tablespaces?
I have a database that, because of some issues, I needed to convert some tables from MyISAM to InnoDB.
I basically did this:
set sql_log_bin = 0;
set sql_mode = 'STRICT_ALL_TABLES';
ALTER TABLE `...
- 61
9
votes
2
answers
4k
views
Is there a rule of thumb regarding the size and number of a buffer pool instances?
I know the consensus seems to be approximately 75% of ram should be dedicated to the buffer pool. But, I'm more interested in the optimal number of buffer pool instances. What are some things to ...
- 761
5
votes
1
answer
1k
views
Should I use a storage engine other than MyISAM to optimise these tables or should I get better disks?
There's a production database I'm working on, whose 4 largest tables contain between 4 million and 10 million rows each and about 15 fields each, with indexes on different field types (numbers, ...
- 163
5
votes
1
answer
9k
views
MySQL RDS Instance eating up memory and swapping
I have an issue with memory on a RDS instance which is of db.m2.4xlarge class.
Below are the specifications of the RDS instance
Instance Class: db.m2.4xlarge ( 68.4 GB of RAM )
Engine: mysql (5.5.37)
...
- 101
4
votes
2
answers
5k
views
What are the causes of InnoDB Index Corruption?
I'm running into issues where many of my database servers are experiencing repeat index corruption. The index corruption across several physical hosts, and many different tables. Whenever I restore a ...
- 141
4
votes
1
answer
4k
views
Derby slows down after 1.2 million records
I'm using a Derby database, mass insertions slow down to 1/4 to 1/6 the speed once there are 1.2 million records (about 6 GB database size, one major table, other tables are tiny). Is that normal? Is ...
- 41
2
votes
2
answers
2k
views
InnoDB + TokuDB fills up RAM then start swapping
I'm trying to face difficulties with my database lately. I've migrated from MyISAM to TokuDB v7.0.4 and InnoDB. I'm using MariaDB - 5.5.34-MariaDB-1~wheezy-log. My problem is that MariaDB fills up RAM ...
- 21
2
votes
3
answers
2k
views
Setting innodb_buffer_pool_size in for Mysql
We have a dedicated DB box with with 8 GB of RAM and running Redhat linux 64 bit OS. Our MySQL Data + Index size almost 7.8 GB. About setting innodb_buffer_pool_size, I have read 2 suggestions
Set it ...
- 121