- discuss - lists.mariadb.org

[Maria-discuss] unexpected index growth
by Said Ramirez 11 Mar '13

11 Mar '13

We have noticed a very strange index growth with one of our tables. The data in the table is currently ~ 42GB and has been growing at a rate of about 1 GB per day for the week. Inserts/Updates on the tables are done with statements like: insert into foo ( ...) on duplicate key update ... We have a job which updates about 1/3 of the table 12 times a day. We running Mariadb version 5.5.27-MariaDB-log We noticed that the index sizes have been growing quite a bit: ** 7 days ago *** > select table_name,index_name,index_total_pages, (index_total_pages * 16*1024)/(1024*1024*1024) index_size_gb from INNODB_INDEX_STATS where table_name='foo'; +--------------------+----------------------+-------------------+---------------+ | table_name | index_name | index_total_pages | index_size_gb | +--------------------+----------------------+-------------------+---------------+ | foo | PRIMARY | 1192456 | 18.1954 | | foo | idx_active_deleted | 5647809 | 86.1787 | | foo | idx_last_update_plus | 5329538 | 81.3223 | | foo | active | 8586719 | 131.0229 | +--------------------+----------------------+-------------------+---------------+ 4 rows in set (0.00 sec) > optimize table db.foo; +---------+----------+----------+-------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +---------+----------+----------+-------------------------------------------------------------------+ | db.foo | optimize | note | Table does not support optimize, doing recreate + analyze instead | | db.foo | optimize | status | OK | +---------------------------------+----------+----------+-------------------------------------------------------------------+ 2 rows in set (4 hours 1 min 24.73 sec) > select table_name,index_name,index_total_pages, (index_total_pages * 16*1024)/(1024*1024*1024) index_size_gb from INNODB_INDEX_STATS where table_name='foo'; +--------------------+----------------------+-------------------+---------------+ | table_name | index_name | index_total_pages | index_size_gb | +--------------------+----------------------+-------------------+---------------+ | foo | PRIMARY | 639296 | 9.7549 | | foo | idx_active_deleted | 403520 | 6.1572 | | foo | idx_last_update_plus | 531392 | 8.1084 | | foo | active | 517312 | 7.8936 | +--------------------+----------------------+-------------------+---------------+ 4 rows in set (0.00 sec) ** Today ** > select table_name,index_name,index_total_pages, (index_total_pages * 16*1024)/(1024*1024*1024) index_size_gb from INNODB_INDEX_STATS where table_name='foo'; +--------------------+----------------------+-------------------+---------------+ | table_name | index_name | index_total_pages | index_size_gb | +--------------------+----------------------+-------------------+---------------+ | foo | PRIMARY | 1013436 | 15.4638 | | foo | idx_active_deleted | 2478512 | 37.8191 | | foo | idx_last_update_plus | 2459700 | 37.5320 | | foo | active | 3888175 | 59.3288 | +--------------------+----------------------+-------------------+---------------+ 4 rows in set (0.10 sec) One of the even stranger things is that the slaves of this table do not experience such a noticeable index size growth: [slave] >select table_name,index_name,index_total_pages, (index_total_pages * 16*1024)/(1024*1024*1024) index_size_gb from INNODB_INDEX_STATS where table_name='foo'; +--------------------+----------------------+-------------------+---------------+ | table_name | index_name | index_total_pages | index_size_gb | +--------------------+----------------------+-------------------+---------------+ | foo | PRIMARY | 1010492 | 15.4189 | | foo | idx_active_deleted | 454510 | 6.9353 | | foo | idx_last_update_plus | 543085 | 8.2868 | | foo | active | 583468 | 8.9030 | +--------------------+----------------------+-------------------+---------------+ 4 rows in set (0.01 sec) Our suspicion is that it has to do with how transactions are executing on the master since on the slaves the insert/updates would be executed in a single thread. However we can't tell why this is happening. Is this a known bug we are hitting ? As anyone else seen this behavior and come up with a solution other than having to run optimize table ? Thanks, -Said

2 4

[Maria-discuss] MariaDB Galera Cluster 5.5.29 Stable (GA) Released
by Daniel Bartholomew 05 Mar '13

05 Mar '13

After some final testing and polishing, the MariaDB project and Codership are pleased to announce the release of MariaDB Galera Cluster 5.5.29. This is a Stable (GA) release. - - MariaDB Galera Cluster 5.5.29 Links - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-galera-5529-release-notes Changelog: http://kb.askmonty.org/en/mariadb-galera-5529-changelog Downloads: http://downloads.mariadb.org/mariadb-galera/5.5.29 APT & YUM Repository Configuration Tool: http://downloads.mariadb.org/mariadb-galera/repositories Overview of MariaDB Galera Cluster 5.5: http://kb.askmonty.org/en/what-is-mariadb-galera-cluster More information: http://kb.askmonty.org/en/galera http://codership.com - - About MariaDB Galera Cluster - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster is made for today's cloud based environments. It is fully read-write scalable, comes with synchronous replication, allows multi-master topologies, and guarantees no lag or lost transactions. Some of its features & benefits are listed below. Features * Synchronous replication * Active-active multi-master topology * Read and write to any cluster node * Automatic membership control, with failed nodes dropped from the cluster * Automatic node joining * True row-level parallel replication * Direct client connections, native MariaDB/MySQL look & feel Benefits The above features yield several benefits for a database clustering solution, including: * No slave lag * No lost transactions * Both read and write scalability * Smaller client latencies Technology MariaDB Galera Cluster uses the Galera Library for the replication implementation. http://codership.com/products/galera_replication To interface with Galera replication, we have enhanced MariaDB to support the replication API definition in the Write Set REPlication (https://launchpad.net/wsrep) project. The implementation of the replication API in MariaDB happens in the open source MySQL-wsrep project. http://www.codership.com/products/mysql-write-set-replication-project - - Operations Support - - - - - - - - - - - - - - - - - - - - - - - - Once you run MariaDB Galera Cluster in production you want to make sure there is a helping hand available whenever needed. We're happy to inform you that our partner, SkySQL, offers 24-hour support for MariaDB Galera Cluster, see http://www.skysql.com/enterprise/galera-cluster for more information. - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous usage information. This information is used by the developers to track trends in usage to better guide development efforts. If you would like to help make MariaDB Galera Cluster better, please add "feedback=ON" to your my.cnf file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: http://mariadb.org/jira We hope you enjoy MariaDB Galera Cluster! - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - http://mariadb.org We're also on: Google+: http://google.com/+mariadb Facebook: http://fb.com/MariaDB.dbms Twitter: http://twitter.com/mariadb Follow, friend, and add us to your circles to keep up to date with MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL

1 0

[Maria-discuss] KB Question: FreeBSD 9.1, Mariadb55, and strfill()
by Daniel Bartholomew 04 Mar '13

04 Mar '13

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/freebsd-91-mariadb55-and-strfill/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - FreeBSD 9.1, Mariadb55, and strfill() Please give me a hint. Under FreeBSD my application cannot find strfill(). It can be found in libmysqlclient.a and libmysqlclient_r.a but NOT in the shared library libmysqlclient.so. Oddly, strcend() can be found in all of those libraries but I cannot find a difference in CMake between the two. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Using 10.0s multi-source replication for database consolidation
by Markus "Shorty" Uckelmann 22 Feb '13

22 Feb '13

Hi all, I want to consolidate the databases on several servers onto a single server. And all this without or only minimal downtime. After reading an article[1] from the Percona folks I was thinking of using the multi-source replication feature of 10.0. But there are a few things I'm not sure about. Maybe someone can help me out. What MySQL/MariaDB versions are needed before and behind the MariaDB 10 server? My plan/idea/dream was the following: 1. Stop the server on a slave and start it with skip-slave and skip-networking. Write down replication data. 2. Dump the databases I want to move with "mysqldump <db-name>" 3. Load the dump into MariaDB 10.0 and configure replication. This is done for all the databases I want to put onto a single server. The rest should be business as usual. BTW: We use similar grants on all servers. So the MariaDB 10.0 will be setup with the same statements and I don't have to care about the "mysql"-database. Does this sound realistic? Or have I missed something? [1] http://www.mysqlperformanceblog.com/2012/12/18/migrating-several-single-sta… Thanks a lot, Shorty

2 4

[Maria-discuss] KB Question: Low level access 8Bit MCU
by Daniel Bartholomew 19 Feb '13

19 Feb '13

The following question has been posted in the Knowledgebase: https://kb.askmonty.org/en/low-level-access-8bit-mcu/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Low level access 8Bit MCU are there any possibilities for a low level access via TCP/IP or UDP with an 8Bit MCU, for the basic functions, read record, edit record, add record. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Configuration tool
by Joerg Stephan 19 Feb '13

19 Feb '13

Hi there, if you follow the instructions regarding Ubuntu 12.04 LTS, the instructions will nit lead to an succesfull installation. apt-get will run into an unresolved dependency state, doing it with aptitude you can resolve the dependency in an second step. Maybe the issue should be fixed, or the docu should be updated. Regards Jörg

2 1

[Maria-discuss] KB Question: What Join?
by Daniel Bartholomew 18 Feb '13

