[Maria-docs] What is MariaDB 10 is rapidly changing
https://mariadb.com/kb/en/what-is-mariadb-100/ for reference • New InnoDB — from MySQL 5.6.5 (MDEV-303) We have a newer InnoDB I believe (from 5.6.10 in 10.0.4) • Performance schema — from MySQL 5.6.5 (without host cache) We now have host cache in P_S in 10.0.4 (https://mariadb.atlassian.net/browse/MDEV-4058) Those were just the items I noted quickly. I think we need to make sure this stuff is usually very updated cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles
On Tue, Oct 8, 2013 at 12:38 AM, Colin Charles <byte@mariadb.com> wrote:
https://mariadb.com/kb/en/what-is-mariadb-100/ for reference
• New InnoDB — from MySQL 5.6.5 (MDEV-303)
We have a newer InnoDB I believe (from 5.6.10 in 10.0.4)
• Performance schema — from MySQL 5.6.5 (without host cache)
We now have host cache in P_S in 10.0.4 (https://mariadb.atlassian.net/browse/MDEV-4058)
Those were just the items I noted quickly. I think we need to make sure this stuff is usually very updated
If you notice anything that needs to be updated please do so. Things do slip through the cracks now and again, especially during alpha and beta stages when there's so much new stuff in every release. I'll double check where the current InnoDB is from and update the page (if you haven't done so already). Thanks for bringing this to my attention! -- Daniel Bartholomew MariaDB
Hi, Colin! On Oct 08, Colin Charles wrote:
https://mariadb.com/kb/en/what-is-mariadb-100/ for reference
• New InnoDB — from MySQL 5.6.5 (MDEV-303)
We have a newer InnoDB I believe (from 5.6.10 in 10.0.4)
• Performance schema — from MySQL 5.6.5 (without host cache)
We now have host cache in P_S in 10.0.4 (https://mariadb.atlassian.net/browse/MDEV-4058)
Those were just the items I noted quickly. I think we need to make sure this stuff is usually very updated
I intend to fix it in a couple of days, feel free to remind me if I forget. Background: I'm giving a talk about MariaDB 10.0 new features, so I've prepared slides and tried create a list of everything we've done. It's a biased non-exhaustive list, though. Small features that are of no interest to the end-user are omitted. Regards, Sergei
On 9 Oct 2013, at 02:29, Sergei Golubchik <serg@mariadb.org> wrote:
Hi, Colin!
On Oct 08, Colin Charles wrote:
https://mariadb.com/kb/en/what-is-mariadb-100/ for reference
• New InnoDB — from MySQL 5.6.5 (MDEV-303)
We have a newer InnoDB I believe (from 5.6.10 in 10.0.4)
• Performance schema — from MySQL 5.6.5 (without host cache)
We now have host cache in P_S in 10.0.4 (https://mariadb.atlassian.net/browse/MDEV-4058)
Those were just the items I noted quickly. I think we need to make sure this stuff is usually very updated
I intend to fix it in a couple of days, feel free to remind me if I forget.
Thanks Serg, Daniel
Background: I'm giving a talk about MariaDB 10.0 new features, so I've prepared slides and tried create a list of everything we've done. It's a biased non-exhaustive list, though. Small features that are of no interest to the end-user are omitted.
How do you think I found these bits ? :-) (presentation writing + looking at changelogs + bzr logs :P) cheers, -colin
Regards, Sergei
-- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles
Hi all In this KB page: https://mariadb.com/kb/en/create-view , I just changed this statement: "This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, LOCK IN SHARE MODE, and PROCEDURE." to: "This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, and LOCK IN SHARE MODE. The PROCEDURE clause cannot be used in a view definition, and it cannot be used if a view is referenced in the FROM clause." I verified this on 5.5: MariaDB [test]> CREATE OR REPLACE VIEW v AS SELECT * FROM t PROCEDURE analyse(); ERROR 1350 (HY000): View's SELECT contains a 'PROCEDURE' clause MariaDB [test]> CREATE OR REPLACE VIEW v AS SELECT * FROM t; Query OK, 0 rows affected (0.72 sec) MariaDB [test]> SELECT * FROM v PROCEDURE analyse(); ERROR 1221 (HY000): Incorrect usage of PROCEDURE and view However, the error is also in the HELP tables. Should I file a bug in JIRA, or is a mail in "maria-docs" enough? Regards Federico
Hi Federico Thanks for the KB fix. The HELP content comes from fill_help_tables.sql, which is generated by MySQL from their documentation, so you should file a bug on their side. I've already adapted the file to replace the MySQL URL's in the HELP with links to our own knowlegebase, but I'm not sure when this will be included in a MariaDB release. A longer-term plan with the HELP is to generate it all from MariaDB's knowledgebase. ian On 09/10/2013 23:45, Federico Razzoli wrote:
Hi all
In this KB page: https://mariadb.com/kb/en/create-view
, I just changed this statement:
"This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, LOCK IN SHARE MODE, and PROCEDURE."
to:
"This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, and LOCK IN SHARE MODE.
The PROCEDURE clause cannot be used in a view definition, and it cannot be used if a view is referenced in the FROM clause."
I verified this on 5.5:
MariaDB [test]> CREATE OR REPLACE VIEW v AS SELECT * FROM t PROCEDURE analyse(); ERROR 1350 (HY000): View's SELECT contains a 'PROCEDURE' clause MariaDB [test]> CREATE OR REPLACE VIEW v AS SELECT * FROM t; Query OK, 0 rows affected (0.72 sec) MariaDB [test]> SELECT * FROM v PROCEDURE analyse(); ERROR 1221 (HY000): Incorrect usage of PROCEDURE and view
However, the error is also in the HELP tables. Should I file a bug in JIRA, or is a mail in "maria-docs" enough?
Regards Federico
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
Thanks for explaining this. The long-term plan looks interesting. May I help somehow? Federico ----- Messaggio originale ----- Da: Ian Gilfillan <launchpad@greenman.co.za> A: maria-docs@lists.launchpad.net Cc: Inviato: Lunedì 14 Ottobre 2013 18:06 Oggetto: Re: [Maria-docs] mistake in kb & help tables Hi Federico Thanks for the KB fix. The HELP content comes from fill_help_tables.sql, which is generated by MySQL from their documentation, so you should file a bug on their side. I've already adapted the file to replace the MySQL URL's in the HELP with links to our own knowlegebase, but I'm not sure when this will be included in a MariaDB release. A longer-term plan with the HELP is to generate it all from MariaDB's knowledgebase. ian On 09/10/2013 23:45, Federico Razzoli wrote:
Hi all
In this KB page: https://mariadb.com/kb/en/create-view
, I just changed this statement:
"This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, LOCK IN SHARE MODE, and PROCEDURE."
to:
"This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, and LOCK IN SHARE MODE.
The PROCEDURE clause cannot be used in a view definition, and it cannot be used if a view is referenced in the FROM clause."
I verified this on 5.5:
MariaDB [test]> CREATE OR REPLACE VIEW v AS SELECT * FROM t PROCEDURE analyse(); ERROR 1350 (HY000): View's SELECT contains a 'PROCEDURE' clause MariaDB [test]> CREATE OR REPLACE VIEW v AS SELECT * FROM t; Query OK, 0 rows affected (0.72 sec) MariaDB [test]> SELECT * FROM v PROCEDURE analyse(); ERROR 1221 (HY000): Incorrect usage of PROCEDURE and view
However, the error is also in the HELP tables. Should I file a bug in JIRA, or is a mail in "maria-docs" enough?
Regards Federico
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
participants (5)
-
Colin Charles -
Daniel Bartholomew -
Federico Razzoli -
Ian Gilfillan -
Sergei Golubchik