- discuss - lists.mariadb.org

[Maria-discuss] MariaDB Galera Cluster 5.5.35 now available
by Daniel Bartholomew 14 Feb '14

14 Feb '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.35. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.35 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5535-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5535-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.35 About MariaDB Galera Cluster - https://mariadb.com/kb/en/galera/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf formats. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - 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: 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 Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Very slow insert with load data infile
by Pierre 12 Feb '14

12 Feb '14

Hello, Mariadb is getting slower and slower when I'm inserting a massive amout of data. I'm trying to insert 166 507 066 rows (12go) using load data infile '' into an empty table. I splitted my file in 13 parts of the same size because it was too long to insert in one shot. When I inserted more than 100M rows, it starts to be extremely slow. Here are the time for each load data infile : LOAD DATA INFILE '/tmp/hash/xaa' : 2min 49sec LOAD DATA INFILE '/tmp/hash/xab' : 2min 49sec LOAD DATA INFILE '/tmp/hash/xac' : 3min 48sec LOAD DATA INFILE '/tmp/hash/xad' : 3min 48sec LOAD DATA INFILE '/tmp/hash/xae' : 3min 49sec LOAD DATA INFILE '/tmp/hash/xaf' : 5min 59sec LOAD DATA INFILE '/tmp/hash/xag' : 10min 50sec LOAD DATA INFILE '/tmp/hash/xah' : 20min 7sec LOAD DATA INFILE '/tmp/hash/xai' : 47min 7sec LOAD DATA INFILE '/tmp/hash/xaj' : 4 hours 1 min 9.34 sec ( ouch !) LOAD DATA INFILE '/tmp/hash/xak' : still running... Now the task is running but mariadb is only using 2% cpu and read to the disk at 2500 Kb/sec (which is slow regarding the disk performance). There is a lot of disk space. If insertion speed continue to slow down at this rate, it will take weeks to insert the 3 remainings files ! It's only 166M rows so I think it's not normal. If I disable the "unique" constraint insertion speed is great but I need to be sure there is no duplicate and I also need an index. Can someone explain me what is happening internaly and why it is so slow ? Do you think if I just create an index (not a unique index) it will be faster ? The problem is I specially delegated this task of unique checking to mysql. If no solution, do you know a database or a key/value store with better for performance for this use case ? (create an index and remove duplicate ?) I can rearrange my table structure (at a cost of more disk space usage) to match a key/value structure. Here is my current table structure : CREATE TABLE `wallets` ( `p1` varbinary(20) DEFAULT NULL, `p2` varbinary(20) DEFAULT NULL, `data` varbinary(32) DEFAULT NULL, UNIQUE KEY `p1` (`p1`), UNIQUE KEY `p2` (`p2`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; Computer specs: 16go RAM and 4x3.1 ghz, 2x1To (with 90% unused disk space) The configuration variables (I tweaked specially for this insertion job) : key_buffer_size = 6G # MyISAM: used with insert to an empty table bulk_insert_buffer_size = 6G # MyISAM/Aria: insert to a non empty table; default 8M myisam_sort_buffer_size = 6G # MyISAM: used for sort but only when : "CREATE INDEX", "ALTER TABLE" or "REPAIR TABLE" read_buffer_size = 6G # MyISAM/Aria/MERGE: allocated for each table scan, for order by, nested query caching, bulk insert into partitions sort_buffer_size = 4M # ALL: allocated each time a session need to do a sort myisam_max_sort_file_size = 128G # MyISAM: tmp file max size I'm using mariadb 5.5.31. Best regards,

6 16

[Maria-discuss] MariaDB 5.5.35 now available
by Daniel Bartholomew 11 Feb '14

11 Feb '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.35. This is a Stable (GA) maintenance (bug fix) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.35 - Release Notes: https://mariadb.com/kb/en/mariadb-5535-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5535-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.35 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf formats. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - 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: 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 Knowledge Base - http://mariadb.com/kb

5 7

[Maria-discuss] New Question: ARCHIVE equivalent
by AskMonty KB 11 Feb '14

11 Feb '14

Hello, A new question has been asked in "MariaDB FAQ" by dumdummare: -------------------------------- What options are there to have a log table that is difficult to change but quick to search using criterias even during inserts? Something like an ARCHIVE with indicies or an InnoDB without UPDATE or DELETE. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/archive-equivalent/

4 4

[Maria-discuss] why are ipv6 tests not simply skipped?
by Reindl Harald 11 Feb '14

11 Feb '14

these tests should be skipped in case the machine has no ipv6 config instead fired up and failing __________________________________ CURRENT_TEST: rpl.rpl_ip_mix mysqltest: In included file "./include/rpl_ip_mix.inc": included from /usr/share/mysql-test/suite/rpl/t/rpl_ip_mix.test at line 11: At line 2: query 'connect master,$IPv6,root,,test,$MASTER_MYPORT' failed: 2003: Can't connect to MySQL server on '::1' (101) The result from queries just before the failure was: #################### IP: ::1 ########################### connect (master,::1,root,,test,MASTER_MYPORT); - saving '/usr/share/mysql-test/var/log/rpl.rpl_ip_mix/' to '/usr/share/mysql-test/var/log/rpl.rpl_ip_mix/' rpl.rpl_ip_mix2 [ fail ] Test ended at 2014-02-11 13:11:55 CURRENT_TEST: rpl.rpl_ip_mix2 mysqltest: In included file "./include/rpl_ip_mix2.inc": included from /usr/share/mysql-test/suite/rpl/t/rpl_ip_mix2.test at line 11: At line 4: query 'connect slave,$IPv6,root,,test,$SLAVE_MYPORT' failed: 2003: Can't connect to MySQL server on '::1' (101) The result from queries just before the failure was: #################### IP: ::1 ########################### connect (master,127.0.0.1,root,,test,MASTER_MYPORT); connect (slave,::1,root,,test,SLAVE_MYPORT); - saving '/usr/share/mysql-test/var/log/rpl.rpl_ip_mix2/' to '/usr/share/mysql-test/var/log/rpl.rpl_ip_mix2/' rpl.rpl_ipv4_as_ipv6 [ pass ] 24 rpl.rpl_ipv6 [ fail ] Test ended at 2014-02-11 13:12:00 CURRENT_TEST: rpl.rpl_ipv6 mysqltest: In included file "./include/rpl_ipv6.inc": included from /usr/share/mysql-test/suite/rpl/t/rpl_ipv6.test at line 13: At line 2: query 'connect master,$IPv6,root,,test,$MASTER_MYPORT' failed: 2003: Can't connect to MySQL server on '::1' (101) The result from queries just before the failure was: #################### IP: ::1 ########################### connect (master,::1,root,,test,MASTER_MYPORT);

2 2

[Maria-discuss] New Question: What version do I need and how to install
by AskMonty KB 11 Feb '14

11 Feb '14

Hello, A new question has been asked in "Getting Started" by rjtuijnman: -------------------------------- I've installed a virtual OpenSuse server. I want to insdtall the latest stable version of MariaDB. What install version do I need and where can I find documentation for installing. I'm an absolute no-know ons Linux... -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/what-version-do-i-need-and-how-to-install/

1 0

[Maria-discuss] MariaDB 10.0.8 now available
by Daniel Bartholomew 10 Feb '14

10 Feb '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.8. This is a Release Candidate (RC) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.8 - Release Notes: https://mariadb.com/kb/en/mariadb-1008-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1008-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.8 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf formats. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - 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: 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 Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] 5.5.35 memory usage
by ImperialNetwork 10 Feb '14

10 Feb '14

Hi, Running a mysqltuner.pl scan tells the following: [--] Up for: 6d 15h 31m 3s (139M q [242.402 qps], 2M conn, TX: 427B, RX: 16B) [--] Reads / Writes: 95% / 5% [--] Total buffers: 2.0G global + 2.3M per thread (175 max threads) [OK] Maximum possible memory usage: 2.4G (31% of installed RAM) However , it seems to be using more than what mysqltuner reports (3.3G now): [~]# ps -eo comm,rss|awk '{arr[$1]+=$2} END {for (i in arr) {print arr[i]/1024, i}}'|grep -v '^0 '|grep mysqld 3314.3 mysqld my.cnf: [mysqld] user = mysql extra_port = 3308 default_storage_engine = MyISAM sql-mode = NO_ENGINE_SUBSTITUTION # DATA STORAGE # datadir = /databases/mysql # MariaDB # thread_handling = pool-of-threads optimizer_switch ='mrr=on' optimizer_switch ='mrr_sort_keys=on' optimizer_switch ='mrr_cost_based=off' optimizer_switch ='join_cache_incremental=on' optimizer_switch ='join_cache_hashed=on' optimizer_switch ='join_cache_bka=on' mrr_buffer_size = 1M aria_pagecache_buffer_size = 128M aria_sort_buffer_size = 128M key_cache_segments = 8 # MyISAM # key_buffer_size = 256M myisam_recover = BACKUP,FORCE myisam_sort_buffer_size = 128M group_concat_max_len = 4096 max_seeks_for_key = 1000 #myisam_use_mmap = 1 # SAFETY # max_allowed_packet = 32M max_connect_errors = 1000 local-infile = 0 # CACHES AND LIMITS # tmp_table_size = 128M max_heap_table_size = 128M query_cache_type = 1 query_cache_size = 128M query_cache_limit = 1M query_cache_min_res_unit = 2K max_connections = 175 max_user_connections = 75 thread_cache_size = 32 open_files_limit = 50K table_definition_cache = 10K table_open_cache = 40K join_buffer_size = 1M sort_buffer_size = 512K read_buffer_size = 256K read_rnd_buffer_size = 256K # INNODB # sysdate_is_now = 1 innodb = FORCE innodb_strict_mode = 1 innodb_flush_method = O_DIRECT innodb_log_files_in_group = 2 innodb_log_file_size = 256M innodb_flush_log_at_trx_commit = 2 innodb_file_per_table = 1 innodb_buffer_pool_size = 1536M innodb_read_io_threads = 4 innodb_write_io_threads = 4 innodb_io_capacity = 400 # LOGGING # slow_query_log = 1 long_query_time = 5 connect_timeout=30 interactive_timeout=120 wait_timeout=120 Is this some memory leak problem , problems with the script or normal behavior ? Thank you in advance, Alexandru

2 1

[Maria-discuss] New Question: I am trying to find the latest MariaDB equivelent of the MySQL reference manual
by AskMonty KB 09 Feb '14

09 Feb '14

Hello, A new question has been asked in "MariaDB FAQ" by robsilver: -------------------------------- For example I am trying to determine regarding using implicit and or explicit Locking e.g Issolation Levels , Locking , transactions processing via [FOR UPDATE | LOCK IN SHARE MODE] I have not found a lot out there but if there is an equivalent PDF file that would be great. I currently have the book: MariaDB Crash Course which I can not find one reference to LOCK IN SHARE MODE or FOR UPDATE. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/i-am-trying-to-find-the-latest-mariadb-equivelent-…

3 2

[Maria-discuss] New Question: What should I know if I am moving database from Oracle to MiriaDB?
by AskMonty KB 08 Feb '14

08 Feb '14

Hello, A new question has been asked in "Does MariaDB support..." by jimwu: -------------------------------- Hi, I am trying to find what difficulty would I meet if I move database from Oracle to MariaDB? Are there similar functions in MariaDB like functions in Oracle, like material view or snapshot....? Best Regards, Jim Wu -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/what-should-i-know-if-i-am-moving-database-from-or…

2 1