You might want to adjust some my.conf parameters:
max_join_size // useful for denying execution of outright stupid queries like large cross-joins.
key_buffer_size, join_buffer_size, innodb_buffer_pool_size // optimal sizes depend on available RAM. I am mentioning it just to make sure it is not left at the default values
max_allowed_packet = 10M // important for imports with long rows. You might have already encountered this limit
sql_mode // I think I was disabling some of MySQL shenanigans and making it more ANSI compatible.
wait_timeout, lock_wait_timeout, max_execution_time // consider decreasing these default values to improve availability of the server for the public
I am writing them from memory → use your own judgment, I might misremember them.
You might want to adjust some my.conf parameters:
max_join_size // useful for denying execution of outright stupid queries like large cross-joins.
key_buffer_size, join_buffer_size, innodb_buffer_pool_size // optimal sizes depend on available RAM. I am mentioning it just to make sure it is not left at the default values
max_allowed_packet = 10M // important for imports with long rows. You might have already encountered this limit
sql_mode // I think I was disabling some of MySQL shenanigans and making it more ANSI compatible.
wait_timeout, lock_wait_timeout, max_execution_time // consider decreasing these default values to improve availability of the server for the public
I am writing them from memory → use your own judgment, I might misremember them.