- discuss - lists.mariadb.org

[Maria-discuss] New Question: Support for non autoincrement kes
by AskMonty KB 28 Jun '14

28 Jun '14

Hello, A new question has been asked in "Archive" by openiduser42: -------------------------------- This documentation says "ARCHIVE allows a maximum of one key. The key can be a PRIMARY KEY on an AUTO_INCREMENT column. However, it has a limitation ...". This sounds like AUTO_INCREMENT is an optional setting that causes a limitation, but trying to create an archive without auto increment gives an error: CREATE TABLE t1 (id int NOT NULL, PRIMARY KEY (id)) ENGINE = ARCHIVE; Error: Can't create table `test`.`t1` (errno: 140 "Wrong create options") Just adding AUTO_INCREMENT solves the problem. So, is this a bug or AUTO_INCREMENT is mandatory for ARCHIVE tables? If so, the documentation should say MUST, not CAN. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/support-for-non-autoincrement-kes/

1 0

[Maria-discuss] New Question: Connect Spring Hibernate and C3p0 application to Mariadb through SSL certificate authentication.
by AskMonty KB 25 Jun '14

25 Jun '14

Hello, A new question has been asked in "MariaDB FAQ" by ashishjagtap: -------------------------------- I have created application in Spring,Hibernate and c3p0 which is now connecting to Mysql database. now we are migrating our application to MariaDB (Server version: 5.5.5-10.0.7-MariaDB Source distribution) through SSL. following is the configuration file that we are using to connect to Mysql database JDBC.properties jdbc.initialPoolSize=10 jdbc.maxPoolSize=30 jdbc.minPoolSize=5 jdbc.acquireIncrement=3 jdbc.acquireRetryAttempts=0 jdbc.preferredTestQuery=SELECT 1 jdbc.idleConnectionTestPeriod=600 jdbc.numHelperThreads=10 jdbc.debugUnreturnedConnectionStackTraces=true jdbc.mydbUrl=jdbc:mysql://myhost.com:3306/mydb?verifyServerCertificate=true&useSSL=true&requireSSL=true&characterEncoding=utf8 jdbc.mydbUsername=myuser datasource-context.xml <bean id="mydbCommon" class="com.mchange.v2.c3p0.ComboPooledDataSource" abstract="true" destroy-method="close"> <property name="driverClass" value="${jdbc.rptdbDriverClassName}"/>  <property name="initialPoolSize" value="${jdbc.initialPoolSize}"/> <property name="maxPoolSize" value="${jdbc.maxPoolSize}"/> <property name="minPoolSize" value="${jdbc.minPoolSize}"/> <property name="acquireIncrement" value="${jdbc.acquireIncrement}"/> <property name="acquireRetryAttempts" value="${jdbc.acquireRetryAttempts}"/> <property name="preferredTestQuery" value="${jdbc.preferredTestQuery}"/> <property name="idleConnectionTestPeriod" value="${jdbc.idleConnectionTestPeriod}"/> <property name="numHelperThreads" value="${jdbc.numHelperThreads}"/> <property name="debugUnreturnedConnectionStackTraces" value="${jdbc.debugUnreturnedConnectionStackTraces}"/> </bean> <bean id="mydb" parent="mydbCommon"> <property name="jdbcUrl" value="${jdbc.mydbUrl}"/> <property name="user" value="${jdbc.mydbUsername}"/> </bean> we are able to connect to DB server through command line using following command mysql -h myhost.com -P3306 -umyuser --ssl-ca ca.crt --ssl-cert app.crt --ssl-key my-key.key now how can I specify --ssl-ca,--ssl-cert and --ssl-cert files while connecting to MariaDB through Hibernate and c3p0. or what is the steps to connect to MariaDB database through SSL using c3p0 and hibernate. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-spring-hibernate-and-c3p0-application-to-m…

1 0

[Maria-discuss] New Question: MariaDB Galera 10 stable?
by AskMonty KB 25 Jun '14

25 Jun '14

Hello, A new question has been asked in "Galera" by massimilianoadamo: -------------------------------- I am using MariaDB-Galera 10 on preprod & test environments and I haven't seen any problem so far. Any chance to see a so-called stable version? Hurry up: Percona XtraDB Cluster 5.6 is out from quite long time... -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera-10-stable/

1 0

[Maria-discuss] User feedback statistics
by Colin Charles 21 Jun '14

21 Jun '14

Hi, http://mariadb.org/feedback_plugin/ in question -- where do we find out information about storage engines in use? List of loaded plugins? So far I see: http://mariadb.org/feedback_plugin/stats/features/ - which has some information but clearly not all information Can we also get access to all the information like if people are using the threadpool or not? I know that information is generated and we're receiving it, but we're just not exposing it (I mean I see this from SELECT * FROM information_schema.feedback;) Its also a good way to see if users are using something like the PERFORMANCE_SCHEMA Let me know how one can access this information (and even better how this can be exposed in the web interface) cheers, -colin -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

3 3

[Maria-discuss] New MariaDB book: Building a Web Application with PHP and MariaDB
by Daniel Bartholomew 18 Jun '14

18 Jun '14

I just received an email from Packt about a new MariaDB book they've just published, Building a Web Application with PHP and MariaDB: A Reference Guide, by Sai Srinivas Sriparasa. If you're interested, check it out: http://www.packtpub.com/building-a-web-application-with-php-and-mariadb/book I was not aware that this book was in the works, so it was a nice surprise! I'm going to pick up a copy, give it a look through, and write up a review on my personal blog. It's been a looong time since I've done anything with PHP (over ten years), so I won't have a lot to say about that part of the content, but I'm reasonably current with MariaDB. ;-) Thanks. -- Daniel Bartholomew, MariaDB Release Manager MariaDB | http://mariadb.com

1 0

[Maria-discuss] Easy way to see different users@hosts connected to all databases?
by Tanstaafl 18 Jun '14

18 Jun '14

Is there a simple command I can issue to see a list of the current users@hosts connected to all of the databases of a running mariadb server? I'm trying to troubleshoot a problem where an update from 5.5.30 to 5.5.37 recently caused all of the connections from my groupware host to start coming from a different hostname, and so were being denied. I need to be able to see if changes that I make change the hostname being used. Thanks, Charles

3 5

[Maria-discuss] New Question: Does Mariadb has a comparison with PostgreSQL ?
by AskMonty KB 18 Jun '14

18 Jun '14

Hello, A new question has been asked in "MariaDB Documentation" by mayuraviraj: -------------------------------- PostgreSQL maintain a page which compare it with MySQL (https://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing…) Why not mariadb maintain a such information ? It will be very valuable for DBAs and developers ? Also I think it will help mariadb to evolve in certain new areas with the light of PostgreSQL. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/does-mariadb-has-a-comparison-with-postgresql/

1 0

[Maria-discuss] fusion io
by Daniel Black 18 Jun '14

18 Jun '14

Hi, I'm trying to get innodb_use_atomic_writes = 1 working on an ext4 on top of LVM on a ioDrive device with a RHEL6 kernel 2.6.32-358.6.2.el6.x86_64 and getting the following error. Which bit(s) need to change to get it working? 140611 7:43:46 InnoDB: Operating system error number 25 in a file operation. InnoDB: Error number 25 means 'Inappropriate ioctl for device'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html InnoDB: File name ./ibdata1 InnoDB: File operation call: 'ioctl'. InnoDB: Error in opening ./ibdata1 -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

5 7

Re: [Maria-discuss] fusion io
by Dhananjoy Das 17 Jun '14

17 Jun '14

+ Torben, Dan Hello, DirectFS name has been deprecated and the new name for the Flash aware filesystem from Fusion-io is NVMFS (NonVolatile Memory FileSystem). NVMFS a fully POSIX compliant filesystem is currently in EA (early access) and can be obtained by signup for the program (by reaching out to Torben/Dan cc-ed ). Please note NVM Compression (page-compression) solution stack uses POSIX interfaces only, and is not “directly" dependent on opennvm intrefaces. Thanks, Joy Dhananjoy Das Architect Sr.,| Office: 408.416.5816 Cell: 408.596.1533 | Email: ddas(a)fusionio.com<mailto:gkerr@fusionio.com> Check out some brief videos: A Brief History of NAND Flash Storage<http://www.youtube.com/watch?v=w-_Hr5f7QHw> Whiteboarding with the Woz: Virtualization, the Basics<http://www.youtube.com/watch?v=fY3yVElwz5g&list=PLYp8b4bSLEi-qyQBiGFBkHv80o…> [cid:BD491E35-4252-4A52-8DC1-DB493990901B] From: Nirbhay Choubey <nirbhay(a)skysql.com<mailto:nirbhay@skysql.com>> Date: Tuesday, June 17, 2014 at 5:20 AM To: Colin Charles <colin(a)mariadb.org<mailto:colin@mariadb.org>> Cc: Callaghan Mark <mdcallag(a)gmail.com<mailto:mdcallag@gmail.com>>, Fusion-io Admin <ddas(a)fusionio.com<mailto:ddas@fusionio.com>>, MariaDB discuss <maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net>> Subject: Re: [Maria-discuss] fusion io Hi, On Tue, Jun 17, 2014 at 7:02 AM, Colin Charles <colin(a)mariadb.org<mailto:colin@mariadb.org>> wrote: Hi Mark, On 14 Jun 2014, at 00:44, MARK CALLAGHAN <mdcallag(a)gmail.com<mailto:mdcallag@gmail.com>> wrote: > Where can directFS be downloaded? This is open source, right? > >From what I gather, there is a public API to this called OpenNVM (http://opennvm.github.io/). But the short answer is that directfs/nvmfs isn't opensource - you only get this if you have a fusion-io card Found this in one of the fusion-io's blogs : " We plan to release directFS as an open source file system to demonstrate the usage and benefits of native interfaces." http://www.fusionio.com/blog/under-the-hood-of-the-iomemory-sdk Best, Nirbhay Fusion-io itself is a commercial product, so nvmfs/directfs is likely from them only (and is probably closed source). I take it others can implement it, but haven't (yet?) ? MariaDB's initial implementation of it is here: http://lists.askmonty.org/pipermail/commits/2013-March/004529.html (and I presume this was then ported to Percona Server as well -- http://www.percona.com/doc/percona-server/5.6/performance/atomic_fio.html) It seems the magic is at: #define DFS_IOCTL_ATOMIC_WRITE_SET _IOW(0x95, 2, uint) I found a presentation that talks about it (nothing about the filesystem itself being opensource): http://www.slideshare.net/fusionio/perconalive-accelerating-mysql-in-open-s… And for reference some older blog posts: https://blog.mariadb.org/significant-performance-boost-with-new-mariadb-pag… https://blog.mariadb.org/mariadb-introduces-atomic-writes/ And attached for brevity, is a short chat I had with Jan Lindström who works on the fusion-io code now: 11:42 < bytee> jplindst: our fusion-io work, is based on the open APIs at http://opennvm.github.io/ correct? 11:46 < jplindst> bytee: To be totally honest, I have no idea what are the API at the http page you mentioned, I have used standard POSIX interfaces to access FusionIO storage, thus you will need FusionIO SSD card and NVMFS file system 11:47 < bytee> jplindst: nvmfs file system - where does one get it ? from fusion-io ? 11:47 < jplindst> bytee: FusionIO card is naturally commercial product, nvmfs to current my understanding does not work with any other device 11:48 < bytee> jplindst: ok, likely because others haven't implemented it 11:48 < jplindst> bytee: correct 11:49 < jplindst> bytee: If you have the card you should have the file system module 11:50 < bytee> jplindst: thanks 11:51 < jplindst> bytee: Last time we did discuss with FusionIO the actual file system was not yet open source 11:51 < jplindst> bytee: not sure if that has been changed now that announcements are out 11:51 < bytee> jplindst: doubt there is, from what i gathere I hope this helps cheers, -colin > > On Tue, Jun 10, 2014 at 5:18 PM, Daniel Black <daniel.black(a)openquery.com<mailto:daniel.black@openquery.com>> wrote: > > Thanks Colin. Missed that line of the doco and/or assumed it was a capability of another file-system. > > > ----- Original Message ----- > > Special ioctl doesn't work unless you use directfs (you're using > > ext4); see: > > https://mariadb.com/kb/en/fusionio-directfs-atomic-write-support/ > > > > On Wednesday, 11 June 2014, Daniel Black < daniel.black(a)openquery.com<mailto:daniel.black@openquery.com> > > > wrote: > > > > > > > > Hi, > > > > I'm trying to get innodb_use_atomic_writes = 1 working on an ext4 on > > top of LVM on a ioDrive device with a RHEL6 kernel > > 2.6.32-358.6.2.el6.x86_64 > > > > and getting the following error. Which bit(s) need to change to get it > > working? > > > > > > 140611 7:43:46 InnoDB: Operating system error number 25 in a file > > operation. > > InnoDB: Error number 25 means 'Inappropriate ioctl for device'. > > InnoDB: Some operating system error numbers are described at > > InnoDB: > > http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html > > InnoDB: File name ./ibdata1 > > InnoDB: File operation call: 'ioctl'. > > InnoDB: Error in opening ./ibdata1 > > > > -- > > -- > > Daniel Black, Engineer @ Open Query ( http://openquery.com.au ) > > Remote expertise & maintenance for MySQL/MariaDB server environments. > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~maria-discuss > > Post to : maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net> > > Unsubscribe : https://launchpad.net/~maria-discuss > > More help : https://help.launchpad.net/ListHelp > > -- > -- > Daniel Black, Engineer @ Open Query (http://openquery.com.au) > Remote expertise & maintenance for MySQL/MariaDB server environments. > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net> > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > > > > -- > Mark Callaghan > mdcallag(a)gmail.com<mailto:mdcallag@gmail.com> -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201<tel:%2B6-012-204-3201> | Skype: colincharles _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp This e-mail (and any attachments) is confidential and may be privileged. Any unauthorized use, copying, disclosure or dissemination of this communication is prohibited. If you are not the intended recipient, please notify the sender immediately and delete all copies of the message and its attachments.

1 0

[Maria-discuss] MariaDB 10.0.12 now available
by Daniel Bartholomew 16 Jun '14

16 Jun '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.12 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.12 - Release Notes: https://mariadb.com/kb/en/mariadb-10012-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10012-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.12 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. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 10.0. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database 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 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