- discuss - lists.mariadb.org

[Maria-discuss] New Question: Hibernate Reverse Engineering wizard with MariaDB
by AskMonty KB 22 Aug '13

22 Aug '13

Hello, A new question has been asked in "MariaDB Documentation" by JohnD: -------------------------------- (Sorry, couldn't find a good place for this query - perhaps there ought to be a folder "MariaDB and ORMs"?) I'm trying to use the Hibernate Reverse Engineering wizard with MariaDB. It's just a very simple example, but I am stuck. I don't see any errors, but it doesn't work as described. Here's what I've got so far: * Windows 7 x64, Eclipse Juno, MariaDB v5.5.3, Hibernate v4.2.3 * I've got an example with Hibernate running using annotations and the same instance of MariaDB, no problem * Now I want to create the classes from the tables, so I'm trying to use the reverse engineering wizard. * I've set up a simple DB and a couple of tables * I've set up a hibernate.cfg.xml file using the same values as my working annotation example * Now I use the wizard (in Eclipse) to "New/Hibernate Reverse Engineering File (reveng.xml)" ** First page ok, second page "Configure Table filters" is where I'm stuck ** I select the correct Console configuration (generated as part of creating the config file) and then press the "Refresh" button ** At this point I should see my two tables in the "Database schema:" column. But it's empty. ** I briefly see "Pending..." - then nothing. ** I can't see any errors. So, how to move forwards? Can I turn on some logging? Where is the error? What logs to check? The Eclipse console window shows a bunch of stuff, all info, no errors and the last three lines are like this: * 2013-08-22 11:34:38,189 DEBUG Worker-33 org.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection * 2013-08-22 11:34:38,198 DEBUG Worker-33 org.hibernate.connection.DriverManagerConnectionProvider - created connection to: jdbc:mysql://localhost:3306/omthibernate, Isolation Level: 4 * 2013-08-22 11:34:38,199 INFO Worker-33 org.hibernate.connection.DriverManagerConnectionProvider - cleaning up connection pool: jdbc:mysql://localhost:3306/omthibernate In case it helps, here is the hibernate config (I've tried a lot of variations): {{{ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory name="xxx"> <property name="hibernate.connection.driver_class">org.mariadb.jdbc.Driver</property> <property name="hibernate.connection.password">password</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/omthibernate</property> <property name="hibernate.connection.username">user</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> </session-factory> </hibernate-configuration> }}} -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/hibernate-reverse-engineering-wizard-with-mariadb/

1 0

[Maria-discuss] More secure Kill command
by Roberto Spadim 21 Aug '13

21 Aug '13

hi guys, i hit a problem in this exact second... some programs are running and i want to kill only one big query well i executed kill 17143 ok.. but when i execute this command, the query was done, and starting a second query... in other words... i killed the wrong query could we add a hash information to kill, to make it more secure and precise? for example... kill 17143 md5 "123456789......." where md5 = id + start time of query + others informations to make it relative unique maybe it exists and i don't know... any other idea how to solve this? thanks -- Roberto Spadim

5 19

[Maria-discuss] NoSQL at mysql client
by Roberto Spadim 19 Aug '13

19 Aug '13

Hi guys, i was reading some time ago about memcache (i use it for a long time ~5years or more) and the handler socket plugin Why we don't implement it at mariadb client? instead of a second library to add nosql, why not implement a built in lib? for example... (pseudo functions...) mysql_connect ... (connect to database and have permission handling...) mysql_select_db ... select the schema being used mysql_query ... execute a query command (SQL QUERIES) mysql_fetch ... get a row mysql_num_rows .. get number of rows now the nosql... mariadb_handler_socket_openindex( handler socket parameters ) mariadb_handler_socket_query mariadb_handler_socket_fetch mariadb_handler_socket_close mariadb_memcache_get mariadb_memcache_set ... this make mariadb a sql/nonsql database with a single user/permission schema, and a nice language set (SQL, handler socket, memcache, redis, drizzle, hadoop, mongodb or others...) in this case we can use the mysql protocol, but instead of sending a QUERY command, we send a "MARIADB" command, and a new parameter telling what mariadb command it is, this can be used with mysql/mariadb/percona, when used with others database probably the database will report a wrong command message but we can contact mysql to reserve a command id to "others uses", and have compatibility with any mysql fork... but the point is... instead of many connections (3-> mariadb, handler socket write, handler socket read, or 2 -> mariadb, memcached) we have only one 1-> mariadb comments are wellcome, any idea why not implement this instead of many different protocol libs? -- Roberto Spadim

2 4

Re: [Maria-discuss] doubt about aria log files
by Roberto Spadim 18 Aug '13

18 Aug '13

well just to document this thread mail list i found the answer , (thanks federico) https://kb.askmonty.org/en/aria-faq/ aria_log_file_size - *Description:* Limit for Aria transaction log size - *Commandline:* --aria-log-file-size=# - *Scope:* Global - *Dynamic:* Yes - *Data Type:* numeric - *Default Value:* 1073741824

1 0

[Maria-discuss] doubt about aria log files
by Roberto Spadim 17 Aug '13

17 Aug '13

hi guys, i have a very big aria log file how could i change it to don't get sooo big? how could i reduce it size? could i delete it? [adm@agra1 sensors]# ls -l total 383008 drwxrwxrwx 2 mysql mysql 4096 Nov 1 2012 1000_sensors drwxrwxrwx 2 mysql mysql 4096 Nov 1 2012 1000_sensors_log -rw-rw---- 1 mysql mysql 362815488 Ago 17 12:19 aria_log.00000024 -rw-rw---- 1 mysql mysql 52 Ago 17 12:17 aria_log_control -rw-rw---- 1 mysql mysql 18874368 Jun 9 2012 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Jun 9 2012 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Jun 9 2012 ib_logfile1 -rwxrwxrwx 1 mysql mysql 13 Dez 27 2010 mysql_upgrade_info -rw-rw---- 1 mysql mysql 4 Dez 8 2012 pbxt-lock ... [adm@agra1 sensors]# du -S 26328352 ./1000_sensors_log 1052 ./1000_sensors 388236 . -- Roberto Spadim

1 0

[Maria-discuss] new kind of plugin
by Roberto Spadim 17 Aug '13

17 Aug '13

Hi guys, I was thinking about a new kind of plugin, a field type plugin... i think it's a relative interesting idea... about sintax: ALTER TABLE table ADD field PLUGIN("plugin_name","version","field_type","parameters") NOT NULL/NULL DEFAULT 'something' AUTOINCREMENT, etc.. an example... ALTER TABLE table ADD field PLUGIN("crypt","1","somecrypto","size=255") NOT NULL DEFAULT 'something' internally (to storage engine) this kind of data will be saved as blob (for example), and to client side it will be a blob too when i use: insert into table(field) values ("some text"); and select * from table i will get "some text" but internally (at filesystem) the value is save as a crypto of "some text" --- other idea is compress ADD field PLUGIN("crypt","1","compress","size=255") NOT NULL DEFAULT 'something' internally it will be saved as varchar(255), when i execute insert it will compress the value and when i select it will uncompress the value the parameters for this new field type is: PLUGIN(plugin name, plugin version, plugin field name, parameters) plugin name is the plugin name... plugin version is important to execute alter table, or when using diferent kind of plugin versions we could know what version is being used and execute a automatic alter table for example... plugin field is the type of field in this plugin parameters are parameters for plugin values another idea is a enum with external table... ADD field PLUGIN("external_enum",'1','enum','table=database.table,id=field_id,value=field_value') it will execute a SELECT internally to table "database.table" and return the id/value of that table id is a bigint/int/mediumint/smallint/tinyint value (like enum index) and value is a string value (varchar,char,longtext,text) to storage engine will be used a bigint, for user it will be used as a enum() field ------ thre's more examples with interesting things, like expand opengis, or add others kind of field types, but the main idea is create a plugin interface for field types what you say guys? bye =) -- Roberto Spadim

