Tag Info

New answers tagged


This is part of the table definition, you'll need to do something similar to this: ALTER TABLE Table1 MODIFY COLUMN Column1 INT AFTER Column2; This will move Column1 after Column2. Alter Table Syntax


I had the same problem with my MySql 5.6.10 version, and the following helped me. Try adding the following in your my.ini (or my.cnf) file under the [mysqld] part: table_definition_cache = 400 performance_schema=0 and restart your mysql server. In my case after doing the above my mysql server's RAM usage went down from ~430MB to ~20 MB. You can read ...


YOSHINORI MATSUNOBU'S BLOG would be the place to start. He recommends splitting up files that do sequential writes from files that do random reads and writes. Random i/o oriented: Table files (*.ibd) UNDO segments (ibdata) Sequential write oriented: REDO log files (ib_logfile*) Binary log files (binlog.XXXXXX) Doublewrite buffer (ibdata) Insert buffer ...


Going by your other questions, it sounds like you have a short archive_timeout so your WAL archives are mostly empty, but are still the full pre-allocated 16MB file. On most platforms you just gzip them, e.g. archive_command = 'gzip -c < "%p" > /archive/path/%f"' On Windows this won't work natively due to the lack of the gzip command. You'll need ...

Top 50 recent answers are included