June 2013 - discuss - lists.mariadb.org

[Maria-discuss] explain for insert/update/delete
by MARK CALLAGHAN 11 Jul '25

11 Jul '25

Does MariaDB have any plans to support explain for insert/update/delete/replace/CTAS? There have been feature requests open for a very long time on official MySQL without any progress. I have had a few problems in production from 'bad' delete statements that had a very different plan than the select statement with the same where clause. The only way to check for a bad plan today is to use SHOW INNODB STATUS to determine whether the statement locks all rows in a table. http://bugs.mysql.com/bug.php?id=14745 http://bugs.mysql.com/bug.php?id=35355 -- Mark Callaghan mdcallag(a)gmail.com

2 1

[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

[Maria-discuss] Silencing "Unsafe statement written to the binary log" log warnings
by Vincent Pelletier 25 Jun '13

25 Jun '13

Hi. We get 500k such lines per day: 130517 0:00:02 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted. Statement: UPDATE [...] Is there a way to silence them ? Intuitively, I would expect a companion option to innodb_locks_unsafe_for_binlog, but couldn't find one in the documentation. The queries triggering those warnings are harmless in our case because the update is rolled back at application level on restart (which necessarily happens in case of disaster recovery involving restoring incremental backups). If you want more details to understand what we are doing - shouldn't be needed for this discussion: The table involved is used as a shared task queue. The update happens when a process wants to process a bunch of tasks, up to a limit. Once a task is over, it is deleted by its primary key. So any task assigned to a worker's identifier upon worker startup can be safely assumed to have to be processed, and is released by that worker (effectively rolling back UPDATE's action). This only represents 2MB gzipped, so we can live with it if we must, but it causes undesired noise which may hide real issues. Regards, -- Vincent Pelletier ERP5 - open source ERP/CRM for flexible enterprises

3 3

[Maria-discuss] New Question: Issue with symlinked database directories loading under windows
by AskMonty KB 25 Jun '13

25 Jun '13

Hello, A new question has been asked in "Using MariaDB" by scottharman: -------------------------------- Hi all, I'm having trouble getting symlinked databases to work under 5.5.31 of MariaDB Currently the databases are held on a different drive, and I've tried both Symlinks and Junctions under windows to get them working under MariaDB Both methods work equally well under MySQL 5.5.31, and I've enabled symlink support in my.ini for Mariadb Any thoughts on why it wouldn't be working? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/issue-with-symlinked-database-directories-loading…

1 0