[Maria-discuss] New Question: Will Aria 2.0 have an option to stay crash-safe, but not have the performance penalties necessary for true transactionality?

2016-02-12 Thread AskMonty KB
Hello, A new question has been asked in "Development" by Moscato. Please answer it at http://mariadb.com/kb/en/will-aria-20-have-an-option-to-stay-crash-safe-but-not-have-the-performance/ as the person asking the question may not be subscribed to the mailing list. --

Re: [Maria-discuss] New Question: COUNT not working on XAMPP

2016-02-12 Thread Peter Laursen
Try *SELECT COUNT(*) FROM repairs;* -- ie. no SPACE-character after "COUNT". Built-in functions don't accept this (but Stored Functiosn do as far as I remember).. -- Peter -- Webyog On Fri, Feb 12, 2016 at 3:55 PM, AskMonty KB wrote: > Hello, > > A new question has been asked in "SQL Comman

[Maria-discuss] New Question: COUNT not working on XAMPP

2016-02-12 Thread AskMonty KB
Hello, A new question has been asked in "SQL Commands" by styxlawyer. Please answer it at http://mariadb.com/kb/en/count-not-working-on-xampp/ as the person asking the question may not be subscribed to the mailing list. I have just installed XAMPP version 7.0.2

Re: [Maria-discuss] Performance issues after upgrading to 10.0

2016-02-12 Thread Sergey Petrunia
On Thu, Feb 11, 2016 at 03:43:54PM +0100, azu...@pobox.sk wrote: > Hi, > > we upgraded MariaDB 5.5 to 10.0 on one server last night and are now > dealing with severe performance issues. Here is one case where it's > notable: > > Query - SELECT b.*, p.category_id FROM brands b JOIN products p > US