- discuss - lists.mariadb.org

[Maria-discuss] faling tests
by Reindl Harald 06 Aug '15

06 Aug '15

just built 10.0.21 and thought it can't be wrong to report the faling test below - this is not new and virtually forever - however, maybe woth a look ______________________________________________________________ /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_not_null_innodb 'row,xtradb' [ fail ] Test ended at 2015-08-06 21:30:45 CURRENT_TEST: rpl.rpl_not_null_innodb 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_not_null_innodb.test at line 15: At line 179: query 'SET GLOBAL gtid_slave_pos= ""' failed: 1198: This operation cannot be performed as you have 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_not_null_innodb-row,xtradb/' to '/usr/share/mysql-test/var/log/rpl.rpl_not_null_innodb-row,xtradb/'

1 1

[Maria-discuss] New Question: What data type should I use to store XML natively in the database?
by AskMonty KB 06 Aug '15

06 Aug '15

Hello, A new question has been asked in "Data Types" by ksoh15. Please answer it at http://mariadb.com/kb/en/what-data-type-should-i-use-to-store-xml-natively-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I could not find a XML data type. Which data type can I use to store XML natively? I need to be able to parse and run XQuery on XML content. https://mariadb.com/kb/en/mariadb/data-types/ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/what-data-type-should-i-use-to-store-xml-natively-…

1 0

[Maria-discuss] MariaDB 10.0.21 and 5.5.45 now available
by Daniel Bartholomew 06 Aug '15

06 Aug '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.21 and 5.5.45. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.21 - Release Notes: https://mariadb.com/kb/en/mariadb-10021-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10021-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.21 - About MariaDB 10.0: https://mariadb.com/kb/en/what-is-mariadb-100 MariaDB 5.5.45 - Release Notes: https://mariadb.com/kb/en/mariadb-5545-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5545-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.45 - 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 - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/ We hope you enjoy MariaDB! -- MariaDB 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] Numa linux
by Roberto Spadim 05 Aug '15

05 Aug '15

Hi guys i'm comfiguring linux kernel, there's some valid numa comfig at kernel to check? It's a xeon server with 2 cpu and 10cores each -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

4 3

[Maria-discuss] New Question: How can I Move (migrate) a Replication Server (MariaDB) to a new Hardware and OS.
by AskMonty KB 04 Aug '15

04 Aug '15

Hello, A new question has been asked in "Standard Replication" by wschwauer. Please answer it at http://mariadb.com/kb/en/how-can-i-move-migrate-a-replication-server-mariad… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a server (Master) and 5 clients (slaves). The replication work’s fine. Now I must migrate the Server/Master Database to a new System. How can I move/migrate the old Master DB to the new Hardware? 1: Install MariaDB on new System. 2: Create all Table and so on on ew system. 3: Stop replikation on old Server 4: export all Tabledata from old Server and import to the new server 5: Start Replikation with the new Server IP ??? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-can-i-move-migrate-a-replication-server-mariad…

1 0

[Maria-discuss] MariaDB 10.1.6 beta now available
by Daniel Bartholomew 27 Jul '15

27 Jul '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.6. This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.6 - Release Notes: https://mariadb.com/kb/en/mariadb-1016-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1016-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.6 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/ We hope you enjoy MariaDB! -- MariaDB 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] Travis-CI and MariaDB
by Daniel Black 24 Jul '15

24 Jul '15

For those that use or develop open source or commercial projects that use Travis CI MariaDB has been added as a plugin. This installs either 5.5, 10.0 or 10.1 from the latest MariaDB repo against for testing. Documentation isn't up yet however it is planned. ref: https://github.com/travis-ci/travis-build/pull/303 As an example of Syntax (https://github.com/grooverdan/PyMySQL/blob/c05bf7c6d0f3161d91b3e1418ac185b8…) to test against all MariaDB versions as well as the pre-installed MySQL. Quick snippet: matrix: include: - addons: mariadb: 5.5 - addons: mariadb: 10.0 - addons: mariadb: 10.1 So add it to your own project's .travis.yml or send a PR to your favourite github project that can use MariaDB and Travis-ci. As for MariaDB-server in Travis-CI? we'll see if the bug committing fairies decide https://github.com/MariaDB/server/pull/84 is useful. -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

2 3

[Maria-discuss] stored procedures external languages
by Federico Razzoli 23 Jul '15

23 Jul '15

Hi all I remember these slides and this worklog about supporting external languages for stored procedures: * http://www.slideshare.net/AntonyTCurtis/external-stored-proceduresformysql2… * http://www.slideshare.net/AntonyTCurtis/a-tour-of-external-language-stored-… * https://dev.mysql.com/worklog/task/?id=820 As far as I can guess from the slides, there has been some active work on this idea, and some working code. I hoped so badly that I could see this in 5.x, and then in10.0, and then in 10.1. Is there any chance to see this feature in a future release, or should I just stop waiting? Please, consider all the benefits that would come from this: using a "real" language, using existing libraries, getting rid of almost all current stored procedures limitations... Regards Federico

4 5

[Maria-discuss] New Question: Installing on Windows 2008
by AskMonty KB 22 Jul '15

22 Jul '15

Hello, A new question has been asked in "MariaDB Community" by meysey. Please answer it at http://mariadb.com/kb/en/installing-on-windows-2008/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are currently MySQL users at the school and I want to migrate us to MariaDB. I tried installing mariadb-5.5.44-winx64.msi and although it installed fine there was no option to migrate the MySQL databases while I installed and there is no migration wizard in the stat menu too. Can anyone help me get up and running. TIA Charlie Markwick -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/installing-on-windows-2008/

1 0

[Maria-discuss] will maria db overcome mysqls feature limitations? (foreign keys+triggers, recursive triggers)
by Ludwig Gramberg 19 Jul '15

19 Jul '15

Hi, I was wondering if mariadb plans to overcome mysqls limitations such as - foreign key operations do not start triggers - triggers can’t be recursive (error 1442) I know that mariadb wants to be compatible with mysql but maybe these features could be optional? The mysql/mariadb comparison shows additional features which wont break compatibility I guess because they don’t exist in mysql (yet?). But besides additional features, is there a chance that mariadb could ever overcome limitations? Is this even a goal of this project? So far I only found postgres to support these features. Background of this question: I am developing an object relational mapper and my goal is to have the database enforce the consistency. So triggers and foreign key constraints working together are vital for this. regards Ludwig

4 5

[Maria-discuss] INSERT IGNORE and triggers
by Federico Razzoli 19 Jul '15

19 Jul '15

Hello. As we all know, IGNORE "catches" some errors and turns them into warnings. But I've noticed that it does not catch the same errors if they were issued by a trigger (using SIGNAL). * Is this by design? * Is this standard SQL behaior? Here is a trigger example to show what I mean: CREATE TRIGGER bi_t BEFORE INSERT ON t FOR EACH ROW BEGIN SIGNAL SQLSTATE '23000' SET MYSQL_ERRNO = 1048; END Regards Federico

2 1

[Maria-discuss] mysqlbinlog
by Rhys.Campbell＠swisscom.com 18 Jul '15

18 Jul '15

Hello All, I've been playing with mysqlbinlog today. I'm Looking at performing backups of the binary logs. The MariaDB<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> version in the sense it's missing a few features. Namely the ability to 'tail' a live binary log... mysqlbinlog --read-from-remote-server --host=host_name --raw --stop-never binlog.000999 I haven't fully tested this but running the MySQL version against MariaDB doesn't appear viable. I'm probably going to fall back to a FLUSH LOGS / file copy solution for the moment. What would be the chances of back-porting these features into the MariaDB version? Cheers, Rhys

4 13

[Maria-discuss] New Question: Ubuntu vivid package missing virtual-mysql-server-core
by AskMonty KB 17 Jul '15

17 Jul '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by wolfgang-baron. Please answer it at http://mariadb.com/kb/en/ubuntu-vivid-package-missing-virtual-mysql-server-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- On ubuntu vivid, the current mariadb-galera-server-10.0 package does not provide virtual package virtual-mysql-server-core (it only provides virtual-mysql-server), which disables the installation of akonadi-backend-mysql, which is obligatory for akonadi-server and thus all akonadi using programs. Is there a way to fake this provision? How do I report a bug like this? Thanks for any help! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/ubuntu-vivid-package-missing-virtual-mysql-server-…

1 0

[Maria-discuss] Getting PAM auth to work with JDBC
by Troels Arvin 16 Jul '15

16 Jul '15

