Should I turn on innodb_strict_mode and add primary key to tables with no primary keys

[j-ed]

@vitachaos

… and and would it be safe turn on innodb_strict_mode.

I found this thread using the search function of this forum, in which a user reported that he has enabled the named parameter. Perhaps his hints to optimize the database access helps you too:

Not that fast hdd's and 250mbps internet connection - i/o waits

Make sure that the database is on a separate physical disk. When sql is the bottle neck the rest will be slow too. Try adjusting InnoDB to tune it. Use mysqltuner script. This is a sample config I’m trying on an old 2 core 1.6ghz AMD e-350. Warning. Do not use O_DSYNC and doublewrite=0 unless you are using a journaling filsystem like btrfs… [mysqld] innodb_buffer_pool_size = 2G innodb_buffer_pool_instances = 2 innodb_file_per_table = 1 innodb_compression_algorithm = …