3 5

[Maria-discuss] MariaDB 10.0.4 Alpha Now Available
by Daniel Bartholomew 16 Aug '13

16 Aug '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.4. This is an Alpha release. It includes new features and bug fixes. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.4 Alpha - Release Notes: https://kb.askmonty.org/en/mariadb-1004-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-1004-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.4 About MariaDB 10.0: https://kb.askmonty.org/en/what-is-mariadb-100 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] PHP 5.3 and mariadb 5.5.32 pam auth problem.
by Rafał Radecki 16 Aug '13

16 Aug '13

Hi All. I have: - one devel application server with php53-mysql-5.3.27-1 MariaDB-compat-5.5.32-1.x86_64 MariaDB-common-5.5.32-1.x86_64 MariaDB-shared-5.5.32-1.x86_64 MariaDB-client-5.5.32-1.x86_64 - one devel database server with MariaDB-compat-5.5.30-1.x86_64 MariaDB-server-5.5.30-1.x86_64 MariaDB-common-5.5.30-1.x86_64 MariaDB-shared-5.5.30-1.x86_64 MariaDB-client-5.5.30-1.x86_64 When I try to make a connection from devel to database server with php mysql_connect function then when I am using: - user with local authentication: connection is ok; - user with pam/ldap authentication I get error "Client does not support authentication protocol requested by server; consider upgrading MariaDB client error 1251" When I use mysql command on application server I can connect to the database server with both users, so only php does not work. Have you got similar issues? Any clues anout how to solve the problem? Best regards, Rafal Radecki.

