- discuss - lists.mariadb.org

[Maria-discuss] MariaDB subquery
by James Qian Wang 15 Apr '14

15 Apr '14

Hi All, I have a query which shows type REF when explained in MySQL 5.5/5.6. However, the same query shows type INDEX in MariaDB 10.0.9 I.e. the query is a lot slower in MariaDB. Any one has the similar experience please? Please drop me a line. -- James Qian Wang

3 5

[Maria-discuss] New Question: MariaDB 10.0 installation errors on Linux Mint 16
by AskMonty KB 15 Apr '14

15 Apr '14

Hello, A new question has been asked in "MariaDB community" by israelbravo: -------------------------------- Trying to install as it is explained on https://downloads.mariadb.org/mariadb/repositories/#mirror=mephi&distro=Min… I get the following error messages: dpkg: error processing mariadb-server-10.0 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mariadb-server: mariadb-server depends on mariadb-server-10.0 (= 10.0.10+maria-1~saucy); however: Package mariadb-server-10.0 is not configured yet. dpkg: error processing mariadb-server (--configure): dependency problems - leaving unconfigured Processing triggers for libc-bin ... Processing triggers for menu ... Errors were encountered while processing: mariadb-server-10.0 mariadb-server E: Sub-process /usr/bin/dpkg returned an error code (1) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-100-installation-errors-on-linux-mint-16/

1 0

[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] innodb_adaptive_flushing_method option in MariaDB 10.0
by Tsai Li Ming 11 Apr '14

11 Apr '14

Hi, I’m looking at the option innodb_adaptive_flushing_method in the docs but I see it has been removed in 10.0 and replaced? https://mariadb.com/kb/en/xtradbinnodb-server-system-variables/#innodb_adap… "Removed: MariaDB 10.0/XtraDB 5.6 - replaced with InnoDB flushing method from MySQL 5.6" Has it been replaced by innodb_flush_method because I’m trying to set “keep_average” for SSD drives. $ mysql --version mysql Ver 15.1 Distrib 10.0.10-MariaDB, for Linux (x86_64) using readline 5.1 Thanks!

2 1

[Maria-discuss] Heartbleed (OpenSSL) -bug and MariaDB
by Peter Laursen 10 Apr '14

10 Apr '14

A far as I understand MariaDB uses OpenSSL (unlike Oracle-MySQL that uses YaSSL). Now what about the heartbleed bug: http://heartbleed.com/ Will all still suported MariaDB versions (5.1, 5.2, 5.3, 5.5 and 10.0 are all still suported I think?) need a release for this bug in OpenSSL? -- Peter -- Webyog

3 6

[Maria-discuss] New Question: Problem with multi master replication and a trigger with mariadb 10.0.10.
by AskMonty KB 10 Apr '14

10 Apr '14

