June 2017 - discuss - lists.mariadb.org

[Maria-discuss] explain for insert/update/delete
by MARK CALLAGHAN 08 Jul '25

08 Jul '25

Does MariaDB have any plans to support explain for insert/update/delete/replace/CTAS? There have been feature requests open for a very long time on official MySQL without any progress. I have had a few problems in production from 'bad' delete statements that had a very different plan than the select statement with the same where clause. The only way to check for a bad plan today is to use SHOW INNODB STATUS to determine whether the statement locks all rows in a table. http://bugs.mysql.com/bug.php?id=14745 http://bugs.mysql.com/bug.php?id=35355 -- Mark Callaghan mdcallag(a)gmail.com

3 3

[Maria-discuss] Galera 23.2.7 mariadb 5.5.33a msvc 1600 binaries available
by Yann Nayn 21 May '25

21 May '25

Binaries have been uploaded for both x86 and amd64 platforms. due to github file size limitations , the directories have been uploaded unarchived. for Win33 binaries , please checkout https://github.com/YannNayn/galera-mariadb-win32.git and for Win64(amd64) binaries (being uploaded/pushed): https://github.com/YannNayn/galera-mariadb-win64.git they are not recommended for a production environment. in the my.cnf file: _________ wsrep_provider=galera_smm.dll wsrep_sst_method=msqldump # percona xtrabackup will be tested soon _________ libevent and openssl(the provided binaries use respectively 2.1.3-alpha and 1.1.0-dev versions ) will be added next on github some limitations are stated on openssl website copied here for convenience: ____________ from http://www.openssl.org/ ____________ This software package uses strong cryptography, so even if it is created, maintained and distributed from liberal countries in Europe (where it is legal to do this), it falls under certain export/import and/or use restrictions in some other parts of the world. PLEASE REMEMBER THAT EXPORT/IMPORT AND/OR USE OF STRONG CRYPTOGRAPHY SOFTWARE, PROVIDING CRYPTOGRAPHY HOOKS OR EVEN JUST COMMUNICATING TECHNICAL DETAILS ABOUT CRYPTOGRAPHY SOFTWARE IS ILLEGAL IN SOME PARTS OF THE WORLD. SO, WHEN YOU IMPORT THIS PACKAGE TO YOUR COUNTRY, RE-DISTRIBUTE IT FROM THERE OR EVEN JUST EMAIL TECHNICAL SUGGESTIONS OR EVEN SOURCE PATCHES TO THE AUTHOR OR OTHER PEOPLE YOU ARE STRONGLY ADVISED TO PAY CLOSE ATTENTION TO ANY EXPORT/IMPORT AND/OR USE LAWS WHICH APPLY TO YOU. THE AUTHORS OF OPENSSL ARE NOT LIABLE FOR ANY VIOLATIONS YOU MAKE HERE. SO BE CAREFUL, IT IS YOUR RESPONSIBILITY. ________________________________________________ msvc 1600 redistributables SP1 need to be installed/available on the target machine: vcredist_x86.exe : http://www.microsoft.com/en-us/download/details.aspx?id=8328 vcredist_x64.exe : http://www.microsoft.com/en-us/download/details.aspx?id=13523 MSys binaries are provided and msqld.bat should then be used instead of mysqld.exe (e.g. mysld.bat --console --wsrep_cluster_address=gcomm:// ) in order to have a working sh shell(cygwin has been proved to do it as well) Please note that oqgraph is disabled (boost trunk is used , that is 1.55) Comments and suggestions are welcome.

5 4

[Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096
by Reindl Harald 05 Jul '20

05 Jul '20

Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? on systemd based distributions that spits now to the global syslog and finally on machines restarting 2 instances every hour for backup reasons it annoys until 10.0.19 or 10.0.20 that was not this way

5 13

[Maria-discuss] Charsets and collations
by Peter Laursen 20 Apr '18

20 Apr '18

Does anybody know if there are any plans to bring collations added in MySQL 8 - refer http://mysqlserverteam.com/new-collations-in-mysql-8-0-0/ - to MariaDB and are there any plans to change the default charset to a unicode-based one? -- Peter -- Webyog

2 2

[Maria-discuss] question about fast path for TRUNCATE TABLE
by MARK CALLAGHAN 06 Aug '17

06 Aug '17

This started as a question on a MyRocks list. MyRocks comes from MariaDB in this case and the code that determines whether the truncate table fast path is used looks different in MariaDB than in FB MySQL. By "fast path" for truncate I mean the use of drop/recreate for truncate. The slow path is delete one row at a time. In this case, truncate is doing delete one row at a time for MyRocks in MariaDB but drop/recreate in FB MySQL. https://groups.google.com/forum/#!topic/myrocks-dev/dhweTwN-9xg -- Mark Callaghan mdcallag(a)gmail.com

3 6

[Maria-discuss] legacy InnoDB compressed tables using row_format=compressed
by Lukas Lehner 05 Jul '17

05 Jul '17

Hey Quote from https://mariadb.com/kb/en/mariadb/compression/ This approach differs significantly from legacy InnoDB compressed tables using row_format=compressed, where both uncompressed and compressed pages can be in the buffer pool. Any details why this is legacy? Should not be used? With a search engine I found a very old blog posting "InnoDB compression woes" from Percona. row_format=compressed is attractive when you pay your DBaaS per GB (storage based usage). Any insides? Lukas

2 1

[Maria-discuss] Duplication of documentation for binlog annotation and a question on replicate_annotate_row_events not being dynamic
by Jean-Francois B. Gagne 03 Jul '17

03 Jul '17

Hi all, This is a documentation organisation question and a technical question on replicate_annotate_row_events not being dynamic. In [1], we can find the documentation for the options binlog-annotate-row-events and replicate-annotate-row-events, and [2] points to [1]. However, there is a duplication of that documentation in [3] and [4], is there a reason for that (there is a risk of those 2 documentation diverging) ? [1]: https://mariadb.com/kb/en/mariadb/annotate_rows_log_event/ [2]: https://mariadb.com/kb/en/mariadb/mysqld-options/ [3]: https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-… [4]: https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-… And the technical question about replicate_annotate_row_events: this variable is not dynamic, is there a reason for that ? I understand that this variable could/should only be modifiable while the slave is stopped, but not being dynamic is not very DBA/SysAdmin/Operator friendly. Many thanks, Jean-François Gagné

3 2

[Maria-discuss] [mysqld] Can't find messagefile '/usr/share/mysql/errmsg.sys'
by Guillermo Cespedes 30 Jun '17

30 Jun '17

Hi, Compilation Instructions: # uname -a Linux framework 3.16.0-4-686-pae #1 SMP Debian 3.16.43-2+deb8u2 (2017-06-26) i686 GNU/Linux # groupadd mysql # useradd -c "MySQL Server" -g mysql -s /bin/false mysql # cmake . -DBUILD_CONFIG=mysql_release \ -DCMAKE_C_FLAGS="-I/usr/local/include -I/usr/include/i386-linux-gnu" \ -DWITH_INNODB_LZ4=ON -DWITH_INNODB_LZMA=OFF -DWITH_INNODB_LZO=OFF \ -DWITH_ZLIB=system -DWITH_SSL=system \ -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_spanish_ci \ -DWITH_DEBUG=0 -DWITH_VALGRIND=0 # make # make install # export PATH=$PATH:/usr/local/mysql/bin # echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile # source /etc/profile # cd /usr/local/mysql # chown -R root . # chown -R mysql data # cp ./support-files/my-medium.cnf /etc/my.cnf # ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --verbose # cp ./support-files/mysql.server /etc/init.d/mysql # chmod +x /etc/init.d/mysql # update-rc.d mysql defaults # service mysql start # ./bin/mysql_secure_installation # ./bin/mysqladmin -u root password Error: # mysqld 2017-06-28 21:37:24 3071039232 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead. 2017-06-28 21:37:24 3071039232 [Note] mysqld (mysqld 10.2.6-MariaDB-log) starting as process 2600 ... 2017-06-28 21:37:24 3071039232 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys' 2017-06-28 21:37:24 3071039232 [ERROR] Aborting # ls -l /usr/share/mysql ls: cannot access /usr/share/mysql: No such file or directory How to indicate the correct directory permanently ? /usr/share/mysql to /usr/local/mysql/share # ls /usr/local/mysql/share aclocal german mysql_performance_tables.sql romanian charsets greek mysql_system_tables_data.sql russian czech hungarian mysql_system_tables.sql serbian danish install_spider.sql mysql_test_data_timezone.sql slovak dutch italian mysql_to_mariadb.sql spanish english japanese norwegian swedish errmsg-utf8.txt korean norwegian-ny ukrainian estonian maria_add_gis_sp_bootstrap.sql pkgconfig fill_help_tables.sql maria_add_gis_sp.sql polish french mroonga portuguese Guillermo Céspedes Full Stack Developer

2 5

[Maria-discuss] Parser language
by Roberto Spadim 28 Jun '17

28 Jun '17

Hi guys, sometime ago i asked if we could select what parser we are using, with an example with nosql (handler socket) or sql, without new socket connection Show we consider this as something we will need? Check that new query ideas are next door: http://probcomp.csail.mit.edu/bayesdb/ -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

1 0

[Maria-discuss] MariaDB 10.2 innodb page_clean question ?
by Ljr Yang 26 Jun '17

26 Jun '17

Hi, Recently, we upgrade 8 MariaDB slaves from MariaDB 10.1.22 to MariaDB 10.2.6. In error log, it frequent occurrence some innodb Note: ............. 2017-06-26 9:01:03 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6142ms. The settings might not be optimal. (flushed=16 and evicted =0, during the time.) 2017-06-26 9:03:54 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4584ms. The settings might not be optimal. (flushed=8 and evicted= 0, during the time.) 2017-06-26 9:05:58 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4728ms. The settings might not be optimal. (flushed=8 and evicted= 0, during the time.) 2017-06-26 9:08:49 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5016ms. The settings might not be optimal. (flushed=8 and evicted= 0, during the time.) 2017-06-26 9:09:12 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4990ms. The settings might not be optimal. (flushed=8 and evicted= 0, during the time.) 2017-06-26 9:11:27 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5387ms. The settings might not be optimal. (flushed=8 and evicted= 0, during the time.) 2017-06-26 9:14:43 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6463ms. The settings might not be optimal. (flushed=0 and evicted= 0, during the time.) 2017-06-26 9:16:27 140022654363392 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4031ms. The settings might not be optimal. (flushed=40 and evicted =0, during the time.) ............ Now, It have not affect the normal use, but we could not confirm, it is our config problem or other reasons? Please help confirm, thanks.

1 0