- discuss - lists.mariadb.org

[Maria-discuss] tx_read_only Vs transaction_read_only
by Rhys Campbell 23 Apr '15

23 Apr '15

You cannot use the tx_read_only in the .cnf file. You must specifiy transaction_read_only = 1 for it to set the value of tx_read_only on system startup. Conversely we do not seem to be able to do... SET SESSION transaction_read_only = OFF; Is this intended? Rhys Campbell Database Administrator TradingScreen, Inc. 23 York House, 5th Floor London WC2B 6UJ Email: rhys.campbell(a)tradingscreen.com<mailto:rhys.campbell@tradingscreen.com> Follow TradingScreen on Twitter<http://twitter.com/#!/TradingScreen> , Facebook<http://www.facebook.com/pages/TradingScreen/214046251945650> and our blog Trading Smarter<tradingsmarter.tradingscreen.com> This message is intended only for the recipient(s) named above and may contain confidential information. If you are not an intended recipient, you should not review, distribute or copy this message. Please notify the sender immediately by e-mail if you have received this message in error and delete it from your system.

1 0

[Maria-discuss] How many open files by daemon is still sane?
by Honza Horak 22 Apr '15

22 Apr '15

Hey, with limited experiences with mariadb deployments, I'm wondering how many open files by the mysqld daemon is still sane (expected). We have a customer that reports hundreds of thousands of open files with 600 connections (thread_pool_max_threads is used). Those processes seem rather stalled, but files in the datadir are often opened 40.000 times. Is it even possible that one file is opened several times during processing one query? Or does it mean there are ~40.000 queries running? Version of MariaDB: 5.5.40 Honza

6 14

[Maria-discuss] garb: unrecognized service
by Umarzuki Mochlis 21 Apr '15

21 Apr '15

$ sudo service garb start garb: unrecognized service After I installed galera-3, the above error appeared when I tried to start garb service. OS: Ubuntu 14.04 galera-3 v25.3.9-trusty

2 1

[Maria-discuss] New Question: Is MariaDB Client Library for Java Applications working on JAVA 6?
by AskMonty KB 21 Apr '15

21 Apr '15

Hello, A new question has been asked in "MariaDB Java Client" by jihoonko. Please answer it at http://mariadb.com/kb/en/is-mariadb-client-library-for-java-applications-wo… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi. Requirements for Latest version of MariaDB Client for java is written java 7 or 8. Which older version of MariaDB Client Library for java is working on java 6 well? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/is-mariadb-client-library-for-java-applications-wo…

1 0

[Maria-discuss] New Question: How to cleanly uninstall MariaDB
by AskMonty KB 20 Apr '15

20 Apr '15

Hello, A new question has been asked in "MariaDB Documentation" by yaroslav_nikitenko_g. Please answer it at http://mariadb.com/kb/en/how-to-cleanly-uninstall-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I've been using MariaDB on my server. It seemed to be hacked. I couldn't restart mariadb, and I deleted it with package manager yum. However, after reinstalling that I still experienced some problems (they didn't disappear). There is an opinion http://superuser.com/a/778269/387511 that some files such as databases are not removed during MariaDB uninstall. Is it true, and what should I take care of when uninstalling MariaDB? Thank you. I've used site search but couldn't find an answer in the official documentation. I suggest adding this to the part about installation of MariaDB. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-cleanly-uninstall-mariadb/

3 4

[Maria-discuss] What should offer base mariadb docker image
by Honza Horak 18 Apr '15

18 Apr '15

