- discuss - lists.mariadb.org

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 13 May '15

13 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 07 May '15

07 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

[Maria-discuss] New Question: Executing: gpg --ignore-time-conflict
by AskMonty KB 23 Apr '15

23 Apr '15

Hello, A new question has been asked in "MariaDB Community" by zakaria. Please answer it at http://mariadb.com/kb/en/executing-gpg-ignore-time-conflict/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- HI, I want to install mariadb in ubuntu server 12.04, but i get this error Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring .... gpg: requesting key 1BB943DB from hkp server keyserver.ubuntu.com gpg: key 1BB943DB: "MariaDB Package Signing Key <package-signing-key(a)mariadb.org>" imported gpg: no ultimately trusted keys found gpg: Total number processed: 1 gpg: imported: 1 when I use this following command : apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db I tried to create a file with full key : 1993 69E5 404B D5FC 7D2F E43B CBCB 082A 1BB9 43DB but i got gpg:no valid openPGP data found. kind regards -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/executing-gpg-ignore-time-conflict/

1 0

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

23 Apr '15

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

1 0

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

22 Apr '15

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

6 14

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

21 Apr '15

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

2 1

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

21 Apr '15

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

1 0

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

20 Apr '15

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

3 4

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

18 Apr '15

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

2 1

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

17 Apr '15

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

2 1

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

16 Apr '15

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

2 2

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

16 Apr '15

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

1 0

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

15 Apr '15

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

2 1

[Maria-discuss] MySQL for Database Administrators Ed 3.1
by Lukas Lehner 15 Apr '15

15 Apr '15

Hi I will attend "MySQL for Database Administrators Ed 3.1" from Oracle University. I will take 1Z0-883 "OCP MySQL 5.6 Database Administrator" exam. I choose Oracle University because of their high quality education (did quite a lot of courses at them). On my job I will work mainly with MariaDB and Galera Cluster. Is this exam and Oracle University course helpful for me? I have a background with classic Oracle RDBMs. cheers

2 1

[Maria-discuss] SHOW GRANTS change?
by Felipe Gasper 15 Apr '15

15 Apr '15

Hi all, I’ve noticed that MariaDB 10.0.14 shows an IDENTIFIED BY PASSWORD .. section in SHOW GRANTS, but 10.0.17 doesn’t show the password. I can’t find anything to this effect in the changelog; was this an intended change, or is it a bug? The MariaDB docs show SHOW GRANTS behaving without the password dump. Thank you! -FG

3 10

[Maria-discuss] MariaDB 10.1.4 now available
by Daniel Bartholomew 14 Apr '15

14 Apr '15

The MariaDB project is pleased to announce the immediate availability of 10.1.4. This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.4 - Release Notes: https://mariadb.com/kb/en/mariadb-1014-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1014-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.4 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: Determining size of a row in bytes
by AskMonty KB 14 Apr '15

14 Apr '15

Hello, A new question has been asked in "MariaDB Community" by shortwave. Please answer it at http://mariadb.com/kb/en/determining-size-of-a-row-in-bytes/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a small but essential requirement that is making me seriously consider a shift away from MySQL and I am wondering if MariaDB is a viable alternative. I need to measure the size of a row in bytes (easily). Specifically, a table consists of rows belonging to several users. I need to know how much disk space is consumed by each of those users. The only solution I can find in MySQL documentation/forums are inefficient and inaccurate approximations. Does MariaDB provide some way of doing this easily? I have to do it on multiple tables which will probably change, so I don't want to build maintenance overheads in. Also obviously I don't want too much of a performance hit. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/determining-size-of-a-row-in-bytes/

1 0

[Maria-discuss] New Question: when you will put out the PyThon connector ?
by AskMonty KB 07 Apr '15

07 Apr '15

Hello, A new question has been asked in "Client Libraries" by gclove. Please answer it at http://mariadb.com/kb/en/when-you-will-put-out-the-python-connector/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- As we know python is higt performance than PHP in Bankend . So ,will you put out PyThon 3 connector , like this ? http://dev.mysql.com/downloads/connector/python/ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/when-you-will-put-out-the-python-connector/

1 0

[Maria-discuss] New Question: Will MariaDB 10.1.X pick up MySQL 5.7.7 system variable changes for innodb?
by AskMonty KB 06 Apr '15

06 Apr '15

Hello, A new question has been asked in "What is in the Different MariaDB Releases?" by vanessaharo. Please answer it at http://mariadb.com/kb/en/will-mariadb-101x-pick-up-mysql-577-system-variabl… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Will MariaDB 10.1.X pick up MySQL 5.7.7 system variable changes for innodb? http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb… • innodb_large_prefix is enabled by default in MySQL 5.7.7. This change coincides with the default value change for innodb_file_format, which is set to Barracuda by default in MySQL 5.7.7. Together, these default value changes allow larger column prefix indexes to be created when using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED. If either option is set to a non-default value, column prefixes are silently truncated to 768 bytes. innodb_large_prefix is deprecated in MySQL 5.7.7, and will be removed in a future release. innodb_large_prefix was introduced in MySQL 5.5 to allow users to create tables compatible with the InnoDB Plugin in MySQL 5.1, which has reached the end of its product lifecycle. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/will-mariadb-101x-pick-up-mysql-577-system-variabl…

1 0

[Maria-discuss] MariaDB 10: repair table leaves 'TMM' files
by Reindl Harald 06 Apr '15

06 Apr '15

if somebody has day for day the ame table damaged just go to the datadir and delete the leave .TMM file and after that it should not happen again for at least some time cms1_user_online.TMM

1 0

[Maria-discuss] Query exceeding 16384 bytes, skipping. Probably a bulk insert query.
by Umarzuki Mochlis 02 Apr '15

02 Apr '15

When I'm restoring dump of all database to one of my MariaDB 10.0 nodes (2 nodes galera cluster), I saw "Query exceeding 16384 bytes, skipping. Probably a bulk insert query.". So I ran again mysqldump for all database and diff with its original dump. There's a lot of differences. Where should I configure on my.cnf to allow each query from dump running successfully? Thanks.

1 0

[Maria-discuss] New Question: Strange issue with a complex stored procedure and Union Query
by AskMonty KB 01 Apr '15

01 Apr '15

Hello, A new question has been asked in "MariaDB Community" by stewartpage. Please answer it at http://mariadb.com/kb/en/strange-issue-with-a-complex-stored-procedure-and-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a complex stored procedure that executes on a schedule. It runs a union query and inserts the results into a table. I recently discovered that it needed to have a LIMIT added to both queries so I enclosed the two selects in brackets, and immediately the query error'd. Removing the brackets allowed the query to run correctly. Are there any issues I should be aware of? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/strange-issue-with-a-complex-stored-procedure-and-…

1 0

[Maria-discuss] One node out of cluster keeps crashing
by Momin Rashid 31 Mar '15

31 Mar '15

Hello everyone, MariaDB-Galera-server-10.0.17-1.el7.centos.x86_64 MariaDB-client-10.0.17-1.el7.centos.x86_64 galera-25.3.9-1.rhel7.el7.centos.x86_64 We have a three node MariaDB-galera cluster, and one of our nodes keeps crashing. The other two nodes have been running fine for weeks without issues. They all have the exact same specifications. I have even rebuilt this node from ground up, and the new node still crashed. Could someone take a look at the following logs and help me figure out what is wrong, and how can we avoid this in future? ===================================== 2015-03-30 10:13:05 7f5be57fc700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 19 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 116110 srv_active, 0 srv_shutdown, 343879 srv_idle srv_master_thread log flush and writes: 459986 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 56843 OS WAIT ARRAY INFO: signal count 804274 Mutex spin waits 1039838, rounds 335818, OS waits 4493 RW-shared spins 393078, rounds 1863774, OS waits 46608 RW-excl spins 34511, rounds 1424782, OS waits 5051 Spin rounds per wait: 0.32 mutex, 4.74 RW-shared, 41.28 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 3156054 Purge done for trx's n:o < 3155992 undo n:o < 0 state: running but idle History list length 814 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 3155294, not started MySQL thread id 246025, OS thread handle 0x7f5d84124700, query id 32716796 ha-proxy.prod.lan 10.0.2.11 appl_01 cleaning up ---TRANSACTION 3154332, not started MySQL thread id 245589, OS thread handle 0x7f5d4c963700, query id 32642939 ha-proxy.prod.lan 10.0.2.11 appl_01 cleaning up ---TRANSACTION 3150705, not started MySQL thread id 245568, OS thread handle 0x7f5d840db700, query id 32777452 ha-proxy.prod.lan 10.0.2.11 appl_01 cleaning up ---TRANSACTION 3152515, not started MySQL thread id 245295, OS thread handle 0x7f5d851ff700, query id 32560015 ha-proxy.prod.lan 10.0.2.11 appl_01 cleaning up ---TRANSACTION 3155566, not started MySQL thread id 245281, OS thread handle 0x7f5d86d23700, query id 32774720 ha-proxy.prod.lan 10.0.2.11 appl_01 cleaning up ---TRANSACTION 3156038, not started TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS -------- 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 294306 OS file reads, 2485633 OS file writes, 532545 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 63, seg size 65, 28112 merges merged operations: insert 42583, delete mark 939, delete 29 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 121964244699 Log flushed up to 121964244699 Pages flushed up to 121964244699 Last checkpoint at 121964244699 Max checkpoint age 216721613 Checkpoint age target 209949063 Modified age 0 Checkpoint age 0 0 pending log writes, 0 pending chkp writes 153001 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 6263013376; in additional pool allocated 0 Total memory allocated by read views 3288 Internal hash tables (constant factor + variable factor) Adaptive hash index 423323504 (96884488 + 326439016) Page hash 757784 (buffer pool 0 only) Dictionary cache 25112304 (24222544 + 889760) File system 854680 (812272 + 42408) Lock system 15172408 (15139192 + 33216) Recovery system 0 (0 + 0) Dictionary memory allocated 889760 Buffer pool size 373496 Buffer pool size, bytes 6119358464 Free buffers 34210 Database pages 319362 Old database pages 118034 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1891, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 294208, created 25154, written 2272207 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 319362, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 46687 Buffer pool size, bytes 764919808 Free buffers 4184 Database pages 40015 Old database pages 14791 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 237, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 36928, created 3087, written 294016 LRU len: 40015, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 46687 Buffer pool size, bytes 764919808 Free buffers 4881 Database pages 39304 Old database pages 14528 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 232, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 36418, created 2886, written 189961 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 39304, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 46687 Buffer pool size, bytes 764919808 Free buffers 4278 Database pages 39906 Old database pages 14748 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 215, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 36782, created 3124, written 154398 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 39906, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 46687 Buffer pool size, bytes 764919808 Free buffers 4286 Database pages 39917 Old database pages 14754 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 247, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 36327, created 3590, written 392683 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 39917, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 46687 Buffer pool size, bytes 764919808 Free buffers 4215 Database pages 39956 Old database pages 14769 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 276, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 36833, created 3123, written 258687 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 39956, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 46687 Buffer pool size, bytes 764919808 Free buffers 4082 Database pages 40127 Old database pages 14831 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 243, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 36928, created 3199, written 252207 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 40127, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 46687 Buffer pool size, bytes 764919808 Free buffers 4010 Database pages 40224 Old database pages 14860 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 223, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 37120, created 3104, written 527443 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 40224, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 46687 Buffer pool size, bytes 764919808 Free buffers 4274 Database pages 39913 Old database pages 14753 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 218, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 36872, created 3041, written 202812 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 39913, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB 8 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 8 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 3156042 Read view up limit trx id 3155989 Read view low limit trx id 3156042 Read view individually stored trx ids: Read view trx id 3155989 Read view trx id 3156029 Read view trx id 3156038 ----------------- Main thread process no. 2488, id 140032660715264, state: sleeping Number of rows inserted 1182044, updated 1504189, deleted 4658, read 2328285511 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long

