Linked Questions
16 questions linked to/from Optimizing InnoDB default settings
40
votes
6
answers
70k
views
How do you tune MySQL for a heavy InnoDB workload?
Assuming a production OLTP system with predominantly InnoDB tables
What are the common symptoms of a mistuned/misconfigured system?
What configuration parameters do you most commonly change from ...
- 1,377
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
22
votes
1
answer
14k
views
Clarification on MySQL innodb_flush_method variable
Let me begin by admitting that I'm very ignorant of the inner workings of hard disks. So when I read over the manual for the variable innodb_flush_method, it confused me. Can I get an explanation in ...
- 23.4k
12
votes
1
answer
9k
views
MySQL Workbench Database Sizes
I'm trying to find the total size on the hard disk that all of my MySQL Workbench databases are using.
Does anyone know of an easy way to figure this out?
If nothing else, the default location mysql/...
- 323
6
votes
2
answers
14k
views
Local database vs Amazon RDS
I am doing large INSERT into a local MySQL database
I am at 2,000,000 rows and am really starting to notice the slowdown now. I always heard that MySQL wasn't very scalable
I expect this database to ...
- 163
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
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
2
votes
2
answers
5k
views
MySQL / InnoDB: Does daily optimization improve performance?
Would performing daily optimizations of tables increase performance for MySQL and InnoDB? I have never did this before, but I have seen this module for Drupal http://drupal.org/project/db_maintenance, ...
- 1,407
4
votes
1
answer
8k
views
How can I find out the last time a MySQL table was analyzed?
I'm interested in this for InnoDB mostly, but also for MyISAM.
I looked around in information_schema and did not see this data anywhere.
I'm using MySQL 5.5.16.
- 714
4
votes
1
answer
3k
views
Need help to understand how information_schema.TABLES get updated
I created large innodb table
mysql> select count(*) from big_data;
+----------+
| count(*) |
+----------+
| 23822336 |
+----------+
checked the stats in informaion_schema.TABLES
mysql> ...
- 41
1
vote
2
answers
5k
views
Where should I look for my.cnf?
I want to add innodb_file_per_table statement to my.cnf file.
Where is my.cnf?
Could I change this file when I have an online site?
- 3,646
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
2
votes
2
answers
1k
views
MySql DB slow after restore until I run mysqlcheck
I frequently have to restore our website's production DB to our test server.
When trying to access the restored copy of production, the performance is AWFUL. For example, one particularly heavy web ...
-1
votes
2
answers
2k
views
MySQL 8 - optimize all tables + indexes
I have a bunch of tables (InnoDB) within several databases (MySQL 8), that I run Garbage Collect scripts on, on daily basis, removing stale records that are no longer needed. All tables do have ...
- 113
2
votes
1
answer
2k
views
Can not drop virtual column | ERROR 1054 (42S22): Unknown column in 'GENERATED ALWAYS'
I'm just running a command:
optimize table some_table_name_here;
But it results with:
Table | Op | Msg_type | Msg_text
db.some_table_name_here | optimize | note | Table does not support optimize, ...
- 31