2 1

[Maria-discuss] New Question: how can i transfer data use cursor
by AskMonty KB 16 Aug '13

16 Aug '13

Hello, A new question has been asked in "MariaDB Documentation" by bhdbing: -------------------------------- in MariaDB the cursor can't be a output datatype, generally in Oracle ,i declare a cursor and use it for transfer data,the sample like: ...rs out sys_refcursor... open rs for select * from %table name%; ... in c#,the cursor rs can be accepted,so i can get the whole data from %table name%. in MariaDB,how can i do this? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/how-can-i-transfer-data-use-cursor/

1 0

[Maria-discuss] New Question: Timestamps are different
by AskMonty KB 14 Aug '13

14 Aug '13

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by confidus: -------------------------------- I am in the very early stages of testing out our Galara cluster with innodb databases. I have a tool that is comparing data against each node on the cluster and I have found that timestamps seem to be the only thing that is inconstant and by exactly 5 hours. I have a record in a Galera cluster that has a field with date time. I took one database and started comparing each table (one by one). I had several thousand records with different timestamps. An example is 2013-07-03 11:13:59, but another server, the date time is 2013-07-03 16:13:59. I would suspect that the times would be synced everywhere exactly the same. If I run a "SELECT NOW();" on all four servers at the same time, I see: +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ +---------------------+ | NOW() | +---------------------+ | 2013-08-13 14:59:51 | +---------------------+ If I run a select @@global.time_zone, @@session.time_zone on all four nodes in the cluster, I also see +--------------------+---------------------+ | @@global.time_zone | @@session.time_zone | +--------------------+---------------------+ | SYSTEM | SYSTEM | +--------------------+---------------------+ And if I enter date on all 4 machines, the time matches just fine. I have checked other non erip databases (some very large databases) and things are correct within those systems. [root@a2 ~]# mysql -u root -p********** -h a2 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on | plan_approval_status | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | 3247 | 292 | 0 | 155 | 133 | 2013-07-03 11:13:59 | 1 | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ [root@a2 ~]# mysql -u root -p********** -h a3 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on | plan_approval_status | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | 3247 | 292 | 0 | 155 | 133 | 2013-07-03 16:13:59 | 1 | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ [root@a2 ~]# mysql -u root -p********** -h a4 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on | plan_approval_status | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ | 3247 | 292 | 0 | 155 | 133 | 2013-07-03 16:13:59 | 1 | +------------------+----------------+------------------+------------------------+------------------+---------------------+----------------------+ -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/timestamps-are-different/

1 0

[Maria-discuss] New Question: flush host
by AskMonty KB 14 Aug '13

14 Aug '13

Hello, A new question has been asked in "FLUSH commands" by h725: -------------------------------- i have looking for info how to 'read' info which are the hosts that hit the max_connect_errors. I have found there was a patch of Jeremy Cole, but i have not found anything for Mariadb. Is there a way to know which hosts increase the max_connect_errors?? any from SHOW or information_schema? thanks a lot -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/flush-host/

1 0

[Maria-discuss] New Question: use trigger for create table
by AskMonty KB 14 Aug '13

14 Aug '13

Hello, A new question has been asked in "MariaDB Documentation" by bhdbing: -------------------------------- as the title,does this db can do this? i want change my db from ORACLE to MariaDB,some problem appeared. and how to use sqlstring? in ORACLE use sql='%some sentences%'; and executed immediate, how it does in MariaDB? so my email:bhdbing@163.com,Thank you for your help! -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/use-trigger-for-create-table/

1 0