I've got the PAM authentication to work, as long as I use a plain command line MariaDB client or HeidiSQL. But I need things to work with JDBC as well. I've found some instructions what seem to indicate that I need to somehow make the JDBC connection use SQL and plain-text authentication. But I have not been able to find specific instructions on doing that. (The instructions, I've seen seem to mainly point to other documents in a circular/byzantine way.) Has someone got the combination of a JDBC client and an PAM-enabled MariaDB server to work? If so: Can you shed some light on the steps you went through? Thanks in advance. -- Regards, Troels Arvin http://troels.arvin.dk

3 2

[Maria-discuss] New Question: ERROR 1932 on a table with recently added VIRTUAL column
by AskMonty KB 16 Jul '15

16 Jul '15

Hello, A new question has been asked in "MariaDB Community" by Bytesmiths. Please answer it at http://mariadb.com/kb/en/error-1932-on-a-table-with-recently-added-virtual-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Using version "10.1.0-MariaDB-log - Source distribution" on MacOS X Server 10.6.8 via phpMyAdmin 4.1.8 using raw SQL, I recently used ALTER TABLE to add a VIRTUAL column to a table that was the simple difference between two columns: "ALTER TABLE s_vehicle_log ADD COLUMN v_distance INT(5) AS (odometer - begin) AFTER odometer". This first appeared to work; I could see the new column in phpMyAdmin and it appeared to have the proper values. But within an hour, I could no longer access that table. Going into the mysql CLI, executing "SELECT count(*) FROM s_vehicle_log;" yields "ERROR 1932 (42S02): Table 'EcoReality.s_vehicle_log' doesn't exist in engine" (I do the same on other tables in the same database successfully.) Going into the shell (bash), I can see the proper files, and they have the same perms as other tables that work properly: # ls -l s_vehicle_* -rw-rw---- 1 _mysql _mysql 1264 Feb 12 18:40 s_vehicle_cost.frm -rw-rw---- 1 _mysql _mysql 98304 Feb 12 18:40 s_vehicle_cost.ibd -rw-rw---- 1 _mysql _mysql 3796 Jul 15 15:56 s_vehicle_log.frm -rw-rw---- 1 _mysql _mysql 688128 Jul 15 15:56 s_vehicle_log.ibd -rw-rw---- 1 _mysql _mysql 2583 Feb 12 18:40 s_vehicle_monthly_query.frm It is interesting that, though ERROR 1932 says the table doesn't exist, phpMyAdmin shows it in the list of tables, showing "in use" as its table type: s_vehicle_cost Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~11 InnoDB latin1_swedish_ci 16 KiB - s_vehicle_log Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop in use mysql SHOW TABLE STATUS isn't very helpful, either: MariaDB [EcoReality]> show table status like 's_vehicle_%' -> ; +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------+ | s_vehicle_cost | InnoDB | 10 | Compact | 11 | 1489 | 16384 | 0 | 0 | 0 | NULL | 2015-02-12 18:40:32 | NULL | NULL | latin1_swedish_ci | NULL | | Cost per km of vehicles over time. | | s_vehicle_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Table 'EcoReality.s_vehicle_log' doesn't exist in engine | | s_vehicle_monthly_query | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Table 'EcoReality.s_vehicle_log' doesn't exist in engine | +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------+ 3 rows in set, 2 warnings (0.00 sec) Looking at the most recent file that seems to be a binlog reveals nothing of interest; just phpMyAdmin logging queries about the damaged table: # mysqlbinlog ../mysql-bin.000127 | fgrep s_vehicle_log REPLACE INTO `phpmyadmin`.`pma__table_uiprefs` VALUES ('root', 'EcoReality', 's_vehicle_log', '[]', NULL) REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]') REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]') REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]') repair table s_vehicle_log REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]') REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_vehicle"},{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"}]') ---------------- Anyone know what's going on, and what to do about it? (Besides "restore from backup," which is a bit old.) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/error-1932-on-a-table-with-recently-added-virtual-…

1 0

[Maria-discuss] doubt - replication at same mysqld process
by Roberto Spadim 15 Jul '15

15 Jul '15

hi guys, i have a doubt about replciation on same machine, i never did this before i have a table running many writes and few reads, and another process start reading a lot, my today solution is replication on two servers (on same machine or other machine), the point is... could i replicate in same server (with only one server running / only one mysqld process) ? something like change table A, and a background process replicate to table B? "many writes" will write at table A, reads will read table B (read can be out of sync) innodb is locking a lot of rows, and myisam/aria is locking table a lot, both engines i have problem with lock, i consider replication to another mysqld process as the only solution, but i'm considering running only one mysqld process (if possible) i was thinking about something like HA in spider, but i didn't tested, maybe with flexviewcdc i could have a materialized view "B" of table A? any idea/help is wellcome -- Roberto Spadim

5 16

[Maria-discuss] ssd and hdd
by Roberto Spadim 12 Jul '15

12 Jul '15

hi guys i`m with a doubt... i have a server with ssd raid 10 array and hdd raid10 array ssd is faster for non sequencial read that's a fact when i change a table from one device to another and check query response histograms my doubt is... today i have myisam, aria, innodb and sometimes tokudb and spider at same server how could i easily select what table should be stored at ssd or hdd array? there's a "table space" to select if i want to use ssd or hdd instead of create table, and create symbolic links, or create table with data directory/index directory? i was thinking about something more easily understood like tablespace, but used by all engines something like create table blabla table space ssd create table blabla table space hdd what i'm doing today... i have many tables that i use normally and don't drop, these tables i can symbolic link to ssd or hdd, but all new tables i use hdd (they normally are temporary tables), i'm using innodb per file, tokudb i'm not using too much but i don't care about where it's today anyone with experience to help or ideas? -- Roberto Spadim

4 3

[Maria-discuss] New Question: Joomla 1.5 and unicode databse
by AskMonty KB 12 Jul '15

12 Jul '15

Hello, A new question has been asked in "Moving to MariaDB" by alijam. Please answer it at http://mariadb.com/kb/en/joomla-15-and-unicode-databse/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a server which (unfortunately) have tens of joomla 1.5 websites, After upgrade from Mysql to Mariadb 10 , all of the unicode texts are being displayed as question marks (i.e. ?????? ????), I looked into the databases , the data seems to be intact, even I moved some of them to another server with mariadb 5.6 which "seems" ok. It seems to be a driver/configuration issue. It works on later versions of joomla (2.5& 3.x) versions. It seems mariadb should also be compatible with joomla 1.5 In the joomla system information it says: Database Version: 10.0.20-MariaDB Database Collation: N/A (mySQL < 4.1.2) PHP Version: 5.4.41 Web Server: Apache Web Server to PHP interface: cgi-fcgi Joomla! Version: Joomla! 1.5.26 Stable [ senu takaa ama busani ] 27-March-2012 18:00 GMT User Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:39.0) Gecko/20100101 Firefox/39.0 Any help would be greatly appreciated , as I'm going to upgrade my other servers to mariadb. Best -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/joomla-15-and-unicode-databse/

1 0

Re: [Maria-discuss] New Question: backup
by Reindl Harald 10 Jul '15

10 Jul '15

Am 10.07.2015 um 14:03 schrieb Pantelis Theodosiou: > Is rsync a valid backup option for a running server? no > Without stopping it or at least (flushing and) locking tables first? no there are files in use and you can't get a safe, consistent snapshot of the datadir when the server is running, what you can do is one hot rsync, then stop mysqld and make a second rsync which should be fast because it only needs to copy the recent changes and fire up the daemon after that but that's just a workaround losing caches and buffers for nothing there is no problem start a replication-slave instance even on the same host while it's prferred to have it on a different because that brings you a "realtime backup" if the master host crashs unclean and refuses to start mysqld because damage of datafiles > On Wed, Jul 8, 2015 at 3:53 PM, Reindl Harald <h.reindl(a)thelounge.net > <mailto:h.reindl@thelounge.net>> wrote: > > > > Am 08.07.2015 um 16:40 schrieb AskMonty KB: > > A new question has been asked in "MariaDB Documentation" by > gtrymore. Please answer it at http://mariadb.com/kb/en/backup/ > as the person asking the question may not be subscribed to the > mailing list. > > -------------------------------- > How do you back up a mariadb server and what is /var/lib/mysql > directory > -------------------------------- > > power down the replication slave and rsync /var/lib/mysql to the > backup-location or whatever folder is configured as datadir - to be > honest you could have typed the same in a google search

1 0

[Maria-discuss] New Question: backup
by AskMonty KB 10 Jul '15

10 Jul '15

Hello, A new question has been asked in "MariaDB Documentation" by gtrymore. Please answer it at http://mariadb.com/kb/en/backup/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do you back up a mariadb server and what is /var/lib/mysql directory -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/backup/

5 8

[Maria-discuss] New Question: MaxScale without a Single Point of Failure?
by AskMonty KB 10 Jul '15

10 Jul '15

Hello, A new question has been asked in "MaxScale Getting Started" by iomdesign. Please answer it at http://mariadb.com/kb/en/maxscale-without-a-single-point-of-failure/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, We are looking at potentially using MaxScale as a solution to load balance our MySQL connections and provide read/write splits in a master slave setup. If we have both web servers pointing to a single proxy then obviously we have a single point of failure. When we were originally looking at HAProxy it was suggested having a local proxy for each web server that could then balance out across the databases. Is it possible to run MaxScale in a similar fashion? Is there a better approach that could be suggested with MaxScale without a single point of failure? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maxscale-without-a-single-point-of-failure/

1 0

[Maria-discuss] mariadb galera on sles?
by Federico Razzoli 07 Jul '15

07 Jul '15

Hi Is there a MariaDB Galera cluster repository for SLES12? I've found MySQL Galera repos, but not MariaDB... Regards Federico

2 1

[Maria-discuss] New Question: Limits in .frm
by AskMonty KB 01 Jul '15

01 Jul '15

Hello, A new question has been asked in "Optimization and Tuning" by lrirwin. Please answer it at http://mariadb.com/kb/en/limits-in-frm/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Does MariaDB implement anything to either split the content of the .frm files (or some other approach) to get beyond the 64K limit? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/limits-in-frm/

1 0

Re: [Maria-discuss] Can't connect to local MySQL server through socket
by Sylvain Raybaud 01 Jul '15

01 Jul '15

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi I'll try hard to fix the problem with rsync, even if I switch to mysqldump or xtrabackup-v2 in the future. Some context : mariadb and galera are built in buildroot and run on raspberry pis (ARMv6). Mariadb is started manually. I fixed the config file as you suggested yesterday (wsrep_cluster_address=gcomm://IP1,IP2,IP3 in my.cnf on all three nodes). I bootstrap the cluster on node #1 with --wsrep-new-cluster and I just start mysqld_safe and nodes #2 and #3. Running: mysql -u root --execute="SHOW GLOBAL STATUS WHERE Variable_name IN ('wsrep_ready', 'wsrep_cluster_size', 'wsrep_cluster_status', 'wsrep_connected');" on node #1 gives me: +----------------------+---------+ | Variable_name | Value | +----------------------+---------+ | wsrep_cluster_size | 3 | | wsrep_cluster_status | Primary | | wsrep_connected | ON | | wsrep_ready | ON | +----------------------+---------+ and on nodes #2 and #3: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111 "Connection refused") If I start mariadb outside a cluster on nodes #2 and #3 it works as expected. It seems nodes #2 and #3 are never synced since SYNCED never appears in error log. wsrep_sst_method is rsync. On 24/06/2015 15:00, Guillaume Lefranc wrote: >> Does this mean that mariadb tries to sync nodes but for some >> reason the script hangs, the nodes are never sync and remain >> unusable? > > I'm afraid that must be something along those lines. I have the > following suspicions: > > * SELinux or Apparmor not disabled, causing the SST to hang > forever. * Ports not open on the firewall (for the record you need > 3306, but also 4444, 4567 and 4568). Neither SELinux or Apparmor is enabled and there is no firewall on any of the boxes. They are all connected to the same ethernet switch. I'm investigating wsrep_sst_rsync script. Here are the processes running: # ps auxf | grep mysql 128 root {mysqld_safe} /bin/sh /usr/bin/mysqld_safe - --defaults-file=/etc/mysql/my.cnf 422 mysql /usr/bin/mysqld --defaults-file=/etc/mysql/my.cnf - --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/plugin - --user=mysql --wsrep_provider=/usr/lib/libgalera_smm.so - --log-error=/var/lib/mysql/buildroot.err --pid-file=/tmp/mysql.pid - --socket=/tmp/mysql.sock --port=3306 - --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1 429 mysql sh -c wsrep_sst_rsync --role 'joiner' --address '192.168.1.80' --auth '' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '422' --binlog '/var/lib/mysql/mariadb-bin' 430 mysql {wsrep_sst_rsync} /bin/bash -ue /usr//bin/wsrep_sst_rsync --role joiner --address 192.168.1.80 --auth --datadir /var/lib/mysql/ --defaults-file /etc/mysql/my.cnf --parent 422 --binlog /var/lib/mysql/mariadb-bin 458 mysql rsync --daemon --no-detach --port 4444 --config /var/lib/mysql//rsync_sst.conf 26966 mysql sleep 0.2 Note the sleep 0.2: it shows up often. It appears in wsrep_sst_rsync in two places: lines 136--140: # wait for tables flushed and state ID written to the file while [ ! -r "$FLUSHED" ] && ! grep -q ':' "$FLUSHED" > /dev/null 2>&1 do sleep 0.2 done lines 281--284: until check_pid_and_port $RSYNC_PID $RSYNC_REAL_PID $RSYNC_PORT do sleep 0.2 done Is it possible that one these loops never terminates? If I run the same commands invoked by mysql manually, they terminate with errors because SST_PROGRESS_FILE and WSREP_SST_OPT_ROLE aren't defined but this is probably not significant. I'll be happy to read any idea you might have. Maybe I should also send this message to galera mailing list? Cheers, - -- Sylvain Raybaud www.green-communications.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJVi9d9AAoJEEkkwl4JtJ9yE6EP/3PVzEXO7KVX9UrKrQSLXXM/ EWuV2a2KKxB8GkH1uDBISrn84futPR6M7/gdbMV8DeRNWAbCWgXWkrY/HVALvLxu jze4znZMmn+mxqDzmhp1klon+w9WAyH7lSfIC4AGgSiAe6ZFP5c8CSfbLNJPlSM+ buoJTQz9BFo+NTh4w7gbZUjAJVEm/7CpM8TwMPsu7+mMvbn4yMMLU2RkjhysGGKI YAJ9dXYjmD+49Z3Z2B54lRGeIbZNMDRjlQ/+F61Ml9XbQYJtDb8gHGN5a4FIiaFh pvOtjCi5foXdGfGv/nPbSkrMqkKBJHL0xbnKeze/OdIdZ1aOVN7Sy5tZJirlCJV3 q/48hmrIIMVU1FuC9F0zW7lGHsgsKiQvLM0X8C/ZdX0ZTvTjWWefoWLa/fSv/vYp z9E5HJxJ47gbnGeSEBby1+TmV/GoXvjiyH3oRXzEuyEP5xQtKH4Kvrh9MhwZdZpv sJc5QO9qfAHPecavhRQ1luuv6JCSqLPGpF+3RB80rB+BRUkwi0dfO0RmBzzmKBGZ vryGxAVBNZmpIatuCWY4cvvrkQm9kF7JMAR1rNTRylxLtyI5TR42c5r24tSasWct P6gICSrMBKVgoCdxanTI2q+faqAur/NDq4W6tgeqRnV/mk9zQW4oxJxfwQlS0zr6 YiUMXGeRi6IT0MTKwChk =goS7 -----END PGP SIGNATURE-----

2 5

[Maria-discuss] New Question: Data Type
by AskMonty KB 29 Jun '15

29 Jun '15

Hello, A new question has been asked in "MariaDB Community" by bhumika. Please answer it at http://mariadb.com/kb/en/data-type/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, Can I create my own custom Data type in Maria DB , Can you please provide me some help on this. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/data-type/

1 0

[Maria-discuss] New Question: ipv6
by AskMonty KB 28 Jun '15

28 Jun '15

Hello, A new question has been asked in "MariaDB FAQ" by gerald_schade_g. Please answer it at http://mariadb.com/kb/en/ipv6/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- does, will or when (and how) will MariaDB support client-connections via ipv6? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/ipv6/

1 0

[Maria-discuss] doubt about index
by Roberto Spadim 26 Jun '15

26 Jun '15

hi guys, i`m with a doubt... when i have a primary key i know that's a unique key when i have a index with primary key + any other column, does mariadb consider that it's unique too? i`m thinking more about SELECT optimization

4 31

[Maria-discuss] FedereratedX ODBC Source
by Darin Keever 25 Jun '15

25 Jun '15

This is regarding: https://mariadb.com/kb/en/mariadb/about-federatedx/ Specifically, the last section bullet - Support for other RDBMS vendors using ODBC My employer started a project to add a generic ODBC source to the FederatedX plugin. Once into the project, it was decided that creating a specific source to our COM server would be faster. The ODBC source did work, but it was buttoned up after read-access was completed. I'm not sure if it will ever be released, but I thought we should distribute the code regardless. Please find an incredibly boring page here: http://stonebond.com/mariadb-contributions/ Included in the zip are the changes to source files, as well as two additional files for connecting to ODBC and to our COM dll. These were only compiled on windows, so likely are not ready for inclusion in the source tree. Let me know if you have any questions.

2 2

[Maria-discuss] More love for Dynamic Columns - support in Sequel Pro
by Tom Worster 24 Jun '15

24 Jun '15

Just a little bundle plugin to view the values in a dyncol blob but very handy all the same. If you use dyncols, which I do. https://github.com/tom--/sequel-pro-maria-dynamic-column In other dyncol news, we've improved the ORM extension <https://github.com/tom--/dynamic-ar> that I mentioned in a previous email. I'm using it in a project and it's really nice not to have to either mess with the schema every day or EAV. Having a nosql document in every row of a table is real swell. Tom

1 0

Re: [Maria-discuss] Can't connect to local MySQL server through socket
by Sylvain Raybaud 24 Jun '15

24 Jun '15

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Guillaume, Nirbhay, On 24/06/2015 15:35, Guillaume Lefranc wrote: > If you want to try xtrabackup SST: * xtrabackup must be installed > on all servers * you need to set wsrep_sst_method=xtrabackup-v2 > (the older method is full of horrible bugs) * you need to set > wsrep_sst_auth to a user account which has permissions to do > backup, e.g. : RELOAD, LOCK TABLES, REPLICATION CLIENT at the > minimum > > I cannot stress it enough but re-read the docs thoroughly before > doing anything :-) > In my case it means creating a buildroot package for xtrabackup, which is definitely on my TODO list, but wasn't scheduled just now :) Since SST fails both with rsync and mysqldump (even when I set credentials properly, or think I do), I think I should fix that before trying to switch to another method. I think this mariadb problem is hiding a more fundamental communication problem between my buildroot boxes. I'll let you know. - -- Sylvain Raybaud www.green-communications.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJVisWEAAoJEEkkwl4JtJ9yPmsQALxq44ZbyqqHhnUStSo5P29H RVvUztKZ9cfG11ksPToFeCIlcuMiVhL6j5nzLQ/nskEIavVPeSCovmUVlYNTqLAm ZufNhGY0xAvUoaaDow125dy7wB0Sxq246cAFytNMP1ru/T770h955uObSCpEu7ql PW18Qd2DMoNDb1xReyAmGiUa2wHdWJMLHP7G5tn4nIauESgymRRMh5Ha/7BpBIWw WoEFr3BPPXvzdm/SHY/rjWRR5pl5xKlKv3gzweuNWw64d5T2ppO906bId3b8fZWz iSEwhmX57Pgkgpn2iPjx3eCQVkRI5Du7rMifhbA0Os5tsHXB+Ia3seVeXs+DMkvL tQTnQIMgzRC7M6zCBOt7axZwQVH0DDuZwBfPDzPbF2EiiSTkwULPZN90Mp/itOR3 84xkC7b2hZG6porEJv2/gNk/SBop8Elvx91JcSv7t7RNDMGggq4q3ZXz6ai4vGMY nIWH/hNqiybeUFrVBRWoVpiRSejLLB+SVf1v74yiB7JeXbuIa8WnbgVek0cle3j5 u4wBk+MkewrcVhDxXB6d1x9k/e0QP1MaohUPMFeyrw25MtoyFx/RfjhI8cMtPSdI 9lF39YqNMDrZ+wlwZ9v1ylh56popD0faYjMaSQwXKMBNH08dMisqUj9Vt94JY2pe Dz2TSVIvCDLlyBGT73nN =yjW8 -----END PGP SIGNATURE-----

1 0

Re: [Maria-discuss] Can't connect to local MySQL server through socket
by Sylvain Raybaud 24 Jun '15

24 Jun '15

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 24/06/2015 15:11, Guillaume Lefranc wrote: > Sylvain, > > On Wed, Jun 24, 2015 at 3:06 PM, Sylvain Raybaud > <sylvain.raybaud(a)green-communications.fr > <mailto:sylvain.raybaud@green-communications.fr>> wrote: > > >> >> I forgot to mention in my previous mail that after starting >> mariadb in the first node I run: >> >> mysql -u root --execute="SET GLOBAL >> wsrep_cluster_address='gcomm://';" >> >> >> Don't do the above. Since you are starting the cluster with >> --wsrep_new_cluster, that's enough. I'm not sure of what it >> would do but I'd rather avoid to bootstrap the cluster two >> times. > > If I don't, the cluster does not start at all, all I get is a > disconnected cluster of size 0 on node #1, exactly as described > here: > https://mariadb.com/blog/mariadb-galera-cluster-quirk-bootstrapping > > > > Yes, but this happens for a good reason and the manual is quite > clear about that: You didn't set wsrep_cluster_address in your > my.cnf. I would recommend to set it on all nodes, as it can cause > all kinds of things to go wrong in the future (imagine you reboot > your 1st node, it has no peers to reconnect to), plus some other > side effects I cannot envision. So recommendation is really to have > this set on all nodes with IP addresses of each node, in your case > wsrep_cluster_address=gcomm://192.168.1.77 > <http://192.168.1.77/>,192.168.1.80,[IP of node 3] Got it, doing that :) I tried setting wsrep_sst_method to mysqldump instead of rsync and it fails. Here are the error logs: node #1: http://pastebin.com/UXr378mC node #2: http://pastebin.com/4xEi2ncS node #3: http://pastebin.com/LWvmrdAt Still investigating. - -- Sylvain Raybaud www.green-communications.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJVirDlAAoJEEkkwl4JtJ9ytK4P/2d8QMDUKbN48MT1/mA4kI4x n2Y1VOahIUWxG6YZjenAHSi96VUpzIkpk5VQvzeozIRTtmsFlfhsitwZwd8pERmu Usse6+fptio2iHpzabyterMmyXrEcI9Dtdu9/4KBPBKs1WBdShDkmEvUJ279oaIU uj3cuOMWo05snac3wFuSk53edCaUPT6CJfTHUn+FkmFQbRzEE89Q2IW+FKdUW23L X9XOuabR5iu1/5FeJxmYut3yS10slByebofjQlMGFdRZ20ZD60phRjuIqr4VtgK+ Pl6wwMlAYMgrwvGxNUOzA3czm23oulfwcziFRk8DA2xkLxJyYDW8XDzGphoBWLzZ oaQIE+ikYNFEUDPGUVvBRnVigmi2NksXz7s8ND8oSROwoXqzgH+MhR1kYdcysPKp aEs94h7uwh1u+0wHVNFmd7xNwbZyJxeb+ICB7GxpTlLMk8EbUZzbuGiiEcZaWNb3 IOfifbs8sc5/eE3Jrds67cFaUsjAchyNLQ2eNraoiDN1b8KD6nflmU8M5bdJ9UYH ICfpa9CSA2+qYWHWh9XfEEwb3Ugal1i/xSqlbObkVeqAlG8/PWbA5ubeBlGhzVDF jObLYVhh5c+bKLtKXPmzi1fvvsCaSiYRvXFxetmWO+8BpL27i37dfhslyc8Fk6/j +YwjwwY+st1sIm1oE/5M =Lvhi -----END PGP SIGNATURE-----

2 1

Re: [Maria-discuss] Can't connect to local MySQL server through socket
by Sylvain Raybaud 24 Jun '15

24 Jun '15

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 24/06/2015 15:00, Guillaume Lefranc wrote: > > > Nope, the database is empty (I just created it with > mysql_install_db; also all nodes are fresh installs). Only the > first node has SYNCED in its log indeed: # grep SYNCED > buildroot.err 700101 0:01:10 [Note] WSREP: Shifting JOINED -> > SYNCED (TO: 0) > > The two others show neither SYNCED or any reference to mysql.sock. > > > > I forgot to mention in my previous mail that after starting mariadb > in the first node I run: > > mysql -u root --execute="SET GLOBAL > wsrep_cluster_address='gcomm://';" > > > Don't do the above. Since you are starting the cluster with > --wsrep_new_cluster, that's enough. I'm not sure of what it would > do but I'd rather avoid to bootstrap the cluster two times. If I don't, the cluster does not start at all, all I get is a disconnected cluster of size 0 on node #1, exactly as described here: https://mariadb.com/blog/mariadb-galera-cluster-quirk-bootstrapping > >> Does this mean that mariadb tries to sync nodes but for some >> reason the script hangs, the nodes are never sync and remain >> unusable? > > I'm afraid that must be something along those lines. I have the > following suspicions: > > * SELinux or Apparmor not disabled, causing the SST to hang > forever. * Ports not open on the firewall (for the record you need > 3306, but also 4444, 4567 and 4568). > Ok, I'm following this lead. I'll let you know. > -- Guillaume Lefranc Consultant / RemoteDBA Services - MariaDB > Corporation Ab - -- Sylvain Raybaud www.green-communications.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJViqtSAAoJEEkkwl4JtJ9yDtMP/RC8SkWQSd4iU2FMJn8Hj1LW K4Y9n0FETIu7pUpFiqAg13l+4ocEblv+SlYPPzAI5bdpBPVTA+EG7ypkyQgolPxX 5TQUUGjIM0rN675IVcDQalX8KPytSR8LkNDvB95oE71fKjOB9Ne71P8YpfdRMZgU 9Y7HMFPxckJulZOcoKb/4erOC9txgn69MY9YZ4QVQKahxK6vKfnbOOkS88SHNojy KYeLrMWR6Jk0wmPz4ivMveRzJfGrCI8cxWGi26btxGfhWXUvq2/Wv0nYrfByN9ZH kRd7Lo5RHnTzwT+EGNVtgkesA1L6UNgUo/N3fW8hGSnpIFuK+4CMcHjAsG6IxXVl iX1uP4H56OydRZh3tzdnY7+vjAN6dz6J6bo1X/mtaUMcKk+f/whkbxy6+Ggeq92d gWjoECDPJUd4R5JzTy4uMDhstg3RKX0KL32AGajPUJmFLAhmA9vkSRh1Wz9MVIBQ /cPMSndhLFjlSRJAfdh2GHy8y1xCjLHxR7k1qQqf7AhKTYCE2Pq21ZTYRdJZkP6S vo0W+KXcV4CvR0+rT15DJCUodwSak+r6GOCJ86koVs64JtcSyuLaqTKvtn0AjX4y r+JG5G9WwKcbAx77BQk75EmL86rnuICFaXhXqe6HYs0Pi7xFuKCtLYZrAFtn2r5H YhApUDevV8dNh4Vwl6wn =iVBf -----END PGP SIGNATURE-----

1 0

Re: [Maria-discuss] Can't connect to local MySQL server through socket
by Sylvain Raybaud 24 Jun '15

24 Jun '15

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 24/06/2015 14:38, Guillaume Lefranc wrote: > Also if I'm correct, you must have rsync running on the processlist > of node 2. As mentioned in my previous email, I don't have much data in this db. However, I do have rsync running on nodes #2 and #3, even long after I started mariadb: # ps aux | grep rsync 464 mysql sh -c wsrep_sst_rsync --role 'joiner' --address '192.168.1.80' --auth '' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '457' --binlog '/var/lib/mysql/mariadb-bin' 465 mysql {wsrep_sst_rsync} /bin/bash -ue /usr//bin/wsrep_sst_rsync --role joiner --address 192.168.1.80 --auth --datadir /var/lib/mysql/ --defaults-file /etc/mysql/my.cnf --parent 457 --binlog /var/lib/mysql/mariadb-bin 493 mysql rsync --daemon --no-detach --port 4444 --config /var/lib/mysql//rsync_sst.conf 14589 root grep rsync Does this mean that mariadb tries to sync nodes but for some reason the script hangs, the nodes are never sync and remain unusable? - -- Sylvain Raybaud www.green-communications.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJViqk1AAoJEEkkwl4JtJ9yawwP/jH6XsdNLwjYgo40baiMn6/e lo6uls7yq+GHnw3GC3R/YBXYqRpBWv2rPi6hKf1wFnXlyP7rN3xY3zR3bnICH0G9 Y/y+RLdeWdzEFncfz7Vxq/kY771ITjAsha+eGdC9ShUkC61FyQ1lOXjj/5N6eHpS UQhkuoHJoP8/sdLN6Q3jnBUOUKZZIpSG7QsRG+Th8RuERPkJP+slDAkTsvM1qe6+ kCSaQugfUrtobxm5glAGSYlprRQ2EojTYDnS+qpqeBKwwAPA8g+u/a25AayDl5MB 32fWBH6iy2DjqnXnRdeS7BX/jhGAXvy8zJGylnfLakRQFDEUScpjZlOB2Bp0UtuC qKRkV35eDDu1LTGHCbWu5dQx1D3TsbSIi571Ffiw4vZtwVgTRsT8LLV8opnA6aa1 ixbEfz3P5lujB4cDASMDsrbTYHQ4MU78G1QnXjVRMQS7PwPaDjAk/zDW9krengyS jfZSR7w1fYOsOyb0elxEl2tzkW6pDoGhAQ3P3ETM++ruyv2gjoxYVaN+GH7vPlee Ooz75NoDPg6t97TfOP1B60QhSHK7Xwp7ISBSJIZd1LXM64MtgxB2vh+bTdGV/C5x JXVvHmihBdsqX+4e78WSxoydb4ZyBDRLG+0jwDmPoUcYuYYxvtH1DYgdGBgfeN54 T5+/U42/4oSSZ1C+HSGz =OXeD -----END PGP SIGNATURE-----

1 0

Re: [Maria-discuss] Can't connect to local MySQL server through socket
by Sylvain Raybaud 24 Jun '15

24 Jun '15

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 24/06/2015 14:38, Guillaume Lefranc wrote: > Sylvain, > > the logs tell that node 2 and 3 have joined the cluster, but that > they are not yet in sync. This is very clear in logs of node 2: > > 700101 0:00:35 [Note] WSREP: *State transfer required:* Group > state: 7cf7113a-1dd3-11b2-a623-76b507fb8ed5:0 Local state: > 00000000-0000-0000-0000-000000000000:-1 700101 0:00:35 [Note] > WSREP: New cluster view: global state: > 7cf7113a-1dd3-11b2-a623-76b507fb8ed5:0, view# 11: Primary, number > of nodes: 3, my index: 0, protocol version 3 700101 0:00:35 > [Warning] WSREP: *Gap in state sequence. Need state transfer.* > 700101 0:00:35 [Note] WSREP: Running: 'wsrep_sst_rsync --role > 'joiner' --address '192.168.1.80' --auth '' --datadir > '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent > '420' --binlog '/var/lib/mysql/mariadb-bin' ' > > I assumed that you started your cluster empty, which might not be > the case. If you have several gigabytes of data on the first node, > you have to allow some time until rsync has finished copying the > data to the other nodes. You can do that by tailing the error log > of node 2 until the SYNCED state keyword appears. Also if I'm > correct, you must have rsync running on the processlist of node 2. Nope, the database is empty (I just created it with mysql_install_db; also all nodes are fresh installs). Only the first node has SYNCED in its log indeed: # grep SYNCED buildroot.err 700101 0:01:10 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) The two others show neither SYNCED or any reference to mysql.sock. I forgot to mention in my previous mail that after starting mariadb in the first node I run: mysql -u root --execute="SET GLOBAL wsrep_cluster_address='gcomm://';" but you probably guessed since I'd get a different error if I hadn't. - -- Sylvain Raybaud www.green-communications.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJViqhmAAoJEEkkwl4JtJ9y7ioP/A5sGSaNrJ8jJhPaaN38XIEQ UAjUxUFyQQBEuzmvo3LY5PoTXKNXjWzhMHL6+bFqvIYb7RXa2mC/jm/gowuNIE8v jBz8NOjUbH/nayWFQquguEOe1EBO2671CNWsGmpqzKkxj5CVq4SykTk34+d6xUye 7EubHiOUKYK5BuILY3zBaVzxGeBlHaZsZCx7C65a81bgB+0wOMFQED2u5u24VbwA pm6+q+psR8O0H6EdeMzgPCvxgQZeGi+HahXWAZuts3/mkTbFpEgFeg/xt8x9jIg9 vz6K6Q5TD43NaMs+XD86Z4mgGPBaEapZKc9YQV8Ge58gngkgZt9L4q+mi//ISZ1z CCbsQlUd6JqLethWLAIr0VdXLU26P28kVza4aAqjnkl9Pz1s4CmweSg4tuo7avXk DDV9//7kOFbAKdLJX+egpHu+fb+WwgWeSKNzdauKjTGfH+qPSPb10j2GSowedEK/ WzCWsZb0GZyn8gHRPMDC6olSs+daCp8imWqKw70LOAjCzMcBrFG/ynMWB8vBoHqU Q5KgEhfUStDLMMZkqgI1Ov91LZDPPG2zr0mjwe7+k7xc5GO6gtih/F8atruT2PRu cdgEvapcR8Qp+fsBlzVdeK15yVrxaWrZDDhh+YaYuLS2kzDW3KGwqHUNYykhyLcl QgaIDguJcH4ye95Sb2Cv =CpJL -----END PGP SIGNATURE-----

1 0

[Maria-discuss] Can't connect to local MySQL server through socket
by Sylvain Raybaud 24 Jun '15

24 Jun '15

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi I'm setting up a 3 nodes cluster of mariadb+galera. The cluster seems to be created properly: mysql -u root -p -e 'SELECT VARIABLE_VALUE as "cluster size" FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME="wsrep_cluster_size"' Enter password: +--------------+ | cluster size | +--------------+ | 3 | +--------------+ Problem is, I can only connect to mysql on the first node I create. On the other nodes it gives me: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111 "Connection refused") /tmp/mysql.sock does exist and has correct permissions. However it does not seem to be in listening state since it is not shown by netstat -l. I feel this must be some simple configuration problem but I'm quite stuck. My configuration can be found at: http://pastebin.com/gVie8uKp Note that since I'm compiling and running mariadb in buildroot I do not have /etc/mysql/debian.cnf. Any idea? Thanks, - -- Sylvain Raybaud www.green-communications.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJVipzlAAoJEEkkwl4JtJ9yn8MP/A3Ld0XxNmkO8DCh2znYud6u E3Wiuw35v+wD0EZx05H4nFT2eI/4G8tMCtWy1B0hJx0qiuyjMItXKMqL6yOIrZfx cA4WAikesCwrLCXZgmL5xj0/Ow+8hzNLctCxMNAmJvYUPcW4YyJkinA3C1ch65aa arrfg1/Z8B40VyapjeOc1T7jr97S1465+YMmB6G5aD/3aFBORYWEjqhMSutRKhfJ K7J6KIFQQwrL0gRqtiPwsMxsD2QW/bc8hQQvMz0Nuy7iriY3YZCCvPqtFA+r8cnp 6P4GB0Bp5YL7HY7SO5YuAKiUYmtb5koBoD1oMtuFBVNIFLTP5X8yWErZr2pZXRbx 97oCBWisp3VqQjPCJJBYLrmP4qx5aYU6+C/vcc51Kr+OEFOLeyszVFM85bPx5+ZL d8W5iuOUSBpguQ3P3dQV1PnBWGqe0FcotSHnDSQMD6lxFfQ/s09er3okqob/Wo1k cqKkqPfjMNUaXcE4yf6/UN/ytNMOnPyHVPQNaIsQmiS+TYoIEtf6T2nItMjfoCAz OJ1PaACOzXrvx3rClT/ay6w/TAjILM0O9GiIYsHhdJRrapgu59r57olZouTbmooo VpU7fKq9LnF3dgZOMFW1VBnegfseXWuyCmzXEXx7fiNpvzEukmDrhFpPAuNYdJ9Y Md+Mm44tp+FpWhFfrU6u =ybAn -----END PGP SIGNATURE-----

2 2

[Maria-discuss] Bug in MAX() function?
by Benoit Panizzon 23 Jun '15

23 Jun '15

Hi all I stumbled over that problem, while trying to graph mail traffic.. I have two different counters for emails sent with authentication and without. Aggregated per hour. I would like to total the both values per row, to create a graph of outgoing emails per hour. MariaDB [maildb]> select mail_out_anon,mail_out_auth from domaincounters; +---------------+---------------+ | mail_out_anon | mail_out_auth | +---------------+---------------+ | 8 | 58 | | 8 | 48 | | 4 | 63 | | 9 | 53 | | 2 | 36 | | 0 | 12 | | 3 | 2 | | 0 | 2 | | 0 | 6 | | 0 | 2 | | 0 | 9 | | 0 | 44 | | 14 | 63 | | 0 | 96 | | 7 | 43 | | 4 | 61 | | 2 | 43 | | 2 | 66 | | 0 | 86 | | 6 | 77 | | 6 | 55 | | 0 | 63 | | 6 | 48 | | 2 | 52 | +---------------+---------------+ > select mail_out_anon+mail_out_auth as mail_out_total from domaincounters; +-----------------------------+ | mail_out_anon+mail_out_auth | +-----------------------------+ | 70 | | 56 | | 67 | | 62 | | 38 | | 12 | | 5 | | 2 | | 6 | | 2 | | 9 | | 44 | | 77 | | 96 | | 50 | | 65 | | 45 | | 68 | | 86 | | 83 | | 61 | | 63 | | 54 | | 54 | +-----------------------------+ Now I need the max value of that addition to auto-scale the graph. MariaDB [maildb]> select MAX(mail_out_anon+mail_out_auth) +----------------------------------+ | MAX(mail_out_anon+mail_out_auth) | +----------------------------------+ | 187 | +----------------------------------+ What did MariaDB count here? I was expecting a value 96 which is the largest value of all the additions. Also trying various ways of first using GREATEST() always returns a way to high value. Is it a bug, or did I do something wrong? Mit freundlichen Grüssen Benoit Panizzon -- I m p r o W a r e A G - ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 07 CH-4133 Pratteln Fax +41 61 826 93 02 Schweiz Web http://www.imp.ch ______________________________________________________

6 13

[Maria-discuss] View missing from EXPLAIN after ORDER BY removed from definition
by Rhys Campbell 23 Jun '15

23 Jun '15

Hello All, I had an interesting problem presented to me this morning. A seemingly simple query was running for ages and filling up /tmp causing MariaDB to crash. Now, this isn't perhaps the best designed database but the query didn't seem to be that bad. T1 is a table but t2 is a view (modified definitions provided below) SELECT SQL_NO_CACHE p.col1 FROM t1 p LEFT OUTER JOIN t2 ot ON p.col1 = ot.col2 LIMIT 500; This has the following explain plan... id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY P1 index \N -- 4 \N 85977207 100 Using index; Using temporary; Using filesort 1 PRIMARY p1 ref IX_1 IX_1 8 -- 1 100 Using where; Using index 3 DEPENDENT SUBQUERY p2 ref IX_1 IX_1 8 -- 1 100 Using where; Using index To rectify this I modified an index that was use by the view (note the key_len = 8 in above, went to 106 with the new index when EXPLAINed separately.). I also removed the ORDER BY from the view. After this the query performance much better returning in ~ 250 milliseconds. Removal of the ORDER By was primarily responsible for the performance improvement. However the EXPLAIN plan now returns this... id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY p index \N idx 4 \N 85977207 100 Using index Why is the view now missing from the EXPLAIN? Is this a bug or is there something else going on here? Cheers, Rhys CREATE TABLE `t1` ( `col1` BIGINT(20) NOT NULL, `col2` ENUM(val1, val2, val3) COLLATE latin1_bin NOT NULL, `col3` CHAR(2) CHARACTER SET latin1 NOT NULL, `col4` INT(10) UNSIGNED DEFAULT NULL, `col5` TINYINT(1) DEFAULT '1', `col6` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `col7` VARCHAR(100) CHARACTER SET latin1 DEFAULT NULL, `col8` VARCHAR(10) CHARACTER SET latin1 DEFAULT NULL, `col9` VARCHAR(32) CHARACTER SET latin1 DEFAULT NULL, `col10` VARCHAR(10) CHARACTER SET latin1 DEFAULT NULL, `col11` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `col12` VARCHAR(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `col13` DECIMAL(16,6) DEFAULT NULL, `col14` DECIMAL(16,6) DEFAULT NULL, `col15` BIGINT(20) DEFAULT NULL, `col16` BIGINT(20) DEFAULT NULL, `col17` BIGINT(20) DEFAULT NULL, `col18` BIGINT(20) DEFAULT NULL, `col19` CHAR(8) CHARACTER SET latin1 DEFAULT NULL, `col20` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, `col21` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, `col22` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, `col23` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, `col24` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, `col25` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, `col26` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, `col27` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, `col28` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, `col29` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, `col30` VARCHAR(45) CHARACTER SET latin1 DEFAULT NULL, PRIMARY KEY (`col1`), .. /* REMOVED **/ KEY `idx_lastupdated` (`col6`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin `compression`='tokudb_zlib' The join view has the following definition... SELECT /* COLS REMOVED */ FROM `t2` `p1` WHERE (`p1`.`col1` = (SELECT `p2`.`col2 ` FROM `t2` `p2` WHERE ((`p2`.`col2` = `p1`.`mcol2`) AND (`p2`.`source` = 'src')) ORDER BY `p2`.`col3` DESC LIMIT 1)) ORDER BY `p1`.`col2`; 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.

3 5

[Maria-discuss] Upgrading mariadb-galera-server
by Tom Worster 19 Jun '15

19 Jun '15

Can I upgrade a production cluster from 10.0.15 to 10.0.19 while the cluster remains in service, upgrading one node at a time?

4 7

[Maria-discuss] MariaDB 10.0.20 now available
by Daniel Bartholomew 18 Jun '15

18 Jun '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.20. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.20 - Release Notes: https://mariadb.com/kb/en/mariadb-10020-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10020-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.20 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 - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/ We hope you enjoy MariaDB! -- MariaDB 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: How can i add another new slave to an existing replication configuration?
by AskMonty KB 16 Jun '15

16 Jun '15

Hello, A new question has been asked in "Standard Replication" by wschwauer. Please answer it at http://mariadb.com/kb/en/how-can-i-add-another-new-slave-to-an-existing-rep… as the person asking the question may not be subscribed to the mailing list. -------------------------------- How can i add another new slave to an existing master slave replication configuration? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-can-i-add-another-new-slave-to-an-existing-rep…

1 0

[Maria-discuss] InnoDB: slow insert (too many fsyncs ?)
by Julien Muchembled 15 Jun '15

15 Jun '15

Hello, I am trying to optimize the insertion of 124 GB of data into InnoDB and it takes much more time than I expected. For the moment this is only a test before migrating prod, using a USB HDD. Prod has much faster storage but I prefer to check if there's anything wrong in my MariaDB setup. The source DB is read as less than 1MB/s with less than 20% CPU usage (<10% for mysqld and <10% for the client app doing the migration). I know that several unsafe settings can be used to import data but I won't be able to use them for the migration of prod. This is because the migration will be done transparently in background, the old db being accessed for not yet migrated data. For the same reason, indexes can't be disabled. Anyway, it was slow that for the moment, I only did a full test with unsafe settings: innodb_flush_log_at_trx_commit = 0 innodb_flush_method = nosync innodb_doublewrite = 0 sync_frm = 0 It took exactly 19.8 hours to import all the data. See attached file for all parameters and detailed statistics. (Sorry for the 'show status' outputs, no idea what I expected to get when I tried 'flush status', whereas 21G were already processed. So 'show status.20941778944' is the output just before the flush, and 'show status' is after everything was finished) The schema of tables can be found here: http://git.erp5.org/gitweb/neoppod.git/blob/HEAD:/neo/storage/database/mysq… 1. fsync Not sure if I read 'show status' correctly, but I'd say it's actually 6 fsyncs per second, and this matches what I see with strace. Why not 0 whereas I disabled them ? There's also less than 1 COMMIT per second, so even without disabling fsyncs I was surprised to see so many in the middle of transactions. 2. Write amplification During my first tests, I saw with iotop that mysqld wrote at 10MB/s. Which means a factor 10. With doublewrite disabled, it's rather a factor 5. These ratios are probably underestimated. For better interpretation of the statistics, I should add that: - source DB is uncompressed but the file format is very compact - most of the imported data ends up in the 'data.value' column, and most values are zlib-compressed, with also deduplication The resulting ibdata is only 70GB. Is this write amplification only caused by indexes & doublewrite ? Thanks, Julien

3 3

[Maria-discuss] Questions regarding Galera Cluster
by Dan Storm 15 Jun '15

15 Jun '15

Hello. I just saw this YouTube video: https://www.youtube.com/watch?v=hYSGsgIyshs It was really informative and it seems like a simple and easy setup. Now, I have a few questions which is regarding maintaining a Galera Cluster, which I hope to get some answers on. 1. A cluster should have an odd number of nodes to avoid brain split. In case I hit the wall with insufficient disk space and I need to scale up my servers, which steps would be the appropriate? My initial thoughts would be taking down one node at a time and add a larger node, what for it to have replicated from the other nodes. Would the - now even numbered of nodes - handle this? And what will have when I do this to the bootstrapped server (the one the others connects to)? 2. According to the video, a slave replication of the cluster would be a way of securing my data in case of disaster. Would creating dumps regularly not suffice? And secondly, in case of hardware failure on one of the nodes, bringing in a new node (probably asking the same as before) would hopefully just replicate the data when it joins again? Thank you for your time. -- Dan Storm

4 3

[Maria-discuss] new table format and CONNECT engine
by Roberto Spadim 14 Jun '15

14 Jun '15

Hi guys, I have a file format that is fixed size, and i want to include at CONNECT engine, anyone could help me? it's a file with 6 columns each one fixed size (1xstring, 1x time64_t, 1x ulong (64bits), 3x double(64bits), each row have 110bytes starting at a fixed position, the file have a header with last update time (time64_t) and a row count (32bits ulong) the file struct is easy but i don't know how to include it with connect engine i just want read access no write thanks :) -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

3 8

Re: [Maria-discuss] ON DELETE/UPDATE/INSERT Triggers
by Rhys Campbell 12 Jun '15

12 Jun '15

Just to add another one into the mix (and I guess it may be related in some sense)... For ON DELETE triggers it currently fires per row. This impacts performance significantly in some situations when a lot of rows are processed. MSSQL gets around this by creating virtual tables, INSERTED & DELETED (in effect similar to the OLD / NEW tags) and the trigger executes only once... https://msdn.microsoft.com/en-us/library/ms191300.aspx Cheers, Rhys -----Original Message----- From: Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=tradingscreen.com@lists.launchpad.net] On Behalf Of Federico Razzoli Sent: 12 June 2015 04:02 To: Geoff Montee; Roberto Spadim Cc: MariaDB discuss Subject: Re: [Maria-discuss] DELETE FROM RETURNING In the meanwhile, we can use ON DELETE triggers. But the request is a good idea, because it is a common operation when we want to move some rows to history tables. Federico -------------------------------------------- Gio 11/6/15, Roberto Spadim <roberto(a)spadim.com.br> ha scritto: Oggetto: Re: [Maria-discuss] DELETE FROM RETURNING A: "Geoff Montee" <geoff.montee(a)gmail.com> Cc: "MariaDB discuss" <maria-discuss(a)lists.launchpad.net> Data: Giovedì 11 giugno 2015, 21:09 +1, good idea, today i execute an insert, and a delete 2015-06-11 16:07 GMT-03:00 Geoff Montee <geoff.montee(a)gmail.com>: Hi Rhys, On Wed, Jun 10, 2015 at 1:23 AM, Rhys Campbell <Rhys.Campbell(a)tradingscreen.com> wrote: > " This might be better suited as a feature request on the MariaDB JIRA." > > I got chastised for doing that before so I'm trying to play nice! ;-) > I don't know why you were chastised in the past, but I've added this to the JIRA: https://mariadb.atlassian.net/browse/MDEV-8307 It sure sounds like a useful feature to me. Thanks for the suggestion! Geoff _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -- Roberto Spadim SPAEmpresarial - Software ERPEng. Automação e Controle -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

3 3

[Maria-discuss] DELETE FROM RETURNING
by Rhys Campbell 12 Jun '15

12 Jun '15

Hello All, Just regarding the RETURNING feature introduced into MariaDB 10.0.5 https://mariadb.com/kb/en/mariadb/delete/ It would be useful, similar to the OUTPUT clause in MSSQL, if we could INSERT the data sent back from a returning clause in a single statement. Something like... CREATE TABEL deleted_ids ( Id INT NOT NULL PRIMARY KEY ); INSERT INTO deleted_ids DELETE FROM t1 WHERE id < 999 RETURNING id; 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.

5 11

[Maria-discuss] MariaDB 5.5 apt repo for Ubuntu 10.04 no longer exists
by Bryan Traywick 11 Jun '15

11 Jun '15

I noticed today that the MariaDB 5.5 apt repository for Ubuntu 10.04 no longer exists. At first I thought this was due to the EOL for 10.04 but the 10.0 apt repository is still present in the repository configurator. I couldn’t find an announcement announcing the termination of these repositories. Is this a temporary oversight or are these apt repositories gone forever? Thanks, — Bryan Traywick

2 1

[Maria-discuss] New Question: MariaDB service fails to start after InnoDB/XtraDB crash
by AskMonty KB 11 Jun '15

11 Jun '15

Hello, A new question has been asked in "XtraDB and InnoDB" by kushkash. Please answer it at http://mariadb.com/kb/en/mariadb-service-fails-to-start-after-innodbxtradb-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I've been running a script, inserting a large amount of data to several MySQL tables. Apparently, InnoDB crashed at some point (when ibdata1 reached ~1.6 Gb). I had to restart the computer and when I tried to restart MariaDB service, I got the following errors: Jun 11 08:58:02 honolulu.bi.technion.ac.il mysqld_safe[7970]: 150611 8:58:02 InnoDB: Operating system error number 5 in a file operation. Jun 11 08:58:02 honolulu.bi.technion.ac.il mysqld_safe[7970]: InnoDB: Error number 5 means 'Input/output error'. Jun 11 08:58:02 honolulu.bi.technion.ac.il mysqld_safe[7970]: InnoDB: Some operating system error numbers are described at Jun 11 08:58:02 honolulu.bi.technion.ac.il mysqld_safe[7970]: InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html Jun 11 08:58:02 honolulu.bi.technion.ac.il mysqld_safe[7970]: InnoDB: File operation call: 'read'. Jun 11 08:58:02 honolulu.bi.technion.ac.il mysqld_safe[7970]: InnoDB: Cannot continue operation.' Jun 11 08:58:02 honolulu.bi.technion.ac.il systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE Jun 11 08:58:02 honolulu.bi.technion.ac.il systemd[1]: mariadb.service: control process exited, code=exited status=1 Jun 11 08:58:02 honolulu.bi.technion.ac.il systemd[1]: Failed to start MariaDB database server. Jun 11 08:58:02 honolulu.bi.technion.ac.il systemd[1]: Unit mariadb.service entered failed state. I checked /var/log/mariadb/mariadb.log to find out what might have caused the crash: 140911 10:40:38 InnoDB: Error: Write to file ./ibdata1 failed at offset 0 220200960. InnoDB: 1048576 bytes should have been written, only 0 were written. InnoDB: Operating system error number 28. InnoDB: Check that your OS and file system support files of this size. InnoDB: Check also that the disk is not full or a disk quota exceeded. InnoDB: Error number 28 means 'No space left on device'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html 140911 10:40:38 InnoDB: Assertion failure in thread 139942049851136 in file os0file.c line 4382 InnoDB: Failing assertion: ret InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately a150505 07:59:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150505 07:59:38 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.SFCcCu' --pid-file='/var/lib/mysql/honolulu.bi.technion.ac.il-recover.pid' 150505 07:59:41 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 150505 7:59:41 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1' 150505 7:59:41 InnoDB: The InnoDB memory heap is disabled 150505 7:59:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins 150505 7:59:41 InnoDB: Compressed tables use zlib 1.2.8 150505 7:59:41 InnoDB: Using Linux native AIO 150505 7:59:41 InnoDB: Initializing buffer pool, size = 128.0M 150505 7:59:41 InnoDB: Completed initialization of buffer pool 150505 7:59:41 InnoDB: highest supported file format is Barracuda. 150505 7:59:41 InnoDB: Waiting for the background threads to start 150505 7:59:42 Percona XtraDB (http://www.percona.com) 5.5.37-MariaDB-35.0 started; log sequence number 458740332 150505 7:59:42 [Note] Plugin 'FEEDBACK' is disabled. 150505 7:59:42 [Note] Server socket created on IP: '0.0.0.0'. 150505 7:59:42 [ERROR] mysqld: Table './mysql/user' is marked as crashed and should be repaired 150505 7:59:42 [Warning] Checking table: './mysql/user' 150505 7:59:42 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly 150505 7:59:42 [ERROR] mysqld: Table './mysql/db' is marked as crashed and should be repaired 150505 7:59:42 [Warning] Checking table: './mysql/db' 150505 7:59:42 [ERROR] mysql.db: 1 client is using or hasn't closed the table properly 150505 7:59:42 [Note] Event Scheduler: Loaded 0 events 150505 7:59:42 [Note] WSREP: Read nil XID from storage engines, skipping position init 150505 7:59:42 [Note] WSREP: wsrep_load(): loading provider library 'none' 150505 7:59:42 [Note] [Debug] WSREP: dummy_init 150505 7:59:42 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.38-MariaDB-wsrep' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server, wsrep_25.10.r3997 150608 04:43:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150608 04:43:00 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.7Yb3bw' --pid-file='/var/lib/mysql/honolulu.bi.technion.ac.il-recover.pid' 150608 04:43:13 mysqld_safe WSREP: Failed to recover position: '150608 4:43:01 InnoDB: The InnoDB memory heap is disabled 150608 4:43:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins 150608 4:43:01 InnoDB: Compressed tables use zlib 1.2.8 150608 4:43:01 InnoDB: Using Linux native AIO 150608 4:43:01 InnoDB: Initializing buffer pool, size = 128.0M 150608 4:43:01 InnoDB: Completed initialization of buffer pool 150608 4:43:01 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 4676403586 150608 4:43:01 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... InnoDB: Error: tried to read 1048576 bytes at offset 0 1048576. InnoDB: Was only able to read 655360. 150608 4:43:13 InnoDB: Operating system error number 5 in a file operation. InnoDB: Error number 5 means 'Input/output error'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html InnoDB: File operation call: 'read'. InnoDB: Cannot continue operation.' I have to say that there shouldn't be any disk space problem: df -h Filesystem Size Used Avail Use% Mounted on /dev/sda5 819G 27G 750G 4% / devtmpfs 7.9G 0 7.9G 0% /dev tmpfs 7.9G 0 7.9G 0% /dev/shm tmpfs 7.9G 8.9M 7.9G 1% /run tmpfs 7.9G 0 7.9G 0% /sys/fs/cgroup tmpfs 7.9G 12K 7.9G 1% /tmp /dev/sda3 1.9T 123M 1.8T 1% /home /dev/sda2 477M 112M 336M 25% /boot The MariaDB is currently installed in default configuration. I really need help on this issue... 1. What might have cause the problem? Do I have to configure some InnoDB parameters? Maybe the ibdata file size is a problem? 2. How to recover my data and restart the MariaDB service? (I tried all kind of tips I found in other forums, but I couldn't backup the ibdata1 file or start InnoDB in recovery mode). -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-service-fails-to-start-after-innodbxtradb-…

1 0

[Maria-discuss] MariaDB 5.5.44 now available
by Daniel Bartholomew 11 Jun '15

11 Jun '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.44. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.44 - Release Notes: https://mariadb.com/kb/en/mariadb-5544-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5544-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.44 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 - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/ We hope you enjoy MariaDB! -- MariaDB 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: restrictions on EVENTs in Galera?
by AskMonty KB 11 Jun '15

11 Jun '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by rjasdf. Please answer it at http://mariadb.com/kb/en/restrictions-on-events-in-galera/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Can EVENTs and TRIGGERs be used in Galera Cluster? If so, are there any restrictions? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/restrictions-on-events-in-galera/

1 0

[Maria-discuss] Multi master replication with dynamic IP
by Joseph Onyilo 10 Jun '15

10 Jun '15

Hello, I want setup MariaDB to be able to use dynamic IP address for a multi master replication setup. Although one of the instance will have static IP address. Also, the instances are are in different geographical location. Is this setup possible? Joe.

1 0

[Maria-discuss] 2 node cluster crash
by absolutely_free＠libero.it 10 Jun '15

10 Jun '15

Hi, I have two node cluster with Mariadb (5.5.43) Both servers are equal (RAM, CPU, disk) and they are in same lan segment. I use official MariaDB package from this repository: deb http://mariadb.kisiek.net//repo/5.5/debian wheezy main I use haproxy with this config: # cat haproxy.cfg global log /dev/log local0 log /dev/log local1 notice chroot /var/lib/haproxy user haproxy group haproxy daemon maxconn 8192 defaults retries 2 timeout connect 30s timeout server 600s timeout client 600s log global listen mariadb-cluster bind 0.0.0.0:3306 mode tcp option mysql-check user haproxy option tcpka balance leastconn server node1 192.168.100.1:3307 check maxconn 4096 server node2 192.168.100.2:3307 check maxconn 4096 listen webinterface bind 0.0.0.0:8080 mode http stats enable stats uri / stats realm Strictly\ Private stats auth Username:Password Often (about 1 time per week) several applications that rely on databases on this cluster encounter problems. When this happens, I check on both machines and I see that mysql is running. When I stop mysql on one node (let's say, node2), all returns working fine. I am trying to find the root cause of this behavior. This is "show innodb status" (during crash): *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 150423 16:22:13 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 35 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 477706 1_second, 477700 sleeps, 47769 10_second, 15 background, 15 flush srv_master_thread log flush and writes: 507815 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 526170, signal count 1091151 Mutex spin waits 2133026, rounds 7742983, OS waits 186497 RW-shared spins 383830, rounds 2284949, OS waits 64704 RW-excl spins 20327, rounds 8918087, OS waits 271756 Spin rounds per wait: 3.63 mutex, 5.95 RW-shared, 438.73 RW-excl -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 497313 OS file reads, 42388195 OS file writes, 22834746 OS fsyncs 0.17 reads/s, 16384 avg bytes/read, 1.57 writes/s, 1.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 213, seg size 215, 46416 merges merged operations: insert 121237, delete mark 2178, delete 701 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 17700827, node heap has 4633 buffer(s) 65.94 hash searches/s, 155.85 non-hash searches/s --- LOG --- Log sequence number 513508907441 Log flushed up to 513508907225 Last checkpoint at 513508907225 Max checkpoint age 848635454 Checkpoint age target 822115597 Modified age 216 Checkpoint age 216 0 pending log writes, 0 pending chkp writes 21724628 log i/o's done, 0.63 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 8816427008; in additional pool allocated 0 Total memory allocated by read views 690656 Internal hash tables (constant factor + variable factor) Adaptive hash index 217517904 (141606616 + 75911288) Page hash 8851208 (buffer pool 0 only) Dictionary cache 38436882 (35403184 + 3033698) File system 328480 (82672 + 245808) Lock system 21567352 (21250568 + 316784) Recovery system 0 (0 + 0) Dictionary memory allocated 3033698 Buffer pool size 524287 Buffer pool size, bytes 8589918208 Free buffers 0 Database pages 519654 Old database pages 191805 Modified db pages 2 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 379103, not young 0 0.17 youngs/s, 0.00 non-youngs/s Pages read 496737, created 768744, written 20279635 0.17 reads/s, 0.00 creates/s, 0.83 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 519654, unzip_LRU len: 0 I/O sum[40]:cur[1], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB 611 transactions active inside InnoDB 611 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 2E3F7975 Read view up limit trx id 2E3D4295 Read view low limit trx id 2E3F7975 Read view individually stored trx ids: Read view trx id 2E3F7974 Read view trx id 2E3F7973 Read view trx id 2E3F796B Read view trx id 2E3F7968 Read view trx id 2E3F7936 Read view trx id 2E3F791E Read view trx id 2E3F7860 Read view trx id 2E3F7859 Read view trx id 2E3F77CE Read view trx id 2E3F76D0 Read view trx id 2E3F75DB Read view trx id 2E3F7578 Read view trx id 2E3F74E3 Read view trx id 2E3F74E0 Read view trx id 2E3F74C2 Read view trx id 2E3F74B1 Read view trx id 2E3F7473 Read view trx id 2E3F7472 Read view trx id 2E3F7441 Read view trx id 2E3F73D2 Read view trx id 2E3F72D1 Read view trx id 2E3F72D0 Read view trx id 2E3F7211 Read view trx id 2E3F71F1 Read view trx id 2E3F71EE Read view trx id 2E3F71ED Read view trx id 2E3F71E1 Read view trx id 2E3F71E0 Read view trx id 2E3F71DF Read view trx id 2E3F713C Read view trx id 2E3F707C Read view trx id 2E3F6F91 Read view trx id 2E3F6C5D Read view trx id 2E3F6C5C Read view trx id 2E3F6C51 Read view trx id 2E3F6C50 Read view trx id 2E3F6C0B Read view trx id 2E3F6B2D Read view trx id 2E3F6AFE Read view trx id 2E3F6AA5 Read view trx id 2E3F69B3 Read view trx id 2E3F695F Read view trx id 2E3F6907 Read view trx id 2E3F68E0 Read view trx id 2E3F6898 Read view trx id 2E3F6878 Read view trx id 2E3F6854 Read view trx id 2E3F682D Read view trx id 2E3F682A Read view trx id 2E3F6813 Read view trx id 2E3F6531 Read view trx id 2E3F61E1 Read view trx id 2E3F6190 Read view trx id 2E3F6147 Read view trx id 2E3F60CE Read view trx id 2E3F5FC3 Read view trx id 2E3F5FC1 Read view trx id 2E3F5F82 Read view trx id 2E3F5F79 Read view trx id 2E3F5F53 Read view trx id 2E3F5F52 Read view trx id 2E3F5EE0 Read view trx id 2E3F5CF1 Read view trx id 2E3F5B28 Read view trx id 2E3F5AFA Read view trx id 2E3F5AE3 Read view trx id 2E3F5995 Read view trx id 2E3F58C8 Read view trx id 2E3F55DF Read view trx id 2E3F5586 Read view trx id 2E3F5393 Read view trx id 2E3F5267 Read view trx id 2E3F524B Read view trx id 2E3F5208 Read view trx id 2E3F4B19 Read view trx id 2E3F49C7 Read view trx id 2E3F4569 Read view trx id 2E3F40D8 Read view trx id 2E3F40D6 Read view trx id 2E3F4095 Read view trx id 2E3F4009 Read view trx id 2E3F3DF6 Read view trx id 2E3F3DE5 Read view trx id 2E3F39D1 Read view trx id 2E3F36E9 Read view trx id 2E3F3666 Read view trx id 2E3F35AF Read view trx id 2E3F340D Read view trx id 2E3F3389 Read view trx id 2E3F3302 Read view trx id 2E3F3298 Read view trx id 2E3F3279 Read view trx id 2E3F3278 Read view trx id 2E3F3199 Read view trx id 2E3F30F3 Read view trx id 2E3F2F41 Read view trx id 2E3F2ECE Read view trx id 2E3F2E12 Read view trx id 2E3F2E07 Read view trx id 2E3F2D2B Read view trx id 2E3F2D22 Read view trx id 2E3F2D21 Read view trx id 2E3F2CC1 Read view trx id 2E3F2A96 Read view trx id 2E3F2A6A Read view trx id 2E3F2A08 Read view trx id 2E3F24C5 Read view trx id 2E3F236A Read view trx id 2E3F2149 Read view trx id 2E3F20D8 Read view trx id 2E3F1FA4 Read view trx id 2E3F1F88 Read view trx id 2E3F1EBF Read view trx id 2E3F1E02 Read view trx id 2E3F1C7C Read view trx id 2E3F1BF9 Read view trx id 2E3F1BE1 Read view trx id 2E3F1BD2 Read view trx id 2E3F1BB5 Read view trx id 2E3F1BA6 Read view trx id 2E3F1BA5 Read view trx id 2E3F1A75 Read view trx id 2E3F19B2 Read view trx id 2E3F191B Read view trx id 2E3F1848 Read view trx id 2E3F17A8 Read view trx id 2E3F1761 Read view trx id 2E3F1501 Read view trx id 2E3F14C6 Read view trx id 2E3F14C5 Read view trx id 2E3F13BA Read view trx id 2E3F13B4 Read view trx id 2E3F11DE Read view trx id 2E3F1102 Read view trx id 2E3F0E4D Read view trx id 2E3F09EA Read view trx id 2E3F0994 Read view trx id 2E3F0993 Read view trx id 2E3F08E3 Read view trx id 2E3F06FE Read view trx id 2E3F06A3 Read view trx id 2E3F050C Read view trx id 2E3F043F Read view trx id 2E3F031D Read view trx id 2E3F0314 Read view trx id 2E3F0194 Read view trx id 2E3F003D Read view trx id 2E3EF007 Read view trx id 2E3EEEBD Read view trx id 2E3EEE8C Read view trx id 2E3EEE83 Read view trx id 2E3EEE70 Read view trx id 2E3EEE06 Read view trx id 2E3EE5B0 Read view trx id 2E3EE51A Read view trx id 2E3EE3E3 Read view trx id 2E3EE3C6 Read view trx id 2E3EE3A4 Read view trx id 2E3EE38A Read view trx id 2E3EE2E3 Read view trx id 2E3EE2CD Read view trx id 2E3EE197 Read view trx id 2E3EE05C Read view trx id 2E3EE05B Read view trx id 2E3EDC81 Read view trx id 2E3EDC4F Read view trx id 2E3EDC06 Read view trx id 2E3EDBC7 Read view trx id 2E3ED910 Read view trx id 2E3ED900 Read view trx id 2E3ED8E4 Read view trx id 2E3ED8B5 Read view trx id 2E3ED77F Read view trx id 2E3ED765 Read view trx id 2E3ED656 Read view trx id 2E3ED3D3 Read view trx id 2E3ED330 Read view trx id 2E3ED214 Read view trx id 2E3ED1C1 Read view trx id 2E3ED1C0 Read view trx id 2E3ED1A0 Read view trx id 2E3ED0F5 Read view trx id 2E3ECEB3 Read view trx id 2E3ECE05 Read view trx id 2E3ECC27 Read view trx id 2E3ECBB1 Read view trx id 2E3ECB95 Read view trx id 2E3ECB4F Read view trx id 2E3ECADE Read view trx id 2E3ECAD5 Read view trx id 2E3EC83E Read view trx id 2E3EC5A4 Read view trx id 2E3EC50E Read view trx id 2E3EC4B1 Read view trx id 2E3EC287 Read view trx id 2E3EC080 Read view trx id 2E3EBFB7 Read view trx id 2E3EBE9E Read view trx id 2E3EBD8A Read view trx id 2E3EBCB8 Read view trx id 2E3EBC33 Read view trx id 2E3EBB70 Read view trx id 2E3EBB3B Read view trx id 2E3EBA2C Read view trx id 2E3EB631 Read view trx id 2E3EB435 Read view trx id 2E3EA1B8 Read view trx id 2E3E9FAA Read view trx id 2E3E9F18 Read view trx id 2E3E9EE4 Read view trx id 2E3E9DAB Read view trx id 2E3E9B23 Read view trx id 2E3E9902 Read view trx id 2E3E9785 Read view trx id 2E3E9781 Read view trx id 2E3E960F Read view trx id 2E3E95FE Read view trx id 2E3E95BA Read view trx id 2E3E927B Read view trx id 2E3E919B Read view trx id 2E3E914B Read view trx id 2E3E908D Read view trx id 2E3E905A Read view trx id 2E3E9052 Read view trx id 2E3E8FD0 Read view trx id 2E3E8FC9 Read view trx id 2E3E8FA0 Read view trx id 2E3E8F9F Read view trx id 2E3E8F8A Read view trx id 2E3E8F87 Read view trx id 2E3E8E9A Read view trx id 2E3E8D88 Read view trx id 2E3E8C14 Read view trx id 2E3E8B71 Read view trx id 2E3E8B44 Read view trx id 2E3E8B1E Read view trx id 2E3E8AD8 Read view trx id 2E3E8A48 Read view trx id 2E3E8980 Read view trx id 2E3E8893 Read view trx id 2E3E87EE Read view trx id 2E3E87ED Read view trx id 2E3E87D6 Read view trx id 2E3E87B5 Read view trx id 2E3E85A1 Read view trx id 2E3E8555 Read view trx id 2E3E8553 Read view trx id 2E3E853E Read view trx id 2E3E84E7 Read view trx id 2E3E84E5 Read view trx id 2E3E84E4 Read view trx id 2E3E84E3 Read view trx id 2E3E849D Read view trx id 2E3E849C Read view trx id 2E3E841F Read view trx id 2E3E83A0 Read view trx id 2E3E8202 Read view trx id 2E3E80AC Read view trx id 2E3E80A3 Read view trx id 2E3E7EA5 Read view trx id 2E3E7CF5 Read view trx id 2E3E7B7B Read view trx id 2E3E7B3A Read view trx id 2E3E7A25 Read view trx id 2E3E7A16 Read view trx id 2E3E79F7 Read view trx id 2E3E7999 Read view trx id 2E3E7998 Read view trx id 2E3E790E Read view trx id 2E3E7693 Read view trx id 2E3E7559 Read view trx id 2E3E658F Read view trx id 2E3E64A2 Read view trx id 2E3E6467 Read view trx id 2E3E6236 Read view trx id 2E3E6155 Read view trx id 2E3E611B Read view trx id 2E3E60B3 Read view trx id 2E3E609D Read view trx id 2E3E5F9B Read view trx id 2E3E5F95 Read view trx id 2E3E5E55 Read view trx id 2E3E5DE1 Read view trx id 2E3E5DB6 Read view trx id 2E3E5B49 Read view trx id 2E3E5AC6 Read view trx id 2E3E59CA Read view trx id 2E3E57E5 Read view trx id 2E3E57E4 Read view trx id 2E3E57E3 Read view trx id 2E3E57A2 Read view trx id 2E3E576D Read view trx id 2E3E5508 Read view trx id 2E3E5424 Read view trx id 2E3E53C6 Read view trx id 2E3E52D2 Read view trx id 2E3E52B8 Read view trx id 2E3E52B7 Read view trx id 2E3E5255 Read view trx id 2E3E5227 Read view trx id 2E3E5121 Read view trx id 2E3E5009 Read view trx id 2E3E4F09 Read view trx id 2E3E4EC7 Read view trx id 2E3E4EAA Read view trx id 2E3E4EA9 Read view trx id 2E3E4DEA Read view trx id 2E3E4DD9 Read view trx id 2E3E4C81 Read view trx id 2E3E4C63 Read view trx id 2E3E4AC2 Read view trx id 2E3E49F8 Read view trx id 2E3E4973 Read view trx id 2E3E4840 Read view trx id 2E3E42C6 Read view trx id 2E3E4228 Read view trx id 2E3E41C6 Read view trx id 2E3E416C Read view trx id 2E3E4145 Read view trx id 2E3E3D89 Read view trx id 2E3E3CFF Read view trx id 2E3E3B2B Read view trx id 2E3E3ABD Read view trx id 2E3E3A33 Read view trx id 2E3E3922 Read view trx id 2E3E36BF Read view trx id 2E3E359B Read view trx id 2E3E3585 Read view trx id 2E3E31A1 Read view trx id 2E3E309B Read view trx id 2E3E3055 Read view trx id 2E3E2F6E Read view trx id 2E3E2F2D Read view trx id 2E3E2E8A Read view trx id 2E3E2E89 Read view trx id 2E3E2DE5 Read view trx id 2E3E29F3 Read view trx id 2E3E2907 Read view trx id 2E3E286E Read view trx id 2E3E282E Read view trx id 2E3E27E8 Read view trx id 2E3E25FD Read view trx id 2E3E215B Read view trx id 2E3E1F9D Read view trx id 2E3E1EDA Read view trx id 2E3E1EBA Read view trx id 2E3E1EAB Read view trx id 2E3E1E22 Read view trx id 2E3E1E0A Read view trx id 2E3E1D76 Read view trx id 2E3E1D35 Read view trx id 2E3E1D17 Read view trx id 2E3E1C6D Read view trx id 2E3E19EF Read view trx id 2E3E181F Read view trx id 2E3E1652 Read view trx id 2E3E1198 Read view trx id 2E3E115B Read view trx id 2E3E0D88 Read view trx id 2E3E0D87 Read view trx id 2E3E0D24 Read view trx id 2E3DF415 Read view trx id 2E3DF31E Read view trx id 2E3DF31C Read view trx id 2E3DF2D2 Read view trx id 2E3DF134 Read view trx id 2E3DF119 Read view trx id 2E3DF032 Read view trx id 2E3DF004 Read view trx id 2E3DEFA5 Read view trx id 2E3DEF63 Read view trx id 2E3DEE30 Read view trx id 2E3DEDD5 Read view trx id 2E3DEC83 Read view trx id 2E3DEC30 Read view trx id 2E3DEBF3 Read view trx id 2E3DEBEC Read view trx id 2E3DEBE0 Read view trx id 2E3DEA93 Read view trx id 2E3DE9AF Read view trx id 2E3DE975 Read view trx id 2E3DE8D5 Read view trx id 2E3DE8D4 Read view trx id 2E3DE879 Read view trx id 2E3DE868 Read view trx id 2E3DE801 Read view trx id 2E3DE7D6 Read view trx id 2E3DE7A0 Read view trx id 2E3DE79F Read view trx id 2E3DE77A Read view trx id 2E3DE779 Read view trx id 2E3DE75F Read view trx id 2E3DE72B Read view trx id 2E3DE6C6 Read view trx id 2E3DE65B Read view trx id 2E3DE64A Read view trx id 2E3DE616 Read view trx id 2E3DE541 Read view trx id 2E3DE52B Read view trx id 2E3DE520 Read view trx id 2E3DE51F Read view trx id 2E3DE4AD Read view trx id 2E3DE443 Read view trx id 2E3DE43A Read view trx id 2E3DE3E1 Read view trx id 2E3DE3B2 Read view trx id 2E3DE371 Read view trx id 2E3DE313 Read view trx id 2E3DE277 Read view trx id 2E3DE265 Read view trx id 2E3DE14F Read view trx id 2E3DE111 Read view trx id 2E3DDFE6 Read view trx id 2E3DDEB5 Read view trx id 2E3DDE74 Read view trx id 2E3DDE6E Read view trx id 2E3DDE6D Read view trx id 2E3DDE69 Read view trx id 2E3DDE66 Read view trx id 2E3DDD86 Read view trx id 2E3DDD69 Read view trx id 2E3DDBF3 Read view trx id 2E3DDBC1 Read view trx id 2E3DDB2F Read view trx id 2E3DD971 Read view trx id 2E3DD96D Read view trx id 2E3DD91F Read view trx id 2E3DD67A Read view trx id 2E3DD663 Read view trx id 2E3DD60C Read view trx id 2E3DD4C3 Read view trx id 2E3DD4BF Read view trx id 2E3DD3F3 Read view trx id 2E3DD36B Read view trx id 2E3DD2DE Read view trx id 2E3DD2DD Read view trx id 2E3DD2DC Read view trx id 2E3DD2DB Read view trx id 2E3DD2DA Read view trx id 2E3DD2D4 Read view trx id 2E3DD2A9 Read view trx id 2E3DD2A8 Read view trx id 2E3DD28D Read view trx id 2E3DD27B Read view trx id 2E3DD18E Read view trx id 2E3DD114 Read view trx id 2E3DCDF6 Read view trx id 2E3DCCB0 Read view trx id 2E3DCAB7 Read view trx id 2E3DCA02 Read view trx id 2E3DC8D3 Read view trx id 2E3DC8CB Read view trx id 2E3DC8C5 Read view trx id 2E3DC852 Read view trx id 2E3DC7FA Read view trx id 2E3DC60C Read view trx id 2E3DBD6D Read view trx id 2E3DB0C4 Read view trx id 2E3DAB06 Read view trx id 2E3DAA1A Read view trx id 2E3DA9EB Read view trx id 2E3DA5C3 Read view trx id 2E3DA5AB Read view trx id 2E3DA58B Read view trx id 2E3DA4CF Read view trx id 2E3DA3E9 Read view trx id 2E3DA046 Read view trx id 2E3D9EB8 Read view trx id 2E3D9DC7 Read view trx id 2E3D9AAD Read view trx id 2E3D9A82 Read view trx id 2E3D9A7A Read view trx id 2E3D9A79 Read view trx id 2E3D99FA Read view trx id 2E3D93AA Read view trx id 2E3D9289 Read view trx id 2E3D9202 Read view trx id 2E3D9183 Read view trx id 2E3D9151 Read view trx id 2E3D90FB Read view trx id 2E3D90DD Read view trx id 2E3D8EB3 Read view trx id 2E3D8E51 Read view trx id 2E3D8D52 Read view trx id 2E3D8C30 Read view trx id 2E3D8C1A Read view trx id 2E3D8C19 Read view trx id 2E3D8BA5 Read view trx id 2E3D89AD Read view trx id 2E3D87AE Read view trx id 2E3D8751 Read view trx id 2E3D8733 Read view trx id 2E3D867F Read view trx id 2E3D8366 Read view trx id 2E3D81CE Read view trx id 2E3D7F01 Read view trx id 2E3D7EFF Read view trx id 2E3D7B73 Read view trx id 2E3D7B2D Read view trx id 2E3D7A9A Read view trx id 2E3D7907 Read view trx id 2E3D78A3 Read view trx id 2E3D785C Read view trx id 2E3D77FF Read view trx id 2E3D7639 Read view trx id 2E3D75BD Read view trx id 2E3D73D5 Read view trx id 2E3D731E Read view trx id 2E3D7134 Read view trx id 2E3D7083 Read view trx id 2E3D7082 Read view trx id 2E3D6FFD Read view trx id 2E3D6FD4 Read view trx id 2E3D6FBC Read view trx id 2E3D6F31 Read view trx id 2E3D6F30 Read view trx id 2E3D6F05 Read view trx id 2E3D6EFD Read view trx id 2E3D6EF5 Read view trx id 2E3D6EA9 Read view trx id 2E3D6E0A Read view trx id 2E3D6DA8 Read view trx id 2E3D6D19 Read view trx id 2E3D6B2E Read view trx id 2E3D6967 Read view trx id 2E3D68FA Read view trx id 2E3D61A2 Read view trx id 2E3D60F7 Read view trx id 2E3D60E5 Read view trx id 2E3D5FC7 Read view trx id 2E3D5F2D Read view trx id 2E3D5E93 Read view trx id 2E3D5E4D Read view trx id 2E3D5CA1 Read view trx id 2E3D5B90 Read view trx id 2E3D59B6 Read view trx id 2E3D5996 Read view trx id 2E3D5953 Read view trx id 2E3D58FB Read view trx id 2E3D58E7 Read view trx id 2E3D58CF Read view trx id 2E3D57DA Read view trx id 2E3D57D2 Read view trx id 2E3D57BC Read view trx id 2E3D5771 Read view trx id 2E3D5738 Read view trx id 2E3D5729 Read view trx id 2E3D5728 Read view trx id 2E3D56F6 Read view trx id 2E3D56F5 Read view trx id 2E3D56DE Read view trx id 2E3D56DD Read view trx id 2E3D56B3 Read view trx id 2E3D5696 Read view trx id 2E3D566B Read view trx id 2E3D55E1 Read view trx id 2E3D55B1 Read view trx id 2E3D5599 Read view trx id 2E3D54F7 Read view trx id 2E3D54C8 Read view trx id 2E3D5496 Read view trx id 2E3D5463 Read view trx id 2E3D5422 Read view trx id 2E3D5382 Read view trx id 2E3D52EC Read view trx id 2E3D5270 Read view trx id 2E3D521F Read view trx id 2E3D50C3 Read view trx id 2E3D501C Read view trx id 2E3D4F8A Read view trx id 2E3D4EC8 Read view trx id 2E3D4E71 Read view trx id 2E3D4DFC Read view trx id 2E3D4D7E Read view trx id 2E3D4D3A Read view trx id 2E3D4D06 Read view trx id 2E3D4D05 Read view trx id 2E3D4D04 Read view trx id 2E3D4D02 Read view trx id 2E3D4D01 Read view trx id 2E3D4CFF Read view trx id 2E3D4CCD Read view trx id 2E3D4C57 Read view trx id 2E3D4C4B Read view trx id 2E3D4BC2 Read view trx id 2E3D4B78 Read view trx id 2E3D4B4C Read view trx id 2E3D4B31 Read view trx id 2E3D48EE Read view trx id 2E3D4860 Read view trx id 2E3D47DA Read view trx id 2E3D4768 Read view trx id 2E3D4604 Read view trx id 2E3D45F8 Read view trx id 2E3D44F1 Read view trx id 2E3D44D9 Read view trx id 2E3D449E Read view trx id 2E3D441E Read view trx id 2E3D437C Read view trx id 2E3D437B Read view trx id 2E3D436E Read view trx id 2E3D4302 Read view trx id 2E3D42BD Read view trx id 2E3D42AD Read view trx id 2E3D42A9 Read view trx id 2E3D42A8 Read view trx id 2E3D42A7 Read view trx id 2E3D42A6 Read view trx id 2E3D429E Read view trx id 2E3D4295 ----------------- Main thread process no. 42459, id 140580935939840, state: sleeping Number of rows inserted 1374217, updated 259069615, deleted 360531, read 5191170325 0.20 inserts/s, 0.54 updates/s, 0.00 deletes/s, 89.03 reads/s ------------ TABLE LOCK table `roundcube`.`session` trx id 2E3F7859 lock mode IX RECORD LOCKS space id 227 page no 350 n bits 80 index `PRIMARY` of table `roundcube`.`session` trx id 2E3F7859 lock mode S locks rec but not gap waiting ---TRANSACTION 2E3F77CE, ACTIVE 6 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 4288287, OS thread handle 0x7fdadfc8d700, query id 44864987 node1 192.168.100.1 roundcube update INSERT INTO `session` (`sess_id`, `vars`, `ip`, `created`, `changed`) VALUES ('44f5q5mncbdqh1kskcsr7018s3', 'bGFuZ3VhZ2V8czo1OiJpdF9JVCI7dGVtcHxiOjE7c2tpbnxzOjU6Im1pY3NvIjs=', '213.xxxxxxxx', now(), now()) ------- TRX HAS BEEN WAITING 6 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 227 page no 378 n bits 80 index `PRIMARY` of table `roundcube`.`session` trx id 2E3F77CE lock mode S locks rec but not gap waiting ------------------ ---TRANSACTION 2E3D4302, ACTIVE 2079 sec mysql tables in use 1, locked 1 94 lock struct(s), heap size 14776, 279 row lock(s), undo log entries 279 MySQL thread id 4283828, OS thread handle 0x7fdde7bfe700, query id 44714554 node1 192.168.100.1 db_dspam_admin query end UPDATE dspam_token_data SET last_hit=CURRENT_DATE(),innocent_hits=innocent_hits+1 WHERE uid=0 AND token IN ('11208966279506063560','14355575044071913407','8469385930432278733','7966374547679573945','3426741056644935886','7964984027734112185','13945758747987769275','11207568337737381816','7966374566296844217','11208965523571177400','7964979679860519113','13945759985008537803','3426745367375869886','9262020720305336524','8302736407489378233','15747196743497709503','11208965542138376392','3618985354802917582','11208959957244014792','182759523735400642','9262016372543223740','7964972414031067065', TABLE LOCK table `db_dspam`.`dspam_token_data` trx id 2E3D4302 lock mode IX RECORD LOCKS space id 17 page no 28 n bits 384 index `id_token_data_01` of table `db_dspam`.`dspam_token_data` trx id 2E3D4302 lock_mode X locks rec but not gap RECORD LOCKS space id 17 page no 1757 n bits 320 index `id_token_data_01` of table `db_dspam`.`dspam_token_data` trx id 2E3D4302 lock_mode X locks rec but not gap RECORD LOCKS space id 17 page no 1655 n bits 384 index `id_token_data_01` of table `db_dspam`.`dspam_token_data` trx id 2E3D4302 lock_mode X locks rec but not gap RECORD LOCKS space id 17 page no 9372 n bits 376 index `id_token_data_01` of table `db_dspam`.`dspam_token_data` trx id 2E3D4302 lock_mode X locks rec but not gap RECORD LOCKS space id 17 page no 2630 n bits 248 index `id_token_data_01` of table `db_dspam`.`dspam_token_data` trx id 2E3D4302 lock_mode X locks rec but not gap RECORD LOCKS space id 17 page no 986 n bits 376 index `id_token_data_01` of table `db_dspam`.`dspam_token_data` trx id 2E3D4302 lock_mode X locks rec but not gap RECORD LOCKS space id 17 page no 52091 n bits 384 index `id_token_data_01` of table `db_dspam`.`dspam_token_data` trx id 2E3D4302 lock_mode X locks rec but not gap RECORD LOCKS space id 17 page no 1959 n bits 384 index `id_token_data_01` of table `db_dspam`.`dspam_token_data` trx id 2E3D4302 lock_mode X locks rec but not gap RECORD LOCKS space id 17 page no 51755 n bits 264 index `id_token_data_01` of table `db_dspam`.`dspam_token_data` trx id 2E3D4302 lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS .. .. Thank you

1 0

[Maria-discuss] New Question: MariaDB keeps crashing on some wordpress posts
by AskMonty KB 08 Jun '15

08 Jun '15

Hello, A new question has been asked in "MariaDB Community" by nunocarapito. Please answer it at http://mariadb.com/kb/en/mariadb-keeps-crashing-on-some-wordpress-posts/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi there. I have a mariadb server with 2 wordpress blogs. Sometimes, when an admin posts something in it, it crashes. I've updated it, and it still happens. Not sure what else Should I do. Here's the log. http://pastebin.com/Sp6fsN4P Thanks for the help. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-keeps-crashing-on-some-wordpress-posts/

1 0

[Maria-discuss] 2015 leap second issues?
by Marco Nicosia 06 Jun '15

06 Jun '15

Hi all, I'm writing to inquire if I should prepare any of our MariaDB/Galera users for the upcoming leap second. According to http://www.timeanddate.com/time/leapseconds.html the next leap second will be added on June 30, 2015 at 23:59:60 UTC. I searched a bit for "leap second mariadb" but didn't find anything recent. Most of our users are on MariaDB 10.0.13 and Galera 25.2.9 or subsequent. Have anyone tested both MariaDB and Galera to ensure that there are versions which are resilient to the introduction of a leap second? If so, is there documentation of versions which are known vulnerable to or proof against it? Thanks! -- Marco Nicosia Product Manager Pivotal Software, Inc.

4 6

[Maria-discuss] New Question: Converting from MySQL to MariadB
by AskMonty KB 05 Jun '15

05 Jun '15

Hello, A new question has been asked in "MariaDB Community" by cavj1. Please answer it at http://mariadb.com/kb/en/converting-from-mysql-to-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi All... I'm in the process of moving from MySQL to MariadB for our web app. Within the web app we use various Crystal Reports that run on the server and present the report to the user. The report currently uses a MySQL ODBC connector. IF I modify the ODBC connector to point to the new server will the MySQL ODBC connector still work? Does anyone know if the MySQL ODBC connector is compatible with MariadB? Otherwise I'd have to modify every report in the system to use the new connector which will be very time consuming. Thank you for any input you provide. Joe -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/converting-from-mysql-to-mariadb/

1 0

[Maria-discuss] Question about Galera "pc.recovery" feature
by Marco Nicosia 05 Jun '15

05 Jun '15

Hi all! We recently discovered the configuration wsrep_provider_options="pc.recovery=TRUE" and set about to set this configuration, as we'd like to avoid unnecessary boostrapping whenever possible. We were further surprised to discover that this feature had been enabled by default. But we were frustrated in our attempts to trigger this feature to actually observe it in action. I understand that the feature is intended to recover from full cluster crashes _such as_ a power outage, but we were unable to come up with a scenario in which we could interrupt the cluster and watch it recover automatically. This included deploying to AWS and setting all three nodes to 'stop' then 'start.' In each instance, we had to manually bootstrap. Am I misunderstanding the feature, or the conditions under which we can trigger it? -- Marco Nicosia Product Manager Pivotal Software, Inc. mnicosia(a)pivotal.io c: 650-796-2948

2 1

[Maria-discuss] MariaDB 10.1.5 now available
by Daniel Bartholomew 04 Jun '15

04 Jun '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.5. This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.5 - Release Notes: https://mariadb.com/kb/en/mariadb-1015-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1015-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.5 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/ We hope you enjoy MariaDB! -- MariaDB 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: Switch over at a database level
by AskMonty KB 04 Jun '15

04 Jun '15

Hello, A new question has been asked in "Standard Replication" by mahoarita. Please answer it at http://mariadb.com/kb/en/switch-over-at-a-database-level/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to switch over an individual database? For example, with the below scenario: - I have 3-server replication - Server contains multiple databases owned by different users I'd like to manually switch over only one database, "MyDb1" as a failover test. The rest of the databases residing on the same MariaDB server should not be impacted. This is to minimize the impact to other databases for failover test exercise. Is this possible by Standard Replication? I'd be grateful for this information. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/switch-over-at-a-database-level/

1 0

[Maria-discuss] New Question: Autoinstall ODBC
by AskMonty KB 03 Jun '15

03 Jun '15

Hello, A new question has been asked in "MariaDB Connector/ODBC" by leopoldotaylhardat. Please answer it at http://mariadb.com/kb/en/autoinstall-odbc/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How can I install ODBC in silent mode with command line (windows) options? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/autoinstall-odbc/

1 0

[Maria-discuss] Unknown crash
by Irwanto 03 Jun '15

03 Jun '15

My Server :Windows 2003 R2RAM 4GMariaDB 10.0.19 01 June i'm sure i shutdown normally02 June is holiday03 June i see "crash recovery" in log file i'm sure disk is ok with chkdsk e: sometime i get this word in log file, so what caused this here my log 150601 20:17:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages150601 20:17:10 [Note] InnoDB: The InnoDB memory heap is disabled150601 20:17:10 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions150601 20:17:10 [Note] InnoDB: Memory barrier is not used150601 20:17:10 [Note] InnoDB: Compressed tables use zlib 1.2.3150601 20:17:10 [Note] InnoDB: Not using CPU crc32 instructions150601 20:17:10 [Note] InnoDB: Initializing buffer pool, size = 1008.0M150601 20:17:10 [Note] InnoDB: Completed initialization of buffer pool150601 20:17:10 [Note] InnoDB: Highest supported file format is Barracuda.150601 20:17:10 [Note] InnoDB: 128 rollback segment(s) are active.150601 20:17:10 [Note] InnoDB: Waiting for purge to start150601 20:17:10 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 10406975924150601 20:17:11 [Note] Server socket created on IP: '0.0.0.0'.150601 20:17:11 [Warning] 'proxies_priv' entry '@% root@kutu' ignored in --skip-name-resolve mode.150601 20:17:11 [Note] Event Scheduler: Loaded 0 events150601 20:17:11 [Note] E:\smart\smart_database_mariadb.10\bin\mysqld.exe: ready for connections.Version: '10.0.19-MariaDB-log' socket: '' port: 3309 mariadb.org binary distribution150601 20:22:11 [Note] feedback plugin: report to 'https://mariadb.org/feedback_plugin/post' was sent150601 20:22:14 [Note] feedback plugin: server replied 'ok'150601 20:33:39 [Note] E:\smart\smart_database_mariadb.10\bin\mysqld.exe: Normal shutdown 150601 20:33:39 [Note] Event Scheduler: Purging the queue. 0 events150601 20:34:02 [ERROR] feedback plugin: ssl failed for url 'https://mariadb.org/feedback_plugin/post' CryptGenRandom error150601 20:34:02 [Note] InnoDB: FTS optimize thread exiting.150601 20:34:02 [Note] InnoDB: Starting shutdown...150603 7:12:49 [Note] InnoDB: Using mutexes to ref count buffer pool pages150603 7:12:49 [Note] InnoDB: The InnoDB memory heap is disabled150603 7:12:49 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions150603 7:12:49 [Note] InnoDB: Memory barrier is not used150603 7:12:49 [Note] InnoDB: Compressed tables use zlib 1.2.3150603 7:12:50 [Note] InnoDB: Not using CPU crc32 instructions150603 7:12:50 [Note] InnoDB: Initializing buffer pool, size = 1008.0M150603 7:12:50 [Note] InnoDB: Completed initialization of buffer pool150603 7:12:50 [Note] InnoDB: Highest supported file format is Barracuda.150603 7:12:50 [Note] InnoDB: The log sequence numbers 10406975924 and 10406975924 in ibdata files do not match the log sequence number 10407001762 in the ib_logfiles!150603 7:12:50 [Note] InnoDB: Database was not shutdown normally!150603 7:12:50 [Note] InnoDB: Starting crash recovery.150603 7:12:50 [Note] InnoDB: Reading tablespace information from the .ibd files...150603 7:13:01 [Note] InnoDB: Restoring possible half-written data pages 150603 7:13:01 [Note] InnoDB: from the doublewrite buffer...InnoDB: Last MySQL binlog file position 0 11515, file name E:\smart\smart_database_mariadb.10\repl\KMS-PLB-bin.000001150603 7:13:02 [Note] InnoDB: 128 rollback segment(s) are active.150603 7:13:02 [Note] InnoDB: Waiting for purge to start150603 7:13:02 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 10407001762150603 7:13:03 [Note] Server socket created on IP: '0.0.0.0'.150603 7:13:03 [Warning] 'proxies_priv' entry '@% root@kutu' ignored in --skip-name-resolve mode.150603 7:13:03 [Note] Event Scheduler: Loaded 0 events150603 7:13:03 [Note] E:\smart\smart_database_mariadb.10\bin\mysqld.exe: ready for connections.Version: '10.0.19-MariaDB-log' socket: '' port: 3309 mariadb.org binary distribution150603 7:18:03 [Note] feedback plugin: report to 'https://mariadb.org/feedback_plugin/post' was sent150603 7:18:04 [Note] feedback plugin: server replied 'ok'

1 0

[Maria-discuss] security scans: 5.5.5-10.0.19 should be 5.5.43-10.0.19
by Reindl Harald 01 Jun '15

01 Jun '15

[harry@rh:~]$ telnet localhost 3306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. ] 5.5.5-10.0.19-MariaDB the 5.5.5 srting leads in false positives for security scans and while i reported that to OpenVAS the correct soultion would be updating the 5.5.5 string to the latest 5.5x release instead "Fix" each scanner out there Medium (CVSS: 4.0) NVT: MariaDB 'COM_CHANGE_USER' Command Insecure Salt Generation Security Bypass Vuln... (OID: 1.3.6.1.4.1.25623.1.0.804037) Solution Upgrade to MariaDB version 5.2.14, 5.3.12, 5.5.29 or later, For updates refer to https://mariadb.org Medium (CVSS: 5.0) NVT: MariaDB Denial Of Service Vulnerability (Windows) (OID: 1.3.6.1.4.1.25623.1.0.804035) Solution Upgrade to MariaDB 5.1.68, 5.2.15, 5.3.13, 5.5.30 or later, For updates refer to https://mariadb.org Product detection result: cpe:/a:mariadb:mariadb:5.5.5- by MySQL/MariaDB Detection (OID: 1.3.6.1.4.1.25623.1.0.100152)

2 1

Re: [Maria-discuss] Dynamic Columns ORM
by Tom Worster 23 May '15

23 May '15

Hi Daniel, Yes, I shall add remarks about indexes to the docs. I didn't have any purpose for "token" other than I needed a name for the strings that go in the SQL that refer to dynamic columns. Is there a problem with that particular word or do you think it would be better to do without any such name? You're spot on about computed columns. From my point of view, doing that amounts to adding the column to the schema. The column name appears in DDL and the corresponding attribute is therefore no longer ad hoc in the the application. The same point applies (in some imaginary future) to adding an index to a dynamic column without needing a computed column. If attributes represented in the application are to be truly fluid then their corresponding dynamic column cannot be indexed, at least not as I understand indexes in MySQL. Thanks for taking a look. Tom From: Daniel Black <daniel.black(a)openquery.com.au> Date: Saturday, May 23, 2015 at 1:27 AM To: Tom Worster <fsb(a)thefsb.org>, maria-discuss email list <maria-discuss(a)lists.launchpad.net> Subject: Re: [Maria-discuss] Dynamic Columns ORM They are generally good for blob like information that is generally retrieved in a query with some structure around name->value pairs. You mentioned (forum) that there isn't an index on these items so you'll get more row scanning on these if people search on a Dynamic attribute tokens (not sure why you are adding "token" to the language here). This limitation to be mentioned more in the documentation you've written. You could use computed columns to extract a variable to index if really needed but you'll need to ask why isn't it a column in its own right. https://mariadb.com/kb/en/mariadb/virtual-computed-columns/ Enhancing frameworks to expose database features is a good thing as they often get omitted in the reduction to the lowest common factor (mysql-5.0?) and sometimes the lowest common factor across db implementations (ansi SQL(?)). -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

2 1

[Maria-discuss] Dynamic Columns ORM
by Tom Worster 23 May '15

23 May '15

In January I was asking about Dynamic Columns because I had started working on an ORM extension for it. It is now tagged 0.1.0 in Github. There probably aren't many here using Yii Framework but at least this shows that some of us like and use Maria's Dynamic Columns. Thank you, Maria. I already got some feedback on IRC from Kolbe who hated it :'( and we'd welcome more of the same :-) https://github.com/tom--/dynamic-ar Yii Framework forum thread: http://www.yiiframework.com/forum/index.php/topic/63995-/ Previous thread started here: https://lists.launchpad.net/maria-discuss/msg02159.html tom[] The empty array without a dollar sign

2 1

[Maria-discuss] mysqldump Spider tables
by Nicolas Payart 21 May '15

21 May '15

Hi list, I am using Spider Storage Engine for multiple purpose. I often create spider tables as a drop-in replacement for Federated(x) tables. But one main difference I notice using spider SE vs Federated is that mysqldump dumps the whole data of remote spider tables whereas it only dumps the table schema of federated tables. I expected these two close storage engines to behave similarly... Is this an expected behaviour of Spider SE (and/or mysqldump)? Is there a workaround to make mysqldump dump only schema of Spider tables, just like it would do with a federated table? Of course, I can use the --no-data option but it's a bit annoying when you have a mix of innodb tables and spider tables in the same database. Thanks, -- Nicolas

2 2

[Maria-discuss] Query Cache with TTL and unconsistent values - remove memcache servers
by Roberto Spadim 20 May '15

20 May '15

Hi guys! I created a MDEV (feature request) sometime ago, https://mariadb.atlassian.net/browse/MDEV-6777 There's a patch ( http://ebergen.net/wordpress/2007/04/23/select-sql_cache_ttl/) but i want change a bit to work "better", it's using "SELECT SQL_CACHE_TTL ..." hint, and could be better change it to "SELECT SQL_CACHE_TTL=9999 ..." to easily change TTL instead of a fixed TTL set by "SET ttl=999;SELECT SQL_CACHE_TTL ..." query, could anyone help me with it? Why? With this we can reduce the memcache use in small/medium systems, reducing app side caching code too the difference between query cache and query cache with ttl is how it's removed from cache, one is removed with table invalidation (consistent cache), and other is removed with time to live even if table change (unconsistent cache) =] help is welcome, thnks guys -- Roberto Spadim

1 0

[Maria-discuss] MariaDB 10.1.4 Progress output
by Rhys Campbell 19 May '15

19 May '15

Note the progress output below. I've seen several like this. i.e... Stage: 1 of 72 'altering table' 350% of stage done. Is this intentional? [cid:image001.png@01D07B7A.526BD6D0] 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.

5 5

[Maria-discuss] MariaDB Galera Cluster 10.0.19 and 5.5.43 now available
by Daniel Bartholomew 18 May '15

18 May '15

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.43 and 10.0.19. These are Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.19 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10019-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10019-changelog/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.19/ MariaDB Galera Cluster 5.5.43 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5543-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5543-changelog/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.43/ 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 - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/ We hope you enjoy MariaDB! -- MariaDB 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] query cache dump_at_shutdown/load_at_startup useful + no character set/collation?
by Daniel Black 17 May '15

17 May '15

I was testing out using the query_cache_info plugin (https://mariadb.com/kb/en/mariadb/query_cache_info-plugin/) to pre-cache data into a server after an upgrade. The read only slaves have a fairly high cache hit ratio. select concat('use ', STATEMENT_SCHEMA, ';', STATEMENT_TEXT, ';') as q INTO OUTFILE '/tmp/qc.txt' FIELDS ESCAPED BY '' TERMINATED BY '' from information_schema.QUERY_CACHE_INFO; Query OK, 7122 rows affected (0.03 sec) When loading these it seems the statements have a collation however this isn't stored in the query cache. $ mysql --force < /tmp/qc.txt > /dev/null ERROR 1267 (HY000) at line 119: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' ERROR 1267 (HY000) at line 2390: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' ERROR 1267 (HY000) at line 7569: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Attempts to force this with --default-character-set={utf8|utf8mb4} also resulted in the same error or same with (echo "set character_set_connection=utf8;"; cat /tmp/qc.txt; ) | time mysql --force.. Are query cache results actually predictable if they have the same statement running in a different session character set/collation? Anyone see a work around to get the restore file usable on all queries? Is asking for query cache dump/load as a feature request (similar to innodb_buffer_pool_dump_at_shutdown/innodb_buffer_pool_restore_at_startup) going to be useful to anyone? -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

2 2

[Maria-discuss] performance_schema
by Rhys Campbell 15 May '15

15 May '15

Hi All, Does anyone know if the performance_schema guarantees that every statement executed will appear in the events_statement_summary_by_digest table (excluding those that could be pushed out due to size restrictions). Or is it a "best effort" system? If it's a best effort system what are the circumstances in which a query may not make it to the performance schema? 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 1

[Maria-discuss] Twitter handles of technical MariaDB guys
by Lukas Lehner 15 May '15

15 May '15

Hi You can recommend me Twitter handles of technical MariaDB guys? I wish to learn, I have immediate DB skills. Lukas

1 0

Re: [Maria-discuss] Innodb Page Compression
by Rhys Campbell 14 May '15

14 May '15

Hi Jan, Just a follow up on my previous email. I understood that simply changing the setting for innodb_compression_algorithm would not change any existing tables. Between each test I was running the employees.sql script from the example database. This contains the following sql at the start of the script…. DROP TABLE IF EXISTS dept_emp, dept_manager, titles, salaries, employees, departments; So I definitely think there’s something up here. I’ve performed a similar set of tests below… SET GLOBAL innodb_compression_algorithm=none; source employees.sql du –sh /var/lib/mysql/employees – 385M <- Note all tables are created here with the PAGE_COMPRESSED=1 option. INNODB_SYS_TABLESPACES shows all are Barrcacuda/Dynamic Next I run the ALTER TABLE … ROW_FORMAT=COMPRESSED PAGE_COMPRESSED=DEFAULT; for each table in the employees database du –sh /var/lib/mysql/employees – 135MB; <- Expected 119MB here, probably due to a log file. SET GLOBAL innodb_compression_algorithm=zlib <- After each compression algorithm change I run alter for each tables as above du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_compression_algorithm=lzo <- Alter run du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_compression_algorithm=lz4 <- Alter run… du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_compression_algorithm=lzma <- alter run du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_compression_algorithm=bzip2 < alter run du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_compression_algorithm=snappy <- alter run du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_use_trim=1; # Now set trim and run above tests again SET GLOBAL innodb_compression_algorithm=zlib # Again the alter table statements are executed as above du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_compression_algorithm=lzo du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_compression_algorithm=lz4 du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_compression_algorithm=lzma du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_compression_algorithm=bzip2 du –sh /var/lib/mysql/employees – 119MB SET GLOBAL innodb_compression_algorithm=snappy du –sh /var/lib/mysql/employees – 119MB Recreating the database without the PAGE_COMPRESSED=1 options, then run ALTER TABLE … ROW_FORMAT=COMPRESSED results in a database size of 119MB. When I attempt the compression without ROW_FORMAT=COMPRESSED I get the same results as I previously poste, i.e. no difference in db size apart from when using lzma. Cheers, Rhys From: Jan Lindström [mailto:jan.lindstrom@mariadb.com] Sent: 14 May 2015 06:14 To: Rhys Campbell Cc: maria-discuss(a)lists.launchpad.net Subject: Re: [Maria-discuss] Innodb Page Compression On Wed, May 13, 2015 at 6:00 PM, Rhys Campbell <Rhys.Campbell(a)tradingscreen.com<mailto:Rhys.Campbell@tradingscreen.com>> wrote: 1. Why when trim is not used is the db size unchanged apart from lzma? SET GLOBAL innodb_compression_algorithm effects only new tables, it does not change existing tables. If you want to change compression algorithm for existing table you need to do: SET GLOBAL innodb_compression_algorithm = lzo; CREATE TABLE t1 (a int not null primary key, b char(200)) engine=innodb page_compressed =1; -- uses lzo SET GLOBAL innodb_compression_algorithm = lz4; -- no change to existing tables ALTER TABLE t1 ENGINE=InnoDB; -- noe table t1 uses compression algorithm lz4; 2. Why is the compressed size the same for all algorithms? Is the correct algorithm being used? No 3. Can I confirm which algorithm has been used for a page. I can’t see anything in information_schema Not really at the moment, I need to think about adding support for this. 4. Status variables / info schema not working? Status variables work only if pages are really compressed or decompressed see 1) 5. ALTER TABLE … PAGE_COMPRESSED = 1 doesn’t work. Must I always do a full dump & load to enable page compression? You have incorrect syntax. ALTER TABLE departments ROW_FORMAT=COMPRESSED means legacy row-compression and if departments table is page compressed you need to specify ALTER TABLE departments ROW_FORMAT=COMPRESSED PAGE_COMPRESSED=DEFAULT; 6. Lzma/9 compression is not that impressive. Is it meant to rival tokudb? (converting to tokudb results in a db size of ~ 54MB and this includes logs!) See 1) tokudb might use different version of lzma as they use bundled one. R: Jan

1 0

Re: [Maria-discuss] Innodb Page Compression
by Rhys Campbell 14 May '15

14 May '15

Hi Jan, That’s for those answers. For #1 I was dropping and recreating all tables after each change to innodb_compression_algorithm. Cheers, Rhys From: Jan Lindström [mailto:jan.lindstrom@mariadb.com] Sent: 14 May 2015 06:14 To: Rhys Campbell Cc: maria-discuss(a)lists.launchpad.net Subject: Re: [Maria-discuss] Innodb Page Compression On Wed, May 13, 2015 at 6:00 PM, Rhys Campbell <Rhys.Campbell(a)tradingscreen.com<mailto:Rhys.Campbell@tradingscreen.com>> wrote: 1. Why when trim is not used is the db size unchanged apart from lzma? SET GLOBAL innodb_compression_algorithm effects only new tables, it does not change existing tables. If you want to change compression algorithm for existing table you need to do: SET GLOBAL innodb_compression_algorithm = lzo; CREATE TABLE t1 (a int not null primary key, b char(200)) engine=innodb page_compressed =1; -- uses lzo SET GLOBAL innodb_compression_algorithm = lz4; -- no change to existing tables ALTER TABLE t1 ENGINE=InnoDB; -- noe table t1 uses compression algorithm lz4; 2. Why is the compressed size the same for all algorithms? Is the correct algorithm being used? No 3. Can I confirm which algorithm has been used for a page. I can’t see anything in information_schema Not really at the moment, I need to think about adding support for this. 4. Status variables / info schema not working? Status variables work only if pages are really compressed or decompressed see 1) 5. ALTER TABLE … PAGE_COMPRESSED = 1 doesn’t work. Must I always do a full dump & load to enable page compression? You have incorrect syntax. ALTER TABLE departments ROW_FORMAT=COMPRESSED means legacy row-compression and if departments table is page compressed you need to specify ALTER TABLE departments ROW_FORMAT=COMPRESSED PAGE_COMPRESSED=DEFAULT; 6. Lzma/9 compression is not that impressive. Is it meant to rival tokudb? (converting to tokudb results in a db size of ~ 54MB and this includes logs!) See 1) tokudb might use different version of lzma as they use bundled one. R: Jan

1 0

[Maria-discuss] doubt about best engine
by Roberto Spadim 14 May '15

14 May '15

hi guys, i'm with doubt about the "best" engine (best = no INSERT lag ~0.100s or less, good SELECT speed ~ 1 to 10 seconds is ok) i have two tables, they only "receive" INSERT and SELECT queries (no DELETE/UPDATE/ALTER) they increase 200MB/day and 3.000.000 rows/day my doubt is, how to have small database size and good read rate? it have ~ 104 inserts / second, but each insert is multi values like ... INSERT INTO table VALUES (),(),(),(),(),() .... in other words... today i'm using aria (it's crash safe) and i don't have problems with concurrent insert / table locks etc, my doubt is about table size and read speed with bigger database i'm considering using spider engine or any other shard system with >100GB , or maybe a big raid-6 system, server is a xeon 8core with 16GB and 2hd 500GB RAID1 SAS (>180MB/s) the client side is a C++ program that i don't have access to change and recompile it, in other words i can only change server side and load balance data table is something like: (datetime decimal(22,6),value decimal(22,6)) the SELECT code use most part of recent data ~5 DAYS, in outlier queries something near to ~1 MONTH ago ideas are wellcome -- Roberto Spadim

3 2

[Maria-discuss] Innodb Page Compression
by Rhys Campbell 13 May '15

13 May '15

Hello All, I have compiled mariadb 10.1.4 from source to have a play with innodb page compression. Not sure if these are bug or misunderstanding on my part, probably a combination of both... I am running in a CentOS 7 x64 VirtualBox VM 10.1.4-MariaDB-wsrep. The compile support for page compression seems to have worked ok... SHOW STATUS LIKE 'innodb_have%'; [cid:image001.png@01D08D88.E9019C90] My experiments have been with the following example database... https://launchpad.net/test-db/employees-db-1/1.0.6/+download/employees_db-f… When this is loaded onto a default install of mariadb (InnoDB Antelope / no compression) The db size is... du -sh /var/lib/mysql/employees - 385MB The when I run ALTER TABLE .. ROW_FORMAT=COMPRESSED the db size is... du -sh /var/lib/mysql/employees - 119MB Next I performed a series of reloads of this database after changing the compression algorithm. Note the total db size doesn't change apart from when compression is lzma. SET GLOBAL innodb_compression_algorithm='zlib'; du -sh /var/lib/mysql/employees - 385MB SET GLOBAL innodb_compression_algorithm='lz4'; du -sh /var/lib/mysql/employees - 385MB SET GLOBAL innodb_compression_algorithm='lzo'; du -sh /var/lib/mysql/employees - 385MB SET GLOBAL innodb_compression_algorithm='lzma'; du -sh /var/lib/mysql/employees - 308MB SET GLOBAL innodb_compression_algorithm='bzip2'; du -sh /var/lib/mysql/employees - 385MB SET GLOBAL innodb_compression_algorithm='snappy'; du -sh /var/lib/mysql/employees - 385MB SET GLOBAL innodb_compression_algorithm='lzma'; SET GLOBAL innodb_compression_level=9; du -sh /var/lib/mysql/employees - 232M SET GLOBAL innodb_compression_algorithm='zlib'; SET GLOBAL innodb_compression_level=9; du -sh /var/lib/mysql/employees - 385MB Note if you then try to execute.. ALTER TABLE departments ROW_FORMAT=COMPRESSED; Table storage engine 'InnoDB' does not support the create option 'PAGE_COMPRESSED' On further reading the documentation<https://mariadb.com/kb/en/mariadb/innodbxtradb-page-compression/> I noted the "Persistent Trim" section. So I tried... SET GLOBAL innodb_compression_algorithm='zlib'; SET GLOBAL innodb_compression_level=9; SET GLOBAL innodb_use_trim=ON; du -sh /var/lib/mysql/employees - 320MB Note the db size is smaller by 65MB FYI innodb_page_compression_saved = 0 at this point. Next I tried the following settings.. vi /etc/my.cnf.d/innodb_compression.cnf innodb_file_format=Barracuda innodb_file_format_max=Barracuda innodb_compression_algorithm=zlib innodb_compression_level=9 innodb_use_trim=1 innodb_use_fallocate=1 du -sh /var/lib/mysql/employees - 232M SET GLOBAL innodb_compression_algorithm='lz4'; du -sh /var/lib/mysql/employees - 232M innodb_page_compression_saved = 0 # All other counters for SHOW STATUS LIKE '%compres%' are zero SET GLOBAL innodb_compression_algorithm='lzma'; du -sh /var/lib/mysql/employees - 232M SET GLOBAL innodb_compression_algorithm='bzip2'; du -sh /var/lib/mysql/employees - 232M SET GLOBAL innodb_compression_algorithm='snappy'; du -sh /var/lib/mysql/employees - 232M innodb_page_compression_saved = 0 # All other counters for SHOW STATUS LIKE '%compres%' are zero information_schema tables INNODB_CMP, INNODB_CMP_RESET, INNODB_CMPMEM & INNODB_CMP_RESET all zero. So I guess the questions here would be... 1. Why when trim is not used is the db size unchanged apart from lzma? 2. Why is the compressed size the same for all algorithms? Is the correct algorithm being used? 3. Can I confirm which algorithm has been used for a page. I can't see anything in information_schema 4. Status variables / info schema not working? 5. ALTER TABLE ... PAGE_COMPRESSED = 1 doesn't work. Must I always do a full dump & load to enable page compression? 6. Lzma/9 compression is not that impressive. Is it meant to rival tokudb? (converting to tokudb results in a db size of ~ 54MB and this includes logs!) Cheers, 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] New Question: license question about libmysqlclient
by AskMonty KB 12 May '15

12 May '15

Hello, A new question has been asked in "MariaDB Connector/C" by seanhan. Please answer it at http://mariadb.com/kb/en/license-question-about-libmysqlclient/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi: I just downloaded and installed the mariadb-10.0.17-linux-x86_64. From the lib directory, I found the libmysqlclient.a and other related files. My question is, are they built from the native mariadb connector? Are they GPL or LGPL. Thank you!! Sean -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/license-question-about-libmysqlclient/

1 0

Re: [Maria-discuss] fsync necessary for synchronous page flush?
by Xiaofei Du 11 May '15

11 May '15

Hi Jan, Thanks for clarification. I should have used synchronous write, instead of synchronous flush. My point is that I noticed for sync writes, fsync is called to force pages to be on persistent storage. while for AIO pages, fsync is not called to force pages to be on persistent storage. My question here is why fsync is required for sync IOs. Does InnoDB maintain a dirty page table? Is fsync called to guarantee the page to be on persistent storage so that the dirty page table can be updated? If this is the case, when is the dirty page table updated for asynchronous IOs? P.S. I couldn't find code for dirty page table. So I am not sure if InnoDB maintains a dirty page table for recovery. Could you please give me a pointer to related code and related resources? Thanks. Xiaofei On Wed, May 6, 2015 at 10:12 AM, Jan Lindström <jan.lindstrom(a)mariadb.com> wrote: > Hi, > > Terminology is little bit confusing here. Page flushing means that we have > done synchronous write to disk but that does not mean that write is > physically on device yet, therefore there is flush to force it to > persistent storage. > > R: Jan > > On Wed, May 6, 2015 at 12:57 AM, Xiaofei Du <xiaofei.du008(a)gmail.com> > wrote: > >> Hello, >> >> When a dirty page is flushed synchronously in buf_flush_write_block_low, >> fsync is called in the following snippet. I am wondering why >> we need this fsync for synchronous flush? The record should be in >> the log already, so recovery should be able to successfully redo it >> and apply to the disk during recovery. Maybe I am missing something here, >> please let me know if I am wrong. Thanks much! >> >> Xiaofei >> >> >> /* When doing single page flushing the IO is done synchronously and we >> flush the changes to disk only for the tablespace we are working on. */ if >> (sync) { ut_ad(flush_type == BUF_FLUSH_SINGLE_PAGE); fil_flush(buf_page_get_space(bpage)); >> /* true means we want to evict this page from the LRU list as well. */ >> buf_page_io_complete(bpage, true); } >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> >

3 16

[Maria-discuss] New Question: MariaDb Crashing after some wordpress posts
by AskMonty KB 10 May '15

10 May '15

Hello, A new question has been asked in "MariaDB Community" by nunocarapito. Please answer it at http://mariadb.com/kb/en/mariadb-crashing-after-some-wordpress-posts/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi there. I have 2 wordpress blogs in a host, both using mariaDB. Sometimes when I add a new post, DB crashes, and can't find the reason of that. I got a screenshot of the log (mariadb.log). http://i.imgur.com/fiwA7VE.png?1 I cant find out the reason of it. Can you guys give me any help? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-crashing-after-some-wordpress-posts/

1 0

[Maria-discuss] How to unsibscribe
by Vadim Pestovnikov 10 May '15

10 May '15

Hi all, Could you please advice me how to unsibscribe from this mailing list? Unfortunately folowing by this link Unsubscribe : https://launchpad.net/~maria-discuss I couldn't find how to do it. Thank you in advance.

2 1

[Maria-discuss] MariaDB 10.0.19 now available
by Daniel Bartholomew 09 May '15

09 May '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.19. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.19 - Release Notes: https://mariadb.com/kb/en/mariadb-10019-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10019-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.19 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 - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/ We hope you enjoy MariaDB! -- MariaDB 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 10.0.18 now available
by Daniel Bartholomew 08 May '15

08 May '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.18. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.18 - Release Notes: https://mariadb.com/kb/en/mariadb-10018-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10018-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.18 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 - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/ We hope you enjoy MariaDB! -- MariaDB 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 13

[Maria-discuss] innodb_file_per_table default setting in the online documentation
by Pantelis Theodosiou 08 May '15

08 May '15

I was looking for the default setting of this variable and the MariaDB documentation <https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/#inn…> has: > *Default Value:* OFF (>= MariaDB/MySQL 5.5.7), ON (MariaDB/MySQL 5.5.0 to 5.5.6) while MySQL documentation <http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb…> has (I think correctly): *Permitted Values* (<= 5.6.5) *Type* boolean* Default *OFF *Permitted Values* (>= 5.6.6) *Type *boolean* Default *ON So, I see two issues: - first, the changing version is 5.6.6 (not 5.5.7), at least in MySQL, and - second, the values OFF / ON in the Maria documentation are reversed. Apologies if this is not the correct list to raise the issue. Pantelis Theodosiou

3 3

[Maria-discuss] New Question: Multi Master Replication and Skip Error
by AskMonty KB 08 May '15

08 May '15

Hello, A new question has been asked in "MariaDB Community" by markwass. Please answer it at http://mariadb.com/kb/en/multi-master-replication-and-skip-error/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi Guys I have 3 MariaDB 10 servers all running on Ubuntu 14.04 in a multi master replication setup. I had an issue the other day with replication where one of my slaves was asking me to run "SET GLOBAL sql_slave_skip_counter=1; start slave;" After running the command it did not fix the issue. So I tried "stop all slaves; SET GLOBAL sql_slave_skip_counter=1; start all slaves;" and still the issue was there. I'm wondering if it's because I'm using GlobaI Transaction ID's? Using_Gtid: Slave_Pos If this is the case then can some one explain to me how I would over come this replication error while using Global Transaction ID's? Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/multi-master-replication-and-skip-error/

1 0

Re: [Maria-discuss] fsync necessary for synchronous page flush?
by Xiaofei Du 07 May '15

07 May '15

Hi Jan, The only place fsync is called after AIO that I could find is in function buf_LRU_remove_pages (buf0lru.cc) But after other AIO operations, I didn't see fsync is called. Do you know how this difference will affect the recovery process? Thanks. Xiaofei On Wed, May 6, 2015 at 8:24 PM, Jan Lindström <jan.lindstrom(a)mariadb.com> wrote: > Hi, > > There is sync for AIO pages also. There is no dirty page table but > naturally dirty pages are marked and they are on LRU list see > buf/buf0lru.cc. > > R: Jan > > On Thu, May 7, 2015 at 12:23 AM, Xiaofei Du <xiaofei.du008(a)gmail.com> > wrote: > >> Hi Jan, >> >> Thanks for clarification. I should have used synchronous write, instead >> of synchronous flush. My point is that I noticed for sync writes, fsync is >> called to force pages to be on persistent storage. while for AIO pages, >> fsync is not called to force pages to be on persistent storage. My question >> here is why fsync is required for sync IOs. Does InnoDB maintain a dirty >> page table? Is fsync called to guarantee the page to be on persistent >> storage so that the dirty page table can be updated? If this is the case, >> when is the dirty page table updated for asynchronous IOs? >> >> P.S. I couldn't find code for dirty page table. So I am not sure if >> InnoDB maintains a dirty page table for recovery. Could you please give me >> a pointer to related code and related resources? Thanks. >> >> Xiaofei >> >> On Wed, May 6, 2015 at 10:12 AM, Jan Lindström <jan.lindstrom(a)mariadb.com >> > wrote: >> >>> Hi, >>> >>> Terminology is little bit confusing here. Page flushing means that we >>> have done synchronous write to disk but that does not mean that write is >>> physically on device yet, therefore there is flush to force it to >>> persistent storage. >>> >>> R: Jan >>> >>> On Wed, May 6, 2015 at 12:57 AM, Xiaofei Du <xiaofei.du008(a)gmail.com> >>> wrote: >>> >>>> Hello, >>>> >>>> When a dirty page is flushed synchronously in buf_flush_write_block_low >>>> , >>>> fsync is called in the following snippet. I am wondering why >>>> we need this fsync for synchronous flush? The record should be in >>>> the log already, so recovery should be able to successfully redo it >>>> and apply to the disk during recovery. Maybe I am missing something >>>> here, >>>> please let me know if I am wrong. Thanks much! >>>> >>>> Xiaofei >>>> >>>> >>>> /* When doing single page flushing the IO is done synchronously and we >>>> flush the changes to disk only for the tablespace we are working on. */ if >>>> (sync) { ut_ad(flush_type == BUF_FLUSH_SINGLE_PAGE); fil_flush(buf_page_get_space(bpage)); >>>> /* true means we want to evict this page from the LRU list as well. */ >>>> buf_page_io_complete(bpage, true); } >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~maria-discuss >>>> Post to : maria-discuss(a)lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~maria-discuss >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >> >

1 0

[Maria-discuss] fsync necessary for synchronous page flush?
by Xiaofei Du 05 May '15

05 May '15

Hello, When a dirty page is flushed synchronously in buf_flush_write_block_low, fsync is called in the following snippet. I am wondering why we need this fsync for synchronous flush? The record should be in the log already, so recovery should be able to successfully redo it and apply to the disk during recovery. Maybe I am missing something here, please let me know if I am wrong. Thanks much! Xiaofei /* When doing single page flushing the IO is done synchronously and we flush the changes to disk only for the tablespace we are working on. */ if (sync) { ut_ad(flush_type == BUF_FLUSH_SINGLE_PAGE); fil_flush(buf_page_get_space(bpage)); /* true means we want to evict this page from the LRU list as well. */ buf_page_io_complete(bpage, true); }

1 0

[Maria-discuss] MariaDB 10 multi-source replciation with SSL enabled
by Vadim Pestovnikov 05 May '15

05 May '15

Hi all, I am having a replication issue with MariaDB 10 using multi-source replication with SSL enabled. I have MariaDB 10 db in China, MariaDB 10 db in US and MariaDB 10 db in Europe. Each of them are getting data from other database sources such as Percona Server, AWS RDS using Tungsten replication because MariaDB 10 is not compatible with AWS RDS and Percona with GTID enabled. US and China MariaDB 10 servers are masters for Europe MariaDB. When I restore US and China MariaDB 10 data in Europe MariaDB 10 slave and start the replication, slave and masers are in sync. Then new data is coming to a masters from Tungsten, but slave doesn't get it. I don't see any errors neither from mysql-error.log or slave status. When I create fake tables and insert records everything replicates perfectly. What can be possible wrong with my setup? -- Vadim

1 0

[Maria-discuss] New Question: Connecting .Net with MariaDB
by AskMonty KB 05 May '15

05 May '15

Hello, A new question has been asked in "MariaDB Connector/ODBC Release Notes" by swarejg. Please answer it at http://mariadb.com/kb/en/connecting-net-with-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I've reading about MariaDB and the way we can connect to it via .Net Can we use MySQL .Net Connector to connect MariaDB? If not, I found that you provide Connector/ODBC for use in .Net. Which are the performance results? Regards Jorge Guevara -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connecting-net-with-mariadb/

1 0

[Maria-discuss] New Question: Are there plans to support Spatial Indexes in InnoDB for the 10.1 Release?
by AskMonty KB 04 May '15

04 May '15

Hello, A new question has been asked in "Geographic Features" by johndailyjr. Please answer it at http://mariadb.com/kb/en/are-there-plans-to-support-spatial-indexes-in-inno… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Are there plans to support Spatial Indexes in InnoDB/XtraDB for the 10.1 Release? I can't seem to find anything relevant in the changelogs. Thanks! John -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/are-there-plans-to-support-spatial-indexes-in-inno…

1 0

[Maria-discuss] Password Complexity Plugin
by Adam Scott 01 May '15

01 May '15

Hi, I noticed MySQL 5.6 has a validate_password plugin. Since it's open-source, can we add it to MariaDB 5.5. Or is that bad form, a hot potato, etc.? We need the features of this plugin in our environment, and the PAM integration is looking not a good "fit" (though it's working great). (I'm trying to get it to compile in right now, but it's having issues with the includes so far...working on it). Thanks, Adam C. Scott

4 7

[Maria-discuss] New Question: Cannot increase open-files-limit
by AskMonty KB 01 May '15

01 May '15

Hello, A new question has been asked in "Managing MariaDB" by raquel.j. Please answer it at http://mariadb.com/kb/en/cannot-increase-open-files-limit/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a LEMP stack on Ubuntu 14.04 with 10.0.17-MariaDB-1~trusty. Mysql is a huge bottleneck for my server. I have tried everything of which I am aware to raise the open files limit for mysql. I have added "open-files-limit = 2097152" to my.cnf. I have added the following to limits.conf: * soft nofile 2097152 * hard nofile 2097152 * soft nproc 2097152 * hard nproc 2097152 mysql soft nofile 2097152 mysql hard nofile 2097152 mysql soft nproc 2097152 mysql hard nproc 2097152 I have added "session required pam_limits.so" to /etc/pam.d/common-session* and /etc/pam.d/sudo and a couple of others. I have tried restarting mysql after reboot - no change. I also checked /etc/apparmor.d/usr.sbin.mysqld to see if it was involved but the file is empty. After all that I still get the following: # ulimit -Sa core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 256538 max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 2097152 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited When I run # mysqld --verbose I get this: 150501 0:19:35 [Warning] Could not increase number of max_open_files to more than 1024 Does anyone have any idea as to what is blocking this change??? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cannot-increase-open-files-limit/

1 0

[Maria-discuss] MariaDB 5.5.43 now available
by Daniel Bartholomew 01 May '15

01 May '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.43. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.43 - Release Notes: https://mariadb.com/kb/en/mariadb-5543-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5543-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.43 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 - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/ We hope you enjoy MariaDB! -- MariaDB 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] R: Re: issue with 2 node cluster
by absolutely_free＠libero.it 30 Apr '15

30 Apr '15

Hi Alexey, thank you for your reply. Yes I am using wsrep_sst_method="xtrabackup-v2" Should I simply delete ALL from /var/lib/mysql/* and restart mysql again? Thank you again. >----Messaggio originale---- >Da: alexey.yurchenko(a)galeracluster.com >Data: 30/04/2015 15.09 >A: <absolutely_free(a)libero.it> >Cc: <maria-discuss(a)lists.launchpad.net>, "Maria-discuss"<maria-discuss- bounces+alexey.yurchenko=codership.com(a)lists.launchpad.net> >Ogg: Re: [Maria-discuss] issue with 2 node cluster > >On 2015-04-30 15:13, absolutely_free(a)libero.it wrote: >> Hi, >> I have 2 mariadb nodes on Debian 7.8. >> After a crash on first node, I can't restart the second one. > >> how can I solve this issue? >> First node is ok, all databases are available. >> Thank you > >It depends. If you are using rsync or xtrabackup SST method, you can >just delete everything from the data directory. >

1 0

[Maria-discuss] issue with 2 node cluster
by absolutely_free＠libero.it 30 Apr '15

30 Apr '15

Hi, I have 2 mariadb nodes on Debian 7.8. After a crash on first node, I can't restart the second one. The message I see in /var/log/mysql/error.log is: 150430 12:55:48 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... 150430 12:55:48 InnoDB: Error: page 7 log sequence number 565808461991 InnoDB: is in the future! Current system log sequence number 565772838412. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information. 150430 12:55:48 InnoDB: Error: page 2 log sequence number 565929024045 InnoDB: is in the future! Current system log sequence number 565772838412. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information. .. .. InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 150430 12:55:48 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 5.5.42-MariaDB-1~wheezy-wsrep-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=0 max_threads=4098 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 25383890 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2b)[0x7f3cc9d0c53b] /usr/sbin/mysqld(handle_fatal_signal+0x422)[0x7f3cc993a4f2] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf0a0)[0x7f3cc900f0a0] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7f3cc786c165] /lib/x86_64-linux-gnu/libc.so.6(abort+0x180)[0x7f3cc786f3e0] /usr/sbin/mysqld(+0x73b5dc)[0x7f3cc9b795dc] /usr/sbin/mysqld(+0x709617)[0x7f3cc9b47617] /usr/sbin/mysqld(+0x70a41a)[0x7f3cc9b4841a] /usr/sbin/mysqld(+0x6f25d8)[0x7f3cc9b305d8] /usr/sbin/mysqld(+0x6c4733)[0x7f3cc9b02733] /usr/sbin/mysqld(+0x6b72d2)[0x7f3cc9af52d2] /usr/sbin/mysqld(+0x6b812c)[0x7f3cc9af612c] /usr/sbin/mysqld(+0x6bad41)[0x7f3cc9af8d41] /usr/sbin/mysqld(+0x6a3db5)[0x7f3cc9ae1db5] /usr/sbin/mysqld(+0x659d1f)[0x7f3cc9a97d1f] /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x48)[0x7f3cc993ce78] /usr/sbin/mysqld(+0x3bb550)[0x7f3cc97f9550] /usr/sbin/mysqld(_Z11plugin_initPiPPci+0x652)[0x7f3cc97fa592] /usr/sbin/mysqld(+0x32b118)[0x7f3cc9769118] /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x2036)[0x7f3cc976b9b6] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xfd)[0x7f3cc7858ead] /usr/sbin/mysqld(+0x321a4d)[0x7f3cc975fa4d] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash.' how can I solve this issue? First node is ok, all databases are available. Thank you

1 0

[Maria-discuss] New Question: Licensing of Mariadb connector/C
by AskMonty KB 30 Apr '15

30 Apr '15

Hello, A new question has been asked in "MariaDB Connector/C" by kmrsankar. Please answer it at http://mariadb.com/kb/en/licensing-of-mariadb-connectorc/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- hi, I have downloaded the source and binary of Maria DB Connector/C library. I see that one of the files mysql_async.h has a GPL license in it. But as such the whole library was declared as LGPL. Is this single GPL license header contaminates this library ? Thanks, Muthu -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/licensing-of-mariadb-connectorc/

1 0

[Maria-discuss] Calculating memory consumption for MariaDB in Munin plugin
by Anna Jonna Armannsdottir 30 Apr '15

30 Apr '15

Hello, I am new to this list and the issue I am presenting here might surely be answered on the development list, but I do not want to impose this issue on the developers, I just hope some of them listen here. There seems to be general aggreement on the calculation of memory consumption for MariaDB and MySQL. There is however an insignificant dispute but very important dispute over the role of tmp_table_size . https://mariadb.com/kb/en/mariadb/server-system-variables/#tmp_table_size The dispute is whether tmp_table_size is a session variable or a kind of global variable. Thus MariaDB memory consumption is calculated as: max_connections * (sum of session variables) + (global variables) Thus if tmp_table_size is considered to be a session variable, it will be multiplied by max_connections . In my config the settings are: max-connections = 1000 tmp-table-size = 32M max-heap-table-size = 32M In my case this means that MariaDB could consume 1000 + 32M + 1000 + (sum of sess.var.) + (global variables) . This point of view was put forward in a discussion on mysql.com: QUOTE: > I disagree with how the previous comment handles the tmp_table_size > value. They treat it as a single allocation on the global scope when > for memory consumption purposes it is more in line with a per thread > buffer. > > A single connection/query can use a single or multiple temporary > tables in the duration of its processing. The connections do not use a > single temporary table "area" reserved just for that purpose. > > If you are going to use a formula for memory consumption, the > tmp_table-size should be located with the other per thread buffers - > not in the single allocation listing. https://dev.mysql.com/doc/refman/5.0/en/memory-use.html I honestly do not believe, this the case. On this discussion list we have examples that have tmp_table_size = 256 MB and max-connections = 1000 . 256 Gigabytes!!! https://lists.launchpad.net/maria-discuss/msg02376.html On the other hand we have sites like: http://www.mysqlcalculator.com/ This site calculates memory consumption in a way I find more agreeable, by not multiplying tmp_table_size by max_connections. This is an issue in a Munin monitoring plugin that reports mysql connection memory. The calculation code is from lines 1941 to 1949. https://github.com/munin-monitoring/munin/blob/devel/plugins/node.d/mysql_ $data->{'mysql_connection_memory'} = $data->{'read_buffer_size'} + $data->{'read_rnd_buffer_size'} + $data->{'sort_buffer_size'} + $data->{'join_buffer_size'} + $data->{'binlog_cache_size'} + $data->{'thread_stack'} + ( $tmp_table_size >= $max_heap_table_size ? $tmp_table_size : $max_heap_table_size ) + ( $data->{'tokudb_read_buf_size'} || 0 ); # wsrep_thread_count was separated from max_connections for mariadb-5.5.38 https://mariadb.atlassian.net/browse/MDEV-6206 $data->{'mysql_connection_memory'} *= $data->{'max_connections'} + ( $data->{'wsrep_thread_count'} || 0 ); I ask for your opinion and support for correcting this issue, so that we may get correct reports in Munin. -- Anna Jonna Armannsdottir <annaj(a)hi.is> University of Iceland Computing Services -- Anna Jonna Armannsdottir <annajonna(a)gmail.com>

2 1

[Maria-discuss] Simple Password Check plugin Backported to 5.5
by Adam Scott 30 Apr '15

30 Apr '15

It's taken some time, but I have backported the simple_password_check plugin and the password api to MariaDB 5.5 The mysql-test is succeeding on all but the test of the strict_password_validation variable. My question is, should a pure backport include support for strict_password_validation variable ( https://mariadb.com/kb/en/mariadb/server-system-variables/#strict_password_…) ? I suspect yes, but wanted to ask to start a further discussion: namely if I submit this patch will it be included in future MariaDB 5.5 releases? It will help customer enforce password complexity beneficial for security auditing. Let me know and I'll submit patch or submit via recommended method. Thank you, Adam Scott p.s. I sent this message on Apr 27 as a reply to the mailing lists for a thread started back in January, but I haven't seen my reply show up in the public archive. Colin suggested I let you know when I have backported the plugin.

1 0

[Maria-discuss] user map auth plugin
by Felipe Gasper 29 Apr '15

29 Apr '15

So, I recently wrote an auth plugin with the intent of implementing a simple user map, authenticated against the hashed password that would be retrieved via the normal password entry scheme. I got far too far along before realizing that this scheme basically requires that either the client use a plugin to communicate with the server auth plugin, or I use the old MySQL auth plugin. ...or is there some way to re-initialize secure MySQL auth from the server auth plugin?? It would really shoot my intents in the gut if every client that wants to log in with user mapping needs to be 5.5+ and to have a plugin...:-( -FG Sent from my android device.

2 1

[Maria-discuss] Moderator: please REMOVE ME
by grantksupport＠operamail.com 29 Apr '15

29 Apr '15

I deleted my launchpad account. Still getting emails from this ML. Can't re-subscribe to launchpad to unsubscribe from the ML. Catch22 ... Could a kindly Moderator please REMOVE ME? Thx.

2 1

[Maria-discuss] UNSUBSCRIBE
by grantksupport＠operamail.com 29 Apr '15

29 Apr '15

2 1

[Maria-discuss] New Question: How to specify the options when using cmake?
by AskMonty KB 29 Apr '15

29 Apr '15

Hello, A new question has been asked in "General FAQ" by fjjiaboming. Please answer it at http://mariadb.com/kb/en/how-to-specify-the-options-when-using-cmake/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- http://www.linuxfromscratch.org/blfs/view/7.7/server/mariadb.html I build MariaDB 10.0.17 with cmake-3 , libevent-2 , python-2 ... Dependencies all are in dir /opt/.. But , how can I specify the modules dir for MariaDB ? `` cmake-3... -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/opt/mariadb-10.0.17 -DINSTALL_DOCDIR=share/doc/mariadb-10.0.17 -DINSTALL_DOCREADMEDIR=share/doc/mariadb-10.0.17 -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql/test -DINSTALL_PLUGINDIR=lib/mysql/plugin -DINSTALL_SBINDIR=sbin -DINSTALL_SCRIPTDIR=bin -DINSTALL_SQLBENCHDIR=share/mysql/bench -DINSTALL_SUPPORTFILESDIR=share/mysql -DMYSQL_DATADIR=/srv/mysql -DMYSQL_UNIX_ADDR=/srv/mysql/mysqld.sock -DWITH_EXTRA_CHARSETS=complex -DWITH_EMBEDDED_SERVER=ON -DTOKUDB_OK=0 .. `` I try to add -DWITH_LIBEVENT=/opt/libevent-2.0.22-stable -DWITH_BOOST=/opt/boost_1_58_0 ... I got some messages to tip me the options are invalid . -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-specify-the-options-when-using-cmake/

1 0

[Maria-discuss] MariaDB finally in Debian officially (Fwd: Debian 8 "Jessie" released)
by Otto Kekäläinen 27 Apr '15

27 Apr '15

Hello! Debian 8 "Jessie" has been released to today. It is the first official Debian release that ships with MariaDB (it has MariaDB 10.0.16 and MySQL 5.5.42). MariaDB client for C (the LGPL version) is also included. Release notes[1] state that in Debian 9 only one MySQL variant will be shipped. Hopefully the decision will tip towards MariaDB. The MariaDB "request for packaging" issue[2] was opened in bugs.debian.org in 2010. I started doing MariaDB packaging for Debian in 2013. The path here has been long and I am glad that this milestone is finally reached. [1] https://www.debian.org/releases/jessie/amd64/release-notes/ch-whats-new.en.… [2] https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=565308 ---------- Forwarded message ---------- From: Paul Wise <pabs(a)debian.org> Date: 2015-04-26 5:28 GMT+03:00 Subject: Debian 8 "Jessie" released To: debian-announce(a)lists.debian.org ------------------------------------------------------------------------ The Debian Project https://www.debian.org/ Debian 8 "Jessie" released press(a)debian.org April 25th, 2015 https://www.debian.org/News/2015/20150426 ------------------------------------------------------------------------ After almost 24 months of constant development the Debian project is proud to present its new stable version 8 (code name "Jessie"), which will be supported for the next 5 years thanks to the combined work of the Debian Security team [1] and of the Debian Long Term Support [2] team. 1: http://security-team.debian.org/ 2: https://wiki.debian.org/LTS "Jessie" ships with a new default init system, systemd. The systemd suite provides many exciting features such as faster boot times, cgroups for services, and the possibility of isolating part of the services. The sysvinit init system is still available in "Jessie". The UEFI ("Unified Extensible Firmware Interface") support introduced in "Wheezy" has also been greatly improved in Jessie. This includes workarounds for many known firmware bugs, support for UEFI on 32-bit systems, and support for 64-bit kernels with 32-bit UEFI firmware (with the latter being included only on our amd64/i386 "multi-arch" installation media). Since the previous release, members of the Debian project have also made important improvements to our supporting services. One of these is a browsable view of all source code shipped in Debian [3] currently available at sources.debian.net [4]. Of course, with over 20,000 source packages, it can be quite daunting to locate the right file. Therefore, we are also very pleased to present Debian Code Search [5], available at codesearch.debian.net [6]. Both services are complemented by a completely rewritten and more reponsive package tracking system [7]. 3: https://www.debian.org/News/weekly/2013/14/#sources 4: https://sources.debian.net 5: https://www.debian.org/News/weekly/2014/17/#DCS 6: https://codesearch.debian.net/ 7: https://tracker.debian.org/ This release includes numerous updated software packages, such as: * Apache 2.4.10 * Asterisk 11.13.1 * GIMP 2.8.14 * an updated version of the GNOME desktop environment 3.14 * GNU Compiler Collection 4.9.2 * Icedove 31.6.0 (an unbranded version of Mozilla Thunderbird) * Iceweasel 31.6.0esr (an unbranded version of Mozilla Firefox) * KDE Plasma Workspaces and KDE Applications 4.11.13 * LibreOffice 4.3.3 * Linux 3.16.7-ctk9 * MariaDB 10.0.16 and MySQL 5.5.42 * Nagios 3.5.1 * OpenJDK 7u75 * Perl 5.20.2 * PHP 5.6.7 * PostgreSQL 9.4.1 * Python 2.7.9 and 3.4.2 * Samba 4.1.17 * Tomcat 7.0.56 and 8.0.14 * Xen Hypervisor 4.4.1 * the Xfce 4.10 desktop environment * more than 43,000 other ready-to-use software packages, built from nearly 20,100 source packages. With this broad selection of packages and its traditional wide architecture support, Debian once again stays true to its goal of being the universal operating system. It is suitable for many different use cases: from desktop systems to netbooks; from development servers to cluster systems; and for database, web, or storage servers. At the same time, additional quality assurance efforts like automatic installation and upgrade tests for all packages in Debian's archive ensure that "Jessie" fulfills the high expectations that users have of a stable Debian release. A total of ten architectures are supported: 32-bit PC / Intel IA-32 (i386), 64-bit PC / Intel EM64T / x86-64 (amd64), Motorola/IBM PowerPC (powerpc for older hardware and ppc64el for the new 64-bit (little- endian)), MIPS (mips (big-endian) and mipsel (little-endian)), IBM S/390 (64-bit s390x) and for ARM, armel and armhf for old and new 32-bit hardware, plus arm64 for the new 64-bit "AArch64" architecture. Want to give it a try? ---------------------- If you simply want to try Debian 8 "Jessie" without having to install it, you can use a special image, known as a live image, available for CDs, USB sticks, and netboot setups. Initially, these images are provided for the amd64 and i386 architectures only. It is also possible to use these live images to install Debian. More information is available from the Debian Live homepage [8]. 8: http://live.debian.net/ If, instead, you want to install it to your computer's permanent storage, you can choose from a range of installation media, such as Blu- ray Discs, DVDs, CDs, and USB sticks, or from the network. Several desktop environments — GNOME, KDE Plasma Desktop and Applications, Xfce, and LXDE — may be installed through CD images; the desired one may be chosen from the boot menus of the CDs/DVDs. In addition, multi- architecture CDs and DVDs are available which support installation of multiple architectures from a single disc. Or you can always create bootable USB installation media (see the Installation Guide [9] for more details). For cloud users Debian also offers pre-built OpenStack images [10], ready to use. 9: https://www.debian.org/releases/jessie/installmanual 10: http://cdimage.debian.org/cdimage/openstack/current/ The installation images may be downloaded right now via bittorrent [11] (the recommended method), jigdo [12], or HTTP [13]; see Debian on CDs [14] for further information. "Jessie" will soon be available on physical DVD, CD-ROM, and Blu-ray Discs from numerous vendors [15] too. 11: https://www.debian.org/CD/torrent-cd/ 12: https://www.debian.org/CD/jigdo-cd/#which 13: https://www.debian.org/CD/http-ftp/ 14: https://www.debian.org/CD/ 15: https://www.debian.org/CD/vendors Upgrading Debian ---------------- Upgrades to Debian 8 from the previous release, Debian 7 (codenamed "Wheezy"), are automatically handled by the apt-get package management tool for most configurations. As always, Debian systems may be upgraded painlessly, in place, without any forced downtime, but it is strongly recommended to read the release notes [16] as well as the installation guide [17] for possible issues, and for detailed instructions on installing and upgrading. The release notes will be further improved and translated to additional languages in the weeks after the release. 16: https://www.debian.org/releases/jessie/releasenotes 17: https://www.debian.org/releases/jessie/installmanual About Debian ------------ Debian is a free operating system, developed by thousands of volunteers from all over the world who collaborate via the Internet. The Debian project's key strengths are its volunteer base, its dedication to the Debian Social Contract and Free Software, and its commitment to provide the best operating system possible. Debian 8 is another important step in that direction. Contact Information ------------------- For further information, please visit the Debian web pages at https://www.debian.org/ or send mail to <press(a)debian.org>. -- To UNSUBSCRIBE, email to debian-announce-REQUEST(a)lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmaster(a)lists.debian.org Archive: https://lists.debian.org/20150426022805.GA7860@chianamo -- Check out our blog at http://seravo.fi/blog and follow @ottokekalainen

3 5

[Maria-discuss] Proxy users in MariaDB?
by Felipe Gasper 24 Apr '15

24 Apr '15

Hello, Is it possible to emulate user roles via PROXY in MariaDB? Basically, I want to log in as “temp_w3gj6d6” but have the system treat that user as “frank”, including setting of DEFINERs and the like. I see that there is a PAM plugin in MariaDB .. has anyone used that plugin to achieve this effect? Thank you! -Felipe Gasper Houston, TX

3 9