- discuss - lists.mariadb.org

[Maria-discuss] New Question: MariaDB Galera
by AskMonty KB 22 Apr '14

22 Apr '14

Hello, A new question has been asked in "Galera" by zainalabidinmamat: -------------------------------- Hi, Does free version of MariaDB Galera support active-active cluster topology? Can it be write/read on both node? Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera/

1 0

[Maria-discuss] MariaDB Galera Cluster 10.0.10 now available
by Daniel Bartholomew 22 Apr '14

22 Apr '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.10 This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.10 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10010-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10010-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.10 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ 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 newly published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - 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: 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 Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] MariaDB 5.5.37 now available
by Daniel Bartholomew 17 Apr '14

17 Apr '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.37 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.37 - Release Notes: https://mariadb.com/kb/en/mariadb-5537-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5537-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.37 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ 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 newly published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - 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: 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 Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: Work the master slave replication only with the same database name on server and client?
by AskMonty KB 17 Apr '14

17 Apr '14

Hello, A new question has been asked in "Replication" by wschwauer: -------------------------------- Work the master slave replication only with the same database name on server and client? So I can’t replicate the table cars from the server DB with name “serverdb” (serverdb.cars) to the client DB with name “client1” (client1.cars)? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/work-the-master-slave-replication-only-with-the-sa…

1 0

[Maria-discuss] Problem in Connect engine with XML default namespace
by Rasmus Johansson 17 Apr '14

17 Apr '14

Hello Olivier, I run into a problem in the Connect engine with XML default namespace. I've reported the problem in JIRA: https://mariadb.atlassian.net/browse/MDEV-6125 Best regards, Rasmus -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

2 1

[Maria-discuss] New Question: Connect to Excel
by AskMonty KB 17 Apr '14

17 Apr '14

Hello, A new question has been asked in "Connect" by arturpritzkau: -------------------------------- How can i connect to an Excel file? I try this: create table Customer engine=connect table_type=ODBC tabname='Sheet1' Connection='DSN=ExcelDSN;DBQ=C:/Test/test.xls;'; I get always get the message: SQL Fehler (1105): [Microsoft][ODBC Driver Manager] Der angegebene DSN weist eine nicht �bereinstimmende Architektur von Treiber und Anwendung auf. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-to-excel/

1 0