[Maria-discuss] Question about MariaDB Non-blocking Client
by Mike Gibson 07 Aug '13

07 Aug '13

Greetings, I'm using the MariaDB Non-blocking API to write a C++ client, but I've hit a wall regarding connection checking. I've been referencing the binding from node-mariasql ( https://github.com/mscdex/node-mariasql/blob/master/src/binding.cc) My app parses a config and creates new objects for each query, where each object has a MYSQL struct and MYSQL *pointer. Then, for each I set state to STATE_CONNECT and call doWork(). This works fine, when I can connect right away. The problem I'm experiencing is if I have a connection and kill the server (/etc/init.d/mysql stop) and then start it back (/etc/init.d/mysql start), I can never get clean reconnects. It's usually a mixture of errcode 2058, 2003, 2013. I'm really confused how to gracefully manage connections. Before I was using the official MySQL C++ connector, and it provides a connection->isConnected() method. I'm wondering how I can get something similar with MariaDB's client, as I need the non-blocking interface. Given: MYSQL mysql, *mysqlHandle; Look at the mysql_real_connect_start() or cont() functions. I provide MYSQL struct and on connect I get a copy of the struct stored in *mysqlHandle. It's not clear to me what the purpose of the copy is at this point as I still use the initial struct to call query(). In the case that I can detect a disconnection, how do I properly clean up the connection and attempt reconnect? Do I mysql_close(&mysql) and/or mysql_close(mysqlHandle), shutdown/close the file descriptor, mysql_init() a new handle and go through mysql_real_connect_start/cont()? Does it even make sense for each object to have its own MYSQL struct that I mysql_init(), or would it be better to have layer on top that mysql_init()s a single MYSQL struct, connects, and passes the returned *mysqlHandle to each query? Thanks for providing the async client, any help is appreciated.

2 2

[Maria-discuss] New Question: Web Applications do not receive all data in Galera Cluster
by AskMonty KB 07 Aug '13

07 Aug '13

Hello, A new question has been asked in "Replication" by confidus: -------------------------------- Hello, I have a real strange issue. I have a web application that appears to not show the correct records. I am using a load balancer for a web farm for a billing system. I am also using a load balancer for the Galera cluster. When a trouble ticket is generated, sometimes that ticket is not available on all the web servers, but when I look at each individual MariaDB server, I see the record. Data commits are synced and all looks good from the cluster side of things. I can perform a mysqldump to another database and point the billing system to that database and all is good. If I reboot each MariaDB server one by one, things start working again. It almost seems like there is some caching where the database cluster at times only shows records that were generated by that web server. I did check that all the web servers in the farm are using the same load balanced ip address for the MariaDB farm and they are. I have replicated this on two different web applications (A CRM & Billing system) both on different web farms. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/web-applications-do-not-receive-all-data-in-galer…

1 0

Re: [Maria-discuss] MariaDB-Galera plans?
by Daniel Bartholomew 07 Aug '13

07 Aug '13

On Tue, Aug 6, 2013 at 3:30 AM, Jan Kirchhoff <j.kirchhoff(a)logical-line.de> wrote: > any news on this? I have a 5.5.29 cluster running fine for some time > now, but I'd actually like to have some functionality of MariaDB 10, > so I am waiting for a 10.0-Galera-release... > what's the packaging problem about? The packaging issues I'm involved with are: https://mariadb.atlassian.net/browse/MDEV-4229 and https://mariadb.atlassian.net/browse/MDEV-4141 I'm hoping to have some sort of fix for both issues within a day or so, and shortly after that to have a release. I don't know the status of MariaDB Galera Cluster 10.0. Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart 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] MariaDB-Galera plans?
by Aleksey Sanin 06 Aug '13

06 Aug '13

Hello, There have been no MariaDB-Galera releases since March and I am curious if you still plan to support it going forward. It feels that MariaDB-Galera development stopped completely and I wonder if I should be switching to Percona instead. Best, Aleksey

3 3

[Maria-discuss] Compiling
by Roberto Spadim 05 Aug '13

05 Aug '13

