January 2014 - discuss - lists.mariadb.org

[Maria-discuss] InnoDB pain points
by Jan Lindström 14 Apr '14

14 Apr '14

Hi all, I would like to know the most affecting InnoDB pain points the customers/potential customers first refer. By pain point, I mean anything that causes concerns, restricts sales etc, pain point can be bug, missing feature, usage problem, performance etc. My goal on asking this question is to find out what are the real issues customers or potential customer are struggling or issues that block customers using MariaDB. After that I will see what I can do about the situation and plan forward to address the raised issues with proper priorities. Dean, if this list does to reach the support engineers and technical sales teams please forward to more suitable list. R: Jan -- Jan Lindström Principal Engineer 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>

14 24

[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] 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] 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