December 2013 - discuss - lists.mariadb.org

[Maria-discuss] INFORMATION_SCHEMA.PROCESSLIST values of PROGRESS, STAGE and STAGE_MAX
by Jean Weisbuch 11 Dec '13

11 Dec '13

Hello, Lately, i did modify mytop (https://mariadb.atlassian.net/browse/MDEV-4476) to use INFORMATION_SCHEMA.PROCESSLIST instead of SHOW PROCESSLIST (when available) to gather running processes informations as it's more flexible and has more informations but the value of the PROGRESS column on both is different, so i wondered if the PROGRESS value on SHOW PROCESSLIST was using a simple formula like this one or something more complex : (STAGE-1)/MAX_STAGE + {decimal progress on the actual stage}/MAX_STAGE There seems to be a broken alinea about that on the KB page of the PROCESSLIST : https://mariadb.com/kb/en/show-processlist/ In any case, what would be the best way to go with mytop, add columns with the actual_stage/max_stage or only keep the progress of the actual stage or only the "total" progress using the formula previously shown? Putting an option and keystroke to show/hide these columns could be another solution as these values might be of use on only "rare" cases depending on the workload. Regards.

3 3

[Maria-discuss] New Question: mariadb run failed on Centos 6.4
by AskMonty KB 09 Dec '13

09 Dec '13

Hello, A new question has been asked in "MariaDB community" by kimbg: -------------------------------- my server installed centos 6.4(32bit) i'll source compile maria db 5.1.67/5.5.34 and yum install. but, i looking error message mysql_install_db. how fixed? maria source version : 5.1.67/5.1.62 5.5.34 (https://downloads.mariadb.org/interstitial/mariadb-5.1.67/kvm-tarbake-jaunt…) compile option [root@localhost var]# ./configure --prefix=/usr/local/mysql --with-extra-charsets=all --with-readline mysql_install_db command [root@localhost ~]# /usr/local/mysql/bin/mysql_install_db Installing MariaDB/MySQL system tables... 131209 11:07:26 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:07:26 [ERROR] Aborting Installation of system tables failed! Examine the logs in /usr/local/mysql/var for more information. You can try to start the mysqld daemon with: shell> /usr/local/mysql/libexec/mysqld --skip-grant & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in /usr/local/mysql/var that may be helpful. The latest information about mysql_install_db is available at http://kb.askmonty.org/v/installing-system-tables-mysql_install_db. MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before mailing us! And remember, if you do mail us, you should use the /usr/local/mysql/bin/mysqlbug script! [root@localhost ~]# /usr/local/mysql/libexec/mysqld --skip-grant & [1] 1402 [root@localhost ~]# 131209 11:20:11 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:20:11 [ERROR] Aborting [1]+ Exit 1 /usr/local/mysql/libexec/mysqld --skip-grant [root@localhost ~]# cat /usr/local/mysql/var/localhost.localdomain.err 131209 11:08:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var 131209 11:08:40 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:08:40 [ERROR] Aborting 131209 11:08:40 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended [root@localhost ~]# -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-run-failed-on-centos-64/

1 0

[Maria-discuss] Galera 23.2.7 mariadb 5.5.33a msvc 1600 binaries available
by Yann Nayn 04 Dec '13

04 Dec '13

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.

1 0

[Maria-discuss] New Question: CMAKE settings to include TokuDB in 5.5.34
by AskMonty KB 02 Dec '13

02 Dec '13

Hello, A new question has been asked in "TokuDB" by markdiener: -------------------------------- I am trying to build 5.5.34 from source on Linux x64 (Fedora 14). I was looking at the readme files and could not find anything about building 5.5.34 from source and including TokuDB (which has the source code in the /storage/TokuDB/ directory) into the build. I was looking for something like: -DWITH_TOKUDB_STORAGE_ENGINE=ON but did not stumble across anything. Anybody got some ideas? Here is my build script: rm -f CMakeCache.txt make clean cmake \ -DCMAKE_BUILD_TYPE=Release \ -DCMAKE_INSTALL_PREFIX=/mysql \ -DENABLED_PROFILING=OFF \ -DENABLE_DEBUG_SYNC=ON \ -DENABLE_GCOV=OFF \ -DINSTALL_LAYOUT=STANDALONE \ -DMYSQL_DATADIR=/mysql/data \ -DINSTALL_INCLUDEDIR=include/mysql \ -DINSTALL_UNIX_ADDRDIR=/mysql/mysql.sock \ -DUSE_ARIA_FOR_TMP_TABLES=ON \ -DWITHOUT_PBXT_STORAGE_ENGINE=ON \ -DWITHOUT_SERVER=OFF \ -DWITH_ARCHIVE_STORAGE_ENGINE=OFF \ -DWITH_EMBEDDED_SERVER=OFF \ -DWITH_FAST_MUTEXES=OFF \ -DWITH_FEDERATEDX_STORAGE_ENGINE=OFF \ -DWITH_FEEDBACK=OFF \ -DWITH_LIBWRAP=OFF \ -DWITH_PIC=ON \ -DWITH_PARTITION_STORAGE_ENGINE=OFF \ -DWITH_PERFSCHEMA_STORAGE_ENGINE=ON \ -DWITH_SPHINX_STORAGE_ENGINE=OFF \ -DWITH_SSL=OFF \ -DWITH_UNIT_TESTS=OFF \ -DWITH_VALGRIND=OFF \ -DWITH_XTRADB_STORAGE_ENGINE=ON \ -DWITHOUT_OQGRAPH=ON \ -DWITH_ZLIB=bundled make (now compiling your program) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cmake-settings-to-include-tokudb-in-5534/

1 0

[Maria-discuss] Fw: [Website feedback] galera mariadb compiled using msvc
by Yann Nayn 02 Dec '13

02 Dec '13

On Monday, December 2, 2013 11:46 AM, Yann Nayn <yann.nayn(a)yahoo.fr> wrote: >Yes, we're reading mariadb mailing list ... I realized that while reading mailing lists archives . galera is now running using mysqldump as the wsrep sst backup method I didnt dig the details yet and will compile percona xtrabackup next Im tested the deployment with two nodes(...) and still find bootstrapping "tiedeous". I will go with basic sql manipulations in the next coming hours I just tested create database on one node , the database is visible from the other node . I might provide soon msi installation packages to ease testing https://github.com/YannNayn

1 0

[Maria-discuss] Mroonga storage engine is merged into MariaDB 10.0
by kentoku 01 Dec '13

01 Dec '13

Hi! We just pushed Mroonga storage engine into "lp:~mroonga/maria/mroonga". Mroonga is a fulltext/geo search storage engine. Would you please bundle Mroonga into MariaDB? Mroonga's strong points are - High-speed updating with multiple thread searching. (lock-free model) - Support CJK languages. - Support wrapper mode. Wrapper mode works adding fulltext/geo index for other storage engines. Mroonga is tested on the following 64bit OS. Debian GNU/Linux squeeze Debian GNU/Linux wheezy Debian GNU/Linux jessie Debian GNU/Linux sid Ubuntu 10.04 LTS Lucid Lynx Ubuntu 12.04 Precise Pangolin Ubuntu 12.10 Quantal Quetzal Ubuntu 13.04 Raring Ringtail Ubuntu 13.10 Saucy Salamander CentOS 5 CentOS 6 Fedora 19 Mac OS X Windows 7 Mroonga documents (English & Japanease) are available on http://mroonga.org/docs/index.html Test command is the followings. The command calls mysql-test-run.plinternally. > ./storage/mroonga/test/run-sql-test.sh Thanks, Kentoku

6 6