- discuss - lists.mariadb.org

[Maria-discuss] New Question: How to define a role for a particular set of users
by AskMonty KB 18 Sep '13

18 Sep '13

Hello, A new question has been asked in "MariaDB community" by lucky7456969: -------------------------------- create role xxx.GM WITH ADMIN CURRENT_USER; here xxx is the schema name I get syntax error out of it. Could anyone shed some lights on this? Thanks Jack -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-define-a-role-for-a-particular-set-of-users/

1 0

[Maria-discuss] New Question: OPTIMIZE my.cnf
by AskMonty KB 17 Sep '13

17 Sep '13

Hello, A new question has been asked in "MariaDB FAQ" by cmejia_22: -------------------------------- I need help for optimize my.cnf what parameters are important and the optimal values? I have a server with 8 core, 64 GB Memory, raid 10 and engine=innodb Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/optimize-mycnf/

1 0

[Maria-discuss] MariaDB 5.5.33 Now Available
by Daniel Bartholomew 17 Sep '13

17 Sep '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.33. This release features the addition of TokuDB as an additional storage engine option. There are also bug and other fixes. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.33 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-5533-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5533-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.33 Overview of MariaDB 5.5: https://mariadb.com/kb/en/what-is-mariadb-55 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - 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 (my.ini on Windows) 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 MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - 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 Knowledgebase - http://mariadb.com/kb

1 0

[Maria-discuss] Doubts about Thread Pool
by Roberto Spadim 16 Sep '13

16 Sep '13

Hi guys, I'm testing threadpool on windows with mariadb 10.0.4 I'm running server with this command line: C:\Program Files\mariadb-10.0.4-win32\bin>mysqld --datadir=..\data\ --log_error=..\log --port=3306 --thread_pool_max_threads=3 Now I'm connected with 10 clients: 2rootlocalhost:41859mysqlSleep50.0003rootlocalhost:41860Sleep180.0004root localhost:41861Sleep130.0005rootlocalhost:41862Sleep110.0006root localhost:41867Sleep170.0007rootlocalhost:41955Sleep90.0008root localhost:41966Sleep40.0009rootlocalhost:41969Query0initshow processlist 0.00010rootlocalhost:42029Sleep90.00011rootlocalhost:42032Sleep40.000 *generated 2013-09-15 22:02:41 by HeidiSQL 8.0.0.4464<http://www.heidisql.com/> * My question is... how i know what thread pool is running each connection? -- Roberto Spadim SPAEmpresarial

2 3

[Maria-discuss] New Question: Migrating from MySql: MariaDB server closing client connections unexpectedly
by AskMonty KB 16 Sep '13

16 Sep '13

Hello, A new question has been asked in "General FAQ" by vivek_kubaji: -------------------------------- We in the process of migrating from MySql to MariaDB due to licensing/commercial usage reasons. We have successfully replaced the MySql connector jar with MariaDB client jar (first change) and are now trying to replace MySql server with MariaDB server without changing the data files. All our applications run perfectly for about 8-12 hours after which we see the following exception: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326) at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:494) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:315) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:257) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209) at $Proxy4.getMessageCountByStatus(Unknown Source) at com.onmobile.cmfweb.monitoring.CmfMessagesMonitor.getMessageCounts(CmfMessagesMonitor.java:56) at sun.reflect.GeneratedMethodAccessor625.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:270) at com.onmobile.cmfshare.MethodInvockingBean.invoke(MethodInvockingBean.java:28) at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:212) at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:79) at org.quartz.core.JobRunShell.run(JobRunShell.java:203) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to localhost:3306: unexpected end of stream, read 0bytes from 4 at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:136) at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at org.mariadb.jdbc.Driver.connect(Driver.java:114) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:544) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423) ... 21 more Caused by: org.mariadb.jdbc.internal.common.QueryException: Could not connect to localhost:3306: unexpected end of stream, read 0bytes from 4 at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:509) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:669) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.<init>(MySQLProtocol.java:264) at org.mariadb.jdbc.Driver.connect(Driver.java:110) ... 28 more Caused by: java.io.EOFException: unexpected end of stream, read 0bytes from 4 at org.mariadb.jdbc.internal.common.packet.buffer.ReadUtil.readFully(ReadUtil.java:84) at org.mariadb.jdbc.internal.common.packet.buffer.ReadUtil.readFully(ReadUtil.java:92) at org.mariadb.jdbc.internal.common.packet.RawPacket.nextPacket(RawPacket.java:77) at org.mariadb.jdbc.internal.common.packet.SyncPacketFetcher.getRawPacket(SyncPacketFetcher.java:67) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:467) ... 31 more The exceptions disappear if MySql server is used again. >From what I have debugged so far MariaDB server is closing the client connections for some reason. I initially suspected of idle connections but we are using Hibernate configurations like 'testOnBorrow' so it shouldn't be the case. Can anyone help us to find out the cause for this and help us fix the problem? Is there any specific configuration in MariaDB that I should be doing? I've even run our applications by increasing the value of the param 'interactive_timeout' in the MariaDB server but it did not help. Btw, we are using Spring-Hibernate and pooling our connections using Commons-pool jar. Any kind of help will be deeply appreciated. PS: The same question is also posted in 'stackoverflow'. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/migrating-from-mysql-mariadb-server-closing-client…

1 0

[Maria-discuss] New Question: Optimize Aria
by AskMonty KB 14 Sep '13

14 Sep '13

Hello, A new question has been asked in "Aria" by subjakt: -------------------------------- When I want to use aria I need to configure the standard myisam variables in my my.ini or something new ? like aria_key_buffer_size or I dont know :)? I hope you understand... -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/optimize-aria/

