April 2015 - discuss - lists.mariadb.org

[Maria-discuss] New Question: Will MariaDB 10.1.X pick up MySQL 5.7.7 system variable changes for innodb?
by AskMonty KB 06 Apr '15

06 Apr '15

Hello, A new question has been asked in "What is in the Different MariaDB Releases?" by vanessaharo. Please answer it at http://mariadb.com/kb/en/will-mariadb-101x-pick-up-mysql-577-system-variabl… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Will MariaDB 10.1.X pick up MySQL 5.7.7 system variable changes for innodb? http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb… • innodb_large_prefix is enabled by default in MySQL 5.7.7. This change coincides with the default value change for innodb_file_format, which is set to Barracuda by default in MySQL 5.7.7. Together, these default value changes allow larger column prefix indexes to be created when using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED. If either option is set to a non-default value, column prefixes are silently truncated to 768 bytes. innodb_large_prefix is deprecated in MySQL 5.7.7, and will be removed in a future release. innodb_large_prefix was introduced in MySQL 5.5 to allow users to create tables compatible with the InnoDB Plugin in MySQL 5.1, which has reached the end of its product lifecycle. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/will-mariadb-101x-pick-up-mysql-577-system-variabl…

1 0

[Maria-discuss] MariaDB 10: repair table leaves 'TMM' files
by Reindl Harald 06 Apr '15

06 Apr '15

if somebody has day for day the ame table damaged just go to the datadir and delete the leave .TMM file and after that it should not happen again for at least some time cms1_user_online.TMM

1 0

[Maria-discuss] Query exceeding 16384 bytes, skipping. Probably a bulk insert query.
by Umarzuki Mochlis 02 Apr '15

02 Apr '15

When I'm restoring dump of all database to one of my MariaDB 10.0 nodes (2 nodes galera cluster), I saw "Query exceeding 16384 bytes, skipping. Probably a bulk insert query.". So I ran again mysqldump for all database and diff with its original dump. There's a lot of differences. Where should I configure on my.cnf to allow each query from dump running successfully? Thanks.

1 0

[Maria-discuss] New Question: Strange issue with a complex stored procedure and Union Query
by AskMonty KB 01 Apr '15

01 Apr '15

Hello, A new question has been asked in "MariaDB Community" by stewartpage. Please answer it at http://mariadb.com/kb/en/strange-issue-with-a-complex-stored-procedure-and-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a complex stored procedure that executes on a schedule. It runs a union query and inserts the results into a table. I recently discovered that it needed to have a LIMIT added to both queries so I enclosed the two selects in brackets, and immediately the query error'd. Removing the brackets allowed the query to run correctly. Are there any issues I should be aware of? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/strange-issue-with-a-complex-stored-procedure-and-…

1 0