- discuss - lists.mariadb.org

[Maria-discuss] MariaDB 5.5.32 now available
by Daniel Bartholomew 18 Jul '13

18 Jul '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.32. This is a bug-fix release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.32 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5532-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5532-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.32 Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - 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 (my.ini on Windows) file! See http://kb.askmonty.org/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 MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] New FRM Format
by Roberto Spadim 17 Jul '13

17 Jul '13

Hi guys, could we add a new FRM file format? a more human readable, maybe JSON or YAML format, internally we could still using today unireg format check this example using JSON: { 'header':{ 'frm_version' :'JSON 1.0', 'server' : 'mysql/mariadb/drizzle/percona/other...', 'server_version' : '1234.1234.1234', 'engine' :'MyISAM', 'io_size' :0, ??? 'key_length' :0, ??? 'rec_length' :0, ??? 'table_options' :'', ??? (maybe put in engine part?) 'table_default_charset':'latin1', 'partition_default_engine':'MyISAM', }, 'rows':{ 'max_rows' :0, 'min_rows' :0, 'avg_row_length':0, 'type' :'PAGE/FIXED/COMPACT/blablalba', 'table_comments':'', 'intervals' :{ '0':['a','b','c'], '1':['enums','and','sets'] }, }, 'fields':[ { 'name' :'', 'type' :'', 'scale' :'', 'flags' :['zerofill','unsigned','not null'], 'default':0, 'charset':'', 'comment':''}, ... ], 'keys':{ 'primary key':{ 'type' :'unique/index/fulltext', 'fields' :[ 0,1,2,3,4, {'field'=>5,'order'=>'asc','left':5}, ... ], 'algorithm':'hash/btree/rtree' }, 'other key': ... }, 'partitions':{ 'p1' : { 'p1 informations' } }, 'myisam': {'some especific information'}, 'aria': {'some especific information'}, 'innodb': {'some especific information'}, 'ndb': {'some especific information'}, 'view':{ 'SQL':"select xyz from a,b", 'algorithm':'temporary, etc...' ... }, 'other_information that mariadb/mysql don't use but it's nice to document': {'hi i can put some information here!'} }

3 3

[Maria-discuss] New Question: A Few Questions About MariaDB
by AskMonty KB 16 Jul '13

16 Jul '13

Hello, A new question has been asked in "General FAQ" by edutrac: -------------------------------- I am starting a new SaaS project, and I am looking at installing MariaDB 10.x for some testing. Below are a few questions I have. 1. Most of the time in MySQL, I would use the InnoDB storage engine in which I used constraints and foreign keys. Is this feature present in XtraDB and/or Aria db engines? 2. If the feature is present in both of them, can you point me in the right direction to see a compare and contrast of the Aria and XtraDB storage engines? 3. Does MariaDB recognize the mysqli function or only the mysql function? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/a-few-questions-about-mariadb/

2 1

[Maria-discuss] deferrable constraints syntax?
by Joeri Leemans 16 Jul '13

16 Jul '13

Hi all, I'm trying to create a deferrable foreign key constraint, according to the knowledge base article at https://kb.askmonty.org/en/constraint_type-foreign-key-constraint/. The syntax of "deferrable initially deferred" doesn't seem to be recognised. Without it, the tables are created just fine. I'm using MariaDB 5.5.31. Example: create table one ( id int primary key ); create table two ( id int primary key, one_ref int, constraint fk foreign key(one_ref) references one(id) deferrable initially deferred ); => error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'deferrable initially deferred )' at line 4 Any idea what's wrong? Is this only supported in MariaDB 10.x? Thanks! Best regards Joeri Leemans

2 1

[Maria-discuss] New Question: Which datatypes are supported by MariaDB
by AskMonty KB 16 Jul '13

16 Jul '13

Hello, A new question has been asked in "Getting Started" by giordano: -------------------------------- I would like to know which datatypes are supported by MariaDB. I'm asking since I'm little confused. For example, the knowledge base contains a chapter temporal datatypes: https://kb.askmonty.org/en/temporal-data-types/ where the the datatype timestamp is defined: "it defines a set of correctly formed values that represent any valid Gregorian calendar date between '0001-01-01' and '9999-12-31'" If I look at the MySQL-site http://dev.mysql.com/doc/refman/5.1/de/datetime.html The definition for timestamp is: "The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC." These are different definitions.I know that the datatype defintions in the knowledge base contains the syntax of SQL-99. What makes me insecure is which definition has priority. Also I do not know if all datatypes in Oracle-MySQL are supported by MariaDB. For example, tinyint, bigint. (Sincerly, I know that MariaDB understand these datatypes, but I wonder if they have the same definition as given by the Oracle-MySQL-site.) Thanks for help -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/which-datatypes-are-supported-by-mariadb/

1 0

[Maria-discuss] New Question: Issue in edit on MariaDB 10
by AskMonty KB 16 Jul '13

16 Jul '13

Hello, A new question has been asked in "Storage Engines" by cirovargas: -------------------------------- I have a problem when editing rows in the database, MariaDB consumes all memory and cpu. On my local computer it does not happen using mysql5.5 http://pastebin.com/k6YTpCUd http://oi42.tinypic.com/w33lt.jpg -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/issue-in-edit-on-mariadb-10/

1 0

[Maria-discuss] New Question: Does MariaDB support multiple data directories within a single instance?
by AskMonty KB 16 Jul '13

16 Jul '13

Hello, A new question has been asked in "Does MariaDB support..." by joshuavalencia: -------------------------------- MySQL 5.6 lets you define separate data directories for individual tables. This is useful if you want to put large tables on a separate storage backend - e.g. frequently used tables go on local disk, and some larger tables go on ISCSI. Does MariaDB support having multiple data directies within a single running instance? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/does-mariadb-support-multiple-data-directories-wi…

1 0

[Maria-discuss] New Question: page_checksum performance implications
by AskMonty KB 11 Jul '13

11 Jul '13

Hello, A new question has been asked in "Aria" by Vasilis: -------------------------------- Does enabling page_checksum for the Aria engine involve significant drops in performance when compared to a disabled page_checksum(ed) table? Are there any benchmarks on this one? At the end, should I enable it or not? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/page_checksum-performance-implications/

1 0

[Maria-discuss] New Question: Creating a System DSN for MariaDB on Windows
by AskMonty KB 09 Jul '13

09 Jul '13

Hello, A new question has been asked in "A MariaDB Primer" by marcw: -------------------------------- Hi, I'd like to use MariaDB to back-end a system that expects an ODBC interface. Is there a way to create a system DSN for MariaDB in Windows 7? It's not showing up as a connection type in the Data Sources panel. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/creating-a-system-dsn-for-mariadb-on-windows/

2 1

[Maria-discuss] New Question: Amazon RDS or AWS services
by AskMonty KB 08 Jul '13

08 Jul '13

Hello, A new question has been asked in "MariaDB community" by openiduser28: -------------------------------- I'm interested in trying out MariaDB, and was wondering if anyone has MariaDB running with Amazon RDS or is it only possible using some sort of VM? I can try it out that way, but being on the free tier sure limits things. Thanks! -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/amazon-rds-or-aws-services/

1 0