Hi guys, i installed slackware-14 downloaded the mariadb-source of 10.0.3 tar -zxf mariadb.tgz cd mariadb-10.0.3 BUILD/configure-pentium64-max and it stoped at: [ 37%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/sql_yacc.cc.o Linking CXX static library libsql_embedded.a [ 37%] Built target sql_embedded gmake: *** [all] Error 2 the point is... why? any log or something like it to check what happened? -- Roberto Spadim

2 10

[Maria-discuss] New Question: mariadb on Cubieboard (ARM AllWinner A10)
by AskMonty KB 04 Aug '13

04 Aug '13

Hello, A new question has been asked in "Does MariaDB support..." by aemlin: -------------------------------- Hello, I'm using mariadb on Cubieboard (within a debian server). The compile of the sources for 5.5 did work perfectly but the 10.0 does not compile , is it possible to have some help to get it running ? Also is there a way to make my mariadb 5.5 available for other users (by exemple as a .deb file)? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/mariadb-on-cubieboard-arm-allwinner-a10/

1 0

[Maria-discuss] RFC opengis and libs
by Roberto Spadim 02 Aug '13

02 Aug '13

hi guys, does we use one lib for opengis? i was using this one with php and c, and i think it's a nice library, maybe a port of this to mariadb should be nice http://trac.osgeo.org/geos/ -- Roberto Spadim SPAEmpresarial

1 0

Re: [Maria-discuss] Compiling
by Roberto Spadim 02 Aug '13

02 Aug '13

please remove this user from list, his email don't exists anymore: alexandre.almeida(a)hti.com.br thanks 2013/8/2 <alexandre(a)hti.com.br>: > Esta conta de email não está mais em uso. A mensagem não foi entregue. Favor reenvie para alexandre.almeida(a)hti.com.br > > This account is no longer in use. The message wasn't delivered. Please resend the message to alexandre.almeida(a)hti.com.br > > -- Roberto Spadim SPAEmpresarial

1 0

Re: [Maria-discuss] Which JOIN
by Richard Couture 31 Jul '13

31 Jul '13

On 07/30/2013 09:17 PM, Roberto Spadim wrote: > ---- > other tip, instead of full table name, *USE* alias > FROM ArticulosPedidos AS a, PedidosIndex AS b, CartArticulos AS c > b.NumDePedido=a.NumDePedido AND > a.ArticuloID=c.ArticuloID > > this decrease TCP/IP or UNIX SOCKET packets... if you have a very high qps > (query per second) this can save a lot of ethernet, example > 1000 queries of 1KB=1MB/second , if you can save near to 50B per query, you > will use 950*1000 = 950KB, in other words, you can send 5% more bytes over > network without changing hardware > --- > The idea is good but the syntax fails The following syntax however does work select sum( CantidadPedida ) as SumPedida, sum( CantidadRecibida ) as SumRecibida, ArticuloCodigo, ArticuloNombre, ArticuloCosto, ArticulosDisponibles, ArticuloUnidad from ArticulosPedidos as a inner join PedidosIndex as b on b.NumDePedido = a.NumDePedido inner join CatArticulos as c on a.ArticuloID = c.ArticuloID where a.Fecha between '{$_POST{'MovsDelAno'}}-{$_POST{'MovsDelMes'}}-{$_POST{'MovsDelDia'}}' and '{$_POST{'MovsAlAno'}}-{$_POST{'MovsAlMes'}}-{$_POST{'MovsAlDia'}}' group by a.ArticuloID order by SumPedida DESC limit 500; Thanks for the tip Richard -- LinuxCabal Asociación Civil Ing. Richard Couture Novell CNE, ECNE, MCNE HP/Compaq ASE Tel.: (+52) (333) 145-2638 Cel.: (+52) (044) 333 377-7505 Cel.: (+52) (044) 333 377-7506 Web: http://www.LinuxCabal.org E-Mail: rrc(a)linuxcabal.org Hosted en la nube Cloud Sigma - www.CloudSigma.com AVISO DE CONFIDENCIALIDAD: Este correo electrónico, incluyendo en su caso, los archivos adjuntos al mismo, pueden contener información de carácter confidencial y/o privilegiada, y se envían a la atención única y exclusivamente de la persona y/o entidad a quien va dirigido. La copia, revisión, uso, revelación y/o distribución de dicha información confidencial sin la autorización por escrito de LinuxCabal está prohibida. Si usted no es el destinatario a quien se dirige el presente correo, favor de contactar al remitente respondiendo al presente correo y eliminar el correo original incluyendo sus archivos, así como cualesquiera copia del mismo. Mediante la recepción del presente correo usted reconoce y acepta que en caso de incumplimiento de su parte y/o de sus representantes a los términos antes mencionados, LinuxCabal tendrá derecho a los daños y perjuicios que esto le cause.

1 0

[Maria-discuss] Which JOIN
by Richard Couture 31 Jul '13

31 Jul '13

I have a table of transactions for ArticleID bought and sold. I want to create a report of the fileds in that table sorted by the SUM of each ArticleID. Any suggestions??? Thanks Richard -- LinuxCabal Asociación Civil Ing. Richard Couture Novell CNE, ECNE, MCNE HP/Compaq ASE Tel.: (+52) (333) 145-2638 Cel.: (+52) (044) 333 377-7505 Cel.: (+52) (044) 333 377-7506 Web: http://www.LinuxCabal.org E-Mail: rrc(a)linuxcabal.org Hosted en la nube Cloud Sigma - www.CloudSigma.com AVISO DE CONFIDENCIALIDAD: Este correo electrónico, incluyendo en su caso, los archivos adjuntos al mismo, pueden contener información de carácter confidencial y/o privilegiada, y se envían a la atención única y exclusivamente de la persona y/o entidad a quien va dirigido. La copia, revisión, uso, revelación y/o distribución de dicha información confidencial sin la autorización por escrito de LinuxCabal está prohibida. Si usted no es el destinatario a quien se dirige el presente correo, favor de contactar al remitente respondiendo al presente correo y eliminar el correo original incluyendo sus archivos, así como cualesquiera copia del mismo. Mediante la recepción del presente correo usted reconoce y acepta que en caso de incumplimiento de su parte y/o de sus representantes a los términos antes mencionados, LinuxCabal tendrá derecho a los daños y perjuicios que esto le cause.

2 3

[Maria-discuss] Master slave
by Richard Couture 27 Jul '13

27 Jul '13

Is it possible to set up replication in such a manner as to permit writing records to either a master or a slave replica? We want to set up a fail safe replica that can easily take over when our connection to the main replica fails, which, unfortunately, is fairly often. I read a document, some time ago which mentioned several types of replication, i.e.: by record, by table ... and the pitfalls, like IDs not necessarily matching... which confused me more than anything else... Can someone point me to some good documentation to enable me to pick the correct type of replication that I need to accomplish my task?? Thanks Richard -- LinuxCabal Asociación Civil Ing. Richard Couture Novell CNE, ECNE, MCNE HP/Compaq ASE Tel.: (+52) (333) 145-2638 Cel.: (+52) (044) 333 377-7505 Cel.: (+52) (044) 333 377-7506 Web: http://www.LinuxCabal.org E-Mail: rrc(a)linuxcabal.org Hosted en la nube Cloud Sigma - www.CloudSigma.com AVISO DE CONFIDENCIALIDAD: Este correo electrónico, incluyendo en su caso, los archivos adjuntos al mismo, pueden contener información de carácter confidencial y/o privilegiada, y se envían a la atención única y exclusivamente de la persona y/o entidad a quien va dirigido. La copia, revisión, uso, revelación y/o distribución de dicha información confidencial sin la autorización por escrito de LinuxCabal está prohibida. Si usted no es el destinatario a quien se dirige el presente correo, favor de contactar al remitente respondiendo al presente correo y eliminar el correo original incluyendo sus archivos, así como cualesquiera copia del mismo. Mediante la recepción del presente correo usted reconoce y acepta que en caso de incumplimiento de su parte y/o de sus representantes a los términos antes mencionados, LinuxCabal tendrá derecho a los daños y perjuicios que esto le cause.

1 0

[Maria-discuss] New Question: Does MariaDB support for Linux on POWER system?
by AskMonty KB 25 Jul '13

25 Jul '13

Hello, A new question has been asked in "Does MariaDB support..." by jinkoo: -------------------------------- Does MariaDB support for Linux on POWER system? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/does-mariadb-support-for-linux-on-power-system/

1 0

[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

[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

[Maria-discuss] Mysql resource limits.
by Rafał Radecki 02 Jul '13

02 Jul '13

Hi All. I would like to limit resources available to a given user in mysql. I know that there is https://dev.mysql.com/doc/refman/5.5/en/user-resources.html, I also know that cgroups can be used at operating system level. What are your experiences in limiting resources in mysql? I've used percona statistics and had information provided by it. Are there any better solutions? Best regards, Rafal Radecki.

1 0

[Maria-discuss] New Question: Local state seqno out of sync with group
by AskMonty KB 02 Jul '13

02 Jul '13

Hello, A new question has been asked in "Galera" by uxbod: -------------------------------- We have MariaDB and Galera working in our lab on a three node cluster. When setting them up the wsrep options for each node were as follows: {{{ node1: wsrep_cluster_address="gcomm://" node2: wsrep_cluster_address="gcomm://172.30.1.3" node3: wsrep_cluster_address="gcomm://172.30.1.1" }}} Once all the nodes were in sync I shutdown node1 and set its wsrep_cluster_address to be 172.30.1.2. This I thought would allow the three nodes to keep in sync. What happened though was when I started MariaDB backup I received the error: {{{ 130702 8:35:51 [ERROR] WSREP: Local state seqno (16053) is greater than group seqno (15898): states diverged. Aborting to avoid potential data loss. Remove '/var/lib/mysql//grastate.dat' file and restart if you wish to continue. (FATAL) at galera/src/replicator_str.cpp:state_transfer_required():34 }}} Why has this happened ? Is it safe to proceed with the recommendation of removing grastate.dat ? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/local-state-seqno-out-of-sync-with-group/

1 0

[Maria-discuss] New Question: xtrabackup sync method
by AskMonty KB 30 Jun '13

30 Jun '13

Hello, A new question has been asked in "Galera" by uxbod: -------------------------------- Hello, have installed Maria on Centos 6.4 x86_64: MariaDB-common-5.5.31-1.x86_64 MariaDB-Galera-server-5.5.29-1.x86_64 MariaDB-compat-5.5.31-1.x86_64 MariaDB-client-5.5.31-1.x86_64 and the primary node is working fine with the configuration: [mysqld] wsrep_provider=/usr/lib64/galera/libgalera_smm.so wsrep_cluster_name="MYCLUSTER" wsrep_node_name=db1 wsrep_cluster_address="gcomm://" wsrep_slave_threads=8 wsrep_sst_method=xtrabackup wsrep_sst_auth=username:password wsrep_node_address=172.30.10.13 datadir=/var/lib/mysql innodb_autoinc_lock_mode=2 The problem is on the second node when it tries to replicate as receiving the error: 130629 8:55:17 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_xtrabackup --role 'joiner' --address '172.30.10.18' --auth 'username:password' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '7131' Read: 'Can't find innobackupex in the path' yet innobackupex is indeed within the path. What could the issue be please ? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/xtrabackup-sync-method/

1 0

[Maria-discuss] New Question: How can I install MariaDB C Client on Fedora 17/18 or CentOS 6.* without uninstalling MySQL
by AskMonty KB 29 Jun '13

29 Jun '13

Hello, A new question has been asked in "MariaDB Client Library for C" by aesterkin: -------------------------------- Hello, I need to install only client libraries without uninstalling MySQL. How can I do it? I tries installing from your YUM repository, but this installation conflicts with mysql-libs and mysql-server pachages (from "remi" repository). Thanks, Alex Esterkin -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/how-can-i-install-mariadb-c-client-on-fedora-1718…

1 0

[Maria-discuss] New Question: Is it possible to specify a user, password, and non standard port for the thrift servers?
by AskMonty KB 28 Jun '13

28 Jun '13

Hello, A new question has been asked in "Cassandra Storage Engine" by frankflynn: -------------------------------- In the Cassandra examples we see: set cassandra_default_thrift_host='192.168.0.10' and then create table cassandra_tbl ( rowkey type PRIMARY KEY, ... thrift_host= can also be specified here But is it currently possible to specify a user, password, and/or a non standard port? I've removed the user and password and tried thrift_host='192.168.0.10:9161' (using my particular IP) but that does not seem to work. The error I get is: ERROR 1429 (HY000): Unable to connect to foreign data source: Could not resolve host for client socket. [1] I can connect to this host / port from the command line. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/is-it-possible-to-specify-a-user-password-and-non…

1 0

[Maria-discuss] New Question: zip or msi
by AskMonty KB 28 Jun '13

28 Jun '13

Hello, A new question has been asked in "What is in the different MariaDB releases?" by Swirl: -------------------------------- Why is the "zip" that much bigger than the "msi"? Does it contain more info/code/tools or whatever? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/zip-or-msi/

2 1

[Maria-discuss] New Question: Changing location of database
by AskMonty KB 28 Jun '13

28 Jun '13

Hello, A new question has been asked in "MariaDB community" by mdavies5: -------------------------------- Using 5.5.31 on Linux Mint. By default datadir is /var/lib/mysql. Like most users I do not want my data on my boot drive so I moved it to a different physical drive which is always mounted. I then stopped server, reset the basedir in my.cnf and restarted. No problem. After a reboot the log shows multiple errors "Table xxx doesn't exist" although it does. In Mysql workbench the tables are listed in the schema tree but any attempt to access causes workbench to abort. I also tried deleting all data, recreate the schema folders and then the scripts to create the tables and routines and data. Again ok until a reboot. The only thing I haven't tried is dropping the schemas and recreating them in workbench. Relevant data: The new data drive is NTFS. The error messages include: [ERROR] Cannot find or open table pword/pword from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains indexes that this version of the engine doesn't support. Would appreciate any suggestions. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/changing-location-of-database/

1 0

[Maria-discuss] New Question: LINQ in C#
by AskMonty KB 27 Jun '13

27 Jun '13

Hello, A new question has been asked in "Using MariaDB" by JDoggieIII: -------------------------------- Hi, I am attempting to replace the database in an application with MariaDB. This application is written in C# and previously accessed the database (mostly inserts) with LINQ. When I attempt to insert (other transactions have the same type of issue) I get the error message: "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 '[t0].[Id], [t0].[BirthYear], [t0].[FirstName], [t0].[Gender], [t0].[LastName], [' at line 1" The table in MariaDB is setup the same as it was in MS SQL. Any thoughts on this subject would be most appreciated. I could go back and remove all use of LINQ and write SQL by hand (which is how I would have implemented it in the first place due to LINQ being the bane of my existence), but if I can get it to work as is it will save a great deal of time, and therefore money. Thanks, Jeremy -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/linq-in-c/

1 0

[Maria-discuss] New Question: installation and license
by AskMonty KB 25 Jun '13

25 Jun '13

Hello, A new question has been asked in "Getting Started" by JDoggieIII: -------------------------------- Hi, we want to use MariaDB on several machines, one of which contains MS SQL 2008 R2 (which we don't want to use). Does MariaDB play nice on the same server as MS SQL 2008 R2? Also, is there a license somewhere, I can't locate one. Thanks, Jeremy -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/installation-and-license/

1 0

[Maria-discuss] Silencing "Unsafe statement written to the binary log" log warnings
by Vincent Pelletier 25 Jun '13

25 Jun '13

Hi. We get 500k such lines per day: 130517 0:00:02 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted. Statement: UPDATE [...] Is there a way to silence them ? Intuitively, I would expect a companion option to innodb_locks_unsafe_for_binlog, but couldn't find one in the documentation. The queries triggering those warnings are harmless in our case because the update is rolled back at application level on restart (which necessarily happens in case of disaster recovery involving restoring incremental backups). If you want more details to understand what we are doing - shouldn't be needed for this discussion: The table involved is used as a shared task queue. The update happens when a process wants to process a bunch of tasks, up to a limit. Once a task is over, it is deleted by its primary key. So any task assigned to a worker's identifier upon worker startup can be safely assumed to have to be processed, and is released by that worker (effectively rolling back UPDATE's action). This only represents 2MB gzipped, so we can live with it if we must, but it causes undesired noise which may hide real issues. Regards, -- Vincent Pelletier ERP5 - open source ERP/CRM for flexible enterprises

3 3

[Maria-discuss] New Question: Issue with symlinked database directories loading under windows
by AskMonty KB 25 Jun '13

25 Jun '13

Hello, A new question has been asked in "Using MariaDB" by scottharman: -------------------------------- Hi all, I'm having trouble getting symlinked databases to work under 5.5.31 of MariaDB Currently the databases are held on a different drive, and I've tried both Symlinks and Junctions under windows to get them working under MariaDB Both methods work equally well under MySQL 5.5.31, and I've enabled symlink support in my.ini for Mariadb Any thoughts on why it wouldn't be working? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/issue-with-symlinked-database-directories-loading…

1 0

[Maria-discuss] New Question: Downloading MariaDB and starting the installation procedure
by AskMonty KB 23 Jun '13

23 Jun '13

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by tsperry: -------------------------------- I've downloaded the package several times but the installation feature won't start. What am I doing wrong? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/downloading-mariadb-and-starting-the-installation…

1 0