- discuss - lists.mariadb.org

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

03 Jun '15

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

1 0

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

01 Jun '15

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

2 1

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

23 May '15

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

2 1

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

23 May '15

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

2 1

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

21 May '15

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

2 2

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

20 May '15

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

1 0

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

18 May '15

Note the progress output below. I've seen several like this. i.e... Stage: 1 of 72 'altering table' 350% of stage done. Is this intentional? [cid:image001.png@01D07B7A.526BD6D0] Rhys Campbell Database Administrator TradingScreen, Inc. 23 York House, 5th Floor London WC2B 6UJ Email: rhys.campbell(a)tradingscreen.com<mailto:rhys.campbell@tradingscreen.com> Follow TradingScreen on Twitter<http://twitter.com/#!/TradingScreen> , Facebook<http://www.facebook.com/pages/TradingScreen/214046251945650> and our blog Trading Smarter<tradingsmarter.tradingscreen.com> This message is intended only for the recipient(s) named above and may contain confidential information. If you are not an intended recipient, you should not review, distribute or copy this message. Please notify the sender immediately by e-mail if you have received this message in error and delete it from your system.

5 5

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

18 May '15

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.43 and 10.0.19. These are Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.19 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10019-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10019-changelog/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.19/ MariaDB Galera Cluster 5.5.43 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5543-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5543-changelog/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.43/ About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] query cache dump_at_shutdown/load_at_startup useful + no character set/collation?
by Daniel Black 17 May '15

17 May '15

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

2 2

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

15 May '15

Hi All, Does anyone know if the performance_schema guarantees that every statement executed will appear in the events_statement_summary_by_digest table (excluding those that could be pushed out due to size restrictions). Or is it a "best effort" system? If it's a best effort system what are the circumstances in which a query may not make it to the performance schema? Rhys Campbell Database Administrator TradingScreen, Inc. 23 York House, 5th Floor London WC2B 6UJ Email: rhys.campbell(a)tradingscreen.com<mailto:rhys.campbell@tradingscreen.com> Follow TradingScreen on Twitter<http://twitter.com/#!/TradingScreen> , Facebook<http://www.facebook.com/pages/TradingScreen/214046251945650> and our blog Trading Smarter<tradingsmarter.tradingscreen.com> This message is intended only for the recipient(s) named above and may contain confidential information. If you are not an intended recipient, you should not review, distribute or copy this message. Please notify the sender immediately by e-mail if you have received this message in error and delete it from your system.

2 1