- discuss - lists.mariadb.org

[Maria-discuss] New Question: MarinaDB and RHEL6.4 on PowerLinux
by AskMonty KB 25 Jul '13

25 Jul '13

Hello, A new question has been asked in "MariaDB community" by jinkoo: -------------------------------- Dear all. I am testing the mariaDB 5.5 on RHEL 6.4 on PowerLinux. When I compile, I met following error message. how to solve this problem? --> snip <-- Linking CXX executable explain_filename-t /usr/bin/ld: ../../storage/csv/libcsv.a(ha_tina.cc.o)(.text+0x2940): sibling call optimization to `String::append(char)' does not allow automatic multiple TOCs; recompile with -mminimal-toc or -fno-optimize-sibling-calls, or make `String::append(char)' extern /usr/bin/ld: ../../storage/csv/libcsv.a(ha_tina.cc.o)(.text+0x2954): sibling call optimization to `String::append(char)' does not allow automatic multiple TOCs; recompile with -mminimal-toc or -fno-optimize-sibling-calls, or make `String::append(char)' extern /usr/bin/ld: final link failed: Bad value collect2: ld returned 1 exit status make[2]: *** [unittest/mysys/explain_filename-t] Error 1 make[1]: *** [unittest/mysys/CMakeFiles/explain_filename-t.dir/all] Error 2 make: *** [all] Error 2 --> end <-- and MariaDB has any plan to support for POWER system? Thanks, -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/marinadb-and-rhel64-on-powerlinux/

1 0

[Maria-discuss] New Question: Multi-threading and Statement.cancel()
by AskMonty KB 19 Jul '13

19 Jul '13

Hello, A new question has been asked in "MariaDB Java Client" by rstepanski: -------------------------------- Attempting to execute queries on multiple threads (10 to 20) with the ability to cancel each Thread's unique Statement mid execution from a separate thread. However, when sharing a single Connection among all threads for their Statement creation, a cancel() on one Statement will cause other thread's executeQuery() to throw a "Query execution was interrupted". Switching to per thread Connections and a thread pool, the cancel() will sometimes fail with "Unknown thread id: xx". I'm assuming this occurs when a thread previously used to work with another connection attempts to cancel() another. This had worked previously with MySql jdbc (and still does with MySql jdbc + MariaDb server). The queries themselves are single table, limited/offset, selects. Where clauses would generally be related: query 1: like 'a%' query 2: like 'ab%' query 3: like 'abc%' With each previous query being cancelled when a more specific query was available. Any comments/suggestions appreciated. Thanks! -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/multi-threading-and-statementcancel/

1 0

[Maria-discuss] upgrading from mariadb 5.5.31 to mariadb 5.5.32 with innodb engine
by Gabriel Sosa 18 Jul '13

18 Jul '13

Hello! few days ago we realized we got cached by the bug MDEV-4754 [1] . Today mariadb 5.5.32 has been released but among the notable Information the mysql bug #69623 [2] is mentioned in case you have the table using the Innodb engine. per our information: | innodb_data_file_path | ibdata1:100M:autoextend | | innodb_data_home_dir | /var/lib/mysql/innodb | | innodb_file_per_table | ON | | innodb_version | 5.5.31-MariaDB-30.2 | I think we fit exactly in that scenario but I need some help to confirm this and be sure can *upgrade* without issues or that we should wait for another release that fix this. Any clue? Thanks! [1] https://mariadb.atlassian.net/browse/MDEV-4754 [2] http://bugs.mysql.com/bug.php?id=69623 -- Gabriel Sosa Sometimes the questions are complicated and the answers are simple. -- Dr. Seuss

4 9

[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