We're having quite interesting discussion about what users expect from general mariadb docker image, so trying to reach out (future) consumers. I see few options, from simple to feature rich scenarios, so let's take three examples.. A) simple one would only include installed packages and run the mysqld server with default configuration. (That one would probably be almost unusable, since users wouldn't have easy way to initialize datadir..) B) the image would include scripts that help to initialize datadir, set basic authentication (if given) and also offers to import some dump during initialization, e.g.: #> docker run -v /mydata:/var/lib/mysql mariadb #> docker run -v /mydata:/var/lib/mysql -v /dump.sql:/expected/dir mariadb #> docker run -e ROOT_PASS=abcdefgh -v /mydata:/var/lib/mysql mariadb C) full featured image that offers simple master/slave replication just by running: #> docker run -e TYPE=master mariadb #> docker run -e TYPE=slave -e MASTER=172.16.1.12 mariadb There are some advocates of the C) but IMHO it is not doable to deliver general enough solution for master/slave (thinking about failover scenarious in the first place), right? So B) sounds much more useful and I'd prefer such docker images. Does anybody has a different opinion? (either developer/user PoV would be welcome) Honza

2 1

[Maria-discuss] verifying a table is using autogenerated PK or not
by Umarzuki Mochlis 17 Apr '15

17 Apr '15

when I deleted a few rows, those rows did not get deleted on mariadb cluster second node. $ sudo grep "wsrep_certify_nonPK" /etc/mysql/my.cnf wsrep_certify_nonPK=1 > show create table comp2012db.uni12_jevents_vevdetail; +-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | uni12_jevents_vevdetail | CREATE TABLE `uni12_jevents_vevdetail` ( `evdet_id` int(12) NOT NULL AUTO_INCREMENT, `rawdata` longtext NOT NULL, `dtstart` int(11) NOT NULL DEFAULT '0', `dtstartraw` varchar(30) NOT NULL DEFAULT '', `duration` int(11) NOT NULL DEFAULT '0', `durationraw` varchar(30) NOT NULL DEFAULT '', `dtend` int(11) NOT NULL DEFAULT '0', `dtendraw` varchar(30) NOT NULL DEFAULT '', `dtstamp` varchar(30) NOT NULL DEFAULT '', `class` varchar(10) NOT NULL DEFAULT '', `categories` varchar(120) NOT NULL DEFAULT '', `color` varchar(20) NOT NULL DEFAULT '', `description` longtext NOT NULL, `geolon` float NOT NULL DEFAULT '0', `geolat` float NOT NULL DEFAULT '0', `location` varchar(120) NOT NULL DEFAULT '', `priority` tinyint(3) unsigned NOT NULL DEFAULT '0', `status` varchar(20) NOT NULL DEFAULT '', `summary` longtext NOT NULL, `contact` varchar(120) NOT NULL DEFAULT '', `organizer` varchar(120) NOT NULL DEFAULT '', `url` text NOT NULL, `extra_info` varchar(240) NOT NULL DEFAULT '', `created` varchar(30) NOT NULL DEFAULT '', `sequence` int(11) NOT NULL DEFAULT '1', `state` tinyint(3) NOT NULL DEFAULT '1', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `multiday` tinyint(3) NOT NULL DEFAULT '1', `hits` int(11) NOT NULL DEFAULT '0', `noendtime` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`evdet_id`) ) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8 | +-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) It seems that there's a PK. But what would cause this?

2 1

[Maria-discuss] Table encryption 10.1.4
by Rhys Campbell 16 Apr '15

16 Apr '15

Hi All, Been playing with encryption in 10.1.4 today and there's a few issues... Firstly the manual<https://mariadb.com/kb/en/mariadb/table-encryption/> gives the following example... "Example my.cnf to enable XtraDB encryption: [mysqld] file-key-management file-key-management-filename = /mount/usb1/keys.txt innodb-encrypt-tables innodb-encrypt-logs innodb-encryption-threads=4" But doesn't make mention of the fact you need to add.. plugin-load-add=file_key_management.so for this to work. Secondly... With this config.. "plugin-load-add=file_key_management.so file_key_management file_key_management_filename = /home/rcampbel/key.enc file_key_management_filekey = FILE:/home/rcampbel/keyfile.txt file_key_management_encryption_algorithm = AES_CBC innodb-encrypt-tables innodb-encrypt-logs innodb-encryption-threads = 4" I receive the following error... ERROR Innodb: Tablespace id 0 encrypted but encryption service not available. Can't continue opening tablespace." Then if I comment out inndob-encrypt-tables we get a step further but it complains.. "unknown option -innodb-encrypt-logs" <- documentation for 10.1.4 says different<https://mariadb.com/kb/en/mariadb/table-encryption/> If I change this to... innodb-encrypt-log The server then starts up successfully. Here's a snip of some relevant variables... [cid:image001.png@01D07869.79EBCC60] After this I do seem to be able to dynamically set innodb_encrypt_tables and create an encrypted table... [cid:image002.png@01D0786A.287E0B80] Side note file_key_management_plugin.so is missing from the 10.1.3 .tar.gz bundles Rhys Campbell Database Administrator TradingScreen, Inc. 23 York House, 5th Floor London WC2B 6UJ Email: rhys.campbell(a)tradingscreen.com<mailto:rhys.campbell@tradingscreen.com> Follow TradingScreen on Twitter<http://twitter.com/#!/TradingScreen> , Facebook<http://www.facebook.com/pages/TradingScreen/214046251945650> and our blog Trading Smarter<tradingsmarter.tradingscreen.com> This message is intended only for the recipient(s) named above and may contain confidential information. If you are not an intended recipient, you should not review, distribute or copy this message. Please notify the sender immediately by e-mail if you have received this message in error and delete it from your system.

2 2

[Maria-discuss] enforce_storage_engine
by Ian Gilfillan 16 Apr '15

16 Apr '15

Hi What is the reason for the the new enforce_storage_engine option being session only? Percona's implementation is global, and I realise there was a request to make it less strict, and be overridden by session for users with the super privilege, but surely it would make sense to allow a global default to be set, rather than just session only? The notes say that it was implemented based on default_storage_engine, but that variable is global and session, not just session. ian

1 0

[Maria-discuss] Does user have SUPER privilege?
by Rasmus Johansson 15 Apr '15

15 Apr '15

Hi, I was wondering if there is a straight forward way to check whether a user has SUPER privileges or not. I came up with doing the following: --check for user’s Super_Priv on the current host SELECT Super_Priv FROM mysql.user WHERE user = 'user1' AND host = 'host1'; --and then also check for user on whatever (%) host: SELECT Super_Priv FROM mysql.user WHERE user = 'user1' AND host = '%' But is there some more convenient way of doing it, maybe using SHOW GRANTS? Rasmus -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

2 1