July 2013 - discuss - lists.mariadb.org

[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] 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

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