1 0

[Maria-discuss] New Question: Please list OS requirements.
by AskMonty KB 31 Mar '15

31 Mar '15

Hello, A new question has been asked in "Graphical Clients" by openiduser56. Please answer it at http://mariadb.com/kb/en/please-list-os-requirements/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- It' quite annoying to have to click around the destination website to try to work out what it takes to actually run the tool. I suspect most people looking for a GUI tool already have an operating system they want it to run on, and sometimes even restrictions on how much extra stuff they can install to get it working. So saying "runs on MacOS... you just need Parallels and a Windows licence" is unlikely to make sense. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/please-list-os-requirements/

1 0

[Maria-discuss] mariadb-galera-server : Depends: mariadb-galera-server-10.0 (= 10.0.17+maria-1~trusty) but it is not going to be installed
by Umarzuki Mochlis 27 Mar '15

27 Mar '15

Hi, Error as title happened when I'm following http://www.severalnines.com/blog/howto-offline-upgrade-galera-cluster-mysql… to upgrade from 5.5 to 10.0 Repos /etc/apt/sources.list.d/MariaDB.list deb http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu trusty main /etc/apt/sources.list deb http://my.archive.ubuntu.com/ubuntu/ trusty main restricted deb-src http://my.archive.ubuntu.com/ubuntu/ trusty main restricted deb http://my.archive.ubuntu.com/ubuntu/ trusty-updates main restricted deb-src http://my.archive.ubuntu.com/ubuntu/ trusty-updates main restricted deb http://my.archive.ubuntu.com/ubuntu/ trusty multiverse deb-src http://my.archive.ubuntu.com/ubuntu/ trusty multiverse deb http://my.archive.ubuntu.com/ubuntu/ trusty-updates multiverse deb-src http://my.archive.ubuntu.com/ubuntu/ trusty-updates multiverse deb http://my.archive.ubuntu.com/ubuntu/ trusty-backports main restricted multiverse deb http://security.ubuntu.com/ubuntu trusty-security main restricted deb-src http://security.ubuntu.com/ubuntu trusty-security main restricted deb http://security.ubuntu.com/ubuntu trusty-security multiverse deb-src http://security.ubuntu.com/ubuntu trusty-security multiverse deb http://repo.percona.com/apt trusty main deb-src http://repo.percona.com/apt trusty main Command used $ sudo LC_ALL=en_US.utf8 DEBIAN_FRONTEND=noninteractive apt-get -o Dpkg::Options::='--force-confnew' -y install mariadb-galera-server galer $ sudo dpkg --get-selections | grep maria libmariadbclient18 install mariadb-client-5.5 deinstall mariadb-client-core-5.5 install mariadb-common install mariadb-galera-server-5.5 deinstall $ sudo apt-get remove libmariadbclient18 mariadb-client-5.5 mariadb-client-core-5.5 mariadb-common mariadb-galera-server-5.5 Even after purging those packages I'm still having same error. How to solve this? Any help is appreciated. Ubuntu 14.04

2 2

[Maria-discuss] Source package for Ubuntu Precise is missing
by Kouhei Sutou 25 Mar '15

25 Mar '15

Hi, It seems that source package of MariaDB 10.0.17 for Ubuntu Precise Pangolin (12.04 LTS) isn't provided. Binary packages for Precise Pangolin are provided. mariadb-10.0_10.0.17+maria-1~trusty.dsc (for Trusty Tahr) and mariadb-10.0_10.0.17+maria-1~utopic.dsc (for Utopic Unicorn) exist at: http://mirror.jmu.edu/pub/mariadb/repo/10.0/ubuntu/pool/main/m/mariadb-10.0/ But for Precise doesn't exist at there. Is Precise support finished? Could you confirm it? FYI: Source package of MariaDB 5.5.42 for Ubuntu Precise Pangolin (12.04 LTS) is provided. http://mirror.jmu.edu/pub/mariadb/repo/5.5/ubuntu/pool/main/m/mariadb-5.5/ Thanks, -- kou

2 2

[Maria-discuss] Inconsistent engine typecode for TokuDB
by Jan Hejl 23 Mar '15

23 Mar '15

Hello, i moved from TokuDB 7.5.x MySQL (5.5.39) fork to MariaDB 10.0.16. Since then mysqld.err show error like this: 150315 22:30:29 [Warning] ./imperial@002bkv@002bcz773/scanner.frm is inconsistent: engine typecode 42, engine name TokuDB (43) for each TokuDB table access. Editing 4th byte of FRM file didn't helped, it gets overwriten to 0x2A value again. Does anyone know how to get rid of these warnings? Thanks Jan

2 3

[Maria-discuss] Reason for changing the thread_pool_size default value?
by Ian Gilfillan 19 Mar '15

19 Mar '15

Hi What was the reason for changing the default thread_pool_size from the number of CPU's to 8? If I look at the history of sql_vars.cc - https://github.com/MariaDB/server/commits/10.1/sql/sys_vars.cc?page=2 - the commit made on the 17th of November still has it as the number of CPU's, but the next commit on the 2nd of December has it at 8. This doesn't appear as a change in the summary. ian

2 1

[Maria-discuss] MariaDB 10: how to convert Aria table to InnoDB?
by Reindl Harald 19 Mar '15

19 Mar '15

