September 2013 - discuss - lists.mariadb.org

[Maria-discuss] -DHAVE_POOL_OF_THREADS not configureable?
by Reindl Harald 22 Sep '13

22 Sep '13

should "-DHAVE_POOL_OF_THREADS" not be configureable? Manually-specified variables were not used by the project: HAVE_POOL_OF_THREADS cd /home/builduser/rpmbuild/BUILD/mariadb-5.5.33a/sql && /usr/bin/c++ -DHAVE_CONFIG_H -DHAVE_EVENT_SCHEDULER -DHAVE_OPENSSL -DHAVE_POOL_OF_THREADS -DMYSQL_SERVER ___________________________ IMHO that is a nice idea but in tests with typical PHP allications it slows things down, in case of applications like "dbmail" which have their own sql-connection-pooling it doe snot have benefits yes, you need to enable it in the my.cnf, but i am a fan of disable things at compile-time which are not used inside a known infrastructure and keep binaries as small as possible

1 0

[Maria-discuss] MariaDB 5.5.33a Now Available
by Daniel Bartholomew 20 Sep '13

20 Sep '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.33a. This is a special bug-fix release to address some packaging and other bugs present in the recent MariaDB 5.5.33 release. See the release notes and changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.33a Stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-5533a-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5533a-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.33a Overview of MariaDB 5.5: https://mariadb.com/kb/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://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 MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://mariadb.com/kb/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://mariadb.com/kb

1 0

[Maria-discuss] New Question: Importing Access Database Structure
by AskMonty KB 20 Sep '13

20 Sep '13

Hello, A new question has been asked in "MariaDB FAQ" by mmontoya19: -------------------------------- Hello Everyone, I am currently conducting a study and trying to find DB software for company use. There is a current database in use that I am wondering if I can export the structure ONLY into MariaDB. Meaning I want to be able to duplicate the Tables, Relationship, Queries, and if possible reports. Is it possible to do this? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/importing-access-database-structure/

1 0

[Maria-discuss] Galera cluster
by Roberto Spadim 20 Sep '13

20 Sep '13

Hi guys, the galera cluster code is "inside" default mariadb-10.0.4 code? or there's a different branch for galera cluster? -- Roberto Spadim

3 4

[Maria-discuss] 'Converting' a myisam to multi-master
by Roberto Spadim 20 Sep '13

20 Sep '13

Hi guys, there's one easy way to implement a multi-master cluster using myisam/aria ? i know that galera cluster use innodb as backend, there's anything similar to aria/myisam? scaledb? ndb? others? the main problem switching from aria/myisam to innodb is the MIN/MAX/COUNT(*) optimization and the rows sizes/index considerations ( https://mariadb.com/kb/en/converting-tables-from-myisam-to-innodb/) and since it's myisam/aria many apps don't use begin transaction / commit (maybe this is a problem for cluster/multi master?) thanks guys :) -- Roberto Spadim

2 8

[Maria-discuss] Benchmark with jemalloc
by Roberto Spadim 20 Sep '13

20 Sep '13

Hi guys, there're benchmark with jemalloc and last malloc implemention? -- Roberto Spadim

4 16

[Maria-discuss] MariaDB Java Client 1.1.5 Now Available
by Daniel Bartholomew 18 Sep '13

18 Sep '13

The MariaDB project is pleased to announce the immediate availability of the MariaDB Java Client 1.1.5. This is a Stable (GA) release. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Java Client 1.1.5 - Release Notes: https://mariadb.com/kb/en/mariadb-java-client-115-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-java-client-115-changelog/ - Downloads: https://downloads.mariadb.org/client-java/1.1.5/ Overview of the MariaDB Java Client: https://kb.askmonty.org/en/about-the-mariadb-java-client/ - - 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://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb 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 - https://mariadb.com/kb

1 0

[Maria-discuss] New Question: How to define a role for a particular set of users
by AskMonty KB 18 Sep '13

18 Sep '13

Hello, A new question has been asked in "MariaDB community" by lucky7456969: -------------------------------- create role xxx.GM WITH ADMIN CURRENT_USER; here xxx is the schema name I get syntax error out of it. Could anyone shed some lights on this? Thanks Jack -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-community-how-to-define-a-role-for-a-parti…

1 0

[Maria-discuss] New Question: How to define a role for a particular set of users
by AskMonty KB 18 Sep '13

18 Sep '13

Hello, A new question has been asked in "MariaDB community" by lucky7456969: -------------------------------- create role xxx.GM WITH ADMIN CURRENT_USER; here xxx is the schema name I get syntax error out of it. Could anyone shed some lights on this? Thanks Jack -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-define-a-role-for-a-particular-set-of-users/

1 0

[Maria-discuss] New Question: OPTIMIZE my.cnf
by AskMonty KB 17 Sep '13

17 Sep '13

Hello, A new question has been asked in "MariaDB FAQ" by cmejia_22: -------------------------------- I need help for optimize my.cnf what parameters are important and the optimal values? I have a server with 8 core, 64 GB Memory, raid 10 and engine=innodb Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/optimize-mycnf/

1 0