- discuss - lists.mariadb.org

[Maria-discuss] 5.5 versus 10.0/5.6 performance issues
by Puff, Werner 03 Jul '13

03 Jul '13

Because of performance issues with our DBMS we recently decided to migrate our software to MySQL or one of its forks. We would prefer MariaDB. We created a performance test suite so that we are sure to make the right decision. Beside other values our test measured the average workflow processing time including multiple database transactions. The unexpected outcome was, that we had a big difference in the processing times between 5.5 and 5.6 based databases. average-time [ms] (lower = better) MySQL 5.6 233 Percona 5.6pre 208 MariaDB 10alpha 194 MariaDB 5.5 1248 MySQL 5.5 993 (Firebird 2.5 9694) We are bound to very special hardware, the biggest bottleneck there is USB-stick based storage (cannot be changed for now). Our interpretation of the results and the research we were doing so far is, that the changes within InnoDB/XtraDB storage engine in connection with our "very special" storage solution causes this differences. Can anybody confirm that the changes had a high impact on storage mediums with slow access rates? Or does anybody have an idea if it possible to optimize MariaDB 5.5 (we would like to go with MariaDB) to get the same performance with MySQL 5.6?

3 4

[Maria-discuss] Mysql resource limits.
by Rafał Radecki 02 Jul '13

02 Jul '13

Hi All. I would like to limit resources available to a given user in mysql. I know that there is https://dev.mysql.com/doc/refman/5.5/en/user-resources.html, I also know that cgroups can be used at operating system level. What are your experiences in limiting resources in mysql? I've used percona statistics and had information provided by it. Are there any better solutions? Best regards, Rafal Radecki.

1 0

[Maria-discuss] New Question: Local state seqno out of sync with group
by AskMonty KB 02 Jul '13

02 Jul '13

Hello, A new question has been asked in "Galera" by uxbod: -------------------------------- We have MariaDB and Galera working in our lab on a three node cluster. When setting them up the wsrep options for each node were as follows: {{{ node1: wsrep_cluster_address="gcomm://" node2: wsrep_cluster_address="gcomm://172.30.1.3" node3: wsrep_cluster_address="gcomm://172.30.1.1" }}} Once all the nodes were in sync I shutdown node1 and set its wsrep_cluster_address to be 172.30.1.2. This I thought would allow the three nodes to keep in sync. What happened though was when I started MariaDB backup I received the error: {{{ 130702 8:35:51 [ERROR] WSREP: Local state seqno (16053) is greater than group seqno (15898): states diverged. Aborting to avoid potential data loss. Remove '/var/lib/mysql//grastate.dat' file and restart if you wish to continue. (FATAL) at galera/src/replicator_str.cpp:state_transfer_required():34 }}} Why has this happened ? Is it safe to proceed with the recommendation of removing grastate.dat ? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/local-state-seqno-out-of-sync-with-group/

1 0

[Maria-discuss] New Question: xtrabackup sync method
by AskMonty KB 30 Jun '13

30 Jun '13

Hello, A new question has been asked in "Galera" by uxbod: -------------------------------- Hello, have installed Maria on Centos 6.4 x86_64: MariaDB-common-5.5.31-1.x86_64 MariaDB-Galera-server-5.5.29-1.x86_64 MariaDB-compat-5.5.31-1.x86_64 MariaDB-client-5.5.31-1.x86_64 and the primary node is working fine with the configuration: [mysqld] wsrep_provider=/usr/lib64/galera/libgalera_smm.so wsrep_cluster_name="MYCLUSTER" wsrep_node_name=db1 wsrep_cluster_address="gcomm://" wsrep_slave_threads=8 wsrep_sst_method=xtrabackup wsrep_sst_auth=username:password wsrep_node_address=172.30.10.13 datadir=/var/lib/mysql innodb_autoinc_lock_mode=2 The problem is on the second node when it tries to replicate as receiving the error: 130629 8:55:17 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_xtrabackup --role 'joiner' --address '172.30.10.18' --auth 'username:password' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '7131' Read: 'Can't find innobackupex in the path' yet innobackupex is indeed within the path. What could the issue be please ? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/xtrabackup-sync-method/

1 0