Hello, A new question has been asked in "Triggers" by wschwauer: -------------------------------- I have a problem with multi master replication and a trigger with mariadb 10.0.10. First. I have installed master db with name DB1 on a Windows system 1 master1 with a table m1, m2, m3, mg Second, I have install “slave” db with name DB1 on a Windows system 2 slave1 with a table s1, s2 Now I setup a row based replication with the table m1 from master1 to slave1. Next I setup a row based replication with the table s1 from slave1 to master1. Now I have a master with table m1, m2, m3, mg and s1 and a slave with table s1, s2 and m1. All replications work well. Ad next I create a trigger on master to manipulate and copy the data from table s1 to mg, but it do not work. I found this information (https://mariadb.atlassian.net/browse/MDEV-5095) but I have not the variable slave_run_triggers_for_rbr or slave_run_triggers. When I create the same trigger on master with table m1 and mg, it still works. But it not work with the replication table s1. I think it is a problem with the replication table s1. Can anyone help me? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problem-with-multi-master-replication-and-a-trigge…

1 0

[Maria-discuss] Backup locks in MariaDB
by Colin Charles 09 Apr '14

09 Apr '14

Hi! Percona Server 5.6 includes backup locks that work with xtrabackup 2.2 MariaDB 10 might want this feature as well. More information: http://www.mysqlperformanceblog.com/2014/03/11/introducing-backup-locks-per… Thoughts? -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

1 0

[Maria-discuss] New Question: Connecting issues
by AskMonty KB 09 Apr '14

09 Apr '14

Hello, A new question has been asked in "MariaDB ODBC Driver" by openiduser41: -------------------------------- Hi I have en application written in Visual Studio 2008 where I use CDatabase to connect to MariaDB via ODBC. When I try and connect I get an exception with the text "Invalid information type" I have tried alot of ODBC connect strings for instance: DRIVER={MariaDB ODBC 1.0 Driver};SERVER=localhost;DATABASE=mydb;UID=test;PWD= or DSN=mydb When I create the DSN every think looks ok. If I change to use {MySQL ODBC 3.51 Driver} it works fine. Another thing is that even though I use the noOdbcDialog option, it still show an ODBC dialog. Also if I create a new Project with database support in VS2008 and select a mariaDB DSN Visual studio crashes. Thanks for your help. /Kennet -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connecting-issues/

1 0

[Maria-discuss] locking on endpoints of range deletes
by Daniel Black 09 Apr '14

09 Apr '14

Anyone see why tx_isolation=REPEATABLE-READ should have a next-record lock on record 3 rather than a record lock? SESSION 1: MariaDB [drupal_test]> create table x ( x bigint unsigned not null auto_increment, PRIMARY KEY x) ); Query OK, 0 rows affected (0.02 sec) MariaDB [drupal_test]> select @@tx_isolation; +-----------------+ | @@tx_isolation | +-----------------+ | REPEATABLE-READ | +-----------------+ 1 row in set (0.00 sec) MariaDB [drupal_test]> insert into x values (1),(2),(3); Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 MariaDB [drupal_test]> begin -> ; Query OK, 0 rows affected (0.00 sec) MariaDB [drupal_test]> delete from x where x <= 3; Query OK, 3 rows affected (0.00 sec) ---TRANSACTION 290E30, ACTIVE 12 sec 2 lock struct(s), heap size 376, 4 row lock(s), undo log entries 3 MySQL thread id 7437, OS thread handle 0x7f37307f5700, query id 3298653 localhost debian-sys-maint sleeping TABLE LOCK table `drupal_test`.`x` trx id 290E30 lock mode IX RECORD LOCKS space id 82547 page no 3 n bits 72 index `PRIMARY` of table `drupal_test`.`x` trx id 290E30 lock_mode X SESSION 2: MariaDB [drupal_test]> insert into x values (DEFAULT); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction And it works in READ-COMMITTED SESSION 1: MariaDB [drupal_test]> set tx_isolation='READ-COMMITTED'; begin; delete from x where x <= 3; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 3 rows affected (0.00 sec) SESSION 2: ---TRANSACTION 290E33, ACTIVE 44 sec 2 lock struct(s), heap size 376, 3 row lock(s), undo log entries 3 MySQL thread id 7437, OS thread handle 0x7f37307f5700, query id 3298661 localhost debian-sys-maint sleeping TABLE LOCK table `drupal_test`.`x` trx id 290E33 lock mode IX RECORD LOCKS space id 82547 page no 3 n bits 72 index `PRIMARY` of table `drupal_test`.`x` trx id 290E33 lock_mode X locks rec but not gap MariaDB [drupal_test]> insert into x values (DEFAULT); Query OK, 1 row affected (0.00 sec) -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

1 0

[Maria-discuss] Trouble getting MariaDB to start up
by Jonathan Gazeley 07 Apr '14

07 Apr '14

Hi folks, I'm reasonably experienced with MySQL and MMM for cluster management but now I am working on a project to replace this with a MariaDB Galera cluster. Basic system info: [jg4461@db3 ~]$ uname -a Linux db3.resnet.bris.ac.uk 2.6.32-431.11.2.el6.x86_64 #1 SMP Tue Mar 25 19:59:55 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux [jg4461@db3 ~]$ cat /etc/redhat-release CentOS release 6.5 (Final) [jg4461@db3 ~]$ mysql -V mysql Ver 15.1 Distrib 5.5.36-MariaDB, for Linux (x86_64) using readline 5.1 I've set up a Galera prototype with two nodes and I got the clustering working. Then I decided to add a load of config options from my old MySQL install to the MariaDB install, and now it fails to start up, but doesn't give an obvious error message. The options were mostly to do with InnoDB buffers etc. This is the output in the log file /var/lib/mysql/db3.resnet.bris.ac.uk.err, the init script hangs for ages after this without giving any further output. 140331 15:07:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140331 15:07:49 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.mlbT89' --pid-file='/var/lib/mysql/db3.resnet.bris.ac.uk-recover.pid' 140331 15:07:51 mysqld_safe WSREP: Failed to recover position: '140331 15:07:49 InnoDB: The InnoDB memory heap is disabled 140331 15:07:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140331 15:07:49 InnoDB: Compressed tables use zlib 1.2.3 140331 15:07:49 InnoDB: Using Linux native AIO 140331 15:07:49 InnoDB: Initializing buffer pool, size = 1.5G 140331 15:07:49 InnoDB: Completed initialization of buffer pool 140331 15:07:49 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140331 15:07:49 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... 140331 15:07:49 InnoDB: Waiting for the background threads to start 140331 15:07:50 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 1607692 140331 15:07:50 [Note] Plugin 'FEEDBACK' is disabled.' My MariaDB config file is attached. Please could someone point me in the right direction of where to go with debugging this. I can't find any other error message so I'm struggling to track down why the server can't start. Any advice gratefully accepted! Thanks, Jonathan

4 6