[Maria-discuss] New MariaDB book: Building a Web Application with PHP and MariaDB

2014-06-18 Thread Daniel Bartholomew
I just received an email from Packt about a new MariaDB book they've just published, Building a Web Application with PHP and MariaDB: A Reference Guide, by Sai Srinivas Sriparasa. If you're interested, check it out: http://www.packtpub.com/building-a-web-application-with-php-and-mariadb/book I wa

Re: [Maria-discuss] Spider and query cache

2014-06-18 Thread Roberto Spadim
nice :) i will test it 2014-06-18 12:57 GMT-03:00 kentoku : > Hi Roberto, > > I added option to Spider 3.2.4 which bundled in MariaDB 10.0.12. Please try > it! > > - query_cache_sync(qcs) > Add same query cache option that executed for Spider table. >0 : It doesn't give it. >1 : Add sql

Re: [Maria-discuss] Spider and query cache

2014-06-18 Thread kentoku
Hi Roberto, I added option to Spider 3.2.4 which bundled in MariaDB 10.0.12. Please try it! - query_cache_sync(qcs) Add same query cache option that executed for Spider table. 0 : It doesn't give it. 1 : Add sql_cache, if SQL(SELECT) is executed with sql_cache for Spider table.

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-06-18 Thread Reindl Harald
Am 18.06.2014 13:30, schrieb Tanstaafl: > I'm very inexperienced mariadb/mysql/sql user/admin, but not totally > clueless, been maintaining a tiny mysql DB for > postfixadmin for years, then converted it to mariadb. > > We recently started using SOGo (groupware). I hired the SOGo guys to help >

[Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-06-18 Thread Tanstaafl
Hi all, I'm very inexperienced mariadb/mysql/sql user/admin, but not totally clueless, been maintaining a tiny mysql DB for postfixadmin for years, then converted it to mariadb. We recently started using SOGo (groupware). I hired the SOGo guys to help with the install/config, and have been u

Re: [Maria-discuss] Easy way to see different users@hosts connected to all databases?

2014-06-18 Thread Federico Razzoli
It's the easiest and least locking way, I think. But if you want more detailed info: SELECT * FROM information_schema.PROCESSLIST Regards Federico El dom, 15/6/14, Tanstaafl escribió: Asunto: Re: [Maria-discuss] Easy way to see different users@hos

Re: [Maria-discuss] Easy way to see different users@hosts connected to all databases?

2014-06-18 Thread Tanstaafl
Actually, I found a much easeir way (for what I needed to see): log into mysql as root, and do: show processlist; Exactly what I needed. But thanks for the other responses, may come in handy later. Charles On 6/15/2014 10:36 AM, Peter Laursen wrote: Maybe this wll help: http://blog.webyog.

[Maria-discuss] New Question: Does Mariadb has a comparison with PostgreSQL ?

2014-06-18 Thread AskMonty KB
Hello, A new question has been asked in "MariaDB Documentation" by mayuraviraj: PostgreSQL maintain a page which compare it with MySQL (https://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007) Why not mariadb mai

Re: [Maria-discuss] fusion io

2014-06-18 Thread Torben Mathiasen
Just to add some flavor. NVM (also known as page) compression does indeed work with any file system supporting the fallocate/trim/discard commands passed via user space (EXT4, XFS). Atomics (as far as I know) is currently only implemented by NVMFS but is not a requirement for NVM compression. It