- discuss - lists.mariadb.org

[Maria-discuss] doubt how to create big query
by Roberto Spadim 10 Feb '16

10 Feb '16

hi guys i'm with a problem / possible feature request i have many tables with same structure (same fields) and i need to create a big query with all tables something like: select * from t1 union all select * from t2 union all select * from ..... ... union all select * from t99999 is there anyway to create a big query with some "template c++ like" feature? something like select * from <union all t1, t2, t3, t3, t4....> ? --- Roberto Spadim

2 4

[Maria-discuss] MariaDB/Galera Cluster with 3 nodes - Change ENGINE from MyISAM to InnoDB without crash
by Lukas Lehner 09 Feb '16

09 Feb '16

Hi http://dba.stackexchange.com/questions/128715/mariadb-galera-cluster-with-3… thanks Lukas

2 1

[Maria-discuss] New Question: How to change Innodb fileformat to Barracuda
by AskMonty KB 07 Feb '16

07 Feb '16

Hello, A new question has been asked in "XtraDB and InnoDB" by gijs. Please answer it at http://mariadb.com/kb/en/how-to-change-innodb-fileformat-to-barracuda/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I've attempted to change to the new barracuda file format. I'm using a Galera cluster (MariaDB 10.1.11) and have innodb_file_format=Barracuda set on all my servers, I've rebooted the servers and exported a database with phpmyadmin. After this I deleted the database and recreated it and then imported the previously exported .sql file with phpmyadmin. I checked the file format in INFORMATION_SCHEMA.INNODB_SYS_TABLES and found that it's still set as Antelope. Why is it not set to Barracuda? How can I change it to Barracuda? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-change-innodb-fileformat-to-barracuda/

1 0

[Maria-discuss] MariaDB JIRA is moving
by Rasmus Johansson 05 Feb '16

05 Feb '16

The MariaDB JIRA instance that currently is in use for project and issue tracking will change. The current instance is hosted in Atlassian's cloud and it has worked well, but we have hit the maximum user limit of 2000 users. It's fantastic to see how many of you actually report bugs and other issues in the MariaDB project! To hit that limit also means that we have to migrate over to a self-hosted instance of JIRA. Below are important details about that change. When will the switch happen: Sat 27th of Feb What is the impact for me as a user of MariaDB's JIRA: 1. URL change - The current instance is hosted in Atalassian's cloud and has the URL mariadb.atlassian.net. The new one will be found at jira.mariadb.org starting from 28th of Feb. 2. RSS feeds - If you have been using JIRA's RSS feeds, you'll need to set up them again since the URL is changing What will happen to old JIRA: The mariadb.atlassian.net JIRA instance will be put into read-only mode and a banner will be visible on each page telling the URL of the new MariaDB JIRA instance. It will remain this way for some time since it has been referenced quite heavily from other sites. source: https://mariadb.org/mariadb-jira-is-moving/ -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

1 0

[Maria-discuss] intentionally corrupting tables
by Federico Razzoli 02 Feb '16

02 Feb '16

Hi all I am looking for a way to intentionally corrupt a table in a "natural" way. Of course I can open a file with Vim and change random characters, but I would probably obtain a kind of corruption that never occurs in the real world. The purpose is testing recovery procedures. Thanks Federico

3 2

[Maria-discuss] Adding timestamp column to a system
by Peter Mclarty 02 Feb '16

02 Feb '16

Hi All Running Mariadb 10.0.16 and need to add a timestamp column to a table with has around 60m rows Testing on lesser hardware instances suggest around 40 minutes to make this change on the production system. To reduce the down time I was planning to alter the slave and role swap the slave to become the master I have added the column to a test slave and notice it alway populates as Unix_epoch 0 ie no current timestamp date | timestamp 2016-01-29 | 0000-00-00 00:00:00 This sounds about right, but to confirm it's not a bug. Other than the timestamp value not being correct up to that time of making any changes, which is acceptable for why it is being added, like the role swap, is there any things to be concerned about if I follow that as an approach? The role swap was needing to be done soon anyway so that in itself isn't a stumpling block I know Percona has their tools that allow online schema changes, I have never used it in anger to achieve this sort of change. Would I be better off using that. Cheers -- *Peter McLarty* * DBA* -- Compare The Market is a brand and trading name of Compare The Market (Pty) Ltd (CTM). This email is for the intended addressee and is confidential and subject to copyright. If you are not the intended addressee, confidentiality has not been waived and any use, interference with, or disclosure of this email is unauthorised. If you are not the intended addressee please immediately notify CTM and then delete the email. CTM does not warrant that this email is error or virus free.

2 1

[Maria-discuss] New Question: Phenomenon of read-only queries performance
by AskMonty KB 02 Feb '16

02 Feb '16

Hello, A new question has been asked in "MariaDB Community" by knizhnik_g. Please answer it at http://mariadb.com/kb/en/phenomenon-of-read-only-queries-performance/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are evaluating Galera cluster with MariaDB and find out interesting phenomenon which we can not explain. We are using standard sysbench compex-OLAP, 10 million records. Performance of read-only queries is about 3k TPS and is quite stable. But then we run for a while read-write version and after it once again read-only version, then in this case performance starts to grow from 4k till 10k TPS. 10K TPS is reached after about 30 seconds of running benchmark and stays at this level. But if we stop benchmark and restart it, then once again speed falls down to 3k TPS. Data is located in temporary file system, so disk is not involved at all. We used recommended configuration settings for MariaDB and Galera. Also the same behavior is observed with standalone mysql without Galera: performance of read-only queries varies from 3k to 6k TPS (but high values are smaller than with Galera, although no load balancing was performed). Is there any explanation of such behavior and where we can look trying to understand the reason? Why performance of standalone mysql can be slower than on Galera cluster? How we can tune it? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/phenomenon-of-read-only-queries-performance/

1 0

[Maria-discuss] Performace issue with insert
by walter harms 01 Feb '16

01 Feb '16

Hello list, i have a strange problem with inserts. The tables is large (time series data) and has a lot of partitions, engine is IMMODB. We have notice that the write performance decreases with time, start of the month good, end of the month bad. The same behavier is the lasted version of mariadb. But when i replace mariadb with mysql the problems vanishes (so its not a hardware issue). I suspect that it is a caching problem but a comparison of the configs did not give a hint. Anyone an idea what may cause the effect ? re, wh

8 16

[Maria-discuss] MariaDB 10.1.11 now available
by Daniel Bartholomew 30 Jan '16

30 Jan '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.11. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.11 - Release Notes: https://mariadb.com/kb/en/mdb-10111-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10111-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.11 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/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

2 1

[Maria-discuss] New Question: MariaDB Power7 support
by AskMonty KB 29 Jan '16

29 Jan '16

Hello, A new question has been asked in "Getting Started" by dtomko_34748. Please answer it at http://mariadb.com/kb/en/mariadb-power7-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello MariaDB, searching through site I didn't find following information: do you support IBM Power 7 systems for MariaDB/MariaDB Enterprise, not just Power8? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-power7-support/

1 0