Re: [Maria-discuss] doubt with thread pool

2015-11-11 Thread Roberto Spadim
hm nice, but check my "problem" with one thread per connection, i can think about an estimation with max_connections with thread pool, what i could do? use the same max_connections or use another variable (thread size?), considering that i have a limit of threads running (i'm thinking that this one

Re: [Maria-discuss] doubt with thread pool

2015-11-11 Thread Roberto Spadim
sorry i sent before writing the example of a thread that stoped, and is waiting a new "job", in this case i should consider max connections or thread pool size? i think it's the second, right? i never used thread pool with many connection, that's the problem (no experience), i will try a dev serv

Re: [Maria-discuss] doubt with thread pool

2015-11-11 Thread Reindl Harald
Am 11.11.2015 um 16:36 schrieb Roberto Spadim: hm nice, but check my "problem" with one thread per connection, i can think about an estimation with max_connections with thread pool, what i could do? use the same max_connections or use another variable (thread size?), considering that i have a li

Re: [Maria-discuss] doubt with thread pool

2015-11-11 Thread Roberto Spadim
nice :) i will do it, if possible share here i got, the hardware is old it will not help a lot but ok 2015-11-11 13:43 GMT-02:00 Reindl Harald : > > Am 11.11.2015 um 16:36 schrieb Roberto Spadim: > >> hm nice, but check my "problem" >> with one thread per connection, i can think about an estimat

[Maria-discuss] GRANT error - undocumented?

2015-11-11 Thread Felipe Gasper
Hello, I’ve found an apparent discrepancy between MySQL 5.6 and MariaDB 10.1. When you GRANT ALL PRIVILEGES on a DB to a user/host that is not in the mysql.users table, MariaDB 10.1 throws ER_PASSWORD_NO_MATCH, whereas MySQL 5.6 creates the user/host entry. Is this by design? I don’t see t

Re: [Maria-discuss] GRANT error - undocumented?

2015-11-11 Thread Daniel Black
https://mariadb.com/kb/en/mariadb/server-system-variables/#sql_mode sql_mode Default Value: NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION (>= MariaDB 10.1.7), password_no_match seems to be odd error however I assume that's the same as mysql in the same sql_mode. - On 12 Nov, 2015, at 10:26

Re: [Maria-discuss] GRANT error - undocumented?

2015-11-11 Thread Peter Laursen
My guess is that the 2 servers are running with different settings for NO_AUTO_CREATE_USER sql-mode (refer http://dev.mysql.com/doc/refman/5.6/en/sql-mode.html#sqlmode_no_auto_create_user and http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_auto_create_user ). -- Peter -- Webyog On

[Maria-discuss] Donating during the downloads

2015-11-11 Thread Colin Charles
Hi, Today I downloaded Ubuntu and saw this awesome page for donations. Do you think we should do this for the MariaDB Server / Connectors / etc. so that the MariaDB Foundation gets funded as well? I know that even LibreOffice has done this (http://donate.libreoffice.org/) We should consider th