[Maria-discuss] New Question: How can I install MariaDB C Client on Fedora 17/18 or CentOS 6.* without uninstalling MySQL
by AskMonty KB 29 Jun '13

29 Jun '13

Hello, A new question has been asked in "MariaDB Client Library for C" by aesterkin: -------------------------------- Hello, I need to install only client libraries without uninstalling MySQL. How can I do it? I tries installing from your YUM repository, but this installation conflicts with mysql-libs and mysql-server pachages (from "remi" repository). Thanks, Alex Esterkin -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/how-can-i-install-mariadb-c-client-on-fedora-1718…

1 0

[Maria-discuss] New Question: Is it possible to specify a user, password, and non standard port for the thrift servers?
by AskMonty KB 28 Jun '13

28 Jun '13

Hello, A new question has been asked in "Cassandra Storage Engine" by frankflynn: -------------------------------- In the Cassandra examples we see: set cassandra_default_thrift_host='192.168.0.10' and then create table cassandra_tbl ( rowkey type PRIMARY KEY, ... thrift_host= can also be specified here But is it currently possible to specify a user, password, and/or a non standard port? I've removed the user and password and tried thrift_host='192.168.0.10:9161' (using my particular IP) but that does not seem to work. The error I get is: ERROR 1429 (HY000): Unable to connect to foreign data source: Could not resolve host for client socket. [1] I can connect to this host / port from the command line. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/is-it-possible-to-specify-a-user-password-and-non…

1 0

[Maria-discuss] New Question: zip or msi
by AskMonty KB 28 Jun '13

28 Jun '13

Hello, A new question has been asked in "What is in the different MariaDB releases?" by Swirl: -------------------------------- Why is the "zip" that much bigger than the "msi"? Does it contain more info/code/tools or whatever? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/zip-or-msi/

2 1

[Maria-discuss] New Question: Changing location of database
by AskMonty KB 28 Jun '13

28 Jun '13

Hello, A new question has been asked in "MariaDB community" by mdavies5: -------------------------------- Using 5.5.31 on Linux Mint. By default datadir is /var/lib/mysql. Like most users I do not want my data on my boot drive so I moved it to a different physical drive which is always mounted. I then stopped server, reset the basedir in my.cnf and restarted. No problem. After a reboot the log shows multiple errors "Table xxx doesn't exist" although it does. In Mysql workbench the tables are listed in the schema tree but any attempt to access causes workbench to abort. I also tried deleting all data, recreate the schema folders and then the scripts to create the tables and routines and data. Again ok until a reboot. The only thing I haven't tried is dropping the schemas and recreating them in workbench. Relevant data: The new data drive is NTFS. The error messages include: [ERROR] Cannot find or open table pword/pword from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains indexes that this version of the engine doesn't support. Would appreciate any suggestions. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/changing-location-of-database/

1 0

[Maria-discuss] New Question: LINQ in C#
by AskMonty KB 27 Jun '13

27 Jun '13

Hello, A new question has been asked in "Using MariaDB" by JDoggieIII: -------------------------------- Hi, I am attempting to replace the database in an application with MariaDB. This application is written in C# and previously accessed the database (mostly inserts) with LINQ. When I attempt to insert (other transactions have the same type of issue) I get the error message: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[t0].[Id], [t0].[BirthYear], [t0].[FirstName], [t0].[Gender], [t0].[LastName], [' at line 1" The table in MariaDB is setup the same as it was in MS SQL. Any thoughts on this subject would be most appreciated. I could go back and remove all use of LINQ and write SQL by hand (which is how I would have implemented it in the first place due to LINQ being the bane of my existence), but if I can get it to work as is it will save a great deal of time, and therefore money. Thanks, Jeremy -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/linq-in-c/

1 0

[Maria-discuss] New Question: installation and license
by AskMonty KB 25 Jun '13

25 Jun '13

Hello, A new question has been asked in "Getting Started" by JDoggieIII: -------------------------------- Hi, we want to use MariaDB on several machines, one of which contains MS SQL 2008 R2 (which we don't want to use). Does MariaDB play nice on the same server as MS SQL 2008 R2? Also, is there a license somewhere, I can't locate one. Thanks, Jeremy -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/installation-and-license/

1 0