- discuss - lists.mariadb.org

[Maria-discuss] MariaDB non-blocking with EPOLL
by Dave C 20 Jun '16

20 Jun '16

Originally posted to : http://stackoverflow.com/questions/37909652/mariadb-non-blocking-with-epoll Edited for context. I have single threaded server written in C that accepts TCP/UDP connections based on EPOLL and supports plugins for the multitude of protocol layers we need to support. That bit is fine. Due to the single threaded nature I wanted to implement a database layer that could utilize the same EPOLL architecture rather then separately iterating over all of the open connections. We use MariaDB and the MariaDB C connector that supports non blocking functions in it's API as described here. https://mariadb.com/kb/en/mariadb/using-the-non-blocking-library/ But what I'm finding is not what I expected, and what I was expecting is described below. First I fire the mysql_real_connect_start() and if it returns zero we dispatch the query immediately as this indicates no blocking was required, although this never happens. Otherwise I fetch the file descriptor that seems to be immediate and register it with EPOLL and bail back to the main EPOLL loop waiting for events. s = mysql_get_socket(mysql); if(s > 0){ brt_socket_set_fds(endpoint, s); struct epoll_event event; event.data.fd = s; event.events = EPOLLRDHUP | EPOLLIN | EPOLLET | EPOLLOUT; s = epoll_ctl(efd, EPOLL_CTL_ADD, s, &event); if (s == -1) { syslog(LOG_ERR, "brd_db : epoll error."); // handle error. }... So then some time later I do get the EPOLLOUT indicating the socket has been opened. And I dutifully call mysql_real_connect_cont() but at this stage it is still returning a non-zero value, indicating I must wait longer? But then that is the last EPOLL event I get, except for the EPOLLRDHUP when I guess the MariaDB hangs up after 10 seconds. Can anyone help me understand if this idea is even workable? Thanks David

2 1

[Maria-discuss] MariaDB 5.5.50 and updated connectors now available
by Daniel Bartholomew 18 Jun '16

18 Jun '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.50, MariaDB Connector/J 1.4.6, and MariaDB Connector/ODBC 2.0.11. These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.50 - Release Notes: https://mariadb.com/kb/en/mdb-5550-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5550-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.50 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.4.6 - Release Notes: https://mariadb.com/kb/en/mcj-146-rn/ - Changelog: https://mariadb.com/kb/en/mcj-146-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.4.6/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/ODBC 2.0.11 - Release Notes: https://mariadb.com/kb/en/mco-2011-rn/ - Changelog: https://mariadb.com/kb/en/mco-2011-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/2.0.11/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-odbc/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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 or my.ini file! See http://mariadb.com/kb/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 the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

3 3

[Maria-discuss] New Question: MariaDB Backup using Percona XtraBackup
by AskMonty KB 16 Jun '16

16 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-backup-using-percona-xtrabackup/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Does percona xtrabackup backs up binary log files also and does it backup all storage engines when using innobackupex as on percona website it says it backs up only Innodb xtradb and myiasm?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-backup-using-percona-xtrabackup/

1 0

[Maria-discuss] New Question: Could you suggest a connector which can work for Django and mariaDB?
by AskMonty KB 15 Jun '16

15 Jun '16

Hello, A new question has been asked in "MariaDB Community" by cpwen. Please answer it at http://mariadb.com/kb/en/could-you-suggest-a-connector-which-can-work-for-d… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, sirs. I am a new guy to learn Django and MariaDB. Could you suggest a connector which can work for Django and mariaDB? The environment is Python3.4, Django1.9, MariaDB10.0. Ubuntu15.10. Thanks a lot in advance. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/could-you-suggest-a-connector-which-can-work-for-d…

1 0

[Maria-discuss] New Question: MONyog Auto-Discovery of MariaDB Databases
by AskMonty KB 15 Jun '16