how do someone convert a Aria table to another engine? MyISAM and InnoDB results in the same error ___________________________________________________________ MariaDB [dbmail]> ALTER TABLE `systemevents` ENGINE = InnoDB; ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support the create option 'TRANSACTIONAL=1' MariaDB [dbmail]> ALTER TABLE `systemevents` TRANSACTIONAL=0; Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [dbmail]> ALTER TABLE `systemevents` ENGINE = InnoDB; ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support the create option 'TRANSACTIONAL=1' ___________________________________________________________ CREATE TABLE `systemevents` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `DeviceReportedTime` datetime DEFAULT NULL, `FromHost` varchar(30) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL, `Message` text, `SysLogTag` varchar(60) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FromHost` (`FromHost`), KEY `SysLogTag` (`SysLogTag`), KEY `DeviceReportedTime` (`DeviceReportedTime`) ) ENGINE=Aria AUTO_INCREMENT=698044 DEFAULT CHARSET=utf8 PACK_KEYS=0 PAGE_CHECKSUM=0 DELAY_KEY_WRITE=1 ROW_FORMAT=PAGE TRANSACTIONAL=0

6 14

[Maria-discuss] New Question: MS-SQL Server Change tracking
by AskMonty KB 18 Mar '15

18 Mar '15

Hello, A new question has been asked in "Moving to MariaDB" by peterhorwood. Please answer it at http://mariadb.com/kb/en/ms-sql-server-change-tracking/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm looking at having our product add MariaDB as a database we support. Currently we only support MS-SQL. One issue I'm wondering about is change tracking. Does MariaSQL have anything like the SQL Server (2008 and newer) Server change tracking? Or do I need to 'roll my own' using insert/update/delete triggers? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/ms-sql-server-change-tracking/

1 0

[Maria-discuss] Sysbench compile error for MariaDB under Centos 6.4
by Fay Hou 18 Mar '15

18 Mar '15

Thank you for your time. I do see the libmysqlclient installed. []# find / -name libmysqlclient_r* /usr/lib64/libmysqlclient_r.so.15 /usr/lib64/libmysqlclient_r.so.15.0.0 /usr/lib64/libmysqlclient_r.so.16.0.0 /usr/lib64/libmysqlclient_r.so.16 /usr/lib64/libmysqlclient_r.a But, I got error when I compile "make". Any ideas? libtool: link: gcc -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast -Wstrict-prototypes -Wnested-externs -Winline -funroll-loops -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align -pthread -O2 -ggdb3 -o sysbench sysbench.o sb_timer.o sb_options.o sb_logger.o db_driver.o sb_percentile.o -L/usr/local/lib tests/fileio/libsbfileio.a tests/threads/libsbthreads.a tests/memory/libsbmemory.a tests/cpu/libsbcpu.a tests/mutex/libsbmutex.a scripting/libsbscript.a drivers/mysql/libsbmysql.a -L/usr/lib64/mysql -lmysqlclient_r scripting/lua/src/liblua.a -ldl -lrt -lm -pthread /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `mysql_get_ssl_cipher': (.text+0x2159): undefined reference to `SSL_get_current_cipher' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `send_client_reply_packet': (.text+0x2a68): undefined reference to `SSL_get_peer_certificate' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `send_client_reply_packet': (.text+0x2a80): undefined reference to `X509_get_subject_name' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `send_client_reply_packet': (.text+0x2a94): undefined reference to `X509_NAME_oneline' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `send_client_reply_packet': (.text+0x2aa3): undefined reference to `X509_free' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `send_client_reply_packet': (.text+0x2cbc): undefined reference to `ERR_error_string_n' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `mysql_close': (.text+0x35f4): undefined reference to `SSL_CTX_free' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `mysql_get_ssl_cipher': (.text+0x2162): undefined reference to `SSL_CIPHER_get_name' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(mysql_async.c.o): In function `my_ssl_read_async': (.text+0xcdf): undefined reference to `SSL_read' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(mysql_async.c.o): In function `my_ssl_read_async': (.text+0xd0e): undefined reference to `SSL_get_error' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(mysql_async.c.o): In function `my_ssl_write_async': (.text+0xd8f): undefined reference to `SSL_write' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(mysql_async.c.o): In function `my_ssl_write_async': (.text+0xdbe): undefined reference to `SSL_get_error' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(vio.c.o): In function `vio_end': (.text+0x5a7): undefined reference to `ERR_remove_state' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(vio.c.o): In function `vio_end': (.text+0x5ac): undefined reference to `ERR_free_strings' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(vio.c.o): In function `vio_end': (.text+0x5b1): undefined reference to `EVP_cleanup' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(vio.c.o): In function `vio_end': (.text+0x5b7): undefined reference to `CRYPTO_cleanup_all_ex_data' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosocket.c.o): In function `vio_is_connected': (.text+0xe86): undefined reference to `SSL_pending' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0x3b): undefined reference to `SSL_new' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0x4f): undefined reference to `SSL_clear' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0x57): undefined reference to `SSL_get_session' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0x62): undefined reference to `SSL_SESSION_set_timeout' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0x6d): undefined reference to `SSL_set_fd' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0x81): undefined reference to `SSL_ctrl' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0xab): undefined reference to `SSL_get_error' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0xef): undefined reference to `SSL_get_error' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0xfc): undefined reference to `SSL_free' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0x159): undefined reference to `SSL_get_fd' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `ssl_do': (.text+0x199): undefined reference to `ERR_get_error' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `vio_ssl_read': (.text+0x1f1): undefined reference to `SSL_read' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `vio_ssl_read': (.text+0x207): undefined reference to `SSL_get_error' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `vio_ssl_write': (.text+0x2e1): undefined reference to `SSL_write' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `vio_ssl_write': (.text+0x2f7): undefined reference to `SSL_get_error' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `vio_ssl_close': (.text+0x3b8): undefined reference to `SSL_set_quiet_shutdown' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `vio_ssl_close': (.text+0x3c0): undefined reference to `SSL_shutdown' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `vio_ssl_delete': (.text+0x407): undefined reference to `SSL_free' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `sslaccept': (.text+0x447): undefined reference to `SSL_accept' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `sslconnect': (.text+0x467): undefined reference to `SSL_connect' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viossl.c.o): In function `vio_ssl_has_data': (.text+0x4ac): undefined reference to `SSL_pending' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x63): undefined reference to `SSL_load_error_strings' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x8a): undefined reference to `TLSv1_server_method' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x92): undefined reference to `SSL_CTX_new' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0xae): undefined reference to `SSL_CTX_set_cipher_list' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0xc5): undefined reference to `SSL_CTX_load_verify_locations' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0xe5): undefined reference to `SSL_CTX_set_default_verify_paths' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x103): undefined reference to `SSL_CTX_get_cert_store' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x116): undefined reference to `X509_STORE_load_locations' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x12b): undefined reference to `X509_STORE_set_flags' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x15f): undefined reference to `SSL_CTX_use_certificate_chain_file' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x17c): undefined reference to `SSL_CTX_use_PrivateKey_file' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x191): undefined reference to `SSL_CTX_check_private_key' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x19e): undefined reference to `DH_new' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x1b9): undefined reference to `BN_bin2bn' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x1d1): undefined reference to `BN_bin2bn' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x1fd): undefined reference to `SSL_CTX_ctrl' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x205): undefined reference to `DH_free' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x221): undefined reference to `TLSv1_client_method' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x268): undefined reference to `SSL_library_init' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x26d): undefined reference to `OPENSSL_add_all_algorithms_noconf' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x2d6): undefined reference to `ERR_get_error_line_data' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x2e3): undefined reference to `SSL_CTX_free' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x32d): undefined reference to `ERR_get_error_line_data' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x3ad): undefined reference to `ERR_get_error_line_data' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x42d): undefined reference to `ERR_get_error_line_data' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x465): undefined reference to `ERR_get_error_line_data' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x47a): undefined reference to `DH_free' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLFd': (.text+0x4ad): undefined reference to `ERR_get_error_line_data' /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(viosslfactories.c.o): In function `new_VioSSLConnectorFd': (.text+0x514): undefined reference to `SSL_CTX_set_verify' under Centos 6.4

3 5

[Maria-discuss] Error Message spelling mistake
by Rhys Campbell 16 Mar '15

16 Mar '15

I feel like a bit of a pedant reporting this... "Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 1-1-7, which is not in the master's binlog. Since the master's binlog contains GTIDs with higher sequence numbers, it probably means that the slave has diverged due to executing extra errorneous transactions'" Errorneous should be erroneous Rhys Campbell Database Administrator TradingScreen, Inc. 23 York House, 5th Floor London WC2B 6UJ Email: rhys.james.campbell(a)googlemail.com<mailto:rhys.james.campbell@googlemail.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 2

[Maria-discuss] Stored Procedure debugger from Peter Gulutzan and Trudy Pelzer
by Alexander Barkov 13 Mar '15

13 Mar '15

Hi, Peter Gulutzan and Trudy Pelzer announced their GUI debugger for stored procedures. Sources, binaries and a demo are available here: http://ocelot.ca/blog/blog/2015/03/02/the-ocelotgui-debugger/ This is a great news. Greetings.

5 8

[Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4
by Michael Widenius 12 Mar '15

12 Mar '15

Hi! We had originally planned to enable the feedback plugin by default for the Alpha and Beta stages of MariaDB 10.1, but we forgot to do this for the alpha so I suggested Sergei today that we should enable it for the beta period of MariaDB 10.0 We agreed that before doing this we would have a discussion on the maria developer list to explain why we would like to do this. The reason we would like to enable it is to get information about which features people are testing and using in MariaDB 10.1, so that we can concentrate our testing and bug fixing during the beta phase for those areas that people are actually using. This would help our development work a lot and would also help us to plan for MariaDB 10.2 development. Anyone will be able to disable the feedback plugin by adding: --feedback=OFF to their my.cnf file. In MariaDB 10.1 gamma/release we would make it default OFF again. We will of course inform everyone about this change, including how to disable the feedback, in the MariaDB changelog and release notes. We do of course hope that as many as possible will have it on, even after gamma, to help us with our development work! Information about the MariaDB feedback plugin and the statistics it provides can be found at: http://mariadb.org/feedback_plugin https://mariadb.com/kb/feedback-plugin As most MariaDB users should know, the feedback is totally anonymous and no private or sensitive information is being sent. Any comments, suggestions or recommendations? Regards, Michael Widenius Creator of MySQL and MariaDB

12 19

[Maria-discuss] MariaDB Galera Cluster 10.0.17 and 5.5.42 now available
by Daniel Bartholomew 11 Mar '15

11 Mar '15

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.17 & 5.5.42 Both are Stable (GA) releases. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.17 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10017-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10017-changelog/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.17 MariaDB Galera Cluster 5.5.42 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5542-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5542-changelog/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.42 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/ - http://www.cafepress.com/mariadb 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] GSOC 2015 :UDFs returning arrays
by Delveri chick 11 Mar '15

11 Mar '15

Hi My name is Blessing Atie and i would love to participate in the Google summer of code 2015 under Mariadb. I am interested in the project UDF returning arrays. I have build mariadb from source and and i also ran the test suites. I am currently studing the sql/sql.** files to understand UDF's and i also downloaded some ebook on mysql internals and mysql plugin development which im reading while hoping to find a breakthrough on this project in them. I would love to know if there are any bugs related to this task on JIRA I could work on as a means of preparing for the project. Please give me the link. Regards

5 14

[Maria-discuss] New Question: Looking for a stable version of ODBC connector for Linux
by AskMonty KB 05 Mar '15

05 Mar '15

Hello, A new question has been asked in "MariaDB Connector/ODBC" by namkyungkim. Please answer it at http://mariadb.com/kb/en/looking-for-a-stable-version-of-odbc-connector-for… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi all, I am looking for a stable version of ODBC connector for Linux. I am kindly asking you when I can have a chance to download it. Thank you and regards, -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/looking-for-a-stable-version-of-odbc-connector-for…

1 0

[Maria-discuss] mariadb 10.0.17 keeps crashing
by Gabriel Sosa 04 Mar '15

04 Mar '15

Hello, I've been a proudly user of mariadb 5.5.x for a long time now but given the nice feature setI decided to give mariadb 10.x a try. I took one of our current slaves running mariadb 5.5.x (on centos 6.5) and followed the upgrade steps using yum and ran *mysql_upgrade*. The upgrade ran without any trouble...then I moved a huge table (about 1B records right now) from InnoDB to TokuDB. Now, every couple of hours I find that the replication is far behind the master and the reason is because this server keeps checking tables marked as crashed.... I can't seems to find any indicator of OOM killer in the system logs NOR anything related to that in the mysql log, the only clue I have is: --------------- *150303 10:08:57 mysqld_safe Number of processes running now: 0* *150303 10:08:57 mysqld_safe mysqld restarted* 150303 10:08:58 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release. 150303 10:08:59 [Warning] option 'innodb-status-file': boolean value 'ib_status' wasn't recognized. Set to OFF. 150303 10:08:59 [Warning] option 'innodb-autoextend-increment': unsigned value 10485760 adjusted to 1000 150303 10:08:59 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150303 10:08:59 [Note] InnoDB: The InnoDB memory heap is disabled 150303 10:08:59 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150303 10:08:59 [Note] InnoDB: Memory barrier is not used 150303 10:08:59 [Note] InnoDB: Compressed tables use zlib 1.2.3 150303 10:08:59 [Note] InnoDB: Using Linux native AIO 150303 10:08:59 [Note] InnoDB: Using CPU crc32 instructions 150303 10:08:59 [Note] InnoDB: Initializing buffer pool, size = 6.0G 150303 10:08:59 [Note] InnoDB: Completed initialization of buffer pool 150303 10:08:59 [Note] InnoDB: Highest supported file format is Barracuda. 150303 10:08:59 [Note] InnoDB: Log scan progressed past the checkpoint lsn 14178608217047 150303 10:08:59 [Note] InnoDB: Database was not shutdown normally! 150303 10:08:59 [Note] InnoDB: Starting crash recovery. 150303 10:08:59 [Note] InnoDB: Reading tablespace information from the .ibd files... 150303 10:09:05 [Note] InnoDB: Restoring possible half-written data pages 150303 10:09:05 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 14178613459456 InnoDB: Doing recovery: scanned up to log sequence number 14178618702336 InnoDB: Doing recovery: scanned up to log sequence number 14178623945216 InnoDB: Doing recovery: scanned up to log sequence number 14178629188096 InnoDB: Doing recovery: scanned up to log sequence number 14178634430976 InnoDB: Doing recovery: scanned up to log sequence number 14178639673856 InnoDB: Doing recovery: scanned up to log sequence number 14178644916736 ...... ...... ...... ...... 150303 10:09:14 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: In a MySQL replication slave the last master binlog file InnoDB: position 0 16433109, file name slave-bin.852141 InnoDB: Last MySQL binlog file position 0 16784214, file name /var/lib/mysql/log/bin/slave-bin.005211 150303 10:09:34 [Note] InnoDB: 128 rollback segment(s) are active. 150303 10:09:34 [Note] InnoDB: Waiting for purge to start 150303 10:09:34 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 14178834821658 Tue Mar 3 10:09:36 2015 TokuFT recovery starting in env /var/lib/mysql/data/ Tue Mar 3 10:09:36 2015 TokuFT recovery scanning backward from 1330297 Tue Mar 3 10:09:36 2015 TokuFT recovery bw_end_checkpoint at 1330297 timestamp 1425395277901416 xid 1330281 (bw_newer) Tue Mar 3 10:09:36 2015 TokuFT recovery bw_begin_checkpoint at 1330281 timestamp 1425395273487081 (bw_between) Tue Mar 3 10:09:36 2015 TokuFT recovery turning around at begin checkpoint 1330281 time 4414335 Tue Mar 3 10:09:36 2015 TokuFT recovery starts scanning forward to 1330297 from 1330281 left 16 (fw_between) Tue Mar 3 10:09:36 2015 TokuFT recovery closing 14 dictionaries Tue Mar 3 10:09:36 2015 TokuFT recovery making a checkpoint Tue Mar 3 10:09:36 2015 TokuFT recovery done 150303 10:09:36 [Note] Recovering after a crash using /var/lib/mysql/log/bin/slave-bin --------------- The odd thing is that the 5.5.x version was working just fine (since about a year) in the same hardware...nothing changed in that front. Any clue? Thank you in advance

4 9

[Maria-discuss] Questions on image data should be stored in database or not?
by Peter Boston 04 Mar '15

04 Mar '15

I don't know the following questions are valid here or not. I just hope I get some help from experienced experts here. I am planning to use MariaDB on 64bit Linux for a new medical application project. I have to store lots of images. The size of one image is about 263KB. There are about 50 images per patient. It's about 14MB. I have two options here for these image data: Option A: store them in file system and have their location linked in database table; Option B: store them in database in a separated table as BOLB with a unique id; I know there are lots of implementations go with Option A. My concern about Option A is the security and backup. I have to do them separately. Do you have any good idea how to do them? For Option B, I am worry about the size of that table and the database. I read somewhere saying the BOLB and TEXT columns in a table are not stored "inline" and will not be counted to the table size. Where I can find the detailed information about this? Oracle has a special way to handle this situation and is pushing save images into database. Is there a similar mechanism in MariaDB? How about compress a series of images for a patient in Option B? Is it worthy to scarify perform for gaining some spaces? Eventually the data size will be very big, what are the options for me to cleanup and archive old data, including the image data? Thanks, Peter

3 4

[Maria-discuss] stored programs
by Federico Razzoli 04 Mar '15

04 Mar '15

Reading 10.0.3 release notes: https://mariadb.com/kb/en/mariadb/mariadb-1013-release-notes/ I see that IF EXISTS, IF NOT EXISTS and OR REPLACE are now almost consistent. "Almost" means that... OR REPLACE still doesn't apply to stored procedures, functions, triggers, events. Recently, during a public session, a PostgreSQL user asked me if MariaDB supports stored procedures - in his opinion, MySQL doesn't, no matter what the manual says. Unfortunately my answer was that MariaDB support for stored procedure is the same as MySQL ("so the answer is no", he said). I feel that these features are generally ignored. I don't understand the reason. While they have many problems in MariaDB/MySQL, some people still tries to use them. Even more people would use them if some developement was made on them. They are also used by important projects like Common Schema and Flexviews, but I'm sure that the authors have to struggle against limitations every time they change a line of code. I struggled hards for a much easier project - an SQL unit test tool. I have several problems in mind: performance, lack of variable number of arguments, cannot prepare a statement from a local variable, no debugger, no way to see the call stack... I'm writing this because I love MariaDB. This is not a hateful criticism: this is a request for something I waited for many years. I hope that you will keep procedures in mind, while planning the next major release. Regards Federico

6 40

[Maria-discuss] MaxScale Multiple Masters
by Riz Plate 03 Mar '15

03 Mar '15

Hi I have a very basic scenario, we have one database which is running out of space. database have some tables with incremental primary key ids. 1- for new ids , we want to send read/write to new server and preferably , do id based statement routing i.e. if id%2=0 push to new-server1 , else read/write to new-server2. 2- some tables are created dynamically i.e. dynamic_table_123. we want to send 123%2=0 to new-server1 else read/write to new-server2. 3- all statements in above #1, #2 should go to same MaxScale abstraction i.e. application should not have logic for routing. Can we do this with MaxsScale? what are the configuraion readwriterouter or the cluster? Thanks for your insight and recommendations. Thanks

1 0

[Maria-discuss] New Question: ResultSetMetaData getColumnClassName accuracy for JDBC
by AskMonty KB 02 Mar '15

02 Mar '15

Hello, A new question has been asked in "Client Libraries" by tommy_pham_g. Please answer it at http://mariadb.com/kb/en/resultsetmetadata-getcolumnclassname-accuracy-for-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi folks, I'm having problems getting the getColumnClassName to return the correct information. I have a sample table: CREATE TABLE `datatypes` ( `mariadb_binary` binary(8) NULL, `mariadb_blob` blob NULL, `mariadb_boolean` tinyint(1) NULL, `mariadb_varbinary` varbinary(16) NULL, `mariadb_varchar` varchar(5) CHARACTER SET utf8 NULL, UNIQUE KEY `mariadb_serial` (`mariadb_serial`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; The ResultSetMetaData is not returning accurate GetColumnClassName information for some of the above columns: [INFO ] 2015-03-02 09:26:52.905 [main] c.d.d.AppDbTest.main - getColumnName mariadb_binary | getColumnLabel mariadb_binary. getColumnClassName [B. getColumnDisplaySize 8. getColumnType -2. getColumnTypeName BINARY. [INFO ] 2015-03-02 09:26:52.905 [main] c.d.d.AppDbTest.main - getColumnName mariadb_blob | getColumnLabel mariadb_blob. getColumnClassName [B. getColumnDisplaySize 65535. getColumnType -4. getColumnTypeName BLOB. [INFO ] 2015-03-02 09:26:52.905 [main] c.d.d.AppDbTest.main - getColumnName mariadb_boolean | getColumnLabel mariadb_boolean. getColumnClassName java.lang.Boolean. getColumnDisplaySize 1. getColumnType -7. getColumnTypeName TINYINT. getPrecision 1. [INFO ] 2015-03-02 09:26:52.998 [main] c.d.d.AppDbTest.main - getColumnName mariadb_varbinary | getColumnLabel mariadb_varbinary. getColumnClassName [B. getColumnDisplaySize 16. getColumnType -3. getColumnTypeName VARBINARY. getPrecision 16. [INFO ] 2015-03-02 09:26:53.014 [main] c.d.d.AppDbTest.main - getColumnName mariadb_varchar | getColumnLabel mariadb_varchar. getColumnClassName java.lang.String. getColumnDisplaySize 5. getColumnType 12. getColumnTypeName VARCHAR. getPrecision 5. Is the above by design? Is it bug within JDBC spec? I'm using MariaDB JDBC version 1.1.8. Thanks, Tommy -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/resultsetmetadata-getcolumnclassname-accuracy-for-…

1 0

[Maria-discuss] Serious problem with latest (10.0.16) Windows installer - destroys services.
by Peter Laursen 02 Mar '15

02 Mar '15

I have MariaDB 5.5, 10.0 and 10.1 installed (as Windows services named 'maria55'. 'maria10' and 'maria10_1' ) and always update them to latest soon after an update is available. Yesterday morning I installed 10.0.16 on top of 10.0.15 using the .msi installer. When I tried to connect to it a few hours later it was not possible. I thought the service might not be running. It wasn't. Actually it did not exist anymore at all! "net start maria10" returned "service does not exist" (and indeed it did not appear in Windows "services management" interface). I copied the /datadir, uninstalle , did a fresh install of 10.0.16d (choosing the option not to upgrade any existing server) and copied the old /datadir back. Now Maria 10.0(.16) works again. But now I see that the 'maria55' service is also gone from the system. Files are intact. I can repeat the exercise I did with 10.0 of course or install service again from commandline. Not a big problem, but very annoying and waste of time. MariaDB 10.1 installaton is not affected. 5 diiferent Oracle/MySQL servers (from 5.0 to 5.7) also are not. I need all those instances for application testing. Questions: * Has somebody else experienced this? * Has somebody replaced @wlad as maintainer of Windows installers? @wlad was the only person who ever was able to write reasonable MySQL/MariaDB installers. So I would regret that. It is perfectly legal on Windows to have multiple MariaDB servers simultaneously running as Windows services. They won't conflict as long as service name, port, basedir and datadir are all different. What happens with one should not affect another. I the installer does not respect this, it is a bug. -- Peter -- Webyog

5 10

[Maria-discuss] MariaDB 10.0.17 and 10.1.3 released
by Daniel Bartholomew 02 Mar '15

02 Mar '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.17 & 10.1.3 MariaDB 10.0.17 is a Stable (GA) release. MariaDB 10.1.3 is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.17 - Release Notes: https://mariadb.com/kb/en/mariadb-10017-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10017-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.17 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ MariaDB 10.1.3 - Release Notes: https://mariadb.com/kb/en/mariadb-1013-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1013-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.3 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/ - http://www.cafepress.com/mariadb 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] Giving up on dynamic columns
by Tom Worster 02 Mar '15

02 Mar '15

I discovered this showstopper on Friday while working with real data in development of a new app. I managed to narrow it down today and filed the bug report. https://mariadb.atlassian.net/browse/MDEV-7650 Looks like Maria saves an illegally formatted dyncol string if a dynamic column is longer than 64kB and is not alphabetically last by name among the dynamic column in the blob. Tbh, even is this were fixed tomorrow so I could proceed with my work, I'm not sure I would use dyncols. My confidence in the feature has been shaken. It's a pity because the Active Record ORM extension I wrote was working. Tom

4 6

[Maria-discuss] myisam_use_mmap unstable in MariaDB 10.0.x
by Reindl Harald 01 Mar '15

01 Mar '15

historical: http://lists.mysql.com/mysql/226361 after it turned out to be stable in 2013/2014 upgrade to MariaDB 10.0.17 yesterday and the logs started with "table corrupt", "table not closed properly" and so on for tables which where not only read this time not with 'mysqld got signal 11' but "only" corrupted MyISAM files and after disable 'myisam_use_mmap' all is clean and stable over hours BTW a 'repair table' don't delete the TMM file leading in a 'optimize table' later failing until you delete the file manually from disk __________________________________________________________________ this configuration is unchanged for years and so my only conclusion is that Oracle managed to kill the feature again, this is also confirmed for Percona Server 5.6 where even queries fail confirmed from another sysadmin which found out that playing with my settings leaded to problems while here MariaDB 5.5.x was in use and hence no troubles - given that 'myisam_use_mmap' is borked at MariaDB 10.x and Percona 5.6 it's likely a backport from MySQL 5.6 delay-key-write = ALL concurrent_insert = 2 open-files-limit = 750000 myisam-recover-options = "FORCE" myisam_use_mmap = 0 wait_timeout = 300 interactive_timeout = 300 max_allowed_packet = 200M max_connections = 500 max_tmp_tables = 150 max_connect_errors = 250 max_delayed_threads = 32 flush_time = 0 query_cache_limit = 256K query_cache_min_res_unit = 1K query_cache_size = 1280M query_cache_type = 1 table_cache = 10000 table_definition_cache = 10000 thread_cache_size = 400 tmp_table_size = 256M max_heap_table_size = 256M key_buffer_size = 256M sort_buffer_size = 256K myisam_sort_buffer_size = 15M join_buffer_size = 1M preload_buffer_size = 128K read_buffer_size = 128K read_rnd_buffer_size = 128K

1 0

[Maria-discuss] warning from binary tarball file installation.
by Peter Boston 28 Feb '15

28 Feb '15

I am installing mariadb-10.0.15 on Fedora 20 from a binary tarball file. After several changes on .my.cnf file, I minimized the installation warning to three. I am using the default my-large.cnf file from the release. How can I eliminate them, particularly the last one: Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist. Thanks, [root@dev2 mysql]# ./scripts/mysql_install_db --defaults-file=~/.my.cnf --user=mysql Installing MariaDB/MySQL system tables in './data' ... 150225 10:37:35 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 10:37:35 [Note] InnoDB: The InnoDB memory heap is disabled 150225 10:37:35 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 10:37:35 [Note] InnoDB: Memory barrier is not used 150225 10:37:35 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 10:37:35 [Note] InnoDB: Using Linux native AIO 150225 10:37:35 [Note] InnoDB: Not using CPU crc32 instructions 150225 10:37:35 [Note] InnoDB: Initializing buffer pool, size = 384.0M 150225 10:37:35 [Note] InnoDB: Completed initialization of buffer pool 150225 10:37:35 [Note] InnoDB: The first specified data file /usr/local/mysql/data/ibdata1 did not exist: a new database to be created! 150225 10:37:35 [Note] InnoDB: Setting file /usr/local/mysql/data/ibdata1 size to 2000 MB 150225 10:37:35 [Note] InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 150225 10:37:42 [Note] InnoDB: Data file /usr/local/mysql/data/ibdata2 did not exist: new to be created 150225 10:37:42 [Note] InnoDB: Setting file /usr/local/mysql/data/ibdata2 size to 10 MB 150225 10:37:42 [Note] InnoDB: Database physically writes the file full: wait... 150225 10:37:42 [Note] InnoDB: Setting log file /usr/local/mysql/data/ib_logfile101 size to 100 MB InnoDB: Progress in MB: 100 150225 10:37:43 [Note] InnoDB: Setting log file /usr/local/mysql/data/ib_logfile1 size to 100 MB InnoDB: Progress in MB: 100 150225 10:37:43 [Note] InnoDB: Renaming log file /usr/local/mysql/data/ib_logfile101 to /usr/local/mysql/data/ib_logfile0 150225 10:37:43 [Warning] InnoDB: New log files created, LSN=45782 150225 10:37:43 [Note] InnoDB: Doublewrite buffer not found: creating new 150225 10:37:43 [Note] InnoDB: Doublewrite buffer created 150225 10:37:43 [Note] InnoDB: 128 rollback segment(s) are active. 150225 10:37:43 [Warning] InnoDB: Creating foreign key constraint system tables. 150225 10:37:43 [Note] InnoDB: Foreign key constraint system tables created 150225 10:37:43 [Note] InnoDB: Creating tablespace and datafile system tables. 150225 10:37:43 [Note] InnoDB: Tablespace and datafile system tables created. 150225 10:37:43 [Note] InnoDB: Waiting for purge to start 150225 10:37:43 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 0 150225 10:37:43 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 150225 10:37:43 [Note] InnoDB: FTS optimize thread exiting. 150225 10:37:43 [Note] InnoDB: Starting shutdown... 150225 10:37:45 [Note] InnoDB: Shutdown completed; log sequence number 1616698 OK Filling help tables... 150225 10:37:45 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 10:37:45 [Note] InnoDB: The InnoDB memory heap is disabled 150225 10:37:45 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 10:37:45 [Note] InnoDB: Memory barrier is not used 150225 10:37:45 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 10:37:45 [Note] InnoDB: Using Linux native AIO 150225 10:37:45 [Note] InnoDB: Not using CPU crc32 instructions 150225 10:37:45 [Note] InnoDB: Initializing buffer pool, size = 384.0M 150225 10:37:45 [Note] InnoDB: Completed initialization of buffer pool 150225 10:37:45 [Note] InnoDB: Highest supported file format is Barracuda. 150225 10:37:45 [Note] InnoDB: 128 rollback segment(s) are active. 150225 10:37:45 [Note] InnoDB: Waiting for purge to start 150225 10:37:45 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 1616698 150225 10:37:46 [Note] InnoDB: FTS optimize thread exiting. 150225 10:37:46 [Note] InnoDB: Starting shutdown... 150225 10:37:48 [Note] InnoDB: Shutdown completed; log sequence number 1616708 OK

2 1

[Maria-discuss] Default privileges for anon. user.
by dE 26 Feb '15

26 Feb '15

Hi! I've realized that by default MariaDB allow full access to a database for anon. users. $ mysql --user asdfasdf test MariaDB [test]> insert into test (sr) values (1); Query OK, 1 row affected (0.12 sec) I tried to revoke but -- Revoke all on test.test from ''@''; ERROR 1141 (42000): There is no such grant defined for user '' on host '%' Is there anyway to disallow all types of access to anon. users?

2 2

[Maria-discuss] questions from a new user
by Peter Boston 25 Feb '15

25 Feb '15

I am new to use mariadb on linux machine. I am using Fedora 20 and I have downloaded the mariadb 10.0.15 tar.gz file and its instruction. I removed the existing mariadb from my Fedora 20. I have installed the mariadb on my machine by following the official instruction. It seems successful (without error) but I cannot start it as expected. I also have few other basic questions. Some background information here: this database will be accessed by a local application. This local application may be running under a general user account, user1. I installed it in /var/local as a root user. Questions: 1. How to uninstall it completely? I want to try again to see if I did anything wrong before. 2. Because it will be accessed by a local application and the local application will be running by a general user, user1, should I install it with user1? 3. Basically I am confused with these three users: user1, mysql and root. "user1" will be used to run the application and login the machine. "mysql" will be used to connect the mariadb. "root" will be used to install mariadb into /usr/local. Who will start the mariadb? It will be "root", I guess. But if "root" starts the service, "user1" and "mysql" don't have problem to access its resources? 4. If I don't want to install it as root, can I still install it under the /usr/local directory? 5. I renamed the my-large.cnf to .my.cnf and uncomment the InnoDB table section. Is this only change I need to make if I want to use InnoDB? should I disable the myisam? how? 6. where should I put the .my.cnf file? put into the home directory of the user who starts the mariadb or the user who logon the system if they are different? 7. there is a my.cnf file from the Fedora 20 installation, when I start mariadb without the "--defaults-file=~/.my.cnf" option, I will get the following error from the log: [ERROR] mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 "No such file or directory") I have to manually create the mysqld folder inside the /var/run folder each time after reboot. how to avoid this? 8. After started with that "old" my.cnf, I try to stop the mariadb but cannot because I cannot find its service name: [user1@dev2 mysql]$ ./bin/mysqladmin -u root -p status Enter password: Uptime: 685 Threads: 1 Questions: 3 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 62 Queries per second avg: 0.004 [user1@dev2 mysql]$ sudo systemctl status mariadb.service mariadb.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) [user1@dev2 mysql]$ sudo systemctl status mysql.service mysql.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) [user1@dev2 mysql]$ sudo systemctl status mysqld.service mysqld.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) how stop it? 9. if I start mariadb with the renamed my-large.cnf ([root@dev2 mysql]# ./bin/mysqld_safe --defaults-file=~/.my.cnf --user=mysql), I got the following error: 150225 0:09:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 150225 0:09:28 [Note] Recovering after a crash using mysql-bin 150225 0:09:28 [Note] Starting crash recovery... 150225 0:09:28 [Note] Crash recovery finished. 150225 0:09:28 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 150225 0:09:28 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 150225 0:09:28 [Note] Server socket created on IP: '::'. 150225 0:09:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 150225 00:09:28 mysqld_safe mysqld from pid file /usr/local/mysql/data/dev2.pid ended Then I try do upgrade as suggested above: [root@dev2 mysql]# ./bin/mysql_upgrade Version check failed. Got the following error when calling the 'mysql' command line client ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2 "No such file or directory") FATAL ERROR: Upgrade failed so I think I need to make the mariadb running first, I use above 7 to make server running and then do upgrade, I got the following errors: [user1@dev2 mariadb-10.0.15-linux-x86_64]$ sudo ./bin/mysql_upgrade [sudo] password for user1: Phase 1/5: Checking mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine status : Operation failed mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats Error : Table 'mysql.innodb_index_stats' doesn't exist in engine status : Operation failed mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist in engine status : Operation failed mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Repairing tables mysql.gtid_slave_pos Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine status : Operation failed mysql.innodb_index_stats Error : Table 'mysql.innodb_index_stats' doesn't exist in engine status : Operation failed mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist in engine status : Operation failed Phase 2/5: Running 'mysql_fix_privilege_tables'... ERROR 1932 (42S02) at line 580: Table 'mysql.innodb_index_stats' doesn't exist in engine ERROR 1932 (42S02) at line 583: Table 'mysql.innodb_table_stats' doesn't exist in engine FATAL ERROR: Upgrade failed why I cannot run mariadb with the my.cnf which comes with this version of mariadb? The old my.cnf doesn't have innoDB section and I cannot enable it. Is this the reason? does the Fedora 20 support mariadb 10.0.15? Thanks, Peter

3 4

[Maria-discuss] New Question: other connectors
by AskMonty KB 24 Feb '15

24 Feb '15

Hello, A new question has been asked in "Client Libraries" by ferreirah. Please answer it at http://mariadb.com/kb/en/other-connectors/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Any plans for connectors for the dot net framework? H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/other-connectors/

1 0

[Maria-discuss] SHOW GRANTS: MySQL vs. MariaDB
by Felipe Gasper 24 Feb '15

24 Feb '15

Hi all, We have custom logic in place that “suspends” a MySQL user by: - reversing the password hash - replacing the leading “*” with “-” In other words (pseudo-code): my $hash = SELECT password FROM mysql.user WHERE user = 'theuser'; $hash = $hash.replace(/^\*/,"").reverse(); UPDATE mysql.user SET password = "-$hash" WHERE user = 'theuser'; I have noticed that MySQL’s SHOW GRANTS reports these “suspended” password hashes with the leading dash “fixed” to a leading asterisk. MariaDB 10, though, has SHOW GRANTS report the literal contents of mysql.user. Is this behavior by design in MariaDB 10? Is it behavior that we can depend on moving forward? -FG

2 1

[Maria-discuss] Dependency questions regarding MariaDB 10 on CentOS6.5 with local mirror of repo
by Sophie L 23 Feb '15

23 Feb '15

Hi everybody, I mirrored MariaDB repo,but noticed servers had unmet dependencies when I tried to install. I have this message: Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libssl.so.1.0.0()(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libcrypto.so.1.0.0()(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.17)(64bit) Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.14)(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.17)(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.15)(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.14)(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.14)(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: aaa_base Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) My server has libstdc++ 4.4.7. Can MariaDb 10 run with this recent version? My apologies if this is not specific to MariaDB. Maybe it it. Would somebody give me some advice? Kind regards, Sophie. Some details, Linux maria1 2.6.32-431.5.1.el6.x86_64 #1 SMP Wed Feb 12 00:41:43 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux # cat /etc/centos-release CentOS release 6.5 (Final) # locate libstdc++.so.6 /usr/lib64/libstdc++.so.6 /usr/lib64/libstdc++.so.6.0.13 # locate libc.so.6 /lib64/libc.so.6 Installed Packages Name : libstdc++ Arch : x86_64 Version : 4.4.7 Release : 4.el6 Size : 964 k Repo : installed >From repo : anaconda-CentOS-201311291202.x86_64

3 4

[Maria-discuss] Mariadb galera tolerance to network and io latency
by Lyle Franklin 21 Feb '15

21 Feb '15

Recently we observed that when network and IO latency increased significantly (and correspondingly, that bandwidth reduced significantly) all nodes in a 3-node mariadb galera cluster reported the other nodes as partitioned. We understand that by default galera is configured to wait 6 seconds before declaring other nodes partitioned. Is there any additional documentation on the performance on mariadb/galera with respect to network/IO latency and bandwidth? Are there hard limits beyond which a cluster is known to fail, and soft limits which are known to degrade performance? Thanks, Rob and Lyle Cloud Foundry Core Services

1 0

[Maria-discuss] New Question: Replication with 2 different minor version
by AskMonty KB 20 Feb '15

20 Feb '15

Hello, A new question has been asked in "Standard Replication" by micimici. Please answer it at http://mariadb.com/kb/en/replication-with-2-different-minor-version/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hallo Support I have a question about replication As source... I have MariaDB 5.5.37 and destination is 5.5.41 Do you know if replication will work with those 2 different versions ? thanks for any info -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/replication-with-2-different-minor-version/

1 0

[Maria-discuss] R: Re: R: Re: R: Re: Switch from rsync to xtrabackup
by absolutely_free＠libero.it 18 Feb '15

18 Feb '15

Ok, thank you all, switch to xtrabackup-v2 accomplished :)

2 1

Re: [Maria-discuss] MariaDB 10.0.16 now available
by Nirbhay Choubey 18 Feb '15

18 Feb '15

Hi Raina, On Tue, Feb 17, 2015 at 1:04 PM, Raina Masand <rmasand(a)pivotal.io> wrote: > Hi Nirbhay, > > Now that Galera 25.3.9 is available, we have tried swapping it in with our > MariaDB 10.0.16 cluster. Seems to work so far, but wondering whether there > are plans to vet this Galera release as the officially recommended version? > I see that the currently recommended Galera version is 25.3.5, which was > released quite a while ago. Any news as to their compatibility would be > appreciated. > I have just finished running some tests on 10.0.16 with galera-25.3.9 with no failure. So, you should be good. By the way, we have not yet released galera-25.3.9 packages, planning to release them in upcoming MariaDB Galera cluster release. Best, Nirbhay > > Thanks, > > Raina and Lyle > Cloud Foundry Services Team > > On Tue, Feb 3, 2015 at 3:15 PM, Nirbhay Choubey <nirbhay(a)mariadb.com> > wrote: > >> Hi! >> >> On Tue, Feb 3, 2015 at 5:25 PM, Raina Masand < >> cf-core-services-eng(a)pivotal.io> wrote: >> >>> Hello, >>> >>> We are looking to use Galera 25.3.9 with our MariaDB cluster, which >>> claims to improve the stability of communication between nodes in the event >>> of network flakiness. Do you know if it will be compatible with MariaDB >>> 10.0.16? The release notes for MariaDB Galera Cluster 10.0.16 seem to >>> suggest that this should be safe, but it would be useful to know the >>> official recommendation. >>> >> >> MariaDB Galera 10.0.16 should be compatible with any 25.x.x galera >> versions. But, 25.3.9, in particular, has not been tested yet with MGC. >> >> Best, >> Nirbhay >> >> >>> Thanks, >>> >>> Raina and Lyle >>> Cloud Foundry Services Team >>> >>> On Wed, Jan 28, 2015 at 6:45 AM, Daniel Bartholomew <dbart(a)mariadb.com> >>> wrote: >>> >>>> On Wed, Jan 28, 2015 at 9:39 AM, Peter Laursen < >>>> peter_laursen(a)webyog.com> wrote: >>>> > YaST "Online Update" interface did not (both yesterday and two hours >>>> ago), >>>> > does not and will not identify that there is an upgrade available for >>>> > MariaDB 10.0.15, when there actually was/is. I cannot decide it this >>>> is an >>>> > issue with the RPM packaging or the repo configuration. But something >>>> is not >>>> > correct for SuSE. >>>> >>>> Ok, I'll look into it. >>>> >>>> Thanks! >>>> >>>> -- >>>> Daniel Bartholomew, MariaDB Release Manager >>>> MariaDB | http://mariadb.com >>>> >>>> _______________________________________________ >>>> 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 >>> >>> >> >

1 0

[Maria-discuss] R: Re: R: Re: Switch from rsync to xtrabackup
by absolutely_free＠libero.it 18 Feb '15

18 Feb '15

Hi Nirbhay, thank you very much for your answer. This cluster is already in production, with few databases (for mail user authentication, radius authentication, and so on). My question is: what would will happen if I change wsrep_sst_method on one node? How the other node can be "synced" if wsrep_sst_method is different (even for a few seconds)? Thank you, regards

2 1

[Maria-discuss] R: Re: Switch from rsync to xtrabackup
by absolutely_free＠libero.it 18 Feb '15

18 Feb '15

Hi, thank you for your reply. What is the correct order for this step? For example: 1) shutdown node 1 2) change config to xtrabackup-v2 on node 1 3) restart node 1? 4) shutdown node 2 5) change config to xtrabackup-v2 on node 2 6) restart node 2 ..and what about garbd on the third node? :) Thank you very much ----Messaggio originale---- Da: nirbhay(a)mariadb.com Data: 17/02/2015 14.22 A: "absolutely_free(a)libero.it"<absolutely_free(a)libero.it> Cc: "MariaDB discuss"<maria-discuss(a)lists.launchpad.net> Ogg: Re: [Maria-discuss] Switch from rsync to xtrabackup Hi! On Tue, Feb 17, 2015 at 6:07 AM, absolutely_free(a)libero.it <absolutely_free(a)libero.it> wrote: Hi, I am using two nodes (Debian 7.8 64bit) with MariaDB (mariadb-galera-server 5.5.41) and garbd on a third node. Now I'm using rsync method, I would like to switch to xtrabackup to avoid "lock" issue. Is it possible? Yes, the lock is taken only for syncing system tables. Should I simply install percona package and change this configuration? Right, the package name is "percona-xtrabackup". wsrep_sst_method=rsync to wsrep_sst_method=xtrabackup ? Or rather go for "xtrabackup-v2".https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_sst_method SST methods other than "rsync" also require "wsrep_sst_auth" variables to be set.https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsre… Best,Nirbhay Thank you very much _______________________________________________ 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

2 1

[Maria-discuss] Network tuning
by absolutely_free＠libero.it 18 Feb '15

18 Feb '15

Hi all, according to this URL: http://www.fromdual.com/huge-amount-of-time-wait-connections is it recommended to change default behavior of tcp_tw_reuse and tcp_tw_recycle? I am using two MariaDB nodes with haproxy, keepalived and garbd on third node. Thank you very much

1 0

[Maria-discuss] INNODB_BUFFER_PAGE
by Rhys Campbell 17 Feb '15

17 Feb '15

Hi All, I've been playing with the innodb buffer pool save / load feature in MariaDB 10.0.14. I initially thought it wasn't working but I've since identified the cause of my confusion The buffer pool was being populated with the correct number of pages but no table/index name values were given in information_schema. INNODB_BUFFER_PAGE. These details are populated as soon as the database has been access. Steps to repeat. 1. Ensure buffer pool save/load is on. 2. Record the SPACE & PAGE_NUMBER details of a page in information_schema.INNODB_BUFFER_PAGE for one of your databases. 3. Stop MariaDB. 4. Start MariaDB 5. Allow time for buffer pool to load... 6. SELECT * FROM information_schema.INNODB_BUFFER_PAGE WHERE SPACE = 157 AND PAGE_NUMBER = 99212; <- NULL values for TABLE_NAME / INDEX_NAME 7. Execute USE <db_name> # Where db_name is the database containing the above page. 8. Repeat above select and TABLE_NAME and INDEX_NAME will be populated correctly. Now, on a busy database this wouldn't be an issue but it did throw me for a while on my dev box. I have found a MySQL bug report... http://lists.mysql.com/announce/847 "When running a query on INFORMATION_SCHEMA.INNODB_BUFFER_PAGE that requested table_name and index_name values, query results would include index pages without table_name or index_name values. (Bug #14529666)" But the bug has been deleted so I can't check the full details to see if this is resolved or still an issue. As an aside the logging for the buffer pool loading feature appears to use a different datetime format... 150217 18:03:37 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 103721589973 2015-02-17 18:03:37 7f53285f8700 InnoDB: Loading buffer pool(s) from /log/file/path/... Rhys Campbell Database Administrator TradingScreen, Inc. 23 York House, 5th Floor London WC2B 6UJ Email: rhys.james.campbell(a)googlemail.com<mailto:rhys.james.campbell@googlemail.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] Switch from rsync to xtrabackup
by absolutely_free＠libero.it 17 Feb '15

17 Feb '15

Hi, I am using two nodes (Debian 7.8 64bit) with MariaDB (mariadb-galera-server 5.5.41) and garbd on a third node. Now I'm using rsync method, I would like to switch to xtrabackup to avoid "lock" issue. Is it possible? Should I simply install percona package and change this configuration? wsrep_sst_method=rsync to wsrep_sst_method=xtrabackup ? Thank you very much

2 1

Re: [Maria-discuss] MariaDB 10 multisource replication from AWS MySQL 5.6 RDS and Percona Server 5.6
by Reindl Harald 16 Feb '15

16 Feb '15

Am 16.02.2015 um 22:53 schrieb Vadim Pestovnikov: > Thank you Reindl. > > So basically what that means is that mariadb is not 100% compatable with > percona and mysql? define 100% - replication is a *binary log* if it would be identical in every aspect it would exist only one product and even if all docs pretend 100% compatibility i would never come to the idea even run different minor versions in a replication setup just follow these instructions leads to the conclusion mix different products is a bad idea: http://dev.mysql.com/doc/refman/5.0/en/replication-upgrade.html P.S.: i don't appreciate off-list replies > On Feb 16, 2015 1:23 PM, "Reindl Harald" <h.reindl(a)thelounge.net > <mailto:h.reindl@thelounge.net>> wrote: > > > > Am 16.02.2015 um 22:19 schrieb Vadim Pestovnikov: > > Error in Log_event::read_log_event(): 'Found invalid event in binary > log', data_len: 44, event_type: 33 > > Error reading relay log event: slave SQL thread aborted because > of I/O error > > My slave is MariaDB 10 with data and logs partitions encrypted > by LUKS > and with SSL enabled. As far as RDS and Percona servers don't > use SSL I > am using non SSL user for the replication. > > Any recommendations or suggestions would be extremely appreciated > > > don't mix different server versions in replication setups > > there is a good reason why it is recommended always to update first > the slaves, run "mysql_upgrade" and then the masters to be 100% sure > that the maste rnever don't write anything into the binlog the slave > won't understand because differences in details

2 1

[Maria-discuss] MariaDB 10 multisource replication from AWS MySQL 5.6 RDS and Percona Server 5.6
by Vadim Pestovnikov 16 Feb '15

16 Feb '15

Hi all, I am trying to setup the multisource replication from AWS MySQL 5.6 RDS to MariaDB 10 using multisource replication. The installation was successful I can see from show slave 'connection' status\G that binary logs and their positions are changing, but If I add a new data on a master it is not replicated to the slave. Also tried to replicate from Percona Server 5.6 to MariaDB 10 using the multisource replication, but got errors like: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 44, event_type: 33 Error reading relay log event: slave SQL thread aborted because of I/O error My slave is MariaDB 10 with data and logs partitions encrypted by LUKS and with SSL enabled. As far as RDS and Percona servers don't use SSL I am using non SSL user for the replication. Any recommendations or suggestions would be extremely appreciated. -- Vadim

2 1

[Maria-discuss] New Question: reading dbase records marked for deletion
by AskMonty KB 16 Feb '15

16 Feb '15

Hello, A new question has been asked in "Data Manipulation" by williamblocher. Please answer it at http://mariadb.com/kb/en/reading-dbase-records-marked-for-deletion/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Can you tell me if dbase records marked for deletion are treated as orinary records or ignored? Thank You Bill Blocher -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/reading-dbase-records-marked-for-deletion/

1 0

[Maria-discuss] New Question: Maria 10.0.15 high CPU/disk usage without queries
by AskMonty KB 16 Feb '15

16 Feb '15

Hello, A new question has been asked in "MariaDB Community" by artemkuchin. Please answer it at http://mariadb.com/kb/en/maria-10015-high-cpudisk-usage-without-queries/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I just migrated the server from mysql 5.5 to mariadb 10.0.15 It is a web hosting server with about 100 sites on different platforms. So, there are about 100 databases. Most tables myisam, some innodb (mostly joomla 3) Before with mysql CPU load was less than 10%, disk uses by mysqld was also not very high. No, with top and top -mio i see pretty high numbers. mysqld takes from 20 to 30% cpu and 80-100% disk About configuration. It is xeon 4 cores+HT (8 cores seen by OS) with 32GB ram, 2 3TB SATA disks in software mirror. os is FreeBSD 10.1 stable I tried using thread of pools, one thread per connection - all the same The weird think what i show processlist i ass about 20 haning connection without any question. This is is normal, some sites leave connections for a while (mod_perl, php) the weirdness is that thare no queies while 20-30% load of CPU. What is mariddb doing? my.cnf [mysqld] #thread-handling= one-thread-per-connection thread_handling=pool-of-threads thread_pool_size=4 thread_cache_size = 45 init-connect='SET NAMES cp1251' default-storage-engine = MyISAM port= 3306 socket= /hoster/tmp/mysql.sock skip-external-locking skip-networking slow_query_log=1 slow_query_log_file=/hosts/MYSQLDB/slow.log # GLOBAL max_connections=800 max_allowed_packet = 50M key_buffer_size = 512M table_open_cache = 32768 query_cache_size = 256M query_cache_limit = 32M # PER THREAD read_buffer_size = 2M # PER REQUEST sort_buffer_size = 32M read_rnd_buffer_size = 1M myisam_sort_buffer_size = 128M join_buffer_size=2M server-id = 1 innodb_data_home_dir = /hosts/MYSQLDB innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend innodb_log_group_home_dir = /hosts/MYSQLDB innodb_buffer_pool_size = 384M innodb_log_file_size = 100M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 3 innodb_lock_wait_timeout = 50 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-10015-high-cpudisk-usage-without-queries/

1 0

Re: [Maria-discuss] Idea of monitoring tool of Mariadb
by Seung Hoon Yoo 12 Feb '15

12 Feb '15

Thanks reply Lefranc. I think 2 git monitoring solution u mention that would be using SQL execute and caching i think ( i guess, my short program knowledge) MY idea is not "SQL access" , but " GATHER info IN Memory Structure on mysqld proces" example select * from performance_schem => cache => GUI/HTTP ( SQL Method) => i think bad pfs structure (sql_parse.cc, pfs.cc) => memcopy... ( => I WANT METHOD) => i think good. 2 soultion u mentioned is use Direct Access Memory or SQL execute ?? Thanks!! and sorry My short English grammer. 2015-02-12 20:48 GMT+09:00 Guillaume Lefranc <guillaume(a)adishatz.net>: > Hello Seung Hoon Yoo, > > there are already some (experimental) tools which do that: > > https://github.com/svaroqui/http_monitor is a plugin for MariaDB 10 which > collects information based on information and performance schema > https://github.com/sjmudd/pstop is a performance monitor top-like you can > run as a command line UI > > Best regards, > > > 2015-02-12 12:36 GMT+01:00 Seung Hoon Yoo <sehyoo96(a)gmail.com>: > >> Hello, >> >> i think about monitoring gui tool ( sure, monyog Nagius support mariadb) >> Mysql Enterprise Monitor is cool, but commercial ver and that is oracle >> haha >> >> Anyway my idea first Performance schema info, >> that is store info in memory structure in source, >> so if during every 1 sec memcopy from performance schema to user-define >> structure >> and that information transfer out of mariadb by udp port etc.. >> >> So, until world in mysql / maria, their tool using proxy method or sql >> script >> thas will be some performance issue happen. >> >> so Direct Mariadb memory Access Method is useful.. >> >> >> So.. mariadb.com has any plan GUI Monitoring tool? >> and how about my idea about gathering performance schema ( + >> information_schema etc) >> info in mysqld thread info( memory structure) ?? >> >> >> Thanks for reading! >> >> p.s i am not used to english. ;) >> >> LG CNS post architecture Team >> >> _______________________________________________ >> 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 >> >> >

2 1

[Maria-discuss] Idea of monitoring tool of Mariadb
by Seung Hoon Yoo 12 Feb '15

12 Feb '15

Hello, i think about monitoring gui tool ( sure, monyog Nagius support mariadb) Mysql Enterprise Monitor is cool, but commercial ver and that is oracle haha Anyway my idea first Performance schema info, that is store info in memory structure in source, so if during every 1 sec memcopy from performance schema to user-define structure and that information transfer out of mariadb by udp port etc.. So, until world in mysql / maria, their tool using proxy method or sql script thas will be some performance issue happen. so Direct Mariadb memory Access Method is useful.. So.. mariadb.com has any plan GUI Monitoring tool? and how about my idea about gathering performance schema ( + information_schema etc) info in mysqld thread info( memory structure) ?? Thanks for reading! p.s i am not used to english. ;) LG CNS post architecture Team

1 0

[Maria-discuss] New Question: Migrating MySQL 5.5 Windows to MariaDB 10.x on new Windows server
by AskMonty KB 11 Feb '15

11 Feb '15

Hello, A new question has been asked in "Moving to MariaDB" by davidgonsalves. Please answer it at http://mariadb.com/kb/en/migrating-mysql-55-windows-to-mariadb-10x-on-new-w… as the person asking the question may not be subscribed to the mailing list. -------------------------------- My company is contemplating moving from MySQL 5.5 to MariaDB 10.x. We don't want to do an in place upgrade because the existing server is an older machine running Win 2003 x64. We have a new server that we're going to build out (don't know complete specs yet), and would like to know how we can best migrate the existing MySQL instance to a new instance of MariaDB on the new server. Is it as simple as doing a mysqldump from the existing server and piping it into the new? I've read how to do it here: http://dba.stackexchange.com/questions/174/how-can-i-move-a-database-from-o… are these answers adequate? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/migrating-mysql-55-windows-to-mariadb-10x-on-new-w…

1 0

[Maria-discuss] New Question: XtraDB + query_cache_size MariaDB 10
by AskMonty KB 11 Feb '15

11 Feb '15

Hello, A new question has been asked in "MariaDB Community" by chrismatthews. Please answer it at http://mariadb.com/kb/en/xtradb-query_cache_size-mariadb-10/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I have read that if your using MySQL InnoDB then you should not use query_cache_size. Does this also apply to MariaDB 10 with XtraDB ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/xtradb-query_cache_size-mariadb-10/

1 0

[Maria-discuss] New Question: Warning: mysqli::mysqli(): Headers and client library minor version mismatch.
by AskMonty KB 11 Feb '15

11 Feb '15

Hello, A new question has been asked in "MariaDB FAQ" by ariez_ahito_g. Please answer it at http://mariadb.com/kb/en/warning-mysqlimysqli-headers-and-client-library-mi… as the person asking the question may not be subscribed to the mailing list. -------------------------------- i am having error with phpipam installation in my centos box.. i got this error Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50173 Library:50312 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/warning-mysqlimysqli-headers-and-client-library-mi…

3 2

[Maria-discuss] New Question: Get the error log of Mariadb
by AskMonty KB 09 Feb '15

09 Feb '15

Hello, A new question has been asked in "MariaDB Community" by nunocarapito. Please answer it at http://mariadb.com/kb/en/get-the-error-log-of-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi there. First of all sorry if I shouldn't be asking this. I have a big database with MariaDB running on CentOS 7, and recently it has been crashing about a time a day. I'm affraid to try anything and crush all database, making it offline for some time. I can't see what is the problem of it, because I cant find the error log of it. How can I enable it or start it? Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/get-the-error-log-of-mariadb/

1 0