[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

[Maria-discuss] New Question: upgraded to MariaDB 10.0 but the systemctl status mariadb.service is not working? mysql command works instead?
by AskMonty KB 06 Apr '14

06 Apr '14

Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: -------------------------------- Have the MariaDB programmers taken out the systemctl status mariadb.service command from the MariaDB 10.0 server. the command was working on my mariadb 5.5 server. can someone help shed some light Server: MariaDB Server version: 10.0.10-MariaDB MariaDB Server Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 1 day 14 hours 11 min 29 sec Threads: 1 Questions: 143 Slow queries: 0 Opens: 31 Flush tables: 1 Open tables: 57 Queries per second avg: 0.001 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/upgraded-to-mariadb-100-but-the-systemctl-status-m…

1 0

[Maria-discuss] Building on Windows with cmake 2.8.12.2 and Visul Studio 2012
by Wes Bullard 03 Apr '14

03 Apr '14

I've been trying for a few days now first with 10.0.9 and now with 10.0.10 to build on windows x64 both by command line and in visual studio 2012. Straight building seems to go fine but if I try and build --target package or even --target msi I get errors about missing pdb files. This is both in RelWithDebInfo and Release configuration. The following are outputs from the builds RelWithDebInfo - http://paste.chainscriptz.net/?paste=5 Release - http://paste.chainscriptz.net/?paste=6 This is in Visual Studio 2012 Ultimate update 4. Sorry if this is in the wrong format first time using a mailing list.

2 1

[Maria-discuss] New Question: Circular Dependency on 5.5.36
by AskMonty KB 03 Apr '14

03 Apr '14

Hello, A new question has been asked in "Installing MariaDB RPM Files" by peter-mclarty: -------------------------------- Does anyone have a clever solution to installing 5.5.36 when compat and common rpms have a circular dependency, Since the contents appear to be needed do we need them packaged separately? [root@faws01_dbs itadmin]# yum install MariaDB-5.5.36-centos6-x86_64-compat.rpm Loaded plugins: product-id, subscription-manager Updating certificate-based repositories. Setting up Install Process Examining MariaDB-5.5.36-centos6-x86_64-compat.rpm: MariaDB-compat-5.5.36-1.el6.x86_64 Marking MariaDB-5.5.36-centos6-x86_64-compat.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package MariaDB-compat.x86_64 0:5.5.36-1.el6 will be installed --> Processing Dependency: MariaDB-common for package: MariaDB-compat-5.5.36-1.el6.x86_64 --> Finished Dependency Resolution Error: Package: MariaDB-compat-5.5.36-1.el6.x86_64 (/MariaDB-5.5.36-centos6-x86_64-compat) Requires: MariaDB-common You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest [root@faws01_dbs itadmin]# yum install MariaDB-5.5.36-centos6-x86_64-common.rpm Loaded plugins: product-id, subscription-manager Updating certificate-based repositories. Setting up Install Process Examining MariaDB-5.5.36-centos6-x86_64-common.rpm: MariaDB-common-5.5.36-1.el6.x86_64 Marking MariaDB-5.5.36-centos6-x86_64-common.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package MariaDB-common.x86_64 0:5.5.36-1.el6 will be installed --> Processing Dependency: MariaDB-compat for package: MariaDB-common-5.5.36-1.el6.x86_64 --> Finished Dependency Resolution Error: Package: MariaDB-common-5.5.36-1.el6.x86_64 (/MariaDB-5.5.36-centos6-x86_64-common) Requires: MariaDB-compat You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest As you can see one is dependent on the other, that is not a smart approach Any thoughts Peter -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/circular-dependency-on-5536/

1 0

[Maria-discuss] New Question: unable to upgrade from MariaDB 5.5 to MariaDB 10.0 using YUM
by AskMonty KB 01 Apr '14

01 Apr '14

Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: -------------------------------- I created a file mariadb.repo and put in info for mariadb 10.0, when I run the command yum -y update or yum -y upgrade mariadb-server mariadb-client, Loaded plugins: langpacks, refresh-packagekit Resolving Dependencies --> Running transaction check ---> Package MariaDB-server.x86_64 0:10.0.10-1.fc20 will be obsoleting ---> Package mariadb-server.x86_64 1:5.5.36-1.fc20 will be obsoleted --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: MariaDB-server x86_64 10.0.10-1.fc20 mariadb 49 M replacing mariadb-server.x86_64 1:5.5.36-1.fc20 Transaction Summary ================================================================================ Install 1 Package Total download size: 49 M Downloading packages: MariaDB-10.0.10-fedora20-x86_64-server.rpm | 49 MB 00:00:10 Running transaction check Running transaction test Transaction test succeeded Running transaction sed: invalid option -- '1' Usage: sed [OPTION]... {script-only-if-no-other-script} [input-file]... -n, --quiet, --silent suppress automatic printing of pattern space -e script, --expression=script add the script to the commands to be executed -f script-file, --file=script-file add the contents of script-file to the commands to be executed --follow-symlinks follow symlinks when processing in place -i[SUFFIX], --in-place[=SUFFIX] edit files in place (makes backup if SUFFIX supplied) -c, --copy use copy instead of rename when shuffling files in -i mode -b, --binary does nothing; for compatibility with WIN32/CYGWIN/MSDOS/EMX ( open files in binary mode (CR+LFs are not treated specially)) -l N, --line-length=N specify the desired line-wrap length for the `l' command --posix disable all GNU extensions. -r, --regexp-extended use extended regular expressions in the script. -s, --separate consider files as separate rather than as a single continuous long stream. -u, --unbuffered load minimal amounts of data from the input files and flush the output buffers more often -z, --null-data separate lines by NUL characters --help display this help and exit --version output version information and exit If no -e, --expression, -f, or --file option is given, then the first non-option argument is taken as the sed script to interpret. All remaining arguments are names of input files; if no input files are specified, then the standard input is read. GNU sed home page: <http://www.gnu.org/software/sed/>. General help using GNU software: <http://www.gnu.org/gethelp/>. ****************************************************************** A MySQL or MariaDB server package () is installed. The current MariaDB server package is provided by a different vendor (package is not installed) than Monty Program AB. Some files may be installed to different locations, including log files and the service startup script in /etc/init.d/. Upgrading directly from MySQL <unrecognized version package is not installed> to MariaDB 10.0 may not be safe in all cases. A manual dump and restore using mysqldump is recommended. It is important to review the MariaDB manual's Upgrading section for version-specific incompatibilities. A manual upgrade is required. - Ensure that you have a complete, working backup of your data and my.cnf files - Shut down the MySQL server cleanly - Remove the existing MySQL packages. Usually this command will list the packages you should remove: rpm -qa | grep -i '^mysql-' You may choose to use 'rpm --nodeps -ev <package-name>' to remove the package which contains the mysqlclient shared library. The library will be reinstalled by the MariaDB-shared package. - Install the new MariaDB packages supplied by Monty Program AB - Ensure that the MariaDB server is started - Run the 'mysql_upgrade' program This is a brief description of the upgrade process. Important details can be found in the MariaDB manual, in the Upgrading section. ****************************************************************** error: %pre(MariaDB-server-10.0.10-1.fc20.x86_64) scriptlet failed, exit status 1 Error in PREIN scriptlet in rpm package MariaDB-server-10.0.10-1.fc20.x86_64 Verifying : MariaDB-server-10.0.10-1.fc20.x86_64 1/2 1:mariadb-server-5.5.36-1.fc20.x86_64 was supposed to be removed but is not! Verifying : 1:mariadb-server-5.5.36-1.fc20.x86_64 2/2 Failed: MariaDB-server.x86_64 0:10.0.10-1.fc20 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-upgrade-from-mariadb-55-to-mariadb-100-u…

1 0

[Maria-discuss] New Question: crash recovery
by AskMonty KB 01 Apr '14

01 Apr '14

Hello, A new question has been asked in "Backing Up and Restoring" by joemurray: -------------------------------- An XtraDB database running in MariaDB - no cluster, no replication - has been crashing about 15 x per day for 3 days and we suspect it may be corrupt. We don't see any reason in the log files for the crashes. We have taken a mysqldump and restored into a new db and run mysqlcheck on the new db and not fond any errors, but I suspect that the dumping and restoring has hidden them. After testing a staging site with this new database we are planning to repeat the process of dumping and restoring into a new db and then making it live. I intend to run mysqlcheck on the production database once it is no longer in production. Any other suggestions from DBAs to this developer? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/crash-recovery/

1 0

[Maria-discuss] MariaDB 10.0.10 now available
by Daniel Bartholomew 31 Mar '14

31 Mar '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.10. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.10 - Release Notes: https://mariadb.com/kb/en/mariadb-10010-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10010-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.10 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 & MySQL community event, 3 Apr 2014 - - - - - - - - - - - The MariaDB Foundation is holding a community event to complement the Percona Live conference and expo in Santa Clara, CA. The event is free. Visit the Community Events page on mariadb.org for full details, including the speaker schedule and to register. - https://mariadb.org/en/community-events/ - - 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 newly published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - 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: 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 Knowledge Base - http://mariadb.com/kb

3 2

[Maria-discuss] New Question: MariaDB wire protocol
by AskMonty KB 31 Mar '14

31 Mar '14

Hello, A new question has been asked in "MariaDB Documentation" by steveteale: -------------------------------- Where is the wire protocol described please. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-wire-protocol/

1 0

[Maria-discuss] bugs in the testsuite
by Reindl Harald 31 Mar '14

31 Mar '14

hi, i see the errors below for a longer time and thought i should mention them - in case of running the test-suite completly alone i would not expect that /usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl --default-myisam --parallel=1 --max-test-fail=0 --mysqld=--binlog-format=mixed --skip-ndb --force' mysql ________________________________________________- rpl.rpl_row_utf32 'row' [ fail ] Test ended at 2014-03-05 19:57:46 CURRENT_TEST: rpl.rpl_row_utf32 mysqltest: In included file "./include/rpl_init.inc": included from ./include/master-slave.inc at line 38: included from /usr/share/mysql-test/suite/rpl/t/rpl_row_utf32.test at line 2: At line 179: query 'RESET SLAVE' failed: 1198: This operation cannot be performed with a running slave; run STOP SLAVE first The result from queries just before the failure was: include/master-slave.inc - saving '/usr/share/mysql-test/var/log/rpl.rpl_row_utf32-row/' to '/usr/share/mysql-test/var/log/rpl.rpl_row_utf32-row/' rpl.rpl_row_view01 'row' [ skipped ] Not ROW format rpl.rpl_row_wide_table 'row' [ skipped ] Not ROW format rpl.rpl_tmp_table_and_DDL 'row' [ fail ] Test ended at 2014-03-05 19:57:50 CURRENT_TEST: rpl.rpl_tmp_table_and_DDL mysqltest: In included file "./include/rpl_init.inc": included from ./include/master-slave.inc at line 38: included from /usr/share/mysql-test/suite/rpl/t/rpl_tmp_table_and_DDL.test at line 8: At line 179: query 'RESET SLAVE' failed: 1198: This operation cannot be performed with a running slave; run STOP SLAVE first The result from queries just before the failure was: include/master-slave.inc - saving '/usr/share/mysql-test/var/log/rpl.rpl_tmp_table_and_DDL-row/' to '/usr/share/mysql-test/var/log/rpl.rpl_tmp_table_and_DDL-row/' rpl.semisync_memleak_4066 'row' [ skipped ] Need semisync plugins rpl.rpl_stm_sql_mode 'stmt' [ fail ] Test ended at 2014-03-05 19:58:31 CURRENT_TEST: rpl.rpl_stm_sql_mode mysqltest: In included file "./include/rpl_init.inc": included from ./include/master-slave.inc at line 38: included from /usr/share/mysql-test/suite/rpl/t/rpl_stm_sql_mode.test at line 2: At line 179: query 'RESET SLAVE' failed: 1198: This operation cannot be performed with a running slave; run STOP SLAVE first The result from queries just before the failure was: include/master-slave.inc - saving '/usr/share/mysql-test/var/log/rpl.rpl_stm_sql_mode-stmt/' to '/usr/share/mysql-test/var/log/rpl.rpl_stm_sql_mode-stmt/'

2 1

[Maria-discuss] New Question: Multi Master Replication
by AskMonty KB 27 Mar '14

27 Mar '14

Hello, A new question has been asked in "MariaDB Documentation" by eddow: -------------------------------- Greetings, I am attempting to set up Multi Master Replication. So far, I have been able to set up multiple masters and data is replicated to one slave. This works great. What I am having a problem with is if I add a new master. When I add the master the data in the slave table is truncated and only the data from the new master is replicated. I loose all my old data in the slave. Example: Master 1300: +----------------+ | name | +----------------+ t1300 Master 13: +----------------+ | name | +----------------+ t13 +----------------+ Slave: +----------------+ | name | +----------------+ t1300 t13 +----------------+ On the slave I do this: change master 't68' to master_host='10.79.84.149', master_user='replication_user', master_port=3306; start slave t1300; select * from name; Slave: +----------------+ | name | +----------------+ t68 +----------------+ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/multi-master-replication/

2 1

[Maria-discuss] Does ADD/DROP INDEX update the InnoDB buffer pool?
by Markus "Shorty" Uckelmann 25 Mar '14

25 Mar '14

Hi all, When adding or dropping a primary and/or secondary index is the InnoDB buffer pool updated too? Is the pool changed in place or will the LRU algo just evict to make room? In the second case buffers of other tables on the server might be affected too and the server would run with a more or less cold buffer pool. We have to fiddle with indices on production servers, which by itself is a precarious matter. So I tried to find out how ADD/DROP INDEX operations affect the memory/buffer pool of our servers. Since I wasn't able (or too stupid) to find something about this topic it would be great if someone could help me out and point me in the right direction. BTW: Version is MariaDB 5.5 Cheers, Shorty

2 1

[Maria-discuss] New Question: can't get mariadb to start in Slackware
by AskMonty KB 25 Mar '14

25 Mar '14

Hello, A new question has been asked in "MariaDB community" by boomhower182: -------------------------------- After my fresh install it was starting just fine and the only thing I changed was my apache config files to get php to work and then I did some updates and it was still working, then all of a sudden it stopped working. this is what my .err file states.. 140324 16:49:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140324 16:49:05 InnoDB: The InnoDB memory heap is disabled 140324 16:49:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140324 16:49:05 InnoDB: Compressed tables use zlib 1.2.8 140324 16:49:05 InnoDB: Using Linux native AIO 140324 16:49:05 InnoDB: Initializing buffer pool, size = 128.0M 140324 16:49:05 InnoDB: Completed initialization of buffer pool 140324 16:49:05 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! 140324 16:49:05 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... 140324 16:49:05 InnoDB: Waiting for the background threads to start 140324 16:49:06 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 1597945 140324 16:49:06 [Note] Plugin 'FEEDBACK' is disabled. 140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 140324 16:49:06 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13) 140324 16:49:06 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 140324 16:49:06 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-get-mariadb-to-start-in-slackware/

2 1

[Maria-discuss] subscribe please
by James Qian Wang 21 Mar '14

21 Mar '14

-- James Qian Wang Mobile: 44 7986 099 233

2 1

[Maria-discuss] New Question: ETL tool for MariaDB
by AskMonty KB 21 Mar '14

21 Mar '14

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by Sunil: -------------------------------- Hello, Please let me know the ETL tools that we can integrate with MAriaDB. Thanks Sunil -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/etl-tool-for-mariadb/

1 0

[Maria-discuss] New Question: installation issue
by AskMonty KB 20 Mar '14

20 Mar '14

Hello, A new question has been asked in "MariaDB Documentation" by rahulsharma: -------------------------------- during installation mariadb5.5 .tar i am getting issue as following:- root@localhost mysql]# ./scripts/mysql_install_db ./scripts/mysql_install_db: line 268: ./bin/my_print_defaults: cannot execute binary file either host 'localhost.localhost' nor 'localhost' could be looked up with ./bin/resolveip please configure the 'hostname' commmand to return a correct hostname. kindly suggest me!!!!! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/installation-issue/

3 2

[Maria-discuss] help - i'm not finding one sql function
by Roberto Spadim 20 Mar '14

20 Mar '14

hi guys, i'm not finding a function to return how many character i have, for example: "banana" i want a function that return 2 "n" characters, example: substr_count("banana","n") => 2 sorry it a begginners question, but i didn't found it in mysql/mariadb manual -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

7 21

[Maria-discuss] New Question: mariaDB_client-1-0-0_win64 in Visual Studio 2012
by AskMonty KB 18 Mar '14

18 Mar '14

Hello, A new question has been asked in "Client libraries" by olivierf77: -------------------------------- Hello, I have installed MariaDB 5.6 , and its works perfectly. Thanks to all the MariaDB team. I also installed (by *.msi) mariaDB_client-1-0-0_win64 in c:\L\SQLClient\mariadb_client-1.0.0-win64\ + added paths as follow in project properties: INCLUDE DIRECTORIES = C:\L\SQLClient\mariadb_client-1.0.0-win64\mariadbclient\include;$(IncludePath) LIBRARY DIRECTORIES = C:\L\SQLClient\mariadb_client-1.0.0-win64\lib;$(LibraryPath) However, when trying to use it even with the most simple programs, compilation is OK, **BUT** linking fails: --- my minimal c++ program (c++ console under Visual Studio 2012 --- #include "stdafx.h" #include <mysql.h> int _tmain(int argc, _TCHAR* argv[]) { MYSQL *my; my = mysql_init(NULL); } -- end of program -- BUILDING PROJETS -> following error msg: 1>------ Build started: Project: cppconMariaDB02, Configuration: Debug Win32 ------ 1>cppconMariaDB02.obj : error LNK2019: unresolved external symbol _mysql_init@4 referenced in function _wmain 1>c:\users\olivier\documents\visual studio 2012\Projects\cppconMariaDB02\Debug\cppconMariaDB02.exe : fatal error LNK1120: 1 unresolved externals ========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ========== Every mysql function gets the same "unresolved external symbol" error, even though I believe I did specify the path to the directory containing the 3 files "libmariadb.dll, libmariadb.lib & mariadbclient.lib", which I even tried (for testing purposes only, and with no better results) to copy into windows/system32. I have spent a lot of time on this issue, with no success. I did see that this question was asked several times on several programming sites, but it never gets any answer. As additional info, here is my directory for the c mariadb_client client: Directory of c:\L\SQLClient\mariadb_client-1.0.0-win64 <DIR> .. docs examples html lib libmysql mariadbclient mysql_config unittest zlib I hope that the above information (and question) is clear and complete, but not over verbose, and that someone in your team will have a few seconds to answer my query, even though the answer may be trivial (at least for him). And once again, many thanks for a very nice product. Sincerely yours Olivier, Paris, France PS And hello to Michael 'Monty' Widenus, whom I met in Paris six months ago. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb_client-1-0-0_win64-in-visual-studio-2012/

1 0

[Maria-discuss] Mariadb Java Driver useOldAliasMetadataBehavior and useColumnNamesInFindColumn
by Peter Mclarty 18 Mar '14

18 Mar '14

Hi Our context file presently has the useOldAliasMetadataBehavior=true in it to handle select count(*) as Bignumber type scenarios.( select as as b from table ) We tried using the mariadb driver as we have started the journey to using mariadb.5.5 and had a meltdown in our app (dev only thanks). I have done some research and it as i read it the mariadb code doesn't honour that parameter. I have done some research and one article stated With JDBC drivers version 4.0 and later you will eventually not get the aliasName As i haven't fully digested the JDBC 4.0 spec, barely scratched the surface am I right to conclude Maria and MySQL drivers will not eventually support this behavior and what is the approach to this using aliases or the selact a as b type scenario. Just point me to the pages is fine Any assistance appreciated Cheers -- *Peter McLarty* *Data Analyst DBA* Compare The Market -- Compare The Market is a brand and trading name of Compare The Market (Pty) Ltd (CTM). This email is for the intended addressee and is confidential and subject to copyright. If you are not the intended addressee, confidentiality has not been waived and any use, interference with, or disclosure of this email is unauthorised. If you are not the intended addressee please immediately notify CTM and then delete the email. CTM does not warrant that this email is error or virus free.

1 0

[Maria-discuss] New Question: pre-seeding databases from remote servers for multi-source replication
by AskMonty KB 17 Mar '14

17 Mar '14

Hello, A new question has been asked in "Backup, Restore and Import" by ivesstoddard: -------------------------------- I'm in the process of pre-seeding a mariadb 10.0.9 multi-source replica server with databases from remote 5.5 servers. I'm looking for the fastest and most stable way of doing this (preferably without using mysqldump). I'm curious if there is a way to import entire databases directly from block-level snapshots, similar to the transportable tablespaces (only on a database level instead of a table level, by copying .idb/.frm/etc. files directly to the target server). NOTE: Transportable tablespaces aren't yet available in 5.5 and also have to be done on a table-by-table basis. Some of the databases are large enough that running mysqldump & import will are impractical. Not only will this process take a considerable amount of time, but to do this in a way that is closest to a snapshot will require a separate server instance to ensure all transactions have been committed to the tablespaces. Is there anyone out there looking at multi-source replication who has a simple solution to this that i might be overlooking? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/pre-seeding-databases-from-remote-servers-for-mult…

1 0

[Maria-discuss] MariaDB vs. MySQL error codes (1900+)
by Felipe Gasper 17 Mar '14

17 Mar '14

Hi everyone, I notice that MariaDB is using the 1900+ range for its own error codes; however, MySQL 5.7, at least, has a few errors in that range as well. Are error codes just going to be an area of increasing conflict between the two, or is there a plan to migrate MariaDB codes to a different numbering scheme? -Felipe Gasper Houston, TX

2 2

[Maria-discuss] Participation in GSOC 2014
by Ivoline Ngong 17 Mar '14

17 Mar '14

Hi, My name is Ngong Ivoline.I am a second year student reading Computer Engineering in the University of Buea (Cameroon in West Africa). I am very excited working with an open source organization as i will finally have the chance to share my ideas as well as learn from others. I love coding and i am proficient in Java ,C and mysql.I will like to not only test but improve my skills by taking part in a google summer of code 2014. One of my goals as an African woman is to encourage the growth of programming in my community, country and continent as a whole. I am interested in the project to statistically optimize mysql-test runs by running less tests. It will be great if i get some guidance on how to continue from here.Look forward to participating in this group. Cheers!! Ivoline.

2 1

[Maria-discuss] New Question: Reentrant mariadbclient on the horizon?
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB community" by markcianfaglione: -------------------------------- I've written an test application that can be multi-threaded and I've done a bit of testing only to find that mariadbclient is not reentrant! (Oh the humanity!) I have got it to run using the reentrant library (libmysqlclient_r) for MySQL but there doesn't seem to be a similar library for mariadbclient. Is this even on the horizon? Mark -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/reentrant-mariadbclient-on-the-horizon/

2 1

[Maria-discuss] New Question: Question about testing
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB FAQ" by openiduser40: -------------------------------- I'd like to run the test suite on MariaDB-5 + MariaDB-10 both. https://mariadb.com/kb/en/mysql-test-overview gives some information + fails to give enough. Suggest docs add a full example. Something like this... 1) create a database net1# mysql_create_database --dbname=mariadb_test --dbuser=mariadb --dbpass=mariadb /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'CREATE DATABASE mariadb_test CHARACTER SET utf8 COLLATE utf8_general_ci' /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'GRANT ALL PRIVILEGES ON mariadb_test.* to 'mariadb@localhost' IDENTIFIED BY "mariadb"; FLUSH PRIVILEGES;' 2) run a test The reason I ask about this is every test I run fails. lsof shows my socket is /var/run/mysqld/mysqld.sock + here are the failures. mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SHOW DATABASES' | grep mariadb_test shows my database exists. These tests fail to connect to database... net1# mysqltest --verbose --protocol=socket --socket=/var/run/mysqld/mysqld.sock --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server (null):3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# mysqltest --verbose --host=localhost --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server localhost:3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SELECT db,user,host FROM mysql.db WHERE db="mariadb_test"' +--------------+---------+-----------+ | db | user | host | +--------------+---------+-----------+ | mariadb_test | mariadb | localhost | +--------------+---------+-----------+ Obviously I'm missing something simple + having a complete example would help. Please update this question with all steps required to run mysqltest. Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/question-about-testing/

1 0

[Maria-discuss] New Question: JSON error
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB community" by miroigov: -------------------------------- Hello, I installed MariaDB Manager on CentOS 6.5 and when i open in browser http://domain.com:8080/MariaDBManager/ it starts loading and then displays error : API did not return JSON for: GET http://localhost/consoleAPI/api/user HTTP 500 - Errors: HTTP/1.1 500 Internal Server Error - The API is unable to function because PHP JSON functions are not available I do not have experience with Tomcat and have no idea how to set json for php. I have php 5 install and json is working fine with default config /etc/php.ini -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/json-error/

1 0

[Maria-discuss] New Question: Permanent link to download last version of MariaDB
by AskMonty KB 12 Mar '14

12 Mar '14

Hello, A new question has been asked in "MariaDB FAQ" by francocorbelli: -------------------------------- I suggest to create permanent link to last version of a given series. Something like this https://downloads.mariadb.org/mariadb-5.5/mariadb-current-winx64.msi With best regards for a great project. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/permanent-link-to-download-last-version-of-mariadb/

1 0

[Maria-discuss] New Question: creating pivot table fails
by AskMonty KB 12 Mar '14

12 Mar '14

Hello, A new question has been asked in "CONNECT Table Types" by nobswolf: -------------------------------- I tried to create a pivot table based on an existing table "test1" and get an error. I am logged in and I can use "test1", so this error makes no sense to me. What I am doing wrong? Any hints? MariaDB [nav]> create table xsort engine=connect table_type=pivot tabname=test1; ERROR 1105 (HY000): (1045) Access denied for user 'root'@'localhost' (using password: NO) MariaDB [nav]> -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/creating-pivot-table-fails/

1 0

[Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'
by Tanstaafl 12 Mar '14

12 Mar '14

Hello all, We have a postfixadmin+mariadb sql database we have been using for many, many years (well, only recently migrated from mysql to mariadb, and it was totally transparent, so thanks for that!). This system is rock solid, and we have no desire to change it. We are in the process of setting up SOGo groupware, amd have run into a stumbling block. Not a show stopper, but it definitely put a heavy burden on me, as the SysAdmin. SOGo can Active Directory just fine for testing Group Memberships for purposes of applying ACLs (for shared calendars, contacts, etc)... We intentionally do not use SSO - we enforce very strong email passwords, but allow much weaker AD computer passwords - so email AUTH happens with our SQL DB. The problem is, SOGo does not have support for using 'Groups' for ACLs when using SQL for the AUTH backend. It also does not (yet) have support for different AUTH and USER DB backends. So, as things stand now, I'm going to have to manually add every single individual userid to every single resource they will need to have access too, rather than just doing this with groups. So, my first questions is, has anyone every come up with a decent schema that provides for managing user groups in the same way as AD groups that scales reasonably well? I'm very dangerous when it comes to this stuff, so can't even attempt this myself, but I have some options available to help get this done, especially if I can get some help/advice with getting started. One thing I do know is the SOGo guy had to create a 'View' to use, so whatever we end up using will have to work inside a View (probably displaying my ignorance to the world with that comment - is pretty much everything in an SQL DB compatible with 'Views'?)... I'd dearly appreciate any help anyone is willing to give... Thanks, Charles

3 5

[Maria-discuss] InnoDB selected projects (corrected links)
by Jan Lindström 12 Mar '14

12 Mar '14

Hi all, After careful weighting and selection process, I have selected following two projects as a starting point to improve InnoDB (1) InnoDB file space defragmentation Description: External tool to physically delete delete marked rows from InnoDB file space and freeing unused file space. https://mariadb.atlassian.net/browse/MDEV-5834 (2) InnoDB fast bulk load Description: External tool to load CVS file directly to InnoDB file space (innodb_file_per_table = 1). https://mariadb.atlassian.net/browse/MDEV-5835 Now, I hope these projects mostly represent the most frequently requested features and are most usable to current customers and/or potential new customers. Next, I would hope some indication which one of the selected project you would like to see first. Votes can be added above links. R: -- -- Jan Lindström, Principal Engineer SkySQL - The MariaDB Company 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>

1 0

[Maria-discuss] MariaDB 10.0.9 now available
by Daniel Bartholomew 10 Mar '14

10 Mar '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.9. This is a Release Candidate (RC) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.9 - Release Notes: https://mariadb.com/kb/en/mariadb-1009-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1009-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.9 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. - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf formats. See the PacktPub website for details: - 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: 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 Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: unable to START MySQL server at BOOT "systemctl enable mysqld.service" does not work
by AskMonty KB 09 Mar '14

09 Mar '14

Hello, A new question has been asked in "MariaDB community" by asifcyberdome: -------------------------------- unable to START MySQL server at BOOT "systemctl enable mysqld.service" does not work I am running FEDORA 20 and I have MySQL installed or the replacement MariaDB. same difference. I am able to do everything correcty. Everything works, except when I run the command: "systemctl enable mysqld.service", It gives me error "failed to issue method call: no such file or directory." Is this a known issue? Is this a known BUG? Is there a way to fix this? I am running Fedora 20 MySQL/MariaDB 5.5 version. Any help is greatly appreciated -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-start-mysql-server-at-boot-systemctl-ena…

1 0

[Maria-discuss] New Question: V5.5.36 will only use default data directory
by AskMonty KB 08 Mar '14

08 Mar '14

Hello, A new question has been asked in "MariaDB community" by mdavies5: -------------------------------- I installed v5.5.36 on a new Mint16 installation and it started ok. I then modified my.cnf to point to an existing data directory. I made sure that all folders and files were owned by mysql user and the mysql group had permissions to read/write. I also deleted existing files ib_logfile0/1, ibdata1 and aria_log_control as I know these must be recreated. When restarting MariaDb I get: Can't create/write to file '/home/michael/mysql/aria_log_control' (Errcode: 13). Files ib_logfile0 & 1 and ibdata1 were created ok so it is not a permissions problems. Why does only aria_log_control fail to create. If I copy all this data to default /var/lib/mysql and reset my.cnf then they work fine -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/v5536-will-only-use-default-data-directory/

1 0

Re: [Maria-discuss] Index bug in aria engine?
by pslawek83 07 Mar '14

07 Mar '14

Ok i wasn't able to reproduce the issue fully, now data is different ... but again, "skipped rows" number changes, and index sizes differ a lot: Uniq index: http://screencast.com/t/SrBS1L5xeB8 http://screencast.com/t/3dVMU7b69AH2 Normal index: http://screencast.com/t/Zl5Jm2OZ http://screencast.com/t/P3SA8U6duly But again, unique index is working much worse than not unique... while it's bigger http://screencast.com/t/rjexoWKwFF http://screencast.com/t/qYdsmRbRbmG7 I'll quickly explain how tables were created... i first took part of the data with unique index, and made smaller copy, thats table 1 Then i just copied the table changed the index to non-unique. After this i copied the tables once again to be sure files are not fragmented, etc. SHOW WARNINGS returns nothing in both cases. It seems that the additional knowledge (only single row with same data) should make the optimizer and query behave better but it's actually behaving much worse... -- Query for reference: EXPLAIN extended SELECT attrib_id, raw_stats_value_id, sum(impressions)FROM raw_stats_other_copyi1_copy INNER JOIN raw_stats_lookupON raw_stats_lookup_id = raw_stats_lookup.idWHERE domain = 'mydomain.com'AND date = '2014-02-10'GROUP BY attrib_id, raw_stats_value_id; -- Thanks, Slawomir. Dnia 6 marca 2014 17:46 Sergei Golubchik <serg(a)mariadb.org> napisał(a): Hi, pslawek83! On Feb 17, pslawek83 wrote: > Hi Guys, > any comments on this issue? It seems that partial unique indexes can't be used in joins. > https://mariadb.atlassian.net/browse/MDEV-5663 Please, show EXPLAIN EXTENDED (and SHOW WARNINGS after it) for this query of yours. > * Why the server is treating same indexes differently depends on if > they're UNIQUE or not It doesn't, there're almost no differences between UNIQUE and non-unique indexes from the optimizer point of view. Optimizer knows that for a unique index there can be at most one matching row (if all index parts are known and are NOT NULL), for non-unique indexes there can be more. That's basically the only difference. > * That's probably not optimizer issue, as we can't FORCE the index You cannot force the index if it is not applicable at all. > * What's internal difference between unique and non-unique index (eg. > memory / file representation / data structure) none. > * What each index type is suitable for, considering query optimization > (as there's no data i was able to find on topic) Aria only supports BTREE indexes anyway. Regards, Sergei

2 2

[Maria-discuss] Index bug in aria engine?
by pslawek83 06 Mar '14

06 Mar '14

Hi Guys, any comments on this issue? It seems that partial unique indexes can't be used in joins. https://mariadb.atlassian.net/browse/MDEV-5663 Regards,

4 5

[Maria-discuss] New Question: mariaDB for arm
by AskMonty KB 05 Mar '14

05 Mar '14

Hello, A new question has been asked in "MariaDB community" by mikestorcheous: -------------------------------- А не подскажите репозиторий для debian 7 armhf? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-for-arm/

1 0

[Maria-discuss] MariaDB & MySQL community event 3rd of April 2014 in Santa Clara
by Michael Widenius 05 Mar '14

05 Mar '14

Hi! I am happy to announce that the MariaDB Foundation is organising a MariaDB & MySQL community event in Santa Clara on Thursday the 3rd of April. The venue is the Hilton Santa Clara hotel, a short walk from the Percona Live 2014 event. You can find more information on my blog at: http://monty-says.blogspot.fi/2014/03/mariadb-mysql-community-event-2014-in… We already got some very interesting talks and speakers, but I would like to see even more talk proposals. It's ok to propose a talk that it's also hold at Percona Live. As this event is free, I expect a totally different group of attendees, so that should be fine! When we have got a nice list of proposed talks, we will post them here so that everyone has a chance of commenting of which talks should be accepted. (Sorry, but this time we don't have time to create a proper selection committee so we have to do this a bit rough) Personally I will talk about MariaDB 10.0, which should be declared stable by then. Hope to see many MariaDB developers and users in Santa Clara! You can sign up for the event and/or dinner at: http://www.eventbrite.com/e/mariadb-mysql-community-event-2014-tickets-1080… Regards, Monty PS: Feel free to discuss the event on this email list! We want to have as many as possible participating in making this the best possible MariaDB and MySQL event.

1 0