Re: [Maria-discuss] Charsets and collations

2018-04-20 Thread Peter Laursen
Hi Peter, > > On 06/16/2017 04:01 PM, Peter Laursen wrote: > >> Does anybody know if there are any plans to bring collations added in >> MySQL 8 - refer >> http://mysqlserverteam.com/new-collations-in-mysql-8-0-0/ - to MariaDB >> and are there any plans to change the

Re: [Maria-discuss] MariaDB 10.3.4 consumes extremely much CPUonWindows.

2018-01-20 Thread Peter Laursen
; > > Oh ok, so it is a “maxi” dump. But stull ,when you just start the > service, the most of the memory allocated by the process is zeroed , thus > zipping the dmp should I think make it much smaller. > > You can share via Google drive, sure. > > > > > >

[Maria-discuss] MariaDB 10.3.4 consumes extremely much CPU on Windows.

2018-01-20 Thread Peter Laursen
On a 4-core (4 physical, 8 logical cores), 3.5 Ghz box, MariaDB 10.3.4 consumes typically 35-40% of available CPU even when completely idle according to Task Manager. Please see image. I cannot tell if previous 10.3 versions also did, as I don't have 10.3 running constantly in the backgorund. I

Re: [Maria-discuss] MariaDB 10.3.4 installation blocked ny MS "WindowsDefender" malware protection

2018-01-19 Thread Peter Laursen
Ikke-godkendte" in Dansih means "non-approved" in English). On Fri, Jan 19, 2018 at 2:17 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > I would translate the dialog like this (but on a system with an English > locale it may not be exactly like this). > &

Re: [Maria-discuss] MariaDB 10.3.4 installation blocked ny MS "WindowsDefender" malware protection

2018-01-19 Thread Peter Laursen
ot see what > we’re doing wrong, we’ll check. Maybe the new certificate needs some > reputation score, I’m not sure about it. > > > > > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > *From: *Peter Laursen

Re: [Maria-discuss] MariaDB 10.3.4 installation blocked ny MS "Windows Defender" malware protection