18 Feb '13

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/what-join/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - I have a table called called ContenidosDeModelos with fields +------------+-------------+------+-----+ | Field | Type | Null | Key | +------------+-------------+------+-----+ | CdMID | int(5) | NO | PRI | | ModeloID | int(5) | NO | MUL | | ArticuloID | int(5) | NO | MUL | | Cantidad | float(10,3) | NO | | +------------+-------------+------+-----+ which in turn is related on the field ArticuloID to a table called CatArticulos with fields +-----------------------+-------------------------------------- | Field | Type +------------------------+------------------------------------- | ArticuloID | int(5) | ArticuloCodigo | char(7) | ArticuloNombre | varchar(45) | ArticuloDesc | varchar(75) | ArticuloDeshabilitado | char(1) | ArticuloUnidad | enum('pz','mts','kg','ton','m3','lts') +-----------------------+-------------------------------------- I want a listing of ALL of table CatArticulos (1300+ records) with the value of the field Cantidad from the table ContenidosDeModelos for a specified ModeloID (3 - 10 records) when there is a common ArticuloID otherwise Cantidad should be NULL when there is no corresponding ArticuloID in ContenidosDeModelos. I have written at least 100 different joins that don't work. Can someone give me a clue? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

2 1

[Maria-discuss] CentOS 6 RPMS - do give them a test
by Colin Charles 18 Feb '13

18 Feb '13

Hi! If you're using CentOS, do consider checking out the testing packages available: http://lists.centos.org/pipermail/centos-devel/2013-February/009029.html Quick start: drop http://dev.centos.org/centos/6/mariadb/mariadb.repo into /etc/yum.repos.d/ and yum list mariadb\* Please let us know how it goes and report bugs to http://bugs.centos.org/ cheers, -colin -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

1 0

[Maria-discuss] testing Galera
by Jan Kirchhoff 12 Feb '13

12 Feb '13

Hi, I'd like to evaluate mariadb-galera on some test databases. Our load is at least 90% writes coming from a datastream and I would try to set up a real-world situation and test with real data. Most of the work load is "insert ... on duplicate key update" mass-inserts (actually updates) of about 4MB/10000 rows each. 99% of these run onto 3-4 tables (each around 10GB/7 million rows of size). Total database size is around 800 GB. We have a traditional statement-based master-slave replication, but all these mass-inserts run over a proxy with SET SQL_LOG_BIN=0 in parallel on all systems - no way to process this amount of data single-threaded on the slaves. I was hoping galera would make this easier and make our proxies obsolete. I have some servers I could use for galera as a first step. I wanted to do this for 4 months now but never got into it, I read your request to test the RC and think I should start now hoping to be able to give some valuable feedback: After reading through the documentation and some blogs I have some doubts, but my idea was to do the following: I'd clone the database of an existing slave to a new machine with mariadb-galera (name the host "testgalera1" and rsync the database or use mysqldump). I'd then set up this one as a "normal" statement based slave connected to one of our masters? Afterwards, the next host "testgalera2" would have to be added to the galera-cluster? And after that, I'd set up one of our older database servers and add that to the cluster, too. My idea was to take an older, slower system to see how much this slowes the cluster down and get an idea how much headroom I'd have when I leave those old machines out (the old machines have only 64GB of RAM and slower CPUs). I'd then modify my proxy for all the incoming inserts and add a writer-thread to one of the hosts in the cluster, that data should be replicated by galera to all other galera hosts. All other data should be coming in via the "traditional" replication thread of testgalera1. This should give me a 95-99% real world write situation on the cluster. Adding a host to a running cluster would mean cloning the whole database (of course), but this also means the host I copy from would have to block write access to its tables and buffer all modifications in memory (at least that's how I read the documentation) during the copy process. Looking at the database size and amount of inserts, I am afraid adding a host to the cluster without taking everything down would be impossible - or even if it works fine now it could cause trouble once the database gets just a little bit larger or my load increases a bit. before I start with this - is galera an insane idea regarding my load? Or is it worth a try? Jan some numbers of some of the old databases: innodb_buffer_pool_size between 60-120 GB depending on server memory configuration. db5: Uptime: 8052248 Threads: 44 Questions: 1413881794 Slow queries: 160049 Opens: 683779 Flush tables: 2 Open tables: 1024 Queries per second avg: 175.588 db6: Uptime: 8070552 Threads: 6 Questions: 873413218 Slow queries: 3208 Opens: 336584 Flush tables: 1 Open tables: 578 Queries per second avg: 108.222 db7: Uptime: 4175032 Threads: 28 Questions: 639627677 Slow queries: 139337 Opens: 522673 Flush tables: 1 Open tables: 2016 Queries per second avg: 153.203 db7# mysql -e 'show global status like "%com\_%" ' |grep -v '\s0$' Variable_name Value Com_admin_commands 289127 Com_alter_table 6269 Com_analyze 725 Com_begin 3712141 Com_change_db 80112 Com_commit 3999309 Com_create_db 1 Com_create_table 253849 Com_create_trigger 10 Com_create_view 68 Com_delete 12365037 Com_delete_multi 7 Com_drop_table 310771 Com_drop_trigger 10 Com_drop_view 65 Com_empty_query 509 Com_flush 48 Com_grant 36 Com_insert 314280963 Com_insert_select 613565 Com_kill 214 Com_lock_tables 85 Com_optimize 1 Com_purge 2320 Com_rename_table 11 Com_repair 1 Com_replace 14240825 Com_replace_select 29920 Com_revoke 8 Com_rollback 13 Com_select 178540996 Com_set_option 6886915 Com_show_binlogs 69960 Com_show_charsets 1542 Com_show_collations 1544 Com_show_create_db 28 Com_show_create_func 195 Com_show_create_table 53282 Com_show_create_trigger 1 Com_show_databases 43584 Com_show_events 3 Com_show_fields 131874 Com_show_function_status 45 Com_show_grants 335 Com_show_keys 2582 Com_show_master_status 142 Com_show_plugins 7224 Com_show_procedure_status 45 Com_show_processlist 116918 Com_show_slave_status 83193 Com_show_status 155732 Com_show_storage_engines 25 Com_show_table_status 7439 Com_show_tables 1973739 Com_show_triggers 538 Com_show_variables 85034 Com_show_warnings 766 Com_stmt_close 363 Com_stmt_execute 363 Com_stmt_prepare 363 Com_truncate 452 Com_unlock_tables 79 Com_update 34496744 Com_update_multi 408212

5 10

[Maria-discuss] Problem in replication with NOW('2012-03-07 17:32:03')
by Jan Kirchhoff 12 Feb '13

12 Feb '13

Hi, I set up 2 hosts as a galera cluster, one of them is a slave of my main database. The galera hosts are 5.5.28a-MariaDB-a1~precise-log, all other databases are 5.2.12-MariaDB-mariadb115~squeeze-log. The 5.5 slave stops with 1064 errors. I figured this is because of updates using NOW() on timestamp columns, I think they come from a phpmyadmin frontend. In the error log the queries look like this: UPDATE ..., some_timestamp_field = NOW('2012-03-07 17:32:03') WHERE ...primary keys... when I manually execute the query and just remove the NOW so it is a simple update some_timestamp_field = '2012-03-07 17:32:03' and then execute set global sql_slave_skip_counter=1;slave start; everything is fine again. All 5.2 hosts replicate just fine. is this a bug in 5.5? Thanks Jan

2 4

[Maria-discuss] service on port 4567 is not starting
by Kőszegi Dániel 12 Feb '13

12 Feb '13

Hi All, I would appreciate a little help. I have done everything how it is in the installation steps, but the galera service on the port 4567 is not starting. No errors in mysql or syslog :( Tried on debian and centos as well. Right now server version: 5.5.28a-MariaDB-a1~squeeze-log mariadb.org binary distribution, wsrep_23.7rc1.rXXXX but I have tried with relevant mysql binaries as well. Do you have any idea why is it not starting the cluster service? wsrep.conf on node1: root@mariaclu01:/etc/mysql# cat /etc/mysql/conf.d/wsrep.cnf [wsrep] wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_address="gcomm://" wsrep_sst_auth=sst:sstpass123 wsrep.conf on node2: root@mariaclu02:~# cat /etc/mysql/conf.d/wsrep.cnf [wsrep] wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_address="gcomm://192.168.1.30:4567" wsrep_sst_auth=sst:sstpass123 MariaDB [(none)]> show status like 'wsrep%'; +--------------------------+----------------------+ | Variable_name | Value | +--------------------------+----------------------+ | wsrep_cluster_conf_id | 18446744073709551615 | | wsrep_cluster_size | 0 | | wsrep_cluster_state_uuid | | | wsrep_cluster_status | Disconnected | | wsrep_connected | OFF | | wsrep_local_index | 18446744073709551615 | | wsrep_provider_name | | | wsrep_provider_vendor | | | wsrep_provider_version | | | wsrep_ready | ON | +--------------------------+----------------------+ root@mariaclu01:/etc/mysql# netstat -tulpn | grep -e 4567 -e 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3387/mysqld Thank you in advance! Cheers, Daniel dudu(a)ihd.hu

2 2

[Maria-discuss] MariaDB 10.0.1-alpha now available
by Daniel Bartholomew 06 Feb '13

06 Feb '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.1. This is an alpha release. MariaDB 10.0 is the development version of MariaDB. It is built on the MariaDB 5.5 series with backported features from MySQL 5.6 and entirely new features not found anywhere else. This is the second 10.0-based release, and we are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases. See the release notes and changelog for details on what is new in this release. Do not use alpha releases on production systems. - - MariaDB 10.0 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-1001-release-notes Changelog: http://kb.askmonty.org/en/mariadb-1001-changelog Downloads: http://downloads.mariadb.org/mariadb/10.0.1 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 10.0: http://kb.askmonty.org/en/what-is-mariadb-100 - - New Packages - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.1 includes packages for Fedora 18 "Spherical Cow" and Ubuntu 12.10 "Quantal Quetzal". Visit the Repository Configurator to generate the necessary commands to easily install MariaDB on these and several other distributions. https://downloads.mariadb.org/mariadb/repositories/ - - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - Along with the news of new package builds is the news that some old distributions have been deprecated. The MariaDB project tries to support as many different operating systems and Linux distributions as possible. However, when a distribution or OS stops receiving upstream security and other updates it becomes difficult to provide packages for that platform. In such cases, our policy is to deprecate that platform and stop building binary packages for it in our build system. As of 1 Feb 2013, we stopped building and testing packages for the following: - Fedora 16 "Verne" - Debian 5 "Lenny" - Ubuntu 10.10 "Maverick" - Ubuntu 11.04 "Natty" Even after your chosen Linux distribution is deprecated, packages and support are still available. Companies such as SkySQL and Monty Program (among others) provide paid support for all versions of MariaDB and back to even very old MySQL versions. This includes packaged binaries. More information on our deprecation policy can be found at: https://kb.askmonty.org/en/mariadb-deprecation-policy/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] mariasql client question (zappajs, coffeescript, nodejs)
by klrumpf 05 Feb '13

05 Feb '13

Hi, I have switched from mysql to mariadb using it with the node-mysql client and this has been runing in prod. for some time. I now want to switch to the mariasql client... inspect = require('util').inspect mdbClient = require('mariasql') ... To do the many queries and simplify the source I wanted to write a principal function for queries that simply returns an object (or array) with the query result and then I could just re-use the existing functionality for the render. So I copied this from the examples doSql = (sqlstring) -> c = new mdbClient() c.connect host: 'localhost' db: 'xyz' # NOT database user: 'abc' password: 'defghi' c.on("connect", -> console.log "Client connected" ).on("error", (err) -> console.log "Client error: " + err ).on "close", (hadError) -> console.log "Client closed" c.query(sqlstring).on("result", (res) -> res.on("row", (row) -> console.log "Result row: " + inspect(row) ).on("error", (err) -> console.log "Result error: " + inspect(err) ).on "end", (info) -> console.log "Result finished successfully, number of rows: " + info.numRows ).on "end", -> console.log "Done with all results" c.end() .... and then @get '/': (req,res) -> # LANDING PAGE) result = doSql("select pakz from pkt where pktnr=10001") console.log "919, result = ",result .... @view.... Console log in the doSql functions shows the results correctly but I have been playing around for a while and I can't get the function to return the result for further processing to the @get routine. Seems like I have not understood the scope issues here and probably a few more things, I am still green with this. My questions - what is the correct approach to do pass the query object from the function to the calling program if this is possible at all? - how do I access the individual rows the way I do it with node-mysql like so row[1].myfield ...? - should I create the instance of the mdbClient in the function or rather once at the very beginning of the program, my principal worry being stability even if the db disconnects here and there for some reason? Thanks, hope this is the right list for this, Karl -- Karl-L. Rumpf klrumpf(a)gmail.com Málaga, Spain

2 2

[Maria-discuss] Files under /etc/my.cnf.d/ read by default
by Honza Horak 05 Feb '13

05 Feb '13

Hi guys, while we were packaging MariaDB into Fedora (finally) we used the upstream's cnf files structure, which means /etc/my.cnf, that includes all files from directory /etc/my.cnf.d/* using statement !includedir. That works fine when user installs (not updates) the MariaDB packages without having them installed before. The problem is if user has changed /etc/my.cnf before updating -- then /etc/my.cnf doesn't get updated (!includedir won't be added) and we end with files under /etc/my.cnf.d/* but nothing what includes them. That is quite confusing for users that may change something in /etc/my.cnf.d/client.cnf but nothing happens. Since files under /etc/my.cnf.d/* are empty by default it shouldn't do any harm if all files corresponding with /etc/my.cnf.d/*.cnf template get loaded even without !includedir in /etc/my.cnf. Actually I believe that is what users expect to happen when they see files under /etc/my.cnf.d.. So, that's basically what I'm proposing -- read files under /etc/my.cnf.d/* by default, without a need to use !includedir. What do you think? Regards, Honza

1 1

Re: [Maria-discuss] Reading a field's default value from a trigger
by Bruce Kirkpatrick 04 Feb '13

04 Feb '13

For anyone encountering the "Field 'xxx' doesn't have a default value" when running insert/update/replace statement on MariaDB, I found that this is actually caused by the sql mode STRICT_TRANS_TABLES. This also fixes when a trigger updates the default value of the field. I believe the default options for MariaDB windows installer cause this option to be enabled, whereas I had previous never designed my application for the various modes supported. You can also fix the issue by giving every field in the table an explicit default value of 0 or '' except for text/longtext columns. I choose not to do that since I don't know how many other things change with STRICT_TRANS_TABLES. If you change my.ini / my.cnf to sql-mode="", you won't have this error occur anymore. You can run SELECT @@GLOBAL.sql_mode; on your mysql server and mariadb server to compare what the current settings are. This is my first post to the MariaDB mailing list. Sorry if I did it wrong. I've been using MySQL for over 10 years and decided to migrate to MariaDB now. -- Bruce Kirkpatrick<http://www.skyflare.com/> 386-405-4643

2 1

[Maria-discuss] MariaDB's tracking of MySQL changes
by Christian Convey 04 Feb '13

04 Feb '13

Can someone explain the relationship between MySQL and MariaDB code updates? I've read that MariaDB is a drop-in *replacement* for MySQL. But I've also read that MariaDB treats MySQL as an upstream code base. So what's the deal? Does MariaDB have alternative implementations for just some of MySQL's components, and when a new MySQL release comes out, MariaDB updates just those components for which it doesn't have its own versions? [This is a re-post from the #maria IRC channel, where I got no answer.] Thanks, Christian

2 1

[Maria-discuss] MariaDB 5.5.29, 5.3.12, 5.2.14, 5.1.67 now available
by Daniel Bartholomew 31 Jan '13

31 Jan '13

The MariaDB project is pleased to announce the immediate availability of the following new MariaDB versions: 5.5.29, 5.3.12, 5.2.14, & 5.1.67 Appologies in advance for the length of this email but we'd rather send out just one combined announce email instead of an email for each of these releases. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.29 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5529-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5529-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.29 MariaDB 5.3.12 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5312-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5312-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.3.12 MariaDB 5.2.14 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5214-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5214-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.2.14 MariaDB 5.1.67 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5167-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5167-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.1.67 - - Other Links - - - - - - - - - - - - - - - - - - - - - - - - - - - APT and YUM Repository Configuration Generator: https://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 Overview of MariaDB 5.3: https://kb.askmonty.org/en/what-is-mariadb-53 Overview of MariaDB 5.2: https://kb.askmonty.org/en/what-is-mariadb-52 Overview of MariaDB 5.1: https://kb.askmonty.org/en/what-is-mariadb-51 - - Security Updates - - - - - - - - - - - - - - - - - - - - - - - - - These releases are "bug fix" releases and they include, among other things, fixes for the following security vulnerabilities: - A buffer overflow that can cause a server crash or arbitrary code execution (a variant of CVE-2012-5611) http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5611 - CVE-2012-5627/MDEV-3915 fast password brute-forcing using the "change user" command http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5627 https://mariadb.atlassian.net/browse/MDEV-3915 - CVE-2012-5615/MDEV-3909 information leakage about existing user accounts via the protocol handshake http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5615 https://mariadb.atlassian.net/browse/MDEV-3909 - fixes for DoS attacks - crashes and server lockups https://mariadb.atlassian.net/browse/MDEV-4029 https://mariadb.atlassian.net/browse/MDEV-729 These releases of MariaDB also include all applicable upstream security fixes from MySQL, such as fix for a CVE-2012-5612/MDEV-3908 and other crashes. http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5612 https://mariadb.atlassian.net/browse/MDEV-3908 - - New Packages - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.29 includes packages for Fedora 18 "Spherical Cow" and Ubuntu 12.10 "Quantal Quetzal". Visit the Repository Configurator to generate the necessary commands to easily install MariaDB on these and many other distributions. We've also extended the repository configuration tool to provide instructions for distributions which include MariaDB. We've started with Mageia and will be adding others soon. https://downloads.mariadb.org/mariadb/repositories/ - - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - Along with the news of new package builds is the news that some old distributions will be deprecated. The MariaDB project tries to support as many different operating systems and Linux distributions as possible. However, when a distribution or OS stops receiving upstream security and other updates it becomes difficult to provide packages for that platform. In such cases, our policy is to deprecate that platform and stop building binary packages for it in our build system. As of 1 Feb 2013, we will stop building and testing packages for the following: - Fedora 16 "Verne" - Debian 5 "Lenny" - Ubuntu 10.10 "Maverick" - Ubuntu 11.04 "Natty" Even after your chosen Linux distribution is deprecated, packages and support are still available. Companies such as SkySQL and Monty Program (among others) provide paid support for all versions of MariaDB and back to even very old MySQL versions. This includes packaged binaries. More information on our deprecation policy can be found at: https://kb.askmonty.org/en/mariadb-deprecation-policy/ - - Archived Releases - - - - - - - - - - - - - - - - - - - - - - - - From the beginning of the MariaDB project in 2009 we've kept all of our old releases online via our network of mirrors. Doing this is great for those few who are interested in old releases, but the disk space required to host all of our old releases is over 130 Gigabytes at present and grows by several gigabytes with each new release. This is too much for some of our mirrors to handle. So, starting with this round of releases our primary mirror will only host the most recent few releases in each series (5.5, 10.0, 5.3, and so on). Mirrors are, of course, free to keep archiving every release, but the primary mirror that they pull from will not. Old releases do have value, so for those that are interested in old releases, we are setting up a simple, no frills, archive server which will host them. Once the server is up and running, links to archived releases on https://downloads.mariadb.org will point at the archive server. During the transition period, links to some old releases may disappear for a short time, but don't worry, they haven't been deleted, they're just being moved! If you have hundreds of spare gigabytes on a fast connection and would also like to host the complete MariaDB archive, contact us at mirror at mariadb.org and we'll include a link your mirror from our archive server. (see https://kb.askmonty.org/en/mirroring-mariadb/ for more information about becoming a mirror) - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

Re: [Maria-discuss] noinstall package for MariaDB
by Vineet Deodhar 25 Jan '13

25 Jan '13

Thank you. I really appreciate the fast & helpful response on this mailing list. --- Vineet --- On Fri, 25/1/13, Vladislav Vaintroub <wlad(a)montyprogram.com> wrote: From: Vladislav Vaintroub <wlad(a)montyprogram.com> Subject: RE: [Maria-discuss] noinstall package for MariaDB To: "'Vineet Deodhar'" <d_vineet(a)yahoo.com> Date: Friday, 25 January, 2013, 15:10 >Thanks Vladislav. >If I get you right, I should copy & paste the directories EXCEPT the data directory. >Is that correct? This is correct, and this is what you also should normally do when updating zips, even if you are not switching MySQL variants. >I am using Windows at present, but going to switch over to Ubuntu 12.04 LTS soon. :-) >Can you pl. share the mariadb download url for linux? Everything is on https://downloads.mariadb.org/mariadb . For example https://downloads.mariadb.org/mariadb/5.5.28a/#os_group=linux_generic would be tar.gz (if you favor non-install packages, like on Windows, those are the right ones)

1 0

[Maria-discuss] noinstall package for MariaDB
by Vineet Deodhar 25 Jan '13

25 Jan '13

Hi ! At present, I am using MySQL noinstall version (which doesn't require ANY installation). Just copy & paste the folder & start. Is there any way to use MariaDB without installing? (Maybe replace MySQL folder containing the binaries with MariaDB folder? If yes, from where to get the noinstall folder for MariaDB?) Thanks, Vineet

2 2

[Maria-discuss] Compatibility problems switching Glassfish application from MySQL to MariaDB
by Guido Winkelmann 24 Jan '13

24 Jan '13

Hi, I'm having some problems switching one of our Java/Glassfish-based web applications over from MySQL to to MariaDB. Since the MariaDB project advertises the software as a fully compatible drop- in replacement for MySQL, the first thing I did was simply stop the MySQL server, uninstall it, and then install and start MariaDB (5.5.28a, from Gentoo portage). We have got several C/C++ based application that access our MySQL databases. Those took a recompile, but afterwards continued to work as if nothing had happened. I didn't have as much luck with our glassfish-based web frontend though. The first problem was that the existing MySQL connector is apparently unable to connect to MariaDB, so I deleted the existing JDBC Connection Pools and replaced them with new ones using the MariaDB Java Client instead. This worked on the surface, however now I'm getting a lot of exceptions whenever I'm accessing parts of the application that make use of BINARY type columns. According to the developer (of the web application on question), this is because either MariaDB itself or the connector are returning binary columns as type string, causing the persistance layer to attempt to convert them to a string object. Since the binary columns in question contain various unprintable characters, including zero-bytes, this fails. Can someone please help me with these problems? Guido

2 2

[Maria-discuss] 10.0.0 msi pack fails first start
by Federico Razzoli 24 Jan '13

24 Jan '13

Hi I tried to install MariaDB 10.0.0 on Windows XP, MSI package. Apparently the installation worked, but the server fails to start. I paste here the log until the first shutdown, just in case you don't know about this problem. Federico 130124 10:49:47 InnoDB: The InnoDB memory heap is disabled 130124 10:49:47 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130124 10:49:47 InnoDB: Compressed tables use zlib 1.2.3 130124 10:49:47 InnoDB: CPU does not support crc32 instructions 130124 10:49:47 InnoDB: Initializing buffer pool, size = 128.0M 130124 10:49:47 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 130124 10:49:47 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 130124 10:49:47 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 130124 10:49:48 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... 130124 10:49:48 InnoDB: Doublewrite buffer not found: creating new 130124 10:49:48 InnoDB: Doublewrite buffer created 130124 10:49:49 InnoDB: 128 rollback segment(s) are active. InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 130124 10:49:49 InnoDB: Waiting for the background threads to start 130124 10:49:49 InnoDB: 1.2.0 started; log sequence number 0 130124 10:49:49 [Note] Plugin 'FEEDBACK' is disabled. 130124 10:49:56 InnoDB: FTS optimize thread exiting. 130124 10:49:56 InnoDB: Starting shutdown... 130124 10:49:58 InnoDB: Shutdown completed; log sequence number 1602824 130124 10:50:00 InnoDB: The InnoDB memory heap is disabled 130124 10:50:00 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130124 10:50:00 InnoDB: Compressed tables use zlib 1.2.3 130124 10:50:00 InnoDB: CPU does not support crc32 instructions 130124 10:50:01 InnoDB: Initializing buffer pool, size = 31.0M 130124 10:50:01 InnoDB: Completed initialization of buffer pool 130124 10:50:01 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 31 MB InnoDB: Database physically writes the file full: wait... 130124 10:50:02 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 31 MB InnoDB: Database physically writes the file full: wait... 130124 10:50:03 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130124 10:50:03 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 130124 10:50:03 InnoDB: 128 rollback segment(s) are active. 130124 10:50:03 InnoDB: Waiting for the background threads to start 130124 10:50:03 InnoDB: 1.2.0 started; log sequence number 1603084 130124 10:50:03 [Note] Plugin 'FEEDBACK' is disabled. 130124 10:50:03 [Note] Event Scheduler: Loaded 0 events 130124 10:50:03 [Note] C:\Programmi\MariaDB 10.0\bin\mysqld.exe: ready for connections. Version: '10.0.0-MariaDB' socket: '' port: 3306 Source distribution 130124 11:03:13 InnoDB: The InnoDB memory heap is disabled 130124 11:03:13 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130124 11:03:13 InnoDB: Compressed tables use zlib 1.2.3 130124 11:03:13 InnoDB: CPU does not support crc32 instructions 130124 11:03:13 InnoDB: Initializing buffer pool, size = 128.0M 130124 11:03:13 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file .\ib_logfile0 is of different size 32505856 bytes InnoDB: than specified in the .cnf file 5242880 bytes! 130124 11:03:14 [ERROR] Plugin 'InnoDB' init function returned error. 130124 11:03:14 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 130124 11:03:15 [Note] Plugin 'FEEDBACK' is disabled. 130124 11:03:16 [ERROR] Unknown/unsupported storage engine: InnoDB 130124 11:03:16 [ERROR] Aborting 130124 11:03:17 [Note] C:/Programmi/MariaDB 10.0/bin/mysqldd: Shutdown complete

1 1

[Maria-discuss] Trouble installing MariaDB 5.5 on Ubuntu 12.04 (& 12.10)
by Aaron Anderson 23 Jan '13

23 Jan '13

Gang, I've installed MariaDB on several Debian/Ubuntu systems in the past few months, without any issues. ~2 days ago on an Unbuntu 12.10 system did an apt-get update/upgrade/dist-upgrade. I believe that MariaDB was updated in that process. After the updates, mysql was "gone" My apps couldn't find it, it wasn't running, etc. I was in a hurry so I had to fall back to the standard mysql package so not a lot of into there. I built a new Ubuntu 12.04 LTS server, added the Maria repo, did an apt-get update/ugprade/dist-upgrade. Rebooted. Here's some output... I'm stuck in this loop. root@nn01:~# apt-get install mariadb-server Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mariadb-server : Depends: mariadb-server-5.5 but it is not going to be installed E: Unable to correct problems, you have held broken packages. root@nn01:~# apt-get install mariadb-server-5.5 Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mariadb-server-5.5 : Depends: mariadb-client-5.5 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed Depends: mariadb-server-core-5.5 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed E: Unable to correct problems, you have held broken packages. root@nn01:~# apt-get install mariadb-client-5.5 Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mariadb-client-5.5 : Depends: libdbd-mysql-perl (>= 1.2202) but it is not going to be installed Depends: mariadb-common but it is not going to be installed Depends: libmariadbclient18 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed Depends: mariadb-client-core-5.5 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed E: Unable to correct problems, you have held broken packages. root@nn01:~#

2 2

[Maria-discuss] KB Question: Issues with ignore-db-dir
by Daniel Bartholomew 23 Jan '13

23 Jan '13

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/issues-with-ignore-db-dir/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Issues with ignore-db-dir Hello, I see that the ignore-db-dir option has been available since Maria 5.3.9 ( https://kb.askmonty.org/en/mariadb-539-changelog/ ) , however I am finding that MariaDB 5.5.27 is not recognizing the option. When I put "ignore-db-dir=lost+found" in the mysqld section of the my.cnf file or when I attempt to start mysqld with "/etc/init.d/mysql start --ignore-db-dir=lost+found", both times mysql fails to start with the following message: 130111 17:08:57 [ERROR] /usr/sbin/mysqld: unknown variable 'ignore-db-dir=lost+found' 130111 17:08:57 [ERROR] Aborting Is there a patch that I was supposed to apply but haven't ? Or maybe I am misunderstanding how or where to specify the ignore-db-dir option. For reference, the full version as reported by mysqld is: $ mysqld --version mysqld Ver 5.5.27-MariaDB for Linux on x86_64 (MariaDB Server) Thanks, -Said - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Fwd: [debian-mysql] Bug#688505: MariaDB packaging.
by Colin Charles 19 Jan '13

19 Jan '13

A good wishlist. I think more should vote for this, quite clearly! cheers, -colin Begin forwarded message: > Resent-From: Robert de Bath <robert$(a)debath.co.uk> > From: Robert de Bath <robert$(a)debath.co.uk> > Subject: [debian-mysql] Bug#688505: MariaDB packaging. > Date: 23 September 2012 16:25:39 GMT+08:00 > Resent-To: debian-bugs-dist(a)lists.debian.org > To: submit(a)bugs.debian.org > Resent-Cc: Debian MySQL Maintainers <pkg-mysql-maint(a)lists.alioth.debian.org> > Reply-To: Robert de Bath <robert$(a)debath.co.uk>, 688505(a)bugs.debian.org > > Package: mysql-server > Version: 5.5.24+dfsg-8 > Severity: wishlist > > My very technically savvy webhost has recently switched from MySQL to > MariaDB and claim it's for both technical and political reasons. > > Both of these reasons (better performance and better licensing) appear > to be good reasons for the software to be packaged as a Debian package > and I expect it's getting to the point that someone will do it themselves. > > BUT the software is technically still not a forked variant of MySQL > but a patched version where the maintainers continually resync to the > Oracle releases. For this reason I would like to see it treated as just > a simple MySQL version within Debian. This way the users (ie: me) can > simply switch by prodding apt in the right way. > > For this to work seamlessly (unlike, for example, the recent multimedia > troubles) the MariaDB package should be packaged identically to MySQL, > which IMO is best done by the same Debian maintainers. > > So my request is that you package the MariaDB as a secondary version of > MySQL in such a way that the two packages can be seamlessly switched within the Debian system. > > -- > Rob. (Robert de Bath <robert$ @ debath.co.uk>) > <http://www.debath.co.uk/> > > _______________________________________________ > pkg-mysql-maint mailing list > pkg-mysql-maint(a)lists.alioth.debian.org > http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

3 3

[Maria-discuss] MariaDB Java Client 1.1.0 Released
by Daniel Bartholomew 16 Jan '13

16 Jan '13

The MariaDB Java Client 1.1.0 has been released. You can download it here: https://downloads.mariadb.org/client-java/1.1.0/ This version focused on fixing all known database metadata bugs and ConnnectorJ incompatibilities. Specific fixes include: - Consistent, compatible with ConnectorJ handling of JDBC catalogs vs schemas vs databases - Implementation of several missing methods in DatabaseMetaData - Better handling of statement timeouts - OSGi-specific entries have been added to MANIFEST.MF so it can be used in OSGi environments - Added support for dumpQueriesOnException=true in the JDBC URL - Added support for IPv6 addresses in the connector - Added SSL support - and more... See the Release Notes and Changelog for more information: - https://kb.askmonty.org/en/mariadb-java-client-110-release-notes - https://kb.askmonty.org/en/mariadb-java-client-110-changelog See also the "About the MariaDB Java Client" page: - https://kb.askmonty.org/en/about-the-mariadb-java-client -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] MariaDB installation failed in fedora17, No more mirrors to try!!!
by Haseena L. 14 Jan '13

14 Jan '13

Hi all, Iam trying to install mariadb in fedora17 using the following link : https://kb.askmonty.org/en/installing-mariadb-with-yum/#manually-importi ng-the-mariadb-signing-key It shows an error, there is no mirror for downloading mariadb. Please see the error log : $ sudo yum install MariaDB-server MariaDB-client Loaded plugins: langpacks, presto, refresh-packagekit fedora/metalink | 8.3 kB 00:00 fedora | 4.2 kB 00:00 fedora/primary_db | 12 MB 00:02 fedora/group_gz | 434 kB 00:00 mariadb | 1.9 kB 00:00 mariadb/primary_db | 15 kB 00:00 updates/metalink | 3.7 kB 00:00 updates | 4.7 kB 00:00 updates/primary_db | 5.9 MB 00:44 updates/group_gz | 439 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package MariaDB-client.i686 0:5.5.28a-1 will be installed --> Processing Dependency: MariaDB-common for package: MariaDB-client-5.5.28a-1.i686 ---> Package MariaDB-server.i686 0:5.5.28a-1 will be obsoleting ---> Package mysql.i686 0:5.5.23-1.fc17 will be obsoleted ---> Package mysql-server.i686 0:5.5.23-1.fc17 will be obsoleted --> Running transaction check ---> Package MariaDB-common.i686 0:5.5.28a-1 will be installed --> Finished Dependency Resolution Dependencies Resolved ======================================================================== ======== Package Arch Version Repository Size ======================================================================== ======== Installing: MariaDB-client i686 5.5.28a-1 mariadb 8.4 M MariaDB-server i686 5.5.28a-1 mariadb 32 M replacing mysql.i686 5.5.23-1.fc17 replacing mysql-server.i686 5.5.23-1.fc17 Installing for dependencies: MariaDB-common i686 5.5.28a-1 mariadb 23 k Transaction Summary ======================================================================== ======== Install 2 Packages (+1 Dependent package) Total size: 41 M Total download size: 41 M Is this ok [y/N]: y Downloading Packages: http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-client.rpm: [Errno 12] Timeout on http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-client.rpm: (28, '') Trying other mirror. http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-server.rpm: [Errno 12] Timeout on http://yum.mariadb.org/5.5/fedora17-x86/rpms/MariaDB-5.5.28a-fedora17-i6 86-server.rpm: (28, '') Trying other mirror. Error Downloading Packages: MariaDB-server-5.5.28a-1.i686: failure: rpms/MariaDB-5.5.28a-fedora17-i686-server.rpm from mariadb: [Errno 256] No more mirrors to try. MariaDB-client-5.5.28a-1.i686: failure: rpms/MariaDB-5.5.28a-fedora17-i686-client.rpm from mariadb: [Errno 256] No more mirrors to try. Please help me... Give me the appropriate mirror for downloading mariadb Regards, Haseena ***** Confidentiality Statement/Disclaimer ***** This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

1 0

[Maria-discuss] Reporting upstream bugs
by Federico Razzoli 10 Jan '13

10 Jan '13

Hi all. I reported a bug in JIRA - I hit it in MariaDB but it was tagged as "upstream". This brings us to the question: is it ok to report upstream bugs in MariaDB's JIRA? There are 2 reasons why I didn't report it to Oracle. Let me explain. 1) MySQL Ab and Sun never had a lot of data about me or the companies where I worked. They only had my email and my full name, plus some optional info, if I remember correctly. But my old account doesn't work anymore, and the new Oracle's sign up page REQUIRES a lot of data - including a physical address and a work phone. I don't want to provide them too much info about me and my company. 2) I tried to sign up with fake data, but after 2 days I didn't receive a confirm email and my account still doesn't work. They are very slow, or something doesn't work fine in their website, or they detected that some data I wrote is fake (but I got no error message). I think that a company which develops open source software should be glad that people reports bugs, and should make the process easier. If the process is hard, I would prefer to report bugs to MariaDB. But, what does MariaDB think about it? Is it ok to report the bugs to you? Federico Razzoli

3 3

[Maria-discuss] ASFORMENTIONED keyword suggestion
by Eric Wood 26 Dec '12

26 Dec '12

Routinely updating records with 20 or more columns can be exhausting work. Many have asked for this for many years and I was hoping a MariaDB developer would take the reins in implementing a shorter ON DUPLICATE KEY UPDATE syntax: INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY UPDATE `a`=VALUES(`a`), `b`=VALUES(`b`), `c`=VALUES(`c`); INSERT INTO `tableName` SET a=1, b=2, c=3 ON DUPLICATE KEY UPDATE a=1, b=2, c=3; INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY UPDATE ASFORMENTIONED; INSERT INTO `tableName` SET a=1, b=2, c=3 ON DUPLICATE KEY UPDATE ASFORMENTIONED; Something like this would certainly make SQL enjoyable again. -Eric Wood

1 0

[Maria-discuss] DrizzleJDBC 1,2
by Marcus Eriksson 06 Dec '12

06 Dec '12

Hi I just released DrizzleJDBC 1.2 DrizzleJDBC is a BSD licensed JDBC driver for MySQL/MariaDB/Drizzle It is in maven central: <dependency> <groupId>org.drizzle.jdbc</groupId> <artifactId>drizzle-jdbc</artifactId> <version>1.2</version> </dependency> Changelog; - IPv6 support, enclose the IP in brackets, [::1] ( https://github.com/krummas/DrizzleJDBC/issues/10) - Correct behavior if getInt on larger than MAXINT values ( https://github.com/krummas/DrizzleJDBC/issues/9) - Fix ssl support, was not possible to close connection ( https://github.com/krummas/DrizzleJDBC/issues/8) - Support InputStream in LOAD DATA INFILE ( https://github.com/krummas/DrizzleJDBC/issues/7) - support getting columns using <table>.<column> ( https://github.com/krummas/DrizzleJDBC/issues/6) - use single quotes (https://github.com/krummas/DrizzleJDBC/pull/5) - clean up unicode support (https://github.com/krummas/DrizzleJDBC/pull/4) - Fix NPE bug when timestamp is null, patch by Tim Rickettsl on launchpad - set FOUND ROWS by default (https://github.com/krummas/DrizzleJDBC/issues/2 ) Report bugs/feature requests etc on github; https://github.com/krummas/DrizzleJDBC /Marcus

3 3

[Maria-discuss] partitioning by timestamp field
by Said Ramirez 30 Nov '12

30 Nov '12

Hello, I am trying to setup a range partitioned table using 5.5.27-MariaDB-log MariaDB Server using a timestamp field. According to the documents, I should be able to use unix_timestamp(ts) as my partitioning function ( http://dev.mysql.com/doc/refman/5.5/en/partitioning-range.html ) . I find, however, that it is not possible to use unix_timestamp using mariadb because with mariadb the unix_timestamp function returns an floating point value: mariadb> select unix_timestamp('2012-12-01'); +------------------------------+ | unix_timestamp('2012-12-01') | +------------------------------+ | 1354320000.000000 | +------------------------------+ 1 row in set (0.00 sec) However the MySQL version of unix_timestamp returns an int value: myqsl> select unix_timestamp('2012-12-01'); +------------------------------+ | unix_timestamp('2012-12-01') | +------------------------------+ | 1354320000 | +------------------------------+ 1 row in set (0.06 sec) How have people worked around this issue? What other ways can I partition by a timestamp in MariaDB ? Thanks, -Said

2 1

Re: [Maria-discuss] Contact Form: Ruslan Kutliakhmetov
by Sergei Golubchik 17 Nov '12

17 Nov '12

Hi, Ruslan! First, please use email for questions of this kind. We have a mailing list maria-discuss(a)lists.launchpad.net - it's much easier to follow the discussion there, and many more people will see your question, so you'll have a better chance of getting a fast and helpful reply. On Nov 17, Ruslan Kutliakhmetov wrote: > ------------------------------------------------ > Hi. I installed on the linux debian MarinaDB 10 for linux debian. > I watched that she doesn't installed. Log: > root @ debian :/ home / tran # apt-get install mariadb-server-5.2 mariadb-client-5.2 > Reading package lists ... Done > Building dependency tree > Reading state information ... Done > Some packages could not be installed. Perhaps you are asking the impossible, > or using the unstable distribution that some required > packages have not yet been created or been moved out of Incoming. > The following information may help you: > > The following packages have unmet dependencies: > mariadb-client-5.2: Depends: mariadb-client-core-5.2 (> = 5.2.12-mariadb115 ~ squeeze) but it is not installed > E: Broken packages > ------------------------------------------------ I don't understand what you are trying to do. Are you installing MariaDB 10.0.0 release? If yes, why do you specify "5.2" in the apt-get command line? If you want to install MariaDB 5.2.12 - why do you mention 10.0? May be, you are trying to upgrade or downgrade? Regards, Sergei

1 0

[Maria-discuss] KB Question: Drop-in replacement on Debian
by Daniel Bartholomew 17 Nov '12

17 Nov '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/drop-in-replacement-on-debian/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Is there a way to make MariaDB install over MySQL on a Debian machine? I have my puppet master, which is running Debian/sid. It has puppet-dashboard, which utilizes MySQL 5.5.28. Much to my dismay, I am unable to install MariaDB over it: - - - - - The following packages have unmet dependencies: libmariadbclient18 : Depends: libmysqlclient18 (= 5.5.28-mariadb1~wheezy) but 5.5.28+dfsg-1 is to be installed E: Unable to correct problems, you have held broken packages. - - - - - But if I try to uninstall the parts of MySQL, then apt wishes to uninstall everything, up to and including puppet-dashboard: - - - - - The following packages were automatically installed and are no longer required: dbconfig-common libaio1 libhttpclient-ruby1.8 mysql-server-core-5.5 rake ruby-dbi ruby-deprecated unzip zip Use 'apt-get autoremove' to remove them. The following packages will be REMOVED: libdbd-mysql-perl libdbd-mysql-ruby libmysqlclient18 mysql-client mysql-client-5.5 mysql-server mysql-server-5.5 puppet-dashboard ruby-dbd-mysql ruby-mysql - - - - - This is unacceptable for a live box... Is there something else I can do to make the install less painful? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

3 2

[Maria-discuss] mDB logs off when there are several ssh under same user
by klrumpf 15 Nov '12

15 Nov '12

4 6

[Maria-discuss] KB Question: Aria Max Table Size
by Daniel Bartholomew 14 Nov '12

14 Nov '12

The following question has been posted in the Knowledgebase: https://kb.askmonty.org/en/aria-max-table-size/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Aria looks to be a safer robust replacement to MyISAM for data warehousing. However, I was unable to find any mention of maximum table sizes for tables in various row formats. Upon creating tables and getting information in SequelPro, I saw the following: Aria Dynamic: 4GB Aria Fixed: 20GB Aria Page: 64GB This would seem counterproductive as MyISAM supports 256TB. Is there an official statistic on the maximum amount of data that Aria can handle? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] MariaDB 10.0.0 Alpha now available
by Daniel Bartholomew 12 Nov '12

12 Nov '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.0. This is an alpha release. MariaDB 10.0 is the development version of MariaDB. It is built on the MariaDB 5.5 series with backported features from MySQL 5.6 and entirely new features not found anywhere else. This is the first 10.0-based release, and we are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases. Do not use alpha releases on production systems. - - MariaDB 10.0 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-1000-release-notes Changelog: http://kb.askmonty.org/en/mariadb-1000-changelog Downloads: http://downloads.mariadb.org/mariadb/10.0.0 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 10.0: http://kb.askmonty.org/en/what-is-mariadb-100 - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - We've created a CafePress store which offers an exclusive t-shirt or other item in return for a donation to the MariaDB project: - http://www.cafepress.com/mariadb Please check it out and let us know what you think! All proceeds go directly to support MariaDB development, so don't think of it as purchasing a t-shirt, think of it as donating to support a worthy project and awesome product... and you get a t-shirt as a nice bonus! If you would like to contribute to MariaDB in other ways, please see our "contributing" and "donations" pages in the Knowledgebase: - https://kb.askmonty.org/en/contributing - https://kb.askmonty.org/en/donations We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] TRUNCATE TABLE becomes hang sometimes
by Haseena L. 10 Nov '12

10 Nov '12

Hi, Now Iam trying to migrate from MySQL to MariaDB. Why does the TRUNCATE TABLE statement hang sometimes? What are the reasons for this type of issue? This problem doesn't happen with MySQL, only with MariaDB. The hanging statement is simply: TRUNCATE TABLE sampledb.datatable; What can cause this to happen, and how could I fix it? Another one observation is if the table have some data, may be one or two rows, then the truncate query works successfully. Else the table have a lot of data, query becomes hang. If the same table have more than one connetion, then the truncate table query hangs. How I fix it??? Now Iam blocking. Engine I selected is MyISAM. Thanks and Regards, Haseena ***** Confidentiality Statement/Disclaimer ***** This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

2 1

[Maria-discuss] TRUNCATE TABLE becomes hang sometimes
by Haseena L. 06 Nov '12

06 Nov '12

Hi, Now Iam trying to migrate from MySQL to MariaDB. Why does the TRUNCATE TABLE statement hang sometimes? What are the reasons for this type of issue? This problem doesn't happen with MySQL, only with MariaDB. The hanging statement is simply: TRUNCATE TABLE sampledb.datatable; What can cause this to happen, and how could I fix it? Another one observation is if the table have some data, may be one or two rows, then the truncate query works successfully. Else the table have a lot of data, query becomes hang. If the same table have more than one connetion, then the truncate table query hangs. How I fix it??? Now Iam blocking. Engine I selected is MyISAM. Thanks and Regards, Haseena ***** Confidentiality Statement/Disclaimer ***** This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

1 0

[Maria-discuss] MariaDB 5.5.28 now available
by Daniel Bartholomew 22 Oct '12

22 Oct '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.28. This is a stable (GA) release. - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5528-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5528-changelog Downloads: http://downloads.mariadb.org/mariadb/5.5.28 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - We've created a CafePress store which offers an exclusive t-shirt or other item in return for a donation to the MariaDB project: - http://www.cafepress.com/mariadb Please check it out and let us know what you think! All proceeds go directly to support MariaDB development, so don't think of it as purchasing a t-shirt, think of it as donating to support a worthy project and awesome product... and you get a t-shirt as a nice bonus! If you would like to contribute to MariaDB in other ways, please see our "contributing" and "donations" pages in the Knowledgebase: - https://kb.askmonty.org/en/contributing - https://kb.askmonty.org/en/donations We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] can I expect deb files of mariadb-galera soon?
by Jan Kirchhoff 12 Oct '12

12 Oct '12

Hi, We are currently using mariadb a lot over here with traditional replication and I'd like to test the galera alpha in the next weeks. I have two brand-new machines with plenty of SAS disks, some SSDs and 128GB of RAM over here with Ubuntu 12.10 alpha ready to do some testing with our real-world workloads. Before I start compiling myself or mess with binary tar.gz-releases: can I expect deb-releases within the next 2 weeks? That would make life much easier for me and I'd delay starting all the testing by a few days if I knew I would then have debs to start right away. regards Jan

2 3

[Maria-discuss] mariadb : possible copyright issues?
by Vineet Deodhar 03 Oct '12

03 Oct '12

I am using MySQL at present. I came across MariaDB, a drop-in replacement for MySQL. 2 simple questions-- 1) File names in MariaDB, in many cases, are same as those in MySQL. Wouldn't that attract objection from Oracle as 'breach of the copyright' ? 2) May I use MariaDB for commercial distribution (with or without using its source) ? Whether the license is similar to MIT license? Thanks, Vineet

3 2

[Maria-discuss] KB Question:Slow Performance for some queries
by Daniel Bartholomew 03 Oct '12

03 Oct '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/slow-performance-for-some-queries/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Slow Performance for some queries Hi there, I have discovered some very low performing queries on our MariaDB version 5.3.7. The query shows up with "string results in query cache" The query: explain select distinct `config`.`agent_id` AS `agent_id`, `config`.`agent_name` AS `agent_name`, `agent`.`agent_version` AS `agent_version`, `config`.`agent_os` AS `agent_os`, `agent`.`agent_os_version` AS `agent_os_version`, `config`.`pconfig_line` AS `pconfig_line`, `config`.`appclass` AS `appclass`, `config`.`instance` AS `instance`, `config`.`parameter` AS `parameter`, `config`.`value` AS `value`, substring_index(substring_index(`config`.`variable`, '/', '4ö'), '/', -(1)) AS `NT_Drive`, `config`.`agent_config_date` AS `agent_config_date`, `config`.`rule_type_name` AS `rule_type_name` from (`agent_config_detail_view` `config` left join `agent` ON ((`agent`.`agent_id` = `config`.`agent_id`))) where (((`config`.`rule_type_id` = 'ccbe914e30c6ec6e3aa5c4780a3525d6') or (`config`.`rule_type_id` = '0091efee7f9b5f0e27211eb7226d0a23') or (`config`.`rule_type_id` = '6311ae17c1ee52b36e68aaf4ad066387')) and ((`config`.`variable` = '/AgentSetup/FILESYSTEM.filterList') or (`config`.`variable` = '/AgentSetup/FILESYSTEM.filterType') or (`config`.`variable` like '/AS/EVENTSPRING/PARAM_SETTINGS/THRESHOLDS/FILESYSTEM%') or (`config`.`variable` like '/RecoveryActions/NT_LOGICAL_DISKS/%/LDldFreeSpacePercent/Mode')) and (`config`.`agent_config_date` > ((select max(`s`.`agent_config_date`) from `agent_config` `s`) - interval 24 hour))) order by `config`.`agent_name` , `config`.`appclass` Here is the explain for the query in question: id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a ALL PRIMARY NULL NULL NULL 7083 "Using temporary; Using filesort" 1 PRIMARY agent eq_ref PRIMARY PRIMARY 34 new_budm.a.agent_id 1 1 PRIMARY b ref PRIMARY,fk_agent_config_agent1,IX_agent_config_date fk_agent_config_agent1 34 new_budm.a.agent_id 3 "Using where" 1 PRIMARY c ref agent_config_rule_fk_agent_config_id,agent_config_rule_fk_rule_id agent_config_rule_fk_agent_config_id 34 new_budm.b.agent_config_id 947 1 PRIMARY d eq_ref PRIMARY,IX_rule_variable PRIMARY 34 new_budm.c.fk_rule_id 1 "Using where" 1 PRIMARY e ref fk_rule_rule_type_rule_type1,fk_rule_rule_type_rule fk_rule_rule_type_rule 34 new_budm.c.fk_rule_id 1 "Using where" 1 PRIMARY f eq_ref PRIMARY PRIMARY 34 new_budm.e.fk_rule_type_id 1 2 SUBQUERY NULL NULL NULL NULL NULL NULL NULL "Select tables optimized away" The query cache (innodb_buffer_pool_size) is set to 8192M. Other queries are running fine (perfomance can always be better). Thank you and regards, Patrick - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Json Explain
by Peter Laursen 30 Sep '12

30 Sep '12

Is Explain output in Json format planned in MariaDB (refer http://glebshchepa.blogspot.in/2012/04/optimizer-new-explain-formatjson.html) ? If so when? and will the implementation details and output format be fully identical to Oracle/MySQL 5.6? (I did not find it mentioned here: http://monty-says.blogspot.dk/2012/09/now-is-good-time-to-be-part-of-future… http://blog.mariadb.org/mariadb-directions/ .. sorry if I overlooked it somewhere) -- Peter -- Webyog

4 8

[Maria-discuss] MariaDB 5.5.27 now available
by Daniel Bartholomew 10 Sep '12

10 Sep '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.27. This is a stable (GA) release. - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5527-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5527-changelog Downloads: http://downloads.mariadb.org/mariadb/5.5.27 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: http://mariadb.org/jira We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.25 Alpha now available
by Daniel Bartholomew 06 Sep '12

06 Sep '12

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.25 Alpha. This is an Alpha release. What is it? * A straight merge of MariaDB 5.5.25 with Galera Cluster by Codership * An alpha release which should not be used in production environments * Using the Galera replication methodology, users get: * Synchronous, multi-master replication with guaranteed data consistency. * This solution provides both read & write scalability The links below have more information. Compatibility? MariaDB Galera Cluster is fully data-compatible with MariaDB or MySQL, as it will work with the standard databases created by these products. There are next to none or very minimal application changes that are required to make the solution work. Where can I get it? See the links below. What's next? The plan is for a rapid release cycle to heavily test the performance and usage of MariaDB Galera Cluster in different environments. Please file bugs at: https://mariadb.atlassian.net Quotes: Seppo Jaakola, CEO for Codership "It's great that we are working closely with an upstream provider of a MySQL-compatible binary, MariaDB. We no longer have to spend time coding against out-of-tree changes as we're part of MariaDB. The excellent MariaDB engineering team constantly releases new versions of MariaDB with high quality assurance (QA). Codership will continue to collaborate closely with the MariaDB engineering team to improve the product and make new versions of the MariaDB Galera Cluster available." Michael "Monty" Widenius, CEO for Monty Program Ab "We've received a significant amount of requests for a MariaDB based Galera cluster and today we're proud to deliver that. We're currently preparing ourselves and our partners for a rollout of the GA product and related professional services via SkySQL to run critical systems on top of MariaDB Galera Cluster." The MariaDB Team will together with Codership work on customer requests and demands in the areas of cluster and replication. Please contact us if you are interested in any services we can offer around Galera, MariaDB or MySQL. http://montyprogram.com/contact - - MariaDB Galera Cluster 5.5.25 Links - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-galera-5525-release-notes Changelog: http://kb.askmonty.org/en/mariadb-galera-5525-changelog Downloads: http://downloads.mariadb.org/mariadb-galera/5.5.25 YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb-galera/repositories (APT repositories are not available at this time.) Overview of MariaDB Galera Cluster 5.5: http://kb.askmonty.org/en/what-is-mariadb-galera-cluster More information: http://kb.askmonty.org/en/galera - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - http://mariadb.org We're also on: Facebook: http://fb.com/MariaDB.dbms Twitter: http://twitter.com/mariadb Google+: http://google.com/+mariadb Follow, friend, and add us to your circles to keep up to date with MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL

1 0

[Maria-discuss] KB entry on SQLyog and MONyog
by Peter Laursen 31 Aug '12

31 Aug '12

Hi! We would like to update the AskMonty Knowledgebase entry on MONyog and SQLyog appearing here: http://kb.askmonty.org/en/monyog-sqlyog/ It will not be an advertisement but a listing of 15-20 main features of each of the programs. We would have the same 'level of details' for both programs as HeidiSQL has currently. Maybe also it would be better to independent entries for each program? The question is: can we just go ahead and do ourselves or should we share content for discussion/approval here first? Regards Peter Laursen Webyog

3 2

[Maria-discuss] KB Question: Future of MariaDB?
by Daniel Bartholomew 28 Aug '12

28 Aug '12

The following question has been posted to the Knowledgebase: http://kb.askmonty.org/en/future-of-mariadb/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Future of MariaDB? Where I work, we depend heavily on MySQL. We were recently made aware that Oracle may be slowly closing the source of MySQL; though we are a Sun customer, we depend heavily (and prefer) open source. I mentioned this to my boss and his response was to ask of the future of MariaDB -- because if this project doesn't survive, we're stuck with having to find yet another DB -- in that case, we might have to drink the Oracle koolaid if it comes to that, or move to PostgreSQL (something I've never touched). Commentary on these topics would be interesting to hear. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

2 1

[Maria-discuss] help tables are obsolete
by Federico Razzoli 18 Aug '12

18 Aug '12

Hello I suppose that you are not going to document MariaDB's features in the help tables. Thought, I think you don't know that the MariaDB 5.5.25 help tables still have MySQL 5.1 contents. This means that: * MySQL 5.5 features (like SIGNAL) are not documented * Existing contents point to MySQL 5.1 documentation. I hope that this feedback is useful. Best greetings, Federico Razzoli

2 1

[Maria-discuss] Debian Wheezy repo for MariaDB?
by Terry 15 Aug '12

15 Aug '12

Hi, Now that Debian Wheezy has gone into a freeze, are there any plans to package MariaDB for Wheezy in the near future? Thanks. -- Terry

2 1

[Maria-discuss] "libmysqlclient.so.18 no version information" issue
by Terry 07 Aug '12

07 Aug '12

Hello, I am a relative newbie learning about Linux/MariaDB. I have a test server running Debian Squeeze 6.0.4 with MariaDB 5.5 installed from the MariaDB Squeeze repository. Everything worked great. I upgraded Squeeze to Wheezy (do have a back up so no issue reverting if necessary). Upgrade went rather smoothly. MariaDB running fine. Everything else working fine. On the first night after the upgrade, cron ran and I received several errors: /usr/lib/libmysqlclient.so.18: no version information available (required by exim4) /usr/lib/libmysqlclient.so.18: no version information available (required by /usr/lib/libmu_auth.so.4) The errors don't seem to cause any problems. I still get the e-mails sent by cron. Exim4 is running fine and I have no problems sending or receiving mail. MariaDB is doing fine and my test websites are performing as expected. Can someone give me a hint about where to start looking for the solutio to this? I've googled this and really couldn't find much info about it. Is this because the MariaDB deb package from the repo was built against Squeeze? If so, would the error be corrected if I downloaded the source and built it against Wheezy? Thanks. -- Terry

2 2

[Maria-discuss] MariaDB 5.5 compile error
by Brian Evans 07 Aug '12

07 Aug '12

Hi, I would like some assistance in figuring out a compile error in MariaDB 5.5 series (tested on 5.5.25). I'm trying to create a minimal (client only) build of 5.5.25. This is the cmake configure command used: cmake --no-warn-unused-cli -C /var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_common_config.cmake -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_INSTALL_PREFIX=/usr -DMYSQL_DATADIR=/var/lib/mysql -DSYSCONFDIR=/etc/mysql -DINSTALL_BINDIR=bin -DINSTALL_DOCDIR=share/doc/mariadb-5.5.25 -DINSTALL_DOCREADMEDIR=share/doc/mariadb-5.5.25 -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_INFODIR=share/info -DINSTALL_LIBDIR=lib64/mysql -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLDATADIR=/var/lib/mysql -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql/mysql-test -DINSTALL_PLUGINDIR=lib64/mysql/plugin -DINSTALL_SBINDIR=sbin -DINSTALL_SCRIPTDIR=share/mysql/scripts -DINSTALL_SQLBENCHDIR=share/mysql -DINSTALL_SUPPORTFILESDIR=/usr/share/mysql -DWITH_COMMENT=Gentoo Linux mariadb-5.5.25 -DWITHOUT_UNIT_TESTS=1 -DNOT_FOR_DISTRIBUTION=1 -DDEFAULT_CHARSET=latin1 -DDEFAULT_COLLATION=latin1_swedish_ci -DWITHOUT_SERVER=1 -DWITHOUT_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DINSTALL_SQLBENCHDIR= -DWITH_SSL=system -DWITH_ZLIB=system -DWITHOUT_LIBWRAP=1 -DWITHOUT_READLINE=1 -DWITHOUT_ARCHIVE_STORAGE_ENGINE=1 -DWITHOUT_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_CSV_STORAGE_ENGINE=1 -DWITHOUT_FEDERATED_STORAGE_ENGINE=1 -DWITHOUT_HEAP_STORAGE_ENGINE=1 -DWITHOUT_INNOBASE_STORAGE_ENGINE=1 -DWITHOUT_MYISAMMRG_STORAGE_ENGINE=1 -DWITHOUT_MYISAM_STORAGE_ENGINE=1 -DWITHOUT_PARTITION_STORAGE_ENGINE=1 -DWITHOUT_INNOBASE_STORAGE_ENGINE=1 -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCMAKE_INSTALL_DO_STRIP=OFF -DCMAKE_USER_MAKE_RULES_OVERRIDE=/var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_rules.cmake /var/tmp/portage/dev-db/mariadb-5.5.25/work/mysql gives the following error during build /var/tmp/portage/dev-db/mariadb-5.5.25/work/mysql/mysys/waiting_threads.c:196:21: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘key_WT_RESOURCE_cond’ make[2]: *** [mysys/CMakeFiles/mysys.dir/waiting_threads.c.o] Error 1 However, if i build the full server, I get no error. cmake configure with no error: cmake --no-warn-unused-cli -C /var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_common_config.cmake -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_INSTALL_PREFIX=/usr -DMYSQL_DATADIR=/var/lib/mysql -DSYSCONFDIR=/etc/mysql -DINSTALL_BINDIR=bin -DINSTALL_DOCDIR=share/doc/mariadb-5.5.25 -DINSTALL_DOCREADMEDIR=share/doc/mariadb-5.5.25 -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_INFODIR=share/info -DINSTALL_LIBDIR=lib64/mysql -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLDATADIR=/var/lib/mysql -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql/mysql-test -DINSTALL_PLUGINDIR=lib64/mysql/plugin -DINSTALL_SBINDIR=sbin -DINSTALL_SCRIPTDIR=share/mysql/scripts -DINSTALL_SQLBENCHDIR=share/mysql -DINSTALL_SUPPORTFILESDIR=/usr/share/mysql -DWITH_COMMENT=Gentoo Linux mariadb-5.5.25 -DWITHOUT_UNIT_TESTS=1 -DNOT_FOR_DISTRIBUTION=1 -DDEFAULT_CHARSET=latin1 -DDEFAULT_COLLATION=latin1_swedish_ci -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DMYSQL_USER=mysql -DMYSQL_UNIX_ADDR=/var/run/mysqld/mysqld.sock -DWITHOUT_READLINE=1 -DWITH_ZLIB=system -DWITHOUT_LIBWRAP=1 -DDISABLE_SHARED=OFF -DWITH_debug=OFF -DWITH_DEBUG=OFF -DWITH_Debug=OFF -DWITH_EMBEDDED_SERVER=OFF -DWITH_profiling=ON -DWITH_PROFILING=ON -DWITH_Profiling=ON -DENABLE_DTRACE=OFF -DWITH_SSL=system -DCMAKE_EXE_LINKER_FLAGS=-ljemalloc -DWITH_SAFEMALLOC=OFF -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_CSV_STORAGE_ENGINE=1 -DWITH_HEAP_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MYISAMMRG_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=ON -DWITH_PBXT_STORAGE_ENGINE=OFF -DWITH_OQGRAPH_STORAGE_ENGINE=OFF -DWITH_SPHINX_STORAGE_ENGINE=OFF -DWITH_FEDERATEDX_STORAGE_ENGINE=ON -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCMAKE_INSTALL_DO_STRIP=OFF -DCMAKE_USER_MAKE_RULES_OVERRIDE=/var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_rules.cmake /var/tmp/portage/dev-db/mariadb-5.5.25/work/mysql gentoo_common_config.cmake contains: SET (LIB_SUFFIX 64 CACHE STRING "library path suffix" FORCE) SET (CMAKE_INSTALL_LIBDIR /usr/lib64 CACHE PATH "Output directory for libraries") I'm at a loss why one way works and the the other doesn't. Thank you.

2 4