find, at
https://kb.askmonty.org/en/mysqld-options-full-list/, it's described
more generally, not specifically mentioning MyISAM. Does this variable
apply to other storage engines as well now (Aria?), or still only MyISAM?
thanks,
ian gilfillan
___
Hi
Does the bulk insert optimization used for MyISAM tables - the cache
determined by the bulk_insert_buffer_size system variable - also apply
to Aria (or any other) tables in the same way?
thanks,
ian
___
Mailing list: https://launchpad.net/~maria
Thanks Kristian, very thorough docs! I've formatted and added to the
knowledgebase (incorporating Arjen's suggestion) at
https://kb.askmonty.org/en/global-transaction-id/
I'll fan out the changes to other affected articles (syntax, server
variables, replication) during the week.
On 06/05/2013 15
I'm documenting the status variables at the moment, and have a question
about Empty_queries vs Com_empty_queries.
Com_empty_queries is not incremented when an empty result is returned,
and appears to be incremented only when an empty query is sent to the
server, eg:
mysql --comments -e '-- s
What does the Syncs server status variable record, and when was it
introduced? I can't seem to find this documented anywhere.
thanks,
ian gilfillan
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-devel
I've been cleaning up the questions on the knowledgebase, but there are
still a few open ones that need a response. If anyone can help, please
pay a visit. Here are the ones still needing feedback:
Multiple error logs: https://kb.askmonty.org/en/multiple-err-logs/
Query optimizer:
https://kb.a
How can one find a definitive list of reserved words for a particular
version? The comments in sql/lex.h say that that's a list of all
reserved words and functions, but it appears to contain some words that
are neither (such as ACTION).
SELECT * FROM mysql.help_keyword also lists ACTION
ACTIO
Hi
SELECT COT(0) returns:
ERROR 1690 (22003): DOUBLE value is out of range in 'cot(0)'
in both MariaDB 10 and 5.5, but in MySQL 5.1 it returns NULL.
I can't find a changelog reference to this, but I see it's still
documented as returning NULL in MySQL 5.5 (I don't have this to test
on). Is t
Hi Kristian
Sure, will do.
ian
On 23/08/2013 14:11, Kristian Nielsen wrote:
Hi Daniel, Ian,
I have implemented a new system variable for global transaction ID and pushed
it into 10.0-base (so it should appear in 10.0.5 I suppose).
I have written some text for documenting the new variable, ap
Hi Roberto
The page you linked is from the SQL-99 book, and is not specific to
MariaDB. You were looking for:
https://kb.askmonty.org/en/alter-table/
which does (very) briefly mention ALTER ONLINE TABLE
There's been quite a bit of confusion about the SQL-99 book. It should
have some prominent
ow could i help with these docs? What mail
list should i send doubts about docs? Devel, discuss, anyother?
Thanks
Em 26/08/2013 04:49, "Ian Gilfillan" <mailto:launch...@greenman.co.za>> escreveu:
Hi Roberto
The page you linked is from the SQL-99 book, and is not
Hi
I would like to document the Opened_plugin_libraries status variable,
introduced in MariaDB 10.0, but can't understand what it's all about.
I have looked at:
http://lists.askmonty.org/pipermail/commits/2013-April/004595.html
but it's not really making sense what it's testing.
In my own set
There are quite a few unanswered questions in the Knowledge Base
https://mariadb.com/kb/en/+questions/
If anyone knowledgeable in those areas can help answer some of these,
even just a request for more info, that would be great :)
thanks,
ian
___
Ma
Hi Jocelyn
Is there a specific KB entry for MariaDB 10.0.6 reserved words ? (I
only see an entry for 5.5 here :
https://mariadb.com/kb/en/reserved-words/ )
There isn't yet an entry for 10.0 reserved words in the Knowledge Base,
but I will look at adding the details to the page you mentioned
Hi
I have been struggling to get OQGRAPH working with MariaDB 10.0.7. The
system has been hanging and crashing frequently. I will post as bugs if
I can recreate them, but this question is simply, how can I update the data?
On a new install of MariaDB 10.0.7 and OQGRAPH
- I create the sample t
There are a few open questions on the Knowledge Base - some have been
around a while, and it would be great if anyone can answer them:
1) Licensing question about MariaDB and dot net Connector:
https://mariadb.com/kb/en/licencing-of-mariadb-and-mysql-dot-net-connector/
2) Query on whether the M
Hi
The schedule for the MariaDB Developers (Un)Conference (to be held in
New York, April 9 and 10) is being fleshed out, so this is a last call
to add or vote for any sessions. You can update the spreadsheet directly:
https://docs.google.com/spreadsheets/d/1mUFk5gd0fd6amjxGhb7hG1xRHQdh-9qxavp5
In order to document this properly (and in response to
https://jira.mariadb.org/browse/MDEV-13236) , I want to clarify a few
things:
As I understand it:
* the variable is dynamic, so changes becomes effective immediately
* tables are created immediately whenever a transaction is seen from a
sp
The dates for the Developers Unconference in Shenzhen, China, are coming
up fast.
This is our first official event in Asia, and will be held from 13
November - 17 November.
13 November - new contributor day
14-15 November - traditional developers unconference
16-17 November - patch days
As a
simultaneous_assignment would be my choice; as you say it's the most
accurate, if a little long.
30/01/2018 13:24, Sergei Golubchik wrote:
Hi, Russell!
On Jan 29, Russell J.T. Dyer wrote:
Is this mode related only to UPDATE and this feature? If so, maybe it
could be something like one of th
A final reminder about the Developers Unconference happening in New York
on Sat 24 and Sun 25 February, just before M|18.
https://mariadb.org/2018-mariadb-developers-unconference/
Please sign up on the Meetup page if you are going to be attending:
https://www.meetup.com/MariaDB-Developers/events
Hi
A reminder about the next MariaDB Developers Unconference, which will be
held in Tampera, Finland, from 26 June to 29 June.
This will be a four-day event; the first day focusing on new
contributors, the 2nd and 3rd the regular Unconference sessions and
discussions, and the 4th day on gett
The best way is to write a comment in the ticket, stating that you are
interested in working on it and some details, and requesting that it be
assigned to you.
On 11/10/2018 16:41, Takashi Sasaki wrote:
Hello,
I wanted to contribute something to MariaDB, so I signed up to Jira,
but how can I
The MariaDB Developer Unconference is taking place in New York 23-24
Feb, just before OpenWorks:
https://mariadb.org/2019-developers-unconference-new-york/
Please sign up on the Meetup page:
https://www.meetup.com/MariaDB-Developers/events/256385430/ - security
is very tight at the building,
Thanks for the alert - I've added this to JIRA:
https://jira.mariadb.org/browse/MDEV-17836
Ideally all issues that require documentation updates should have a
related documentation task - at the moment there are still numerous
changes that are only picked up afterwards.
On 2018/11/26 13:17,
On 2018/11/26 13:32, Alexander Barkov wrote:
Should developers create related documentation tasks to MDEVs
that need attention from the documentation team?
Yes, please do.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : m
I see the eq_range_index_dive_limit default has been set to 10 in
10.4.3. I see some different EXPLAIN results in the commit, but I don't
see any notes on why or how 10 was chosen over any other value. MySQL
increased the default to 200 from MySQL 5.7.4, based it seems on some
community feedbac
A final reminder about the MariaDB Developers Unconference taking place
23 - 24 February in New York, just before OpenWorks.
We're almost at capacity, so if you haven't signed up yet, please do so
soon. Details about where to sign up and how to suggest sessions are at
https://mariadb.org/2019-
On 23/04/2014 09:28, Alexander Barkov wrote:
Jan, can you please update the manual?
Sure, will do. Thanks for the detailed writeup. Which release is this
variable scheduled to be included in?
It's Ian, not Jan btw, although all comes from one and the same root
name originally ;)
ian
Hi Alexander
I will document these shortly, but please clarify the version.
https://mariadb.atlassian.net/browse/MDEV-4051 states the fix version as
10.1.0, but I presume this isn't correct. Will they be in 10.0.12?
thanks,
ian
On 30/05/2014 14:28, Alexander Barkov wrote:
Hello Ian,
I have
I like Jocelyn's solution. The whole situation is quite messy with all
sorts of edge cases, but this seems to make the best of it. THE SHOW
CREATE statement will be functional, and the metadata will be displayed
in a readable form.
On 08/07/2014 14:21, Jocelyn Fournier wrote:
This is easy t
Hi
I am trying to document the CONNECT system variables at
https://mariadb.com/kb/en/mariadb/documentation/storage-engines/connect/connect-system-variables/
but I can't seem to find much documentation in the code. I managed to
put something together from Olivier's notes in JIRA for some of the
Thanks, the new page should rather use 8 as the default, so I've changed
it there and mentioned the Windows 32-bit oddity on the other pages.
On 06/08/2014 23:45, Jeremy Cole wrote:
Haha, this is the code in storage/innobase/handler/ha_innodb.cc:
3260 ▸ if (innobase_buffer_pool_instance
There was a suggestion on the docs mailing list that we rename Virtual
Columns to Computed Columns. I think it makes sense, but before we
implement I want to make sure everyone is happy with the change, so am
repeating it here as not everyone follows docs.
Currently, we use the term Virtual Co
On 01/19/2015 03:50 PM, Peter Laursen wrote:
1) As regards terminology, IMHO it would be logical if 'computed' is
used as the "upperlevel" term. "sublevel' terms would be 'virtual'
and 'persistent' (ie. a 'computed' column may be either 'virtual' or
'persistent').
Yes, that's right.
2) It i
Seeing as there's already discussion starting, and already tasks labeled
gsoc2015 in Jira, I've created the GSoC 2015 page on the Knowledge Base
- https://mariadb.com/kb/en/mariadb/google-summer-of-code-2015/
Feel free to add details there.
ian
___
I understand that the statistics would have some meaning, and understand
that there's no actual data being sent, etc.
However, enabling the feedback plugin by default IS going to create a
whole lot of negative publicity for MariaDB. Is the limited data the
feedback plugin provides worthwhile?
I think the dates listed at https://wiki.debian.org/LTS should be used
as guidelines.
Squeeze "LTS" will be supported until Feb 2016.
On 06/05/2015 21:08, Otto Kekäläinen wrote:
Hello!
2015-05-06 21:42 GMT+03:00 Daniel Bartholomew :
On the MariaDB Deprecation Policy page we list planned depr
This has now been added to the documentation :)
On 20/06/2015 09:46, Daniel Black wrote:
Will only get used if documented:
https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/ +
https://mariadb.com/kb/en/mariadb/server-system-variables/
- On 18 Jun, 2015, at 6:45 PM, Ja
Thanks, will do.
On 27/07/2015 13:50, Kristian Nielsen wrote:
I was asked about the difference between master_use_gtid = slave_pos or
current_pos. This comes up often, and I thought the below text, which I used
to answer the question earlier, might be helpful.
Ian, do you think you could incorp
From a user's perspective, I like the idea of introducing the change
for both parallel and non-parallel in 10.1.
On 15/10/2015 08:16, Kristian Nielsen wrote:
It was brought to my attention an issue with parallel replication and the
Seconds_Behind_Master field of SHOW SLAVE STATUS. I have a poss
06/11/2015 07:51, Peter Laursen wrote:
I reported this bug report to Oracle:
http://bugs.mysql.com/bug.php?id=79148
It is almost the same in MariaDB - but the error message is different, see
SELECT VERSION(); -- 10.1.2-MariaDB-log
CREATE TABLE `vc_test`.`t1`(
`id` INT NOT NULL,
`id3` INT
lients
would 'abort on error' and flood its log with error messages.
-- Peter
On Fri, Nov 6, 2015 at 11:32 AM, Ian Gilfillan <mailto:i...@mariadb.org>> wrote:
06/11/2015 07:51, Peter Laursen wrote:
I reported this bug report to Oracle:
http://bugs.my
On 14/11/2015 11:44, Kristian Nielsen wrote:
Ian, do you have enough information from this thread that you could update
the docs in the knowledgebase accordingly?
Thanks, yes, I will update the documentation around the release time.
___
Mailing list:
On 25/11/2015 15:59, Otto Kekäläinen wrote:
Hello!
No decision about this has yet been made. I reviewed the thread and
Discourse seems to have most support.
Is here 1 or even better 2 persons who would like to volunteer?
Discourse looks good, but wouldn't it make more sense if self-hosting to
u
Hi
I quite often find out about a new feature after release, either by
looking through the changelog and commits, or because someone points out
it's missing from the documentation.
It's time-consuming trying to keep track of every change, and I miss
things (especially in non-default plugins etc),
The MariaDB Developers Meetup will be taking place from the 6th to the
8th of October in Amsterdam.
https://mariadb.org/2016-mariadb-developers-meetup/
Details of where to sign up, and where to suggest topics for the meetup
are on that page. Please feel free to suggest topic you're interested i
A reminder that the MariaDB Developers Meetup will be taking place from
the 6th to the 8th of October in Amsterdam.
Please feel welcome to attend, sign up on the Meetup Group, as well to
propose a topic, or vote for an existing topic.
Details at https://mariadb.org/2016-mariadb-developers-meet
Thanks - I'm away until the 22nd, will add it the KB when I get back.
On 16/10/2016 23:58, Kristian Nielsen wrote:
Re: https://jira.mariadb.org/browse/MDEV-7145
Delayed replication (a feature shipped in MySQL 5.6) has been a MariaDB
I have now pushed this into 10.2.
Ian, I have written so
Responding to the portion of the thread extracted below, "INSERT, INSERT
.. SELECT don't increment partitions" is not meaningless, but both
"INSERT, INSERT .. SELECT don't increment the number of partitions" and
"INSERT, INSERT .. SELECT don't auto-create partitions" are better.
It comes down
50 matches
Mail list logo