15 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-auto-discovery-of-mariadb-databases/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to discover all the mariadb instance running on a particular server and register them automtically in monyog..suppose i have mariadb 1 running on port 3306 and mariadb 2 on 3307 and what monyog should do is i give the ip address of the server and mariadb 1 and mariadb 2 should get confgured automatically and start monitoring. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-auto-discovery-of-mariadb-databases/

1 0

[Maria-discuss] New Question: ST_AsGeoJSON Support
by AskMonty KB 14 Jun '16

14 Jun '16

Hello, A new question has been asked in "Geographic Features" by jerome_savin. Please answer it at http://mariadb.com/kb/en/st_asgeojson-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Are there some plans to support ST_AsGeoJSON function ? Will ST_AsGeoJSON be available soon ? Many Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/st_asgeojson-support/

1 0

[Maria-discuss] Odd behavior with query and connection pool
by Stu Smith 14 Jun '16

14 Jun '16

Hello, Forgive me for reporting this on the behalf of some other developers, I will gather more details as needed. But the basic problem we're having is with a query that: - is always fast the first time ( < 3 seconds ) - is very slow the following time, when using a connection pool (~ 30 seconds) - is pretty fast the following time, when not using a connection pool (5 or 6 seconds) This is even on a single DB with no other load. It's a fairly complicated query with sub queries, grouping, and such. I've been told it creates two temp tables. I know this is not a whole lot to go one - but are there any pointer for connection pool vs no connection pool on a lightly loaded DB? This was actually tried and reproduced with multiple connection pools - hikari-db, c3p0, and apache connection pool. Take care, -stu

3 2

[Maria-discuss] R: Odd behavior with query and connection pool
by Federico Razzoli 14 Jun '16

14 Jun '16

Weird issue. I'm trying to figure out how the connection pool can add an overhead to a single query. The only case I can think is if you use a network storage engine (Federated, Connect, Spider) pointing to tables on localhost. Is this the case? More likely... are you sure this problem is caused by the connection pool? * After the first execution, do a SHOW STATUS. Then FLUSH STATUS. Then execute again and, if it takes long time, do another SHOW STATUS. Post your results here, so we can see what happened. * While the query takes a long time, try a SHOW PROCESSLIST from another client. See if the connection is waiting for a lock. Regards Federico -------------------------------------------- Mar 14/6/16, Stu Smith <stu26code(a)gmail.com> ha scritto: Oggetto: [Maria-discuss] Odd behavior with query and connection pool A: maria-discuss(a)lists.launchpad.net Data: Martedì 14 giugno 2016, 03:36 Hello, Forgive me for reporting this on the behalf of some other developers, I will gather more details as needed. But the basic problem we're having is with a query that: - is always fast the first time ( < 3 seconds ) - is very slow the following time, when using a connection pool (~ 30 seconds) - is pretty fast the following time, when not using a connection pool (5 or 6 seconds) This is even on a single DB with no other load. It's a fairly complicated query with sub queries, grouping, and such. I've been told it creates two temp tables. I know this is not a whole lot to go one - but are there any pointer for connection pool vs no connection pool on a lightly loaded DB? This was actually tried and reproduced with multiple connection pools - hikari-db, c3p0, and apache connection pool. Take care, -stu -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

1 0

[Maria-discuss] New Question: the difference
by AskMonty KB 14 Jun '16

14 Jun '16

Hello, A new question has been asked in "What is in the Different MariaDB Releases?" by hongyan_0318_54417. Please answer it at http://mariadb.com/kb/en/the-difference/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- About MariaDB I am a new boy,now I am using version 5.5.36 ,I want to upgrade version to 10.0.2 ,so the quesion is what's the question between them ,my English is poor ,give me a simply apply please ,thanks a lot . -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/the-difference/

1 0

[Maria-discuss] F5 iRules for galera
by Umarzuki Mochlis 14 Jun '16

14 Jun '16

I found a article related to monitoring galera at https://devcentral.f5.com/articles/monitoring-open-source-databases-with-bi…. but it did no into detail of iRules used for multi-master. Anyone have sample(s) to share? Mariadb 10.1 Big-IP 11

1 0