New answers tagged

-1

"mysql> SET GLOBAL sort_buffer_size = 1024 * 1024 * 4;" its a bad way to put in 4m the sort buffer size, thats makes sort buffer size have 4GB use "mysql> SET GLOBAL sort_buffer_size = 1024 * 4;" If i'm been your, i don't try to change short buffer size, that is a good way to make crash your server, and send to trash performance. It's better try to make ...


2

We have millions of tables deployed running ARIA in production. It is definitely a better choice over MyISAM as far as crashing and recovering from a crashed table. If you have high concurrent write neither are a option as they both only support table level locks. For tables with more write intensive operations stick with InnoDB, and with heavy write tables ...



Top 50 recent answers are included