2018-01-19 Thread Peter Laursen
Using Win10 Pro, BTW. On Fri, Jan 19, 2018 at 1:40 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > Please see image. (you can clik "more info" adn the option to "install > anyway" will appear. > > Did you forget to sign the installer this

[Maria-discuss] MariaDB 10.3.4 installation blocked ny MS "Windows Defender" malware protection

2018-01-19 Thread Peter Laursen
Please see image. (you can clik "more info" adn the option to "install anyway" will appear. Did you forget to sign the installer this time or has some certificate expired? -- Peter -- Webog ___ Mailing list: https://launchpad.net/~maria-discuss Post

Re: [Maria-discuss] ALTER TABLE removes check constraint

2017-11-22 Thread Peter Laursen
ECK) CONSTRAINTs for a table (or a complete database/schema)? I don't find anything in Information_Schema anywhere. Such 'metadata instrumentation' is extremely important for client development. -- Peter On Wed, Nov 22, 2017 at 3:28 PM, Peter Laursen <peter_laur...@webyog.com> wrote: >

Re: [Maria-discuss] ALTER TABLE removes check constraint

2017-11-22 Thread Peter Laursen
ot unnamed - CHECK constraints! But thanks for the explanation. -- Peter On Wed, Nov 22, 2017 at 2:56 PM, Sergei Golubchik <s...@mariadb.org> wrote: > Hi, Peter! > > On Nov 22, Peter Laursen wrote: > > Test case: > > > > CREATE TABLE checks (a INT CHECK (a>2), b I

[Maria-discuss] ALTER TABLE removes check constraint

2017-11-22 Thread Peter Laursen
Test case: CREATE TABLE checks (a INT CHECK (a>2), b INT CHECK (b>2), CONSTRAINT a_greater CHECK (a>b)); SHOW CREATE TABLE checks; ALTER TABLE `test`.`checks` CHANGE `a` `a` INT(11) NULL; SHOW CREATE TABLE checks; /' -- and now one constraint is gone! CREATE TABLE `checks` ( `a` int(11) DEFAULT

Re: [Maria-discuss] 10.2.7 and xtradb in changelog

2017-07-13 Thread Peter Laursen
I think this is another result of changelogs being maintaned automatically (as Harald already noticed). Changelogs is MariaDB are hardly usable unless you are deeply involved in the coding yourself. Unlike MySQL/Oracle be where you may actually be e4nriched by skim-reading changelogs for new

Re: [Maria-discuss] JSON in MariaDB 10.2.7 and MySQL

2017-07-13 Thread Peter Laursen
I personally think like this col1 JSON being equal to col1 LONGTEXT CHARACTER SET utf8mb4 CHECK(JSON_VALID(col1)) .. would be nice. -- Peter On Thu, Jul 13, 2017 at 12:03 PM, Sergei Golubchik <s...@mariadb.org> wrote: > Hi, Peter! > > On Jul 13, Pete

Re: [Maria-discuss] JSON in MariaDB 10.2.7 and MySQL

2017-07-13 Thread Peter Laursen
uot; + ")"). -- Peter On Thu, Jul 13, 2017 at 10:50 AM, Peter Laursen <peter_laur...@webyog.com> wrote: > -- MariaDB 10.2.7 > CREATE TABLE `jsontst`( `id` INT NOT NULL AUTO_INCREMENT, `str` JSON, > PRIMARY KEY (`id`) ) ENGINE=Aria CHARSET=latin1; > SHOW CREATE TAB

[Maria-discuss] Charsets and collations

2017-06-16 Thread Peter Laursen
Does anybody know if there are any plans to bring collations added in MySQL 8 - refer http://mysqlserverteam.com/new-collations-in-mysql-8-0-0/ - to MariaDB and are there any plans to change the default charset to a unicode-based one? -- Peter -- Webyog

Re: [Maria-discuss] thank you for getting MyRocks into MariaDB 10.2

2017-05-24 Thread Peter Laursen
I have figured out already. Found the link myself. Thanks anyway. -- Peter On Wed, May 24, 2017 at 1:45 PM, Vladislav Vaintroub <vvaintr...@gmail.com> wrote: > > > On 24.05.2017 12:22, Peter Laursen wrote: > > I don't have MyRocks storage engine on my MariaDB 10.2.6 serve

Re: [Maria-discuss] thank you for getting MyRocks into MariaDB 10.2

2017-05-24 Thread Peter Laursen
Sorry .. please ignore my mail. It was intended for other recipients. -- Peter On Wed, May 24, 2017 at 12:22 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > I don't have MyRocks storage engine on my MariaDB 10.2.6 server according > to SHOW ENGINES. So either it is n

Re: [Maria-discuss] thank you for getting MyRocks into MariaDB 10.2

2017-05-24 Thread Peter Laursen
I don't have MyRocks storage engine on my MariaDB 10.2.6 server according to SHOW ENGINES. So either it is not available in Windows yet or it is a plugin that must be enabled like is the case with TokuDB. It is an important storage engine and has to potential to become as big as InnoDB IMO (unlike

Re: [Maria-discuss] MariaDB Server maintenance policy for 10.0

2017-04-26 Thread Peter Laursen
Even OpenSuSE LEAP 42.3 (latest OpenSuSE release) ships with MariaDB 10.0.x. -- Peter On Wed, Apr 26, 2017 at 4:40 PM, Colin Charles wrote: > Hi! > > I just read: > https://mariadb.org/about/maintenance-policy/ > > It says the 5 year boundary date for support ending

Re: [Maria-discuss] 10.1.x: Got packet bigger than 'max_allowed_packet' bytes

2017-02-16 Thread Peter Laursen
The particular error message "Got packet bigger than 'max_allowed_packet' bytes" is returned from the client and not the server. Both the server and the client has a "max_allowed_packet" setting. The client-one is listed here https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html.

Re: [Maria-discuss] LOAD DATA LOCAL INFILE

2017-02-15 Thread Peter Laursen
According to https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_local_infile this variable has GLOBAL scope (and I don-t think mariaDB has changed anything here. The SESSION-scope value is always inherited from the GLOBAL setting. 'local-infile' is also considered a

Re: [Maria-discuss] Download speeds on archive.mariadb.org

2016-11-12 Thread Peter Laursen
In my post kbps = kilo *BIT* per second. Maybe Guillaume means kilo *BYTE* per seocnd? Then we are not far from each others (but in my world it is common practice to use BIT for network transfer and BYTE for storage). - Peter On Sat, Nov 12, 2016 at 4:36 PM, Peter Laursen <peter_l

Re: [Maria-discuss] Download speeds on archive.mariadb.org

2016-11-12 Thread Peter Laursen
Right now I get around 50 kbps on archive.mariadb.org. This means that a complete server package (with tests etc.) could take ~10 hours to download. Or even 4 days with the 6 kbps that Guillaume experiences (all roughly calculated numbers). I understand the probems with hosting/storage (incl.

Re: [Maria-discuss] MYSQL_OPT_CONNECT_TIMEOUT default?

2016-11-03 Thread Peter Laursen
Does "undefined" in practice mean "none" or "random/non-deterministic" then? -- Peter On Wed, Nov 2, 2016 at 11:52 PM, Sergei Golubchik <s...@mariadb.org> wrote: > Hi, Peter! > > According to Georg, MariaDB Connector/C default is 0, which is >

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-10-16 Thread Peter Laursen
ok .. I should have checked properly! :-( On Sun, Oct 16, 2016 at 6:15 PM, Sergei Golubchik <s...@mariadb.org> wrote: > Hi, Peter! > > On Oct 16, Peter Laursen wrote: > > Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it > > from there into

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-10-16 Thread Peter Laursen
CONSTRAINT check_i_must_be_between_7_and_12 > FOREIGN KEY (i_must_be_between_7_and_12) > REFERENCES truth (t) > ); > > On Wed, Apr 6, 2016 at 6:46 PM, Pantelis Theodosiou <yperc...@gmail.com> > wrote: > >> >> >> On Mon, Apr 4, 2016 at 2:10 PM, Peter L

Re: [Maria-discuss] MariaDB Server 10.3 notes

2016-10-13 Thread Peter Laursen
Personally I think (as told a few times before when this discussion arrived in this mailing list) that such feature should not be an *external language* as it should not IMO use what is installed independentlyof MysqL/MariaDB on the system. This lanugage intepreters should ship with the server -

Re: [Maria-discuss] MariaDB Server 10.3 notes

2016-10-13 Thread Peter Laursen
.. so +1 for Rocks as compared to Toku: cross-platform support. -- Peter On Thu, Oct 13, 2016 at 1:49 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > I think Sergei G. told me once that TokuDB would not compile with Visual > Studio and that MariaDB would only try to fix i

Re: [Maria-discuss] MariaDB Server 10.3 notes

2016-10-13 Thread Peter Laursen
, Vladislav Vaintroub <vvaintr...@gmail.com> wrote: > > > On 13.10.2016 12:00, Peter Laursen wrote: > > I have a few questions > > 1) will RocksDB be available on Windows? ToduDB isn't (because it does not > compile on Visual Studio I think). > > Personally, I

Re: [Maria-discuss] MariaDB Server 10.3 notes

2016-10-13 Thread Peter Laursen
Now I remember that the name of the storage engine, I referred, was PBXT. -- Peter On Thu, Oct 13, 2016 at 12:00 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > I have a few questions > > 1) will RocksDB be available on Windows? ToduDB isn't (because it does not >

Re: [Maria-discuss] MariaDB Server 10.3 notes

2016-10-13 Thread Peter Laursen
I have a few questions 1) will RocksDB be available on Windows? ToduDB isn't (because it does not compile on Visual Studio I think). 2) How large a set of configuraton options will RocksDB have? InnoDB now has100+ I guess, and that is a mess IMO. I liked the simplicity of the now dead Primebase

