July 2013 - discuss - lists.mariadb.org

[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

[Maria-discuss] 5.5 versus 10.0/5.6 performance issues
by Puff, Werner 03 Jul '13

03 Jul '13

Because of performance issues with our DBMS we recently decided to migrate our software to MySQL or one of its forks. We would prefer MariaDB. We created a performance test suite so that we are sure to make the right decision. Beside other values our test measured the average workflow processing time including multiple database transactions. The unexpected outcome was, that we had a big difference in the processing times between 5.5 and 5.6 based databases. average-time [ms] (lower = better) MySQL 5.6 233 Percona 5.6pre 208 MariaDB 10alpha 194 MariaDB 5.5 1248 MySQL 5.5 993 (Firebird 2.5 9694) We are bound to very special hardware, the biggest bottleneck there is USB-stick based storage (cannot be changed for now). Our interpretation of the results and the research we were doing so far is, that the changes within InnoDB/XtraDB storage engine in connection with our "very special" storage solution causes this differences. Can anybody confirm that the changes had a high impact on storage mediums with slow access rates? Or does anybody have an idea if it possible to optimize MariaDB 5.5 (we would like to go with MariaDB) to get the same performance with MySQL 5.6?

3 4