- discuss - lists.mariadb.org

[Maria-discuss] New Question: JSON error
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB community" by miroigov: -------------------------------- Hello, I installed MariaDB Manager on CentOS 6.5 and when i open in browser http://domain.com:8080/MariaDBManager/ it starts loading and then displays error : API did not return JSON for: GET http://localhost/consoleAPI/api/user HTTP 500 - Errors: HTTP/1.1 500 Internal Server Error - The API is unable to function because PHP JSON functions are not available I do not have experience with Tomcat and have no idea how to set json for php. I have php 5 install and json is working fine with default config /etc/php.ini -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/json-error/

1 0

[Maria-discuss] New Question: Permanent link to download last version of MariaDB
by AskMonty KB 12 Mar '14

12 Mar '14

Hello, A new question has been asked in "MariaDB FAQ" by francocorbelli: -------------------------------- I suggest to create permanent link to last version of a given series. Something like this https://downloads.mariadb.org/mariadb-5.5/mariadb-current-winx64.msi With best regards for a great project. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/permanent-link-to-download-last-version-of-mariadb/

1 0

[Maria-discuss] New Question: creating pivot table fails
by AskMonty KB 12 Mar '14

12 Mar '14

Hello, A new question has been asked in "CONNECT Table Types" by nobswolf: -------------------------------- I tried to create a pivot table based on an existing table "test1" and get an error. I am logged in and I can use "test1", so this error makes no sense to me. What I am doing wrong? Any hints? MariaDB [nav]> create table xsort engine=connect table_type=pivot tabname=test1; ERROR 1105 (HY000): (1045) Access denied for user 'root'@'localhost' (using password: NO) MariaDB [nav]> -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/creating-pivot-table-fails/

1 0

[Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'
by Tanstaafl 12 Mar '14

12 Mar '14

Hello all, We have a postfixadmin+mariadb sql database we have been using for many, many years (well, only recently migrated from mysql to mariadb, and it was totally transparent, so thanks for that!). This system is rock solid, and we have no desire to change it. We are in the process of setting up SOGo groupware, amd have run into a stumbling block. Not a show stopper, but it definitely put a heavy burden on me, as the SysAdmin. SOGo can Active Directory just fine for testing Group Memberships for purposes of applying ACLs (for shared calendars, contacts, etc)... We intentionally do not use SSO - we enforce very strong email passwords, but allow much weaker AD computer passwords - so email AUTH happens with our SQL DB. The problem is, SOGo does not have support for using 'Groups' for ACLs when using SQL for the AUTH backend. It also does not (yet) have support for different AUTH and USER DB backends. So, as things stand now, I'm going to have to manually add every single individual userid to every single resource they will need to have access too, rather than just doing this with groups. So, my first questions is, has anyone every come up with a decent schema that provides for managing user groups in the same way as AD groups that scales reasonably well? I'm very dangerous when it comes to this stuff, so can't even attempt this myself, but I have some options available to help get this done, especially if I can get some help/advice with getting started. One thing I do know is the SOGo guy had to create a 'View' to use, so whatever we end up using will have to work inside a View (probably displaying my ignorance to the world with that comment - is pretty much everything in an SQL DB compatible with 'Views'?)... I'd dearly appreciate any help anyone is willing to give... Thanks, Charles

3 5

[Maria-discuss] InnoDB selected projects (corrected links)
by Jan Lindström 12 Mar '14

12 Mar '14

Hi all, After careful weighting and selection process, I have selected following two projects as a starting point to improve InnoDB (1) InnoDB file space defragmentation Description: External tool to physically delete delete marked rows from InnoDB file space and freeing unused file space. https://mariadb.atlassian.net/browse/MDEV-5834 (2) InnoDB fast bulk load Description: External tool to load CVS file directly to InnoDB file space (innodb_file_per_table = 1). https://mariadb.atlassian.net/browse/MDEV-5835 Now, I hope these projects mostly represent the most frequently requested features and are most usable to current customers and/or potential new customers. Next, I would hope some indication which one of the selected project you would like to see first. Votes can be added above links. R: -- -- Jan Lindström, Principal Engineer SkySQL - The MariaDB Company MariaDB | MaxScale | skype: jan_p_lindstrom www.skysql.com <http://www.skysql.com/> Twitter <http://twitter.com/skysql> Blog <http://www.skysql.com/blog/> Facebook <http://www.facebook.com/skysql> LinkedIn <http://www.linkedin.com/company/1214250> Google+ <https://plus.google.com/117544963211695643458/posts>

1 0

[Maria-discuss] MariaDB 10.0.9 now available
by Daniel Bartholomew 10 Mar '14

10 Mar '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.9. This is a Release Candidate (RC) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.9 - Release Notes: https://mariadb.com/kb/en/mariadb-1009-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1009-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.9 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] New Question: unable to START MySQL server at BOOT "systemctl enable mysqld.service" does not work
by AskMonty KB 09 Mar '14

09 Mar '14

Hello, A new question has been asked in "MariaDB community" by asifcyberdome: -------------------------------- unable to START MySQL server at BOOT "systemctl enable mysqld.service" does not work I am running FEDORA 20 and I have MySQL installed or the replacement MariaDB. same difference. I am able to do everything correcty. Everything works, except when I run the command: "systemctl enable mysqld.service", It gives me error "failed to issue method call: no such file or directory." Is this a known issue? Is this a known BUG? Is there a way to fix this? I am running Fedora 20 MySQL/MariaDB 5.5 version. Any help is greatly appreciated -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-start-mysql-server-at-boot-systemctl-ena…

1 0

[Maria-discuss] New Question: V5.5.36 will only use default data directory
by AskMonty KB 08 Mar '14

08 Mar '14

Hello, A new question has been asked in "MariaDB community" by mdavies5: -------------------------------- I installed v5.5.36 on a new Mint16 installation and it started ok. I then modified my.cnf to point to an existing data directory. I made sure that all folders and files were owned by mysql user and the mysql group had permissions to read/write. I also deleted existing files ib_logfile0/1, ibdata1 and aria_log_control as I know these must be recreated. When restarting MariaDb I get: Can't create/write to file '/home/michael/mysql/aria_log_control' (Errcode: 13). Files ib_logfile0 & 1 and ibdata1 were created ok so it is not a permissions problems. Why does only aria_log_control fail to create. If I copy all this data to default /var/lib/mysql and reset my.cnf then they work fine -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/v5536-will-only-use-default-data-directory/

1 0

Re: [Maria-discuss] Index bug in aria engine?
by pslawek83 07 Mar '14

07 Mar '14

Ok i wasn't able to reproduce the issue fully, now data is different ... but again, "skipped rows" number changes, and index sizes differ a lot: Uniq index: http://screencast.com/t/SrBS1L5xeB8 http://screencast.com/t/3dVMU7b69AH2 Normal index: http://screencast.com/t/Zl5Jm2OZ http://screencast.com/t/P3SA8U6duly But again, unique index is working much worse than not unique... while it's bigger http://screencast.com/t/rjexoWKwFF http://screencast.com/t/qYdsmRbRbmG7 I'll quickly explain how tables were created... i first took part of the data with unique index, and made smaller copy, thats table 1 Then i just copied the table changed the index to non-unique. After this i copied the tables once again to be sure files are not fragmented, etc. SHOW WARNINGS returns nothing in both cases. It seems that the additional knowledge (only single row with same data) should make the optimizer and query behave better but it's actually behaving much worse... -- Query for reference: EXPLAIN extended SELECT attrib_id, raw_stats_value_id, sum(impressions)FROM raw_stats_other_copyi1_copy INNER JOIN raw_stats_lookupON raw_stats_lookup_id = raw_stats_lookup.idWHERE domain = 'mydomain.com'AND date = '2014-02-10'GROUP BY attrib_id, raw_stats_value_id; -- Thanks, Slawomir. Dnia 6 marca 2014 17:46 Sergei Golubchik <serg(a)mariadb.org> napisał(a): Hi, pslawek83! On Feb 17, pslawek83 wrote: > Hi Guys, > any comments on this issue? It seems that partial unique indexes can't be used in joins. > https://mariadb.atlassian.net/browse/MDEV-5663 Please, show EXPLAIN EXTENDED (and SHOW WARNINGS after it) for this query of yours. > * Why the server is treating same indexes differently depends on if > they're UNIQUE or not It doesn't, there're almost no differences between UNIQUE and non-unique indexes from the optimizer point of view. Optimizer knows that for a unique index there can be at most one matching row (if all index parts are known and are NOT NULL), for non-unique indexes there can be more. That's basically the only difference. > * That's probably not optimizer issue, as we can't FORCE the index You cannot force the index if it is not applicable at all. > * What's internal difference between unique and non-unique index (eg. > memory / file representation / data structure) none. > * What each index type is suitable for, considering query optimization > (as there's no data i was able to find on topic) Aria only supports BTREE indexes anyway. Regards, Sergei

2 2

[Maria-discuss] Index bug in aria engine?
by pslawek83 06 Mar '14

06 Mar '14

Hi Guys, any comments on this issue? It seems that partial unique indexes can't be used in joins. https://mariadb.atlassian.net/browse/MDEV-5663 Regards,

4 5

[Maria-discuss] New Question: mariaDB for arm
by AskMonty KB 05 Mar '14

05 Mar '14

Hello, A new question has been asked in "MariaDB community" by mikestorcheous: -------------------------------- А не подскажите репозиторий для debian 7 armhf? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-for-arm/

1 0

[Maria-discuss] MariaDB & MySQL community event 3rd of April 2014 in Santa Clara
by Michael Widenius 05 Mar '14

05 Mar '14

Hi! I am happy to announce that the MariaDB Foundation is organising a MariaDB & MySQL community event in Santa Clara on Thursday the 3rd of April. The venue is the Hilton Santa Clara hotel, a short walk from the Percona Live 2014 event. You can find more information on my blog at: http://monty-says.blogspot.fi/2014/03/mariadb-mysql-community-event-2014-in… We already got some very interesting talks and speakers, but I would like to see even more talk proposals. It's ok to propose a talk that it's also hold at Percona Live. As this event is free, I expect a totally different group of attendees, so that should be fine! When we have got a nice list of proposed talks, we will post them here so that everyone has a chance of commenting of which talks should be accepted. (Sorry, but this time we don't have time to create a proper selection committee so we have to do this a bit rough) Personally I will talk about MariaDB 10.0, which should be declared stable by then. Hope to see many MariaDB developers and users in Santa Clara! You can sign up for the event and/or dinner at: http://www.eventbrite.com/e/mariadb-mysql-community-event-2014-tickets-1080… Regards, Monty PS: Feel free to discuss the event on this email list! We want to have as many as possible participating in making this the best possible MariaDB and MySQL event.

1 0

[Maria-discuss] New Question: Downloaded; how do I install?
by AskMonty KB 28 Feb '14

28 Feb '14

Hello, A new question has been asked in "MariaDB Documentation" by jeffreythomas: -------------------------------- I've downloaded MariaDB; how do I install it? Thanks, Jeff -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/downloaded-how-do-i-install/

1 0

[Maria-discuss] New Question: Maria DB - changing hosting with a different DB
by AskMonty KB 26 Feb '14

26 Feb '14

Hello, A new question has been asked in "MariaDB community" by hannasles: -------------------------------- Hi Guys! I am moving my web-site from one hosting to another. The DB on the first hosting is MariaDB, DB on the hosting I am moving to is MyIsam. When importing the DB, I am getting this message: ERROR 1064 (42000) at line 19: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PAGE_CHECKSUM=1' at line 6 Line 19 runs: CREATE TABLE `wp_blc_filters` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=Aria DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1; As I am not good at all with DB and my hosting supports can not answer my enquiries, I have to open this question here. I will really appreciate that if you could help me with this! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-db-changing-hosting-with-a-different-db/

2 1

[Maria-discuss] New Question: How do I keep the graph table and data table in sync?
by AskMonty KB 26 Feb '14

26 Feb '14

Hello, A new question has been asked in "OQGRAPH" by prestonthayne: -------------------------------- So I added some rows to the data table before I created the graph table that then showed up just fine. I then added some more rows to the data table and did a select * on the graph table and the new rows weren't there. I did a shortest route query and they showed up. A subsequent select * query to the graph table and they were there. What triggered them to appear? I then added a few more and no matter what I do they won't show up. The last one that won't show up was a two way link ( insert into oq_backing (origid,destid) values (9,10),(10,9) ). That's not a problem is it? And lastly, is there any good documentation/literature around for how oqgraph works and how to use it? Thanks, Preston -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-do-i-keep-the-graph-table-and-data-table-in-sy…

1 0

[Maria-discuss] MariaDB 5.5.36 now available
by Daniel Bartholomew 25 Feb '14

25 Feb '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.36. This is a Stable (GA) maintenance (bug fix) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.36 - Release Notes: https://mariadb.com/kb/en/mariadb-5536-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5536-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.36 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. - - MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - - - - Getting Started with MariaDB A how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. 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] New Question: Unknown option 'table_data' OQGraph in MariaDB 10.0.7
by AskMonty KB 25 Feb '14

25 Feb '14

Hello, A new question has been asked in "OQGRAPH" by prestonthayne: -------------------------------- I am trying to evaluate MariaDB and OQGraph and am having difficulty creating the tables. I follow the examples exactly as on the site. I create the backing table, I insert some data into the backing table, I attempt to create the graph table and I get an error that the option 'table_data' is unknown. I am using MariaDB 10.0.7 on CentOS 6.5. Any advice would be greatly appreciated. Preston -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unknown-option-table_data-oqgraph-in-mariadb-1007/

1 0

[Maria-discuss] We are participating in Google Summer of Code 2014
by Colin Charles 25 Feb '14

25 Feb '14

Hi, It is with great pleasure that I can inform you that we have been accepted as an organisation to participate in Google Summer of Code 2014! It would be great to see more ideas pop up here: https://mariadb.com/kb/en/google-summer-of-code-2014/ More mentors are always wanted! I presume we will see a lot more student discussions here as well. If you have any questions that aren't answered on the lists, please send me a personal note Here's to more features & contributors in 2014. cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

1 0

[Maria-discuss] InnoDB: Assertion failure in thread 139652707100416 in file buf0buf.c line 4172
by Reindl Harald 21 Feb '14

21 Feb '14

Hi after chnage to MariaDB i faced tonight that the third time on one of our dbmail-replication-slaves while that never happened with MySQL over years :-( 140221 3:19:50 InnoDB: Assertion failure in thread 139652707100416 in file buf0buf.c line 4172 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 140221 3:19:50 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 5.5.35-MariaDB key_buffer_size=10485760 read_buffer_size=131072 max_used_connections=1 max_threads=502 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 211932 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x48000 /usr/libexec/mysqld(my_print_stacktrace+0x2e)[0x7f037fbde42e] /usr/libexec/mysqld(handle_fatal_signal+0x505)[0x7f037f847a25] /lib64/libpthread.so.0(+0xef90)[0x7f037d686f90] /lib64/libc.so.6(gsignal+0x39)[0x7f037d2ec9e9] /lib64/libc.so.6(abort+0x148)[0x7f037d2ee0f8] /usr/libexec/mysqld(+0x63f008)[0x7f037fa03008] /usr/libexec/mysqld(+0x676218)[0x7f037fa3a218] /usr/libexec/mysqld(+0x5f8048)[0x7f037f9bc048] /lib64/libpthread.so.0(+0x7c53)[0x7f037d67fc53] /lib64/libc.so.6(clone+0x6d)[0x7f037d3acdbd] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 140221 3:19:52 InnoDB: The InnoDB memory heap is disabled 140221 3:19:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140221 3:19:52 InnoDB: Compressed tables use zlib 1.2.7 140221 3:19:52 InnoDB: Using Linux native AIO 140221 3:19:52 InnoDB: Initializing buffer pool, size = 64.0M 140221 3:19:52 InnoDB: Completed initialization of buffer pool 140221 3:19:52 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 153930874326 140221 3:19:52 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... InnoDB: Doing recovery: scanned up to log sequence number 153931613156 140221 3:19:53 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 75471956, file name bin.000375 InnoDB: and relay log file InnoDB: position 75472234, file name ./mysql-relay-bin.001426 InnoDB: Last MySQL binlog file position 0 1179902, file name /data/mysql/mysql_dbmail/bin.000224 140221 3:19:53 InnoDB: Waiting for the background threads to start 140221 3:19:54 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 153931613156 140221 3:19:54 [Note] Plugin 'FEDERATED' is disabled. 140221 3:19:54 [Note] Plugin 'FEEDBACK' is disabled. 140221 3:19:54 [Note] Server socket created on IP: '0.0.0.0'. 140221 3:19:55 [Note] Slave SQL thread initialized, starting replication in log 'bin.000375' at position 75471956, relay log './mysql-relay-bin.001426' position: 75472234 140221 3:19:55 [Note] Slave I/O thread: connected to master 'replication@******:3307',replication started in log 'bin.000376' at position 245 140221 3:19:55 [Note] Event Scheduler: Loaded 0 events 140221 3:19:55 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.35-MariaDB' socket: '/var/lib/mysql/mysqld_dbmail.sock' port: 3307

1 0

[Maria-discuss] Codership's Galera patch part of standard MariaDB
by Honza Horak 20 Feb '14

20 Feb '14

Hi guys, my Google-foo is poor today and I can't find any discussion about "inclusion of Codership's Galera patch to standard code-source of MariaDB". I'd like to see that one could just use the wresp plugin and have a working Galera cluster (even if that would mean to introduce new engine) without having another instance of the package. Is that technically possible at all and if so, are there any thoughts like this? Thanks, Honza

4 5

[Maria-discuss] Doubt - replication and ssh/ssl
by Roberto Spadim 19 Feb '14

19 Feb '14

Hi guys, i'm with a doubt... What is better (better = more secure, and with good compression), a ssh tunnel, or a native mariadb ssl connection between master/slave replication mariadb servers? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

2 4

[Maria-discuss] Implementing APPROXIMATE_COUNT(*)
by Tomek R 19 Feb '14

19 Feb '14

Hi, I have realised that whenever I am doing any query and want to count number of rows:SELECT COUNT(*) FROM atable WHERE <complicated condition>; On large tables (>10e6 rows), when the count is >100e3, it takes over a second... even when all the indexes are set up, etc... and with large counts, I have not been able to go below ~<1 s. So I would like to implement APPROXIMATE_COUNT(*) function, which checks, if, for example every 10th, 100th or 1000th row is present in my final output... and based on this statistics, return the approximate number of rows that given query produces. I am using MyISAM engine and would like to do the implementation on it, where the total number of rows is automatically stored. Obviously, it would be useful for anybody dealing with these huge aggregate websites, where users do not really need to know if their keyword search returned 1234567890 results or just 1.2e9 results... Please, can you advise me how to start this project? I.e. whether it's easy to do in SQL or whether I would have to start looking somewhere in the source code of MariaDB? I have plenty of time, programming/SQL experience, but no experience with maria/mysql source code. Tomek

3 2

[Maria-discuss] New Question: Data limit on joins with connect tables?
by AskMonty KB 18 Feb '14

18 Feb '14

Hello, A new question has been asked in "Connect" by benkendrick: -------------------------------- I am attempting run a query against two tables in a remote database with an inner join. These tables reside in a Progress Database. I have used the CONNECT engine via the ODBC connection that I have set up. The first query had 24 columns returned by the query, I got 930 rows as a result. If I reduce the number of columns that I select, the number of rows returned by the database goes up. Even with only two rows select, I only get about 12,000 rows. The total result should be 14,149 rows. I have used the same ODBC connection with LibreOffice Base and received the full number of rows. If I query each table individually, I get the full number of rows (The tables have a 1 to 1 relationship with the current data). I am using MariaDB 10.0.8 32-bit on Windows 7 querying a remote Progress Database. Is there some sort of data limit? I have noticed that the total number of data points (rows multiplied by columns) is between 20,000 and 24,000. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/data-limit-on-joins-with-connect-tables/

1 0

[Maria-discuss] MySQL 5.6 optimizer trace functionality in MariaDB 10?
by Tim Callaghan 17 Feb '14

17 Feb '14

Is this feature or something similar already in MariaDB 10? If not, is it on the roadmap? http://dev.mysql.com/doc/internals/en/optimizer-tracing.html -Tim Callaghan

5 9

[Maria-discuss] Potential participation in Google Summer of Code 2014
by Colin Charles 15 Feb '14

15 Feb '14

Hi! We have applied to be part of the Google Summer of Code 2014 project, and hope to gain some new contributors. If you are on this list and think you can be a mentor for a project, please consider writing a note at: https://mariadb.com/kb/en/google-summer-of-code-2014/ I think the aim for the GSoC students code should be for 10.1 inclusion If you have any queries, don't hesitate to ask me about them, I'm happy to help. Typically mentors need about 4 hours or so per week to assist the student in seeing their project become a reality I encourage many to participate as its a rewarding experience. In 2013, we did participate, and got 3 features out of it: SQL ROLES, PCRE regular expressions, and a Kerberos authentication plugin Looking forward to seeing more happen in 2014! (here's hoping we get accepted into GSoC 2014 of course!) cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

1 0

[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

[Maria-discuss] New Question: CONNECT engine windows
by AskMonty KB 06 Feb '14

06 Feb '14

Hello, A new question has been asked in "CONNECT Table Types" by jpser2: -------------------------------- with mariadb 10.07 installed on windows, how to setup engines, particulary CONNECT engine We do appreciate your effort to produce an efficient product with many engines capabilities, But in your web site communication , it is not obvious that all the soultions exposed ( in particular, ENGINES) are effective, anf it they are : on what OS can they be installed. Thanks for answer -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-engine-windows/

1 0

[Maria-discuss] Connect engine assistance needed with nested first node in XML
by Rasmus Johansson 04 Feb '14

04 Feb '14

Hi, I'm trying to parse GPX files, which are XML with the connect engine. They look like this: <?xml version="1.0" encoding="UTF-8"?> <gpx version="1.1" creator="runtastic - makes sports funtastic, http://www.runtastic.com"> <trk> <trkseg> <trkpt lon="-0.7057708501815800" lat="51.4470825195312003"> <ele>76.6089172363281</ele> <time>2013-08-12T18:17:25.000Z</time> </trkpt> <trkpt lon="-0.7059442996978760" lat="51.4470443725586009"> <ele>72.1513061523437</ele> <time>2013-08-12T18:17:28.000Z</time> </trkpt> <trkpt lon="-0.7059520483016970" lat="51.4470558166503977"> <ele>75.0039749145508</ele> <time>2013-08-12T18:17:30.000Z</time> </trkpt> </trkseg> </trk> </gpx> Once I have the Connect -engine enabled I do the following: create table GPXSource ( lat char(20) field_format='@', lon char(20) field_format='@') engine=CONNECT table_type=XML file_name='/home/rasmus/nodegpxmariadb/public/uploads/runtastic_20130812_2157_Running.gpx' tabname='gpx/trk/trkseg' option_list='rownode=trkpt'; It doesn't work, I cannot figure out how to tell the Connect engine that the data I'm interested is beneath the gpx/trk/trkseg -node (tabname). If I remove the trk and trkseg -nodes from the data and just have the gpx -node left and all trkpt -nodes inside it everything works perfectly. Any help is appriciated. BR, Rasmus -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

3 8

[Maria-discuss] Threadpool benchmarks / feature note
by Colin Charles 01 Feb '14

01 Feb '14

Hi! Svoj: this is MDEV-5533 (https://mariadb.atlassian.net/browse/MDEV-5533) XL: Can you think about doing benchmarks like Ranger has done? (http://www.mysqlperformanceblog.com/2014/01/23/percona-server-improve-scala…) Thanks -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

2 2

[Maria-discuss] New Question: Maximum number of columns
by AskMonty KB 30 Jan '14

30 Jan '14

Hello, A new question has been asked in "MariaDB FAQ" by robpaton: -------------------------------- Hi there, What is the maximum number of columns a row can have in MariaDB? I can't find this info anywhere on the web. Best regards, Rob -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maximum-number-of-columns/

4 7

Re: [Maria-discuss] Threadpool benchmarks / feature note
by Colin Charles 30 Jan '14

30 Jan '14

Hi XL, On 28 Jan 2014, at 18:20, Axel Schwenke <axel(a)mariadb.com> wrote: > Hi Colin, > >> XL: Can you think about doing benchmarks like Ranger has done? (http://www.mysqlperformanceblog.com/2014/01/23/percona-server-improve-scala…) > > I did those benchmarks for 5.5. The r/w benchmark looked much worse than > what Percona has here. That's why I blogged results for readonly workload only. > > But they test with much more data - that might make the difference. I agree > that this benchmark should be repeated with 10.0. http://www.mysqlperformanceblog.com/2014/01/29/percona-server-thread-pool-i… Ranger has now responded (if he's reading this list, Hi!) cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

3 3

[Maria-discuss] GSoC 2014
by Rushi Shukla 30 Jan '14

30 Jan '14

Hello I am a student of Dhirubhai Ambani Institute of Information and Communication Technology (DAIICT), Gandhinagar, India. I am really interested in going for GSoC 2014. I would like to contribute to MariaDB community and for it to be my mentoring organisation for GSoC 2014. I am highly dedicated towards programming and research. How do I get started on working with the source code and playing around with it? Any sort of help is highly appreciated.Awaiting your reply soon. Regards, Rushi Shukla irc : rushboy

2 1

[Maria-discuss] Mariadb upgrade issues
by Constantine 27 Jan '14

27 Jan '14

Recently we migrate to mariadb and every version upgrade failed (last failed from 10.0.6 to 10.0.7). After investigation I find this thread http://mirzmaster.wordpress.com/2009/01/16/mysql-access-denied-for-user-deb… after password update issue fixed. I find bug https://bugs.launchpad.net/maria/+bug/983322 but it marked as incomplete -- With Best Regards, Constantine

2 1

[Maria-discuss] Guidance required
by Rushi Shukla 26 Jan '14

26 Jan '14

Hello I am a student of Dhirubhai Ambani Institute of Information and Communication Technology (DAIICT), Gandhinagar, India. I am really interested in going for GSoC 2014. I would like to contribute to MariaDB community and for it to be my mentoring organisation for GSoC 2014. I am highly dedicated towards programming and research. How do I get started on working with the source code and playing around with it? Any sort of help is highly appreciated.Awaiting your reply soon. Regards, Rushi Shukla

2 1

[Maria-discuss] New Question: Stable release of 10.0
by AskMonty KB 24 Jan '14

24 Jan '14

Hello, A new question has been asked in "What is in the different MariaDB releases?" by pranava: -------------------------------- Hi, In which month there will be a stable release of 10.0? We are using 5.5.34 and want to upgrade to 10.0 but are waiting for a stable release. Thanks Pranav. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/stable-release-of-100/

1 0

[Maria-discuss] New Question: Asynchronous Replication with Galera Cluster ?
by AskMonty KB 24 Jan '14

24 Jan '14

Hello, A new question has been asked in "Galera" by nicolasblanc: -------------------------------- My question is simple. Today i have a Galera Cluster with 3 nodes to write/read. And i want to put one(more to come) slave (asynchronous replication) to the cluster. As all my writes are located on 1 node, it's ok. But if i change the node on which the writes come... My slave is not synchronized anymore. I had to change the master of the slave to have the new written node as master. It seems that each galera node write only transactions from "real client" to replication binary log, not the ones from wsrep. Is there a way that i can ask to a Galera cluster node to always write commited transaction on the replication binary log ? Even if the transaction come from wsrep and not "real client" ? Thx in advance, -- Nicolas Blanc. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/asynchronous-replication-with-galera-cluster/

1 0

[Maria-discuss] Software patent?
by Peter Laursen 24 Jan '14

24 Jan '14

I occasionally found this in a Google search: http://www.google.nl/patents/US8510270 What does this mean? Are anybody able to explain what the patent covers that has not been used in MySQL replication for 10+ years before the patent? Does this mean any restrictions for utilizing binary log information in applications? -- Peter -- Webyog

4 6

[Maria-discuss] mysqltuner
by Reindl Harald 22 Jan '14

22 Jan '14

mysqltuner seems to be no longer maintained while you should not take any recommendation blindly it was really usefull over the years, with MariaDB some values are looking wrong Up for: 3d 17h 7m 44s (15M q [47.927 qps], 477K conn, TX: 33B, RX: 3B) [OK] Query cache efficiency: 48.1% (10M cached / 21M selects) 21M selects out of 15M queries as example :-) it would be pretty cool have a compareable tool (maybe native code) in the MariaDB setup - sadly Bash/PHP are my skills :-( ______________________________________ >> MySQLTuner 1.2.0 - Major Hayden <major(a)mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter your MySQL administrative login: root Please enter your MySQL administrative password: -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.5.34-MariaDB-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 472M (Tables: 4995) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [!!] Total fragmented tables: 141 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 3d 17h 7m 44s (15M q [47.927 qps], 477K conn, TX: 33B, RX: 3B) [--] Reads / Writes: 92% / 8% [--] Total buffers: 1.8G global + 1.8M per thread (500 max threads) [OK] Maximum possible memory usage: 2.6G (26% of installed RAM) [OK] Slow queries: 0% (2/15M) [OK] Highest usage of available connections: 8% (44/500) [OK] Key buffer size / total MyISAM indexes: 256.0M/189.1M [OK] Key buffer hit rate: 100.0% (328M cached / 71K reads) [OK] Query cache efficiency: 48.1% (10M cached / 21M selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 1% (737 temp sorts / 55K sorts) [!!] Joins performed without indexes: 1140 [OK] Temporary tables created on disk: 22% (45K on disk / 201K total) [OK] Thread cache hit rate: 99% (44 created / 477K connections) [OK] Table cache hit rate: 36% (5K open / 14K opened) [OK] Open file limit used: 1% (10K/750K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Adjust your join queries to always utilize indexes Variables to adjust: join_buffer_size (> 1.0M, or always use indexes with joins)

2 2

[Maria-discuss] Statistics/Counters for number SHOW INDEX FROM queries
by Markus Uckelmann 22 Jan '14

22 Jan '14

Hi all, We have a lot of SHOW INDEX FROM queries coming from our ORM layer. Usually there is a mechanism to prevent this but it doesn't seem to work at the moment. To better analyze the problem it would be helpful if we could see how many such queries happened on a server. Is there a counter or a statistic which can provide us this information? We use MariaDB 5.5. Cheers, Shorty

3 4

[Maria-discuss] start mariadb randomly fails or answers with wrong response to systemd
by Reindl Harald 20 Jan '14

20 Jan '14

i have for at least 5 years a backup server with two mysql-instances * one replication instance listening on port 3307 * one "live" service * a script once a hour stop both instances and rsync replication->live * after that start both intances again * looking at the mysqld logs i am pretty sure there is nothing wrong and only the non.zero response causes systemd to restart the daemon one time well, with MariaDB on Fedora 19 systemd cries about failing service at the same time there is nothing in the mysql-errorlog (both instances using the same) the systemd-units are configured to restart the daemon again if it fails what replaces the mysqld_safe scripts and is done this way unchanged since summer 2011 with MySQL 5.5.x has anybody an idea what causes the "mysqld.service" instance to respond with status 1 instead 0 causing systemd to consider the service as failed while there is nothing uncommon in the mysqld-logs? the "Error reading relay log event: slave SQL thread was killed" as well as "Error reading packet from server" are not relevant in that context because they are from the not failing "replication.service" and normal due shutdown the slave (well, i dislike "error" in that context, but that's OT) interesting is that i have 3 machine-pairs with the 100% identical logic two of them are failing this way nearly every hour (backup schedule 60 minutes) while the one with 5000 tables is running perfect all the time any information i could provide additional to the logs and configs below? ___________________________________________________________________________ Jan 7 20:21:04 localhost backups: stop replication service Jan 7 20:21:04 localhost systemd[1]: Stopping MySQL Replication... Jan 7 20:21:04 localhost systemd[1]: Stopped MySQL Replication. Jan 7 20:21:04 localhost backups: stop live database Jan 7 20:21:04 localhost systemd[1]: Stopping MariaDB Database... Jan 7 20:21:04 localhost systemd[1]: Stopped MariaDB Database. Jan 7 20:21:04 localhost backups: backup replication data to '/data/mysql_data/' Jan 7 20:21:04 localhost backups: backup replication data finished Jan 7 20:21:04 localhost backups: start MySQL-Replication-Service Jan 7 20:21:04 localhost systemd[1]: Starting MySQL Replication... Jan 7 20:21:04 localhost systemd[1]: Started MySQL Replication. Jan 7 20:21:04 localhost backups: start MySQL-Live-Service Jan 7 20:21:04 localhost systemd[1]: Starting MariaDB Database... Jan 7 20:21:04 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1 Jan 7 20:21:04 localhost systemd[1]: Failed to start MariaDB Database. Jan 7 20:21:04 localhost systemd[1]: Unit mysqld.service entered failed state. Jan 7 20:21:04 localhost backups: database backup finished Jan 7 20:21:05 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart. Jan 7 20:21:05 localhost systemd[1]: Stopping MariaDB Database... Jan 7 20:21:05 localhost systemd[1]: Starting MariaDB Database... Jan 7 20:21:06 localhost systemd[1]: Started MariaDB Database. ___________________________________________________________________________ 140107 20:21:04 [Note] /usr/libexec/mysqld: Normal shutdown 140107 20:21:04 [Note] Event Scheduler: Purging the queue. 0 events 140107 20:21:04 [Note] Error reading relay log event: slave SQL thread was killed 140107 20:21:04 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 140107 20:21:04 [Note] Slave I/O thread killed while reading event 140107 20:21:04 [Note] Slave I/O thread exiting, read up to log 'bin.000002', position 245 140107 20:21:04 [Note] /usr/libexec/mysqld: Shutdown complete 140107 20:21:04 [Note] /usr/libexec/mysqld: Normal shutdown 140107 20:21:04 [Note] Event Scheduler: Purging the queue. 0 events 140107 20:21:04 [Note] /usr/libexec/mysqld: Shutdown complete 140107 20:21:04 [Note] Plugin 'InnoDB' is disabled. 140107 20:21:04 [Note] Plugin 'FEDERATED' is disabled. 140107 20:21:04 [Note] Plugin 'FEEDBACK' is disabled. 140107 20:21:04 [Note] Plugin 'InnoDB' is disabled. 140107 20:21:04 [Note] Plugin 'FEDERATED' is disabled. 140107 20:21:04 [Note] Plugin 'FEEDBACK' is disabled. 140107 20:21:04 [Note] Event Scheduler: Loaded 0 events 140107 20:21:04 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.34-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 0 thelounge 140107 20:21:04 [Note] Event Scheduler: Loaded 0 events 140107 20:21:04 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.34-MariaDB' socket: '/var/lib/mysql/mysql_replication.sock' port: 0 thelounge 140107 20:21:04 [Note] Slave SQL thread initialized, starting replication in log 'bin.000002' at position 245, relay log './mysql-relay-bin.000016' position: 523 140107 20:21:04 [Note] /usr/libexec/mysqld: Normal shutdown 140107 20:21:04 [Note] Event Scheduler: Purging the queue. 0 events 140107 20:21:04 [Note] /usr/libexec/mysqld: Shutdown complete 140107 20:21:04 [Note] Slave I/O thread: connected to master 'replication@masterserver:3306',replication started in log 'bin.000002' at position 245 140107 20:21:05 [Note] Plugin 'InnoDB' is disabled. 140107 20:21:05 [Note] Plugin 'FEDERATED' is disabled. 140107 20:21:05 [Note] Plugin 'FEEDBACK' is disabled. 140107 20:21:05 [Note] Event Scheduler: Loaded 0 events 140107 20:21:05 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.34-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 0 thelounge ___________________________________________________________________________ /usr/lib/systemd/system/mysqld.service [Unit] Description=MariaDB Database Before=postfix.service dovecot.service dbmail-imapd.service dbmail-lmtpd.service dbmail-pop3d.service dbmail-postfix-policyd.service [Service] Type=simple PIDFile=/var/run/mysqld/mysqld.pid ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --open-files-limit=750000 --basedir=/usr --user=mysql ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID Restart=always RestartSec=1 TimeoutSec=300 LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 SysVStartPriority=64 PrivateTmp=true CapabilityBoundingSet=~CAP_SYS_PTRACE ReadOnlyDirectories=/etc ReadOnlyDirectories=/usr InaccessibleDirectories=/boot InaccessibleDirectories=/home InaccessibleDirectories=/root Restart=always InaccessibleDirectories=/usr/local/scripts InaccessibleDirectories=/var/lib/rpm InaccessibleDirectories=/var/lib/yum InaccessibleDirectories=/var/spool [Install] WantedBy=multi-user.target ___________________________________________________________________________ /usr/lib/systemd/system/replication.service [Unit] Description=MySQL Replication [Service] Type=simple PIDFile=/var/run/mysqld/mysqld_replication.pid ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my-replication.cnf --pid-file=/var/run/mysqld/mysqld_replication.pid --socket=/var/lib/mysql/mysql_replication.sock --open-files-limit=30000 --basedir=/usr --user=mysql Restart=always RestartSec=1 TimeoutSec=300 LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 SysVStartPriority=64 PrivateTmp=true CapabilityBoundingSet=~CAP_SYS_PTRACE ReadOnlyDirectories=/etc ReadOnlyDirectories=/usr InaccessibleDirectories=/boot InaccessibleDirectories=/home InaccessibleDirectories=/root InaccessibleDirectories=/usr/local/scripts InaccessibleDirectories=/var/lib/rpm InaccessibleDirectories=/var/lib/yum InaccessibleDirectories=/var/spool [Install] WantedBy=multi-user.target

2 5

[Maria-discuss] Top voted features for MariaDB 10.1
by Rasmus Johansson 19 Jan '14

19 Jan '14

Hi, Yesterday Daniel Bartholomew published a blog post about voting for features in MariaDB 10.1, https://blog.mariadb.org/what-do-you-want-to-see-in-mariadb-10-1/ . To make it easier to follow which the most wanted (most votes) features are I pulled together a list in JIRA for anyone interested. It can be found here https://mariadb.atlassian.net/secure/Dashboard.jspa?selectPageId=11500 . The page doesn't require login, but if you want to vote you need to log in. BR, Rasmus -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

2 1