Re: [Maria-discuss] MariaDB 10.1.16 now available

2016-07-18 Thread Peter Laursen
And still no repo for OpenSuSE Leap 42.1 ?? -- Peter On Mon, Jul 18, 2016 at 5:23 PM, Daniel Bartholomew wrote: > The MariaDB project is pleased to announce the immediate availability > of MariaDB 10.1.16. This is a Stable (GA) release. See the Release > Notes and Changelog

Re: [Maria-discuss] AUTO_COMMIT=0 for a session - READ inconsistencyi - ssue or no issue

2016-06-09 Thread Peter Laursen
I think you should refer https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html. It looks like your transaction isolation level is set to REPEATABLE_READ (what is also default in MySQL/MariaDB - unlike in Oracle for instance). If you want to see COMMITS from other sessions in your current

[Maria-discuss] Virtual CHECK constraint using Virtual columns

2016-04-04 Thread Peter Laursen
As described in this Blog http://mablomy.blogspot.dk/2016/04/check-constraint-for-mysql-not-null-on.html. A very nice hack/trick IMO. However it is not working with MariaDB as VC's cannot be declared NOT NULL. What prevents that? -- Peter -- Webyog

Re: [Maria-discuss] Collations, trailing spaces and unique indexes

2016-03-11 Thread Peter Laursen
An idea that may work for you could be to TRIM() - http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_trim - the original varchar column into a virtual (PERSISTENT) column, and add an index on this column? Peter On Fri, Mar 11, 2016 at 12:59 PM,

Re: [Maria-discuss] Is there something like "best practices" to migrate from Paradox to MariaDB?

2016-02-17 Thread Peter Laursen
directly (as the client/server protocol is the same for 32 and 64 bit servers). -- Peter On Wed, Feb 17, 2016 at 2:28 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > BTW: as an ODBC driver exists, I believe you can also connect to your > Paradox database file with the "connect e

Re: [Maria-discuss] Is there something like "best practices" to migrate from Paradox to MariaDB?

2016-02-17 Thread Peter Laursen
clamer. I never used the Connect engine. You may run into some datatype compatibility issues between Paradox and MariaDB and ODBC/ANSI SQL). In SQLyog import-tool manual datatype mapping/conversion is possible if defaults fail for some reason -- Peter On Wed, Feb 17, 2016 at 2:17 PM, Peter Laursen <p

Re: [Maria-discuss] Is there something like "best practices" to migrate from Paradox to MariaDB?

2016-02-17 Thread Peter Laursen
and run into issues, just contact us at support@webyog com (or use our Forums). It should work and if it doesn't, we will fix it. Attaching a screenshot of the 32 bit ODBC drivers in Win10 64 bit (Danish language interface - I hope that the language is not a "blocker"). -- Peter Lau

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

[Maria-discuss] JSON in MySQL and MariaDB

2016-02-11 Thread Peter Laursen
capabilites in our (SQLyog) GUI client soon. But the 'uneven' implementation in MariaDB and MySQL is indeed a problem. I think the reply to questions above would be approproate for a Blog, BTW. (@Anders - something for you?) -- Peter Laursen -- Webyog

Re: [Maria-discuss] MariaDB 10.1.11 now available

2016-01-30 Thread Peter Laursen
Still no OpenSuSE LEAP repo? -- Peter On Fri, Jan 29, 2016 at 7:52 PM, Daniel Bartholomew wrote: > The MariaDB project is pleased to announce the immediate availability > of MariaDB 10.1.11. This is a Stable (GA) release. See the Release > Notes and Changelog for details. >

Re: [Maria-discuss] C header files in binary distribution on Windows

2016-01-21 Thread Peter Laursen
OK. And welcome back, BTW. You have been missed! -- Peter On Wed, Jan 20, 2016 at 10:17 PM, Vladislav Vaintroub <vvaintr...@gmail.com> wrote: > > > On 1/20/2016 4:40 PM, Peter Laursen wrote: > >> I have an almost fresh Win10 installation with MariaDB 10.1.9 installe

[Maria-discuss] C header files in binary distribution on Windows

2016-01-20 Thread Peter Laursen
I have an almost fresh Win10 installation with MariaDB 10.1.9 installed with .msi installer from this link (I believe) https://downloads.mariadb.org/interstitial/mariadb-10.0.21/win32-packages/mariadb-10.0.21-win32.msi/from/http%3A//mirror.one.com/mariadb/. No older version has been installed on

Re: [Maria-discuss] C header files in binary distribution on Windows

2016-01-20 Thread Peter Laursen
Sorry, my link was wrong. It was 10.1.9 appearing on this page https://downloads.mariadb.org/ (now replaced with 10.1.10). And it was the 64 bit.msi installer. -- Peter On Wed, Jan 20, 2016 at 4:40 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > I have an almost fresh Win10 ins

Re: [Maria-discuss] After Fedora 22->23 update maria db doesn't start

2015-11-24 Thread Peter Laursen
" .. that mysql_upgrade *complains* about", I meant. On Tue, Nov 24, 2015 at 3:01 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > I think that maybe the MySQL installation was damaged before the OS > upgrade (for instance files accidentially deleted but going un-no

Re: [Maria-discuss] After Fedora 22->23 update maria db doesn't start

2015-11-24 Thread Peter Laursen
I think that maybe the MySQL installation was damaged before the OS upgrade (for instance files accidentially deleted but going un-noticed). @Carl - do you have .frm, .MYI and .MYD files for the tables that mysql_upgrade completes about? -- Peter On Tue, Nov 24, 2015 at 2:27 PM, Reindl Harald

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

2015-11-12 Thread Peter Laursen
In the page where Ian linked to there should now be comparison with MySQL 5.7 (replacing or in addition to MySQL 5.6), right? -- Peter On Thu, Nov 12, 2015 at 2:55 PM, Ian Gilfillan wrote: > This is documented on the page comparing MariaDB 10.1 and MySQL 5.6 > defaults: > >

Re: [Maria-discuss] verifying a table is using autogenerated PK or not

2015-04-17 Thread Peter Laursen
Just an idea: It could be because your PK-column is an int(12). An INT is an int(11) unless column length is defined otherwise specifically. An int(12) is unusual datatype (it does create however and returns the number formatted as a 12-character string as expected, so it is valid, it seems).

Re: [Maria-discuss] Does user have SUPER privilege?

2015-04-15 Thread Peter Laursen
What about SHOW GRANTS FOR 'user'@'host' ?? Refer https://dev.mysql.com/doc/refman/5.6/en/show-grants.html On Wed, Apr 15, 2015 at 7:45 PM, Rasmus Johansson ras...@mariadb.com wrote: Hi, I was wondering if there is a straight forward way to check whether a user has SUPER privileges or

Re: [Maria-discuss] R: Stored Procedure debugger from Peter Gulutzan and Trudy Pelzer

2015-03-12 Thread Peter Laursen
But it depends on functionalities available only in a Linux shell, I think, and is not cross-platform? Further I agree with Federico that it is a server-side *API* we need, so that functionalities are exposed to any client that wants to use it. -- Peter On Thu, Mar 12, 2015 at 7:48 AM,

Re: [Maria-discuss] R: Stored Procedure debugger from Peter Gulutzan and Trudy Pelzer

2015-03-12 Thread Peter Laursen
license? On Thu, Mar 12, 2015 at 8:46 PM, Peter Gulutzan pgulut...@ocelot.ca wrote: Dear Alexander Barkov, Thanks for looking at the debugger feature of Ocelot's open-source GUI client. As you saw, ocelotgui supports breakpoints, flow control, and context inspection. Recently we added

Re: [Maria-discuss] stored programs

2015-03-03 Thread Peter Laursen
Your 3rd test case takes 2:02 in MariaDB 10.1 and 2:13 in MySQL 5.6 on my system (when otherwise idle) . -- Peter On Tue, Mar 3, 2015 at 1:58 PM, Federico Razzoli federico_...@yahoo.it wrote: I made some quick test to show what I mean by performance problem. Note that I'm not saying the the

Re: [Maria-discuss] stored programs

2015-03-03 Thread Peter Laursen
version your whole code base and push out a new version to use a new name. Sent from my iPhone On Mar 3, 2015, at 6:22 AM, Peter Laursen peter_laur...@webyog.com wrote: If this You can't drop a busy proc in production to replace it was for me, then note the passage from my blog: you can add

Re: [Maria-discuss] stored programs

2015-03-03 Thread Peter Laursen
on your system too, right? --Justin Sent from my iPhone On Mar 3, 2015, at 6:18 AM, Peter Laursen peter_laur...@webyog.com wrote: Your 3rd test case takes 2:02 in MariaDB 10.1 and 2:13 in MySQL 5.6 on my system (when otherwise idle) . -- Peter On Tue, Mar 3, 2015 at 1:58 PM, Federico

Re: [Maria-discuss] stored programs

2015-03-03 Thread Peter Laursen
, Peter Laursen peter_laur...@webyog.com ha scritto: Oggetto: Re: [Maria-discuss] stored programs A: Federico Razzoli federico_...@yahoo.it Cc: Maria Discuss maria-discuss@lists.launchpad.net Data: Martedì 3 marzo 2015, 12:48 1) +1 for ability to prepare a statement from a local variable

Re: [Maria-discuss] stored programs

2015-03-03 Thread Peter Laursen
If this You can't drop a busy proc in production to replace it was for me, then note the passage from my blog: you can add a IN-parameter *(debug: integer)* to a Stored Procedure paramer-list and *CALL mysp(….,0|1)* what would then control if the stored program should enter or bypass debugging

Re: [Maria-discuss] stored programs

2015-03-03 Thread Peter Laursen
Mar 3/3/15, Justin Swanhart greenl...@gmail.com ha scritto: Oggetto: Re: [Maria-discuss] stored programs A: Peter Laursen peter_laur...@webyog.com Cc: Federico Razzoli federico_...@yahoo.it, Maria Discuss maria-discuss@lists.launchpad.net Data: Martedì

Re: [Maria-discuss] MariaDB 10: how to convert Aria table to InnoDB?

2015-03-02 Thread Peter Laursen
I agree with Harald here! -- Peter On Mon, Mar 2, 2015 at 2:37 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 02.03.2015 um 14:26 schrieb Ian Gilfillan: This is probably because strict mode is set. If unset, it should return a warning, not an error. From MariaDB 10.1.2, you can use:

Re: [Maria-discuss] MariaDB 10: how to convert Aria table to InnoDB?

2015-03-02 Thread Peter Laursen
Actually I think the behavior of MariaDB here is somewhat consistent with how MySQL always did - see CREATE TABLE blah (id INT) ENGINE = MYISAM MAX_ROWS = 500; ALTER TABLE blah ENGINE = INNODB; SHOW CREATE TABLE blah; /* CREATE TABLE `blah` ( `id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT

Re: [Maria-discuss] MariaDB 10: how to convert Aria table to InnoDB?

2015-03-02 Thread Peter Laursen
At least the error/warning message is wrong IMO. this Table storage engine 'InnoDB' does not support the create option 'TRANSACTIONAL=1' should rather be something like Table storage engine 'InnoDB' does not support the create option 'TRANSACTIONAL'. We preserve it though so that ALTER

Re: [Maria-discuss] MariaDB 10: how to convert Aria table to InnoDB?

2015-03-02 Thread Peter Laursen
Thanks to Jean. Even this works: CREATE TABLE `systemevents` ( `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `DeviceReportedTime` DATETIME DEFAULT NULL, `FromHost` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL, `Message` TEXT, `SysLogTag` VARCHAR(60) DEFAULT

Re: [Maria-discuss] Bls: Serious problem with latest (10.0.16) Windows installer - destroys services.

2015-02-28 Thread Peter Laursen
Problem seems to persist in 10.0.17. Service is not created. :-( -- Peter On Sun, Feb 1, 2015 at 5:50 PM, Elena Stepanova ele...@montyprogram.com wrote: Hi Peter, On 01.02.2015 19:27, Peter Laursen wrote: I have already re-created the removed/destroyed MariaDB 5.5 and 10.0 services (one

[Maria-discuss] Serious problem with latest (10.0.16) Windows installer - destroys services.

2015-01-31 Thread Peter Laursen
I have MariaDB 5.5, 10.0 and 10.1 installed (as Windows services named 'maria55'. 'maria10' and 'maria10_1' ) and always update them to latest soon after an update is available. Yesterday morning I installed 10.0.16 on top of 10.0.15 using the .msi installer. When I tried to connect to it a few

Re: [Maria-discuss] Serious problem with latest (10.0.16) Windows installer - destroys services.

2015-01-31 Thread Peter Laursen
...@mariadb.org wrote: Hi, Peter! On Jan 31, Peter Laursen wrote: I have MariaDB 5.5, 10.0 and 10.1 installed (as Windows services named 'maria55'. 'maria10' and 'maria10_1' ) and always update them to latest soon after an update is available. Yesterday morning I installed 10.0.16 on top of 10.0.15

Re: [Maria-discuss] MariaDB 10.0.16 now available

2015-01-28 Thread Peter Laursen
that YaST can understand. -- Peter On Wed, Jan 28, 2015 at 3:14 PM, Colin Charles co...@mariadb.org wrote: Hi, On 28 Jan 2015, at 04:06, Peter Laursen peter_laur...@webyog.com wrote: I did not learn anything and obvuously you did not either. We have agreed before that you

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-28 Thread Peter Laursen
@Roberto. A comment to i think it's a nice human readable format for arrays/objects, nothing less nothing more. But why will you then need to **store** as JSON? Could not something like SELECT .. INTO JSON ... do the trick? (with hindsight: SELECT .. INTO XML ... could have been implemented in

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-27 Thread Peter Laursen
On 12/26/14 I posted here I posted the question to this mailing list: *Dynamic columns support in libmaria client library?* *This page https://mariadb.com/kb/en/mariadb/documentation/nosql/dynamic-columns-api/ https://mariadb.com/kb/en/mariadb/documentation/nosql/dynamic-columns-api/ does not

Re: [Maria-discuss] MariaDB 10.0.16 now available

2015-01-27 Thread Peter Laursen
.. -- Peter -- Webyog On Tue, Jan 27, 2015 at 7:57 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 27.01.2015 um 19:28 schrieb Peter Laursen: On OpenSuse 12.3 YaST Online Update does not find 10.0.16 as an update available for already installed (From MariaDB's repository for OpenSuSE) 10.0.15

Re: [Maria-discuss] MariaDB 5.5.41 now available

2014-12-22 Thread Peter Laursen
Downloads or download links are broken. Nothing downloads. page not found. -- Peter On Sun, Dec 21, 2014 at 11:30 PM, Daniel Bartholomew db...@mariadb.com wrote: The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.41 This is a Stable (GA) release. See the

Re: [Maria-discuss] MariaDB 5.5.41 now available

2014-12-22 Thread Peter Laursen
? I tried a couple, it worked for me; but some mirrors can probably take longer to update (or are really broken). Regards, /E On 22.12.2014 13:30, Peter Laursen wrote: Downloads or download links are broken. Nothing downloads. page not found. -- Peter On Sun, Dec 21, 2014 at 11:30 PM

Re: [Maria-discuss] MariaDB 5.5.41 now available

2014-12-22 Thread Peter Laursen
The links redirect to the mirror at ...from/ftp%3A// ftp.ulak.net.tr/pub/MariaDB. Is this really a correct URL? -- Peter On Mon, Dec 22, 2014 at 12:34 PM, Peter Laursen peter_laur...@webyog.com wrote: I don't use *mirrors*. I use *links*. :-) Nothing here https://downloads.mariadb.org

Re: [Maria-discuss] MariaDB 5.5.41 now available

2014-12-22 Thread Peter Laursen
Ok .. it looks like the server at ftp://ftp.ulak.net.tr/ is down. .tr is top-level domain for Turkey. I don't understand why I get redirected there. I am in Denmark. -- Peter On Mon, Dec 22, 2014 at 12:36 PM, Peter Laursen peter_laur...@webyog.com wrote: The links redirect to the mirror

Re: [Maria-discuss] MariaDB 5.5.41 now available

2014-12-22 Thread Peter Laursen
OK .. I never noticed this before. It downloads now. -- Peter On Mon, Dec 22, 2014 at 12:43 PM, Elena Stepanova ele...@montyprogram.com wrote: On 22.12.2014 14:40, Peter Laursen wrote: Ok .. it looks like the server at ftp://ftp.ulak.net.tr/ is down. .tr is top-level domain for Turkey. I

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-12-10 Thread Peter Laursen
this to the page. On 12/09/2014 06:01 PM, Peter Laursen wrote: The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-to-enable-tokudb-in-mariadb/ .. should have added for SuSE YAST2 - Bootloader - Kernel Parameters. Add transparent_hugepage=never to Optional

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-12-10 Thread Peter Laursen
It seem that you guys think that SuSE is just *another Red Hat flavor. It is not! -- Peter On Wed, Dec 10, 2014 at 5:02 PM, Peter Laursen peter_laur...@webyog.com wrote: I noticed in https://downloads.mariadb.org/mariadb/repositories/#mirror=ulakbimversion=10.0distro_release=opensuse13

[Maria-discuss] What happened to 10.1 downloads

2014-12-10 Thread Peter Laursen
Not listed here: https://downloads.mariadb.org/ -- Peter -- Webyog ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help :

Re: [Maria-discuss] R: What happened to 10.1 downloads

2014-12-10 Thread Peter Laursen
/mariadb/10.1/ Regards Federico Mer 10/12/14, Peter Laursen peter_laur...@webyog.com ha scritto: Oggetto: [Maria-discuss] What happened to 10.1 downloads A: Maria Discuss maria-discuss@lists.launchpad.net Data: Mercoledì 10 dicembre 2014, 19

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-12-09 Thread Peter Laursen
It seems they are not yet in the RPMs of the MariaDB repo for OpenSuSE. At least they were not 5-6 hours ago. But I am not in a hurry. -- Peter On Tue, Dec 9, 2014 at 2:41 PM, Sergei Golubchik s...@mariadb.org wrote: Hi, Peter! On Dec 09, Peter Laursen wrote: But most important TokuDB

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-12-09 Thread Peter Laursen
;--and it *IS* there NOW. -- Peter On Tue, Dec 9, 2014 at 2:46 PM, Peter Laursen peter_laur...@webyog.com wrote: It seems they are not yet in the RPMs of the MariaDB repo for OpenSuSE. At least they were not 5-6 hours ago. But I am not in a hurry. -- Peter On Tue, Dec 9, 2014 at 2:41 PM, Sergei

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-12-09 Thread Peter Laursen
Please ignore my post starting It seems they are not yet .. -- Peter On Tue, Dec 9, 2014 at 3:18 PM, Peter Laursen peter_laur...@webyog.com wrote: You were right .. error log snippet: Transparent huge pages are enabled, according to /sys/kernel/mm/transparent_hugepage/enabled 141209 12:26

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-12-09 Thread Peter Laursen
OK. And you're done. It'll take effect on the next reboot. (according to the reply I had here https://forums.opensuse.org/showthread.php/503373-How-to-disable-Transparent-Hugepages?p=2681756#post2681756 - I have not tried yet myself). -- Peter On Tue, Dec 9, 2014 at 3:21 PM, Peter Laursen

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-12-09 Thread Peter Laursen
...@mariadb.org wrote: Thanks Peter, I've added this to the page. On 12/09/2014 06:01 PM, Peter Laursen wrote: The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-to-enable-tokudb-in-mariadb/ .. should have added for SuSE YAST2 - Bootloader - Kernel Parameters. Add

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-12-09 Thread Peter Laursen
about what other people should know. And you have also proved that you don't know how to behave on a mailing list. -- Peter On Tue, Dec 9, 2014 at 7:18 PM, Brian Evans grkni...@scent-team.com wrote: On 12/9/2014 1:00 PM, Peter Laursen wrote: @Brian .. your reply is just *noise*. It is complete

Re: [Maria-discuss] New Question: MariaDB client/server (TCP) protocol

2014-12-07 Thread Peter Laursen
License does apply not to the *protocol as such*. But license applies to *the implementation of the protocol in code*, such as the C-API. Oracle's API (and connectors) are GPL-licensed (or rather dual-licensed: GPL or commercial) MariaDB' s API and connectors are LGPL-licensed. See for instance

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

2014-12-06 Thread Peter Laursen
I checked in Fedora21 (Desktop). It's standard repositories have MariaDB 10.0.14 available and here rpm -qa | grep maria returns what it should. -- peter On Tue, Nov 25, 2014 at 4:47 PM, Peter Laursen peter_laur...@webyog.com wrote: One more correction/etal. MySQL acutally appears in YaST

[Maria-discuss] Oracle sets 'tone' and standard/level of discussion

2014-12-04 Thread Peter Laursen
http://mysqlrelease.com/2014/12/official-mysql-repos-for-suse-linux/ Regarding SUSE Linux Enterprise 12, SUSE unfortunately chose to not provide users with a mature and robust version of MySQL as part of the distro, https://www.suse.com/releasenotes/x86_64/SUSE-SLES/12/#fate-316482 The MariaDB

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-11-26 Thread Peter Laursen
(conflicts, dependencies) is new and might have some rough edges? Peter, I've created MDEV-7211 for this issue to make sure it won't be forgotten. Regards, Sergei On Nov 25, Peter Laursen wrote: I *CERTAINLY* think this https://downloads.mariadb.org/mariadb/repositories/#mirror=23Mediaversion

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-11-26 Thread Peter Laursen
* (or not only) . SuSE users often don't! For some people the primary reason to use SuSE is that it has a very strong GUI for managing the system. You can manage SuSE 95% without command line at all. -- Peter On Wed, Nov 26, 2014 at 10:12 AM, Peter Laursen peter_laur...@webyog.com wrote: OK

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-11-26 Thread Peter Laursen
zypper command or GUI. -- Peter On Wed, Nov 26, 2014 at 12:37 PM, Peter Laursen peter_laur...@webyog.com wrote: NO.. I thought it would bea separate RPM (Like the OQGraph). I will check when I get time. it coudl take a day or two now. Sorry for false alarm. ButSuSE should be listed here https

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-11-26 Thread Peter Laursen
If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed on same page. -- Peter On Wed, Nov 26, 2014 at 1:30 PM, Sergei Golubchik s...@mariadb.org wrote: Hi, Peter! On Nov 26, Peter Laursen wrote: NO.. I

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

2014-11-25 Thread Peter Laursen
be prefaerable if MariaDBs RPMs for SuSE had the same structure and dependencies as those shipped by SuSE so that existing installation could be upgraded. But that is a rather 'unqualified opinion'. You probably have reasons to do as you do. -- Peter On Mon, Nov 24, 2014 at 8:22 PM, Peter Laursen

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

2014-11-25 Thread Peter Laursen
) MariaDB [(none)] -- Peter MariaDB [(none)] .. but therpm command does not return it? -- Peter On Tue, Nov 25, 2014 at 1:38 PM, Peter Laursen peter_laur...@webyog.com wrote: oops .. it seems that I am wrong! peter@linux-hwpu:~ rpm -qa | grep mysql libmysqld18-10.0.13-2.3.2.x86_64

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

2014-11-25 Thread Peter Laursen
One more correction/etal. MySQL acutally appears in YaST Service Manager. But (I think) it appears as running even if it stoppedd. -- Peter On Tue, Nov 25, 2014 at 2:36 PM, Peter Laursen peter_laur...@webyog.com wrote: Addtionally I had hoped that TokuDb was there. But it seems not. SuSE

Re: [Maria-discuss] MariaDB 10.0.15 now available

2014-11-25 Thread Peter Laursen
I *CERTAINLY* think this https://downloads.mariadb.org/mariadb/repositories/#mirror=23Mediaversion=10.0distro_release=opensuse13-amd64distro=openSUSE is premature taken this discussion into account! And I believe this You will also be prompted about a conflict between openSUSE's own MariaDB 5.5

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

2014-11-24 Thread Peter Laursen
Thanks Elena. That even I can understand. But error on installation of server packet No packet found allowing for the action specified. I am simply launching YaST graphical interface from the context menu of the RPM file placed on my desktop (install with packet manager). There is a reference to

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

2014-11-24 Thread Peter Laursen
Thanks a lot. I will try this (tomorow probably). -- Peter On Mon, Nov 24, 2014 at 3:26 PM, Sergei Golubchik s...@mariadb.org wrote: Hi, Peter! On Nov 24, Peter Laursen wrote: Thanks Elena. That even I can understand. But error on installation of server packet No packet found allowing

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

2014-11-24 Thread Peter Laursen
-6.2.2.x86_64 libreoffice-base-drivers-mysql-4.3.3.2-4.1.x86_64 peter@linux-zayf:~ rpm -qa | grep maria mariadb-client-10.0.13-2.3.2.x86_64 mariadb-errormessages-10.0.13-2.3.2.x86_64 mariadb-10.0.13-2.3.2.x86_64 peter@linux-zayf:~ -- Peter On Mon, Nov 24, 2014 at 3:36 PM, Peter Laursen peter_laur

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

2014-11-24 Thread Peter Laursen
).Restoring snapshot! -- Peter On Mon, Nov 24, 2014 at 3:54 PM, Peter Laursen peter_laur...@webyog.com wrote: And teh *bonus question*. What should I remove and not remove before installing your packages? peter@linux-zayf:~ rpm -qa | grep mysql libmysqlclient18-10.0.13-2.3.2.x86_64 libqt4-sql

[Maria-discuss] MariaDB for OpenSuSE 12.3

2014-11-23 Thread Peter Laursen
I have OpenSuSE 12.3. It ships with MariaDB 1.0.13 - and with no TokuDB and no Galera options. I would like to upgrade to 10.0.14 and also enable TokuDB. And it does not seem that an upgrade will be available from SuSE software repositories. There are a lot of RPMs in the yum repository

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

2014-11-23 Thread Peter Laursen
(but Federated is available as a plugin - and same for Archive and Blackhole engines). -- Peter On Sun, Nov 23, 2014 at 12:51 PM, Peter Laursen peter_laur...@webyog.com wrote: I have OpenSuSE 12.3. It ships with MariaDB 1.0.13 - and with no TokuDB and no Galera options. I would like

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

2014-11-23 Thread Peter Laursen
that promise! In other words: please PISS OFF. My nerves cannot tolerate you as a person. You are the most annoying person I ever encountered! -- Peter. On Sun, Nov 23, 2014 at 8:47 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 23.11.2014 um 20:37 schrieb Peter Laursen: BTW: the CONNECT engine

  1   2   >