- discuss - lists.mariadb.org

[Maria-discuss] New Question: Looking for a stable version of ODBC connector for Linux
by AskMonty KB 05 Mar '15

05 Mar '15

Hello, A new question has been asked in "MariaDB Connector/ODBC" by namkyungkim. Please answer it at http://mariadb.com/kb/en/looking-for-a-stable-version-of-odbc-connector-for… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi all, I am looking for a stable version of ODBC connector for Linux. I am kindly asking you when I can have a chance to download it. Thank you and regards, -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/looking-for-a-stable-version-of-odbc-connector-for…

1 0

[Maria-discuss] mariadb 10.0.17 keeps crashing
by Gabriel Sosa 04 Mar '15

04 Mar '15

Hello, I've been a proudly user of mariadb 5.5.x for a long time now but given the nice feature setI decided to give mariadb 10.x a try. I took one of our current slaves running mariadb 5.5.x (on centos 6.5) and followed the upgrade steps using yum and ran *mysql_upgrade*. The upgrade ran without any trouble...then I moved a huge table (about 1B records right now) from InnoDB to TokuDB. Now, every couple of hours I find that the replication is far behind the master and the reason is because this server keeps checking tables marked as crashed.... I can't seems to find any indicator of OOM killer in the system logs NOR anything related to that in the mysql log, the only clue I have is: --------------- *150303 10:08:57 mysqld_safe Number of processes running now: 0* *150303 10:08:57 mysqld_safe mysqld restarted* 150303 10:08:58 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release. 150303 10:08:59 [Warning] option 'innodb-status-file': boolean value 'ib_status' wasn't recognized. Set to OFF. 150303 10:08:59 [Warning] option 'innodb-autoextend-increment': unsigned value 10485760 adjusted to 1000 150303 10:08:59 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150303 10:08:59 [Note] InnoDB: The InnoDB memory heap is disabled 150303 10:08:59 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150303 10:08:59 [Note] InnoDB: Memory barrier is not used 150303 10:08:59 [Note] InnoDB: Compressed tables use zlib 1.2.3 150303 10:08:59 [Note] InnoDB: Using Linux native AIO 150303 10:08:59 [Note] InnoDB: Using CPU crc32 instructions 150303 10:08:59 [Note] InnoDB: Initializing buffer pool, size = 6.0G 150303 10:08:59 [Note] InnoDB: Completed initialization of buffer pool 150303 10:08:59 [Note] InnoDB: Highest supported file format is Barracuda. 150303 10:08:59 [Note] InnoDB: Log scan progressed past the checkpoint lsn 14178608217047 150303 10:08:59 [Note] InnoDB: Database was not shutdown normally! 150303 10:08:59 [Note] InnoDB: Starting crash recovery. 150303 10:08:59 [Note] InnoDB: Reading tablespace information from the .ibd files... 150303 10:09:05 [Note] InnoDB: Restoring possible half-written data pages 150303 10:09:05 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 14178613459456 InnoDB: Doing recovery: scanned up to log sequence number 14178618702336 InnoDB: Doing recovery: scanned up to log sequence number 14178623945216 InnoDB: Doing recovery: scanned up to log sequence number 14178629188096 InnoDB: Doing recovery: scanned up to log sequence number 14178634430976 InnoDB: Doing recovery: scanned up to log sequence number 14178639673856 InnoDB: Doing recovery: scanned up to log sequence number 14178644916736 ...... ...... ...... ...... 150303 10:09:14 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: In a MySQL replication slave the last master binlog file InnoDB: position 0 16433109, file name slave-bin.852141 InnoDB: Last MySQL binlog file position 0 16784214, file name /var/lib/mysql/log/bin/slave-bin.005211 150303 10:09:34 [Note] InnoDB: 128 rollback segment(s) are active. 150303 10:09:34 [Note] InnoDB: Waiting for purge to start 150303 10:09:34 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 14178834821658 Tue Mar 3 10:09:36 2015 TokuFT recovery starting in env /var/lib/mysql/data/ Tue Mar 3 10:09:36 2015 TokuFT recovery scanning backward from 1330297 Tue Mar 3 10:09:36 2015 TokuFT recovery bw_end_checkpoint at 1330297 timestamp 1425395277901416 xid 1330281 (bw_newer) Tue Mar 3 10:09:36 2015 TokuFT recovery bw_begin_checkpoint at 1330281 timestamp 1425395273487081 (bw_between) Tue Mar 3 10:09:36 2015 TokuFT recovery turning around at begin checkpoint 1330281 time 4414335 Tue Mar 3 10:09:36 2015 TokuFT recovery starts scanning forward to 1330297 from 1330281 left 16 (fw_between) Tue Mar 3 10:09:36 2015 TokuFT recovery closing 14 dictionaries Tue Mar 3 10:09:36 2015 TokuFT recovery making a checkpoint Tue Mar 3 10:09:36 2015 TokuFT recovery done 150303 10:09:36 [Note] Recovering after a crash using /var/lib/mysql/log/bin/slave-bin --------------- The odd thing is that the 5.5.x version was working just fine (since about a year) in the same hardware...nothing changed in that front. Any clue? Thank you in advance

4 9

[Maria-discuss] Questions on image data should be stored in database or not?
by Peter Boston 04 Mar '15

04 Mar '15

I don't know the following questions are valid here or not. I just hope I get some help from experienced experts here. I am planning to use MariaDB on 64bit Linux for a new medical application project. I have to store lots of images. The size of one image is about 263KB. There are about 50 images per patient. It's about 14MB. I have two options here for these image data: Option A: store them in file system and have their location linked in database table; Option B: store them in database in a separated table as BOLB with a unique id; I know there are lots of implementations go with Option A. My concern about Option A is the security and backup. I have to do them separately. Do you have any good idea how to do them? For Option B, I am worry about the size of that table and the database. I read somewhere saying the BOLB and TEXT columns in a table are not stored "inline" and will not be counted to the table size. Where I can find the detailed information about this? Oracle has a special way to handle this situation and is pushing save images into database. Is there a similar mechanism in MariaDB? How about compress a series of images for a patient in Option B? Is it worthy to scarify perform for gaining some spaces? Eventually the data size will be very big, what are the options for me to cleanup and archive old data, including the image data? Thanks, Peter

3 4

[Maria-discuss] stored programs
by Federico Razzoli 04 Mar '15

04 Mar '15

Reading 10.0.3 release notes: https://mariadb.com/kb/en/mariadb/mariadb-1013-release-notes/ I see that IF EXISTS, IF NOT EXISTS and OR REPLACE are now almost consistent. "Almost" means that... OR REPLACE still doesn't apply to stored procedures, functions, triggers, events. Recently, during a public session, a PostgreSQL user asked me if MariaDB supports stored procedures - in his opinion, MySQL doesn't, no matter what the manual says. Unfortunately my answer was that MariaDB support for stored procedure is the same as MySQL ("so the answer is no", he said). I feel that these features are generally ignored. I don't understand the reason. While they have many problems in MariaDB/MySQL, some people still tries to use them. Even more people would use them if some developement was made on them. They are also used by important projects like Common Schema and Flexviews, but I'm sure that the authors have to struggle against limitations every time they change a line of code. I struggled hards for a much easier project - an SQL unit test tool. I have several problems in mind: performance, lack of variable number of arguments, cannot prepare a statement from a local variable, no debugger, no way to see the call stack... I'm writing this because I love MariaDB. This is not a hateful criticism: this is a request for something I waited for many years. I hope that you will keep procedures in mind, while planning the next major release. Regards Federico

6 40

[Maria-discuss] MaxScale Multiple Masters
by Riz Plate 03 Mar '15

03 Mar '15

Hi I have a very basic scenario, we have one database which is running out of space. database have some tables with incremental primary key ids. 1- for new ids , we want to send read/write to new server and preferably , do id based statement routing i.e. if id%2=0 push to new-server1 , else read/write to new-server2. 2- some tables are created dynamically i.e. dynamic_table_123. we want to send 123%2=0 to new-server1 else read/write to new-server2. 3- all statements in above #1, #2 should go to same MaxScale abstraction i.e. application should not have logic for routing. Can we do this with MaxsScale? what are the configuraion readwriterouter or the cluster? Thanks for your insight and recommendations. Thanks

1 0

[Maria-discuss] New Question: ResultSetMetaData getColumnClassName accuracy for JDBC
by AskMonty KB 02 Mar '15

02 Mar '15

Hello, A new question has been asked in "Client Libraries" by tommy_pham_g. Please answer it at http://mariadb.com/kb/en/resultsetmetadata-getcolumnclassname-accuracy-for-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi folks, I'm having problems getting the getColumnClassName to return the correct information. I have a sample table: CREATE TABLE `datatypes` ( `mariadb_binary` binary(8) NULL, `mariadb_blob` blob NULL, `mariadb_boolean` tinyint(1) NULL, `mariadb_varbinary` varbinary(16) NULL, `mariadb_varchar` varchar(5) CHARACTER SET utf8 NULL, UNIQUE KEY `mariadb_serial` (`mariadb_serial`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; The ResultSetMetaData is not returning accurate GetColumnClassName information for some of the above columns: [INFO ] 2015-03-02 09:26:52.905 [main] c.d.d.AppDbTest.main - getColumnName mariadb_binary | getColumnLabel mariadb_binary. getColumnClassName [B. getColumnDisplaySize 8. getColumnType -2. getColumnTypeName BINARY. [INFO ] 2015-03-02 09:26:52.905 [main] c.d.d.AppDbTest.main - getColumnName mariadb_blob | getColumnLabel mariadb_blob. getColumnClassName [B. getColumnDisplaySize 65535. getColumnType -4. getColumnTypeName BLOB. [INFO ] 2015-03-02 09:26:52.905 [main] c.d.d.AppDbTest.main - getColumnName mariadb_boolean | getColumnLabel mariadb_boolean. getColumnClassName java.lang.Boolean. getColumnDisplaySize 1. getColumnType -7. getColumnTypeName TINYINT. getPrecision 1. [INFO ] 2015-03-02 09:26:52.998 [main] c.d.d.AppDbTest.main - getColumnName mariadb_varbinary | getColumnLabel mariadb_varbinary. getColumnClassName [B. getColumnDisplaySize 16. getColumnType -3. getColumnTypeName VARBINARY. getPrecision 16. [INFO ] 2015-03-02 09:26:53.014 [main] c.d.d.AppDbTest.main - getColumnName mariadb_varchar | getColumnLabel mariadb_varchar. getColumnClassName java.lang.String. getColumnDisplaySize 5. getColumnType 12. getColumnTypeName VARCHAR. getPrecision 5. Is the above by design? Is it bug within JDBC spec? I'm using MariaDB JDBC version 1.1.8. Thanks, Tommy -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/resultsetmetadata-getcolumnclassname-accuracy-for-…

1 0

[Maria-discuss] Serious problem with latest (10.0.16) Windows installer - destroys services.
by Peter Laursen 02 Mar '15

02 Mar '15

I have MariaDB 5.5, 10.0 and 10.1 installed (as Windows services named 'maria55'. 'maria10' and 'maria10_1' ) and always update them to latest soon after an update is available. Yesterday morning I installed 10.0.16 on top of 10.0.15 using the .msi installer. When I tried to connect to it a few hours later it was not possible. I thought the service might not be running. It wasn't. Actually it did not exist anymore at all! "net start maria10" returned "service does not exist" (and indeed it did not appear in Windows "services management" interface). I copied the /datadir, uninstalle , did a fresh install of 10.0.16d (choosing the option not to upgrade any existing server) and copied the old /datadir back. Now Maria 10.0(.16) works again. But now I see that the 'maria55' service is also gone from the system. Files are intact. I can repeat the exercise I did with 10.0 of course or install service again from commandline. Not a big problem, but very annoying and waste of time. MariaDB 10.1 installaton is not affected. 5 diiferent Oracle/MySQL servers (from 5.0 to 5.7) also are not. I need all those instances for application testing. Questions: * Has somebody else experienced this? * Has somebody replaced @wlad as maintainer of Windows installers? @wlad was the only person who ever was able to write reasonable MySQL/MariaDB installers. So I would regret that. It is perfectly legal on Windows to have multiple MariaDB servers simultaneously running as Windows services. They won't conflict as long as service name, port, basedir and datadir are all different. What happens with one should not affect another. I the installer does not respect this, it is a bug. -- Peter -- Webyog

5 10

[Maria-discuss] MariaDB 10.0.17 and 10.1.3 released
by Daniel Bartholomew 02 Mar '15

02 Mar '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.17 & 10.1.3 MariaDB 10.0.17 is a Stable (GA) release. MariaDB 10.1.3 is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.17 - Release Notes: https://mariadb.com/kb/en/mariadb-10017-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10017-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.17 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ MariaDB 10.1.3 - Release Notes: https://mariadb.com/kb/en/mariadb-1013-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1013-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.3 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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 or my.ini file! See http://mariadb.com/kb/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 the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Giving up on dynamic columns
by Tom Worster 02 Mar '15

02 Mar '15

I discovered this showstopper on Friday while working with real data in development of a new app. I managed to narrow it down today and filed the bug report. https://mariadb.atlassian.net/browse/MDEV-7650 Looks like Maria saves an illegally formatted dyncol string if a dynamic column is longer than 64kB and is not alphabetically last by name among the dynamic column in the blob. Tbh, even is this were fixed tomorrow so I could proceed with my work, I'm not sure I would use dyncols. My confidence in the feature has been shaken. It's a pity because the Active Record ORM extension I wrote was working. Tom

4 6

[Maria-discuss] myisam_use_mmap unstable in MariaDB 10.0.x
by Reindl Harald 01 Mar '15

01 Mar '15

historical: http://lists.mysql.com/mysql/226361 after it turned out to be stable in 2013/2014 upgrade to MariaDB 10.0.17 yesterday and the logs started with "table corrupt", "table not closed properly" and so on for tables which where not only read this time not with 'mysqld got signal 11' but "only" corrupted MyISAM files and after disable 'myisam_use_mmap' all is clean and stable over hours BTW a 'repair table' don't delete the TMM file leading in a 'optimize table' later failing until you delete the file manually from disk __________________________________________________________________ this configuration is unchanged for years and so my only conclusion is that Oracle managed to kill the feature again, this is also confirmed for Percona Server 5.6 where even queries fail confirmed from another sysadmin which found out that playing with my settings leaded to problems while here MariaDB 5.5.x was in use and hence no troubles - given that 'myisam_use_mmap' is borked at MariaDB 10.x and Percona 5.6 it's likely a backport from MySQL 5.6 delay-key-write = ALL concurrent_insert = 2 open-files-limit = 750000 myisam-recover-options = "FORCE" myisam_use_mmap = 0 wait_timeout = 300 interactive_timeout = 300 max_allowed_packet = 200M max_connections = 500 max_tmp_tables = 150 max_connect_errors = 250 max_delayed_threads = 32 flush_time = 0 query_cache_limit = 256K query_cache_min_res_unit = 1K query_cache_size = 1280M query_cache_type = 1 table_cache = 10000 table_definition_cache = 10000 thread_cache_size = 400 tmp_table_size = 256M max_heap_table_size = 256M key_buffer_size = 256M sort_buffer_size = 256K myisam_sort_buffer_size = 15M join_buffer_size = 1M preload_buffer_size = 128K read_buffer_size = 128K read_rnd_buffer_size = 128K

1 0