1 0

[Maria-discuss] New Question: How to install MariaDB rpms in CentOS 6.4 using rpm (not yum cmd) + handling mysql-libs conflicts
by AskMonty KB 14 Sep '13

14 Sep '13

Hello, A new question has been asked in "MariaDB community" by theone: -------------------------------- I need to script the install of MariaDB using the rpm command in CentOS 6.4. I can't use yum since it's gong to be an offline install so there's no live access to the repository. The only MySQL package installed is mysql-libs as various other packages depend on it. When I did a test install of MariaDB with yum using the command: yum install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared It correctly accounted for mysql-libs and uninstalled it at the end as MariaDB could handle the dependencies after it was installed: Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package MariaDB-client.x86_64 0:5.5.32-1 will be installed ---> Package MariaDB-common.x86_64 0:5.5.32-1 will be installed ---> Package MariaDB-compat.x86_64 0:5.5.32-1 will be obsoleting ---> Package MariaDB-devel.x86_64 0:5.5.32-1 will be installed ---> Package MariaDB-server.x86_64 0:5.5.32-1 will be installed ---> Package MariaDB-shared.x86_64 0:5.5.32-1 will be obsoleting ---> Package mysql-libs.x86_64 0:5.1.66-2.el6_3 will be obsoleted --> Finished Dependency Resolution Dependencies Resolved ==================================================================================================================================================================== Package Arch Version Repository Size ==================================================================================================================================================================== Installing: MariaDB-client x86_64 5.5.32-1 mariadb 10 M MariaDB-common x86_64 5.5.32-1 mariadb 23 k MariaDB-compat x86_64 5.5.32-1 mariadb 2.7 M replacing mysql-libs.x86_64 5.1.66-2.el6_3 MariaDB-devel x86_64 5.5.32-1 mariadb 5.6 M MariaDB-server x86_64 5.5.32-1 mariadb 34 M MariaDB-shared x86_64 5.5.32-1 mariadb 1.1 M replacing mysql-libs.x86_64 5.1.66-2.el6_3 Transaction Summary My question is, what is the equivalent way to install the MariaDB packages using the rpm command only as opposed to yum? If I do rpm -ivh MariaDB*.rpm, I will get a ton of messages like the following about conflicts with mysql-libs: file /etc/my.cnf from install of MariaDB-common-5.5.32-1.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64 file /usr/share/mysql/charsets/Index.xml from install of MariaDB-common-5.5.32-1.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64 I used the --force option to install and then uninstalled mysql-libs and didn't get any weird messages but I'm not sure that is the cleanest method to handle the conflicts. So can someone confirm that installing MariaDB with the following rpm commands would be the same as using yum to install the packages and handle mysql-libs conflicts/removal: rpm -ivh --force MariaDB*.rpm rpm -e mysql-libs Thanks for any input! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-install-mariadb-rpms-in-centos-64-using-rpm…

1 0

[Maria-discuss] New Question: Replication stops after one hour or so
by AskMonty KB 11 Sep '13

11 Sep '13

Hello, A new question has been asked in "Replication" by Martin22: -------------------------------- Hi there, we operate a big MariaDB-server (24 CPUs, 48 GB RAM, Version 5.5.32 with Percona XTRADB). Because it is mission-critical it is replicated to another server of similar size (row based replication). We get the ball rolling with "innobackupex" (GREAT tool to clone a life server). After setting the slave to its coordinates it starts up, catches up to the master (times behind = 0) and all is well. For an hour. Or four. Or two days. Then the slave suddenly stops executing the masters binlog. There are no errors logged. I checked the binlog and relaylog on master and slave around the last log entry processed and can't find anything strange. I'm at a total loss. I can't say that I'm an MySQL or MariaDB specialist, so I'd like to reach out to this community in order to get some idea what's happening. Anybody got an idea? Thanks in advance! Best regards Martin Trenz, Soquero GmbH, Frankfurt, Germany -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/replication-stops-after-one-hour-or-so/

2 1

[Maria-discuss] MariaDB Java Client 1.1.4 Released
by Daniel Bartholomew 10 Sep '13

10 Sep '13

The MariaDB project is pleased to announce the immediate availability of the MariaDB Java Client 1.1.4. This is a Stable (GA) release. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Java Client 1.1.4 - Release Notes: https://mariadb.com/kb/en/mariadb-java-client-114-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-java-client-114-changelog/ - Downloads: https://downloads.mariadb.org/client-java/1.1.4/ Overview of the MariaDB Java Client: https://kb.askmonty.org/en/about-the-mariadb-java-client/ - - 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 MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: Unable to get pdo_mysql to work with CentOS 6 and MariaDB 5.5.32
by AskMonty KB 10 Sep '13

10 Sep '13

Hello, A new question has been asked in "Client libraries" by Ruskicowboy: -------------------------------- I just installed from YUM the MariaDB-server and MariaDB-client. These are the packages installed: compat-mysql55.x86_64 MariaDB-client.x86_64 MariaDB-common.x86_64 MariaDB-compat.x86_64 MariaDB-server.x86_64 MariaDB-shared.x86_64 But when trying to run a PHP script that uses PDO (which worked with MySQL 5.5), I get this error: PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pdo_mysql.so' - /usr/lib64/php/modules/pdo_mysql.so: symbol mysql_options, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference in Unknown on line 0 I have searched Google and here quite a bit but can't seem to find the answer. Any help would be greatly appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-get-pdo_mysql-to-work-with-centos-6-and-…

1 0