The error you are getting is WSAECONNREFUSED (you can find a lot of useful information googling just for 10061)This means, there is no server on the machine/port you’re connecting to. You can try telnet to the machine and port, from the client machine, first. Get telnet to work, and spits out the
Hi Chris, CMake caches files , and skips download them if files already exist on disk during the build.If pcre2-10.36.zip already exists in the build_directory/extra/pcre2/src/, then build output will look similar to below Performing download step (download, verify and extract) for 'pcre2' --
Note, if you do not build something, you won’t install it either. To avoid building unit tests for example, there is -DWITH_UNIT_TESTS=0 (I think it perhaps should be even default, the unit tests run rather rare, mostly on CI) If you want to exclude embedded -DWITH_EMBEDDED_SERVER=0. Cuts build ti
Hi Andy, Since you asked . The right place to file bugs (the last 2 emails were bug reports), is our JIRAhttps://jira.mariadb.org/projects/CONJ - for JDBC connectorhttps://jira.mariadb.org/projects/MDEV - for the server You can write exactly the same content as you do here. You can also try stackov
It is very unusual to benchmark a debug build. No wonder it lags
So this is the first, and most important performance “tweak” – benchmark an
optimized build.
Once you get there, rerun your benchmarks, and then more advanced things can
be discussed.
From: Nisarg Shah
Sent: Wednesday, 4 Decembe
Hi Kenneth,
There have been some reports about this symptoms, but nothing that we would be
able to reproduce on any of our machines.
So far I think the SSL handshake error that was seen was either intermittent
“Unknown SSL error (0x80090308)”, say one in couple of hundred attempts. for
which a
Hi Björn,
The time for more than 4 bytes in UTF8 will never come, and even the emojis
expand so that more than 1112064 “characters” , new encoding will not be
called UTF8 anymore, and I doubt it will even be called Unicode.
UTF8 is not up to 7 characters. While the encoding scheme with leadin
Given zero optimization in the original post, innodb_flush_log_at_trx_commit =
2 is almost the right fix, orders of magnitude faster on hard disk.
Add simple batching to this, and it is possible to add another order of
magnitude, or 2.
Write into several tables instead of 1, and that will improv
). Definitely
not thousands of connections. Perhaps a single client connection will suffice.
From: JCA
Sent: Monday, 7 October 2019 20:52
To: Vladislav Vaintroub
Cc: maria-discuss@lists.launchpad.net
Subject: Re: [Maria-discuss] Performance tuning sought for MariaDB
On Mon, Oct 7, 2019 at 11:06
You do not share many details how exactly your application exactly interacts
with the server.
Do you work with large batches, I.e generate big (say 1MB) multi-valued
statements like
INSERT INTO t(a,b) VALUES(a1,b1),(a2,b2)..,(aN, bN)
ON DUPLICATE KEY UPDATE counter=counter+1
The mass-del
You mentioned, you use MariaDB 10.3 with FIPS. If you can use it, then it is
not disabled by OpenSSL, since SHA1 is required for usual authentication with
non-empty password.
From: Maria-discuss
on behalf of
Captain Wiggum
Sent: Monday, September 2, 2019 8:28
There is no kSnappyCompression on Windows, unless you managed to somehow
compile it yourself.
From: Maria-discuss
on behalf of
Juan Telleria Ruiz de Aguirre
Sent: Monday, September 10, 2018 5:09:01 PM
To: maria-discuss@lists.launchpad.net
Subject: Re: [Maria-d
ct: Re: [Maria-discuss] Is disabling doublewrite safe on ZFS?
Il 14-08-2018 19:58 Vladislav Vaintroub ha scritto:
> There is at least one case I know where you do not need doublewrite
> buffer. And you even do not need CoW filesystem.
>
> A combination of OS guarantee of atomic writes if
There is at least one case I know where you do not need doublewrite buffer. And
you even do not need CoW filesystem.
A combination of OS guarantee of atomic writes if they are sector-sized writes,
and matching innodb page size being. If you have disks with 4K sectors (quite
common), and you ch
u can create the stacktraces yourself, with cdb or
Visual Studio Debugger. Let's continue this dialog in the ticket, so we
do not spam the discuss list.
Wlad.
Am 10.06.2018 um 22:38 schrieb Vladislav Vaintroub:
I think this is a bug, and as such it is best to have in J
error log and core (which will be named mysqld.dmp
and created in the data directory) to the bug report, and we’ll take it from
there.
From: Vicențiu Ciorbaru
Sent: Sunday, June 10, 2018 8:23 PM
To: TD
Cc: Maria Discuss; maria-developers; Marko Mäkelä; Vladislav Vaintroub
Subject: Re: [Maria
Hi Kevin,
you are creating partial backups .The way to restore them preparing with
–export option, and this would export every Innodb table in the backup.
Now you also need ALTER TABLE IMPORT TABLESPACE to get exported tables to their
final destination, something similar to what is described he
The latest backup will not work with your 10.1 server. Mariabackup version
should match server version that you have on the same box.
mariabackup from 10.1 appears to work with 5.5 and 10.0, but this is merely by
luck and by accident.
From: Florent B
Sent: Wednesday, February 14, 2018 11:58 AM
innodb_page_cleaners=1 a try , as a “blind” attempt to workaround.
From: Peter Laursen
Sent: Saturday, January 20, 2018 5:38 PM
To: Vladislav Vaintroub
Cc: Maria Discuss
Subject: Re: [Maria-discuss] MariaDB 10.3.4 consumes extremely muchCPUonWindows.
I should have thought about compressing, obviously
:23 PM
To: Vladislav Vaintroub
Cc: Maria Discuss
Subject: Re: [Maria-discuss] MariaDB 10.3.4 consumes extremely much
CPUonWindows.
It happens always and immediately when I start the 10.3.4 mysqld process (as a
service with "net start .." or from Control Panel .. Administration ..
Ser
Hi Peter,
Could you take a 2-3 different process dumps , when it happens?
You do this by switching to “Detail” tab in Task manager, then mysqld.exe,
rightclick, “Create dump”, and mysqld.DMP will be stored in temp directory.
Could you then attach minidumps somewhere (ideally to a new bug in o
he dialog like this (but on a system with an
English locale it may not be exactly like this).
"Windows Defender Smartscreen prevented an unknown app in
starting. You may possibly expose your system to a security risk,
if you are running this app".
On Fri, Jan 19, 20
What does it say in plain English?
We did not forget to sign the package, and you can check that by rightclicking
on the MSI, Properties/Digital Signature, check the single one in the list,
press “Detail”.
It will show that signature is OK.
However, we did change Authenticode certificate, beca
http://www.clusterdb.com/mysql/mysql-with-windows-server-2008-r2-failover-clustering
You can ignore that it talks about MySQL, it applies the same to MariaDB,.
Sent from Mail for Windows 10
From: vv2599
Sent: Sunday, August 27, 2017 6:05 AM
To: Vladislav Vaintroub
Cc: Guillaume Lefranc; maria
The out-of-the-box Windows HA solution is Windows failover clustering
It does require shared disk though
Sent from Mail for Windows 10
From: vv2599
Sent: Saturday, August 26, 2017 10:39 PM
To: Guillaume Lefranc
Cc: maria-discuss@lists.launchpad.net
Subject: Re: [Maria-discuss] Mariadb cluster o
also strace applied to the mysqld process.
Sent from Mail for Windows 10
From: Ali, Saqib
Sent: Monday, July 24, 2017 7:38 PM
To: Vladislav Vaintroub
Cc: Maria Discuss
Subject: Re: [Maria-discuss] MariaDB unable to read the /etc/krb5.keytab
Vladislav,
I enabled the TRACE log. But that doesn&#
Those errors come from GSSAPI/Kerberos APIs, they are not originated
directly by the server.
You can use environment variable KRB5_TRACE as described in
https://web.mit.edu/kerberos/krb5-latest/doc/admin/troubleshoot.html to see
more output. Set it before you start up the server.
You can also us
On 17.07.2017 15:47, Reindl Harald wrote:
Am 17.07.2017 um 15:37 schrieb Vladislav Vaintroub:
On 17.07.2017 15:07, Reindl Harald wrote:
see above, also another piece of my intial posting - why in the
world does "Threadpool_threads" not reach the highest value under
load but
On 17.07.2017 15:07, Reindl Harald wrote:
Am 17.07.2017 um 15:02 schrieb Vladislav Vaintroub:
see above, also another piece of my intial posting - why in the world
does "Threadpool_threads" not reach the highest value under load but
after the benchmark is finished
what makes
On 17.07.2017 15:14, Reindl Harald wrote:
Am 17.07.2017 um 15:02 schrieb Vladislav Vaintroub:
You are getting HY000/2002, the range starting with 2000 (ending iirc
3000) is the error originating on client. If I was to guess it is a
client-side connection timeout
are you aware that the
On 17.07.2017 14:19, Reindl Harald wrote:
i can reprduce that also on the 12-core production sevrer, in that
case only 250 connections are failing and also here only with
Keep-Alive requests to the webserver, otherwise not enough load
i guess "futex(0x7f65e917eae0, FUTEX_WAIT_PRIVATE, 2, NUL
On 13.07.2017 21:22, Reindl Harald wrote:
Am 13.07.2017 um 21:08 schrieb Vladislav Vaintroub:
On 13.07.2017 20:44, Reindl Harald wrote:
previously i had -DWITH_SYSTEMD=OFF and while trying to switch to
Type=notify i switched that to -DWITH_SYSTEMD=ON - well, nothing
mentions systemd
On 13.07.2017 20:44, Reindl Harald wrote:
previously i had -DWITH_SYSTEMD=OFF and while trying to switch to
Type=notify i switched that to -DWITH_SYSTEMD=ON - well, nothing
mentions systemd (yes, systemd-devel is installed)
remove the option completly and oh look:
-- Looking for include file
On 24.05.2017 12:22, Peter Laursen wrote:
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 p
used SQLServer,MySQL, or JDBC may have different
expectations of the default.
Can anyone provide some reasons for why we need to keep the
auto-commit enabled at server level.
Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
Windows 10
*From: *Vladislav Vain
On 17.05.2017 11:26, ksubraman...@paycommerce.com wrote:
All,
We have set auto-commit=false at server level.
But our .Net developers want to enable this auto-commit as true
(default behaviour) that I hesitant to do that. Is there any connector
(driver) properties that we can set at connect
On 5/4/2017 7:16 AM, Zach Lym wrote:
database could grow into an awesome onramp for the right way of doing
things, but MariaDB is letting its only decent UI atrophy.
Why it is the "only decent UI"? I never liked it as UI, personally I
found it to huge to be likable.
I like HeidiSQL for UI pu
On 21.03.2017 12:21, Ayano Kosaka wrote:
Hi,
Hi Ayano,
I can not build MariaDB 10.0.30 and 10.1.22 with Visual Studio 2013
on Windows 7 Pro 64 bit. `identifier "int64_t" is undefined` occurs
at `storage/xtradb/btr/btr0cur.cc`.
It is probably caused by the following merge commit:
[Merge bran
On 2/1/2017 12:01 PM, Reindl Harald wrote:
Am 01.02.2017 um 10:25 schrieb Colin Charles:
On 1 Feb 2017, at 16:40, Ian Gilfillan wrote:
Can someone clarify the status of Cassandra in CentOS7? It appears
to have been available in 6, but not in 7.
I think the CassandraSE is deprecated.
On 1/21/2017 6:23 PM, Reindl Harald wrote:
Am 21.01.2017 um 06:59 schrieb Reindl Harald:
why does MariaDB use "-g -static-libgcc" in "mysql_release.cmake" and so
besides override -g0 break -flto builds?
I think you might be misunderstanding the purpose of mysql_release.cmake
it is there t
On 22.12.2016 17:38, l vic wrote:
I run this query every minute and I have this exception after couple
of hours...
Class.forName("org.mariadb.jdbc.Driver");
conn = DriverManager.getConnection(DB_URL, USER, PASS);
stmt = conn.createStatement();
String sql = "SHOW STATUS LIKE 'wsrep_%'";
rs = st
"SHOW STATUS" fails because server closes the client socket.
"Could not read resultset: unexpected end of stream, read 0 bytes from
4" is a slightly weird message, but client reads 0 bytes instead of
packet header(4 bytes). Reading 0 bytes which means socket was closed
orderly (as opposed to
On 13.10.2016 17:26, Andrew Hutchings wrote:
Whilst I agree it would be a nice feature and something I've heard for
years, the implementation would likely be more complex than it seems.
For starters you have to consider the possibility of a procedure
crashing and taking the whole daemon with
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 plan to make this happen . At least RocksDB works on
Windows, the port seems to be done by competent pe
trying to find a way to integrate the MariaDB shutdown
gracefully (in UNIX this is all much simpler and straightforward).
-Mark
*From:*Vladislav Vaintroub [mailto:vvaintr...@gmail.com]
*Sent:* Monday, June 6, 2016 11:39
*To:* Mark mailto:asar...@xs4all.nl
Yes, it is possible that Windows does not give enough time to MariaDB to
shut down gracefully. I just created a task for this one here
https://jira.mariadb.org/browse/MDEV-10183.
Still, Innodb should handle this situation gracefully, and recover on
startup, so what you see is a bug. It is a pi
If you're using MSIs, It is possible. You can install /upgrade MariaDB
on a remote servers, e.g by using psexec (remoting tool from
sysinternals) that runs msiexec in quiet mode
The whole command I used to install 10.1.13 and later upgrade to 10.1.14
psexec \\remote-box-address -u -p
msi
It is not enough to just install bison to C:\GnuWin32 .
https://mariadb.com/kb/en/mariadb/Building_MariaDB_on_Windows states
"Add |C:\GnuWin32\bin| to your system |PATH| after installation"
On 3/18/2016 7:48 AM, Shubham Barai wrote:
Hello everyone,
I was trying to build MariaDB f
On 1/20/2016 4:40 PM, Peter Laursen wrote:
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/mar
On Tue, Nov 10, 2015 at 6:47 PM, Roberto Spadim
wrote:
> i'm with a doubt
> if i have a thread pool with 1000 threads and a max_connections with 100
> connections
> can i have more than 100 clients connected (1000 threads for example)? dos
> thread pool size limit the max connections, or max conn
Hi Serg,
On 03/12/15 09:17, Sergei Golubchik wrote:
MariaDB Windows installer has a special dialog about it with a
checkbox that's enabled by default, if I'm not mistaken).
I'm sorry, but you are mistaken :) Checkbox is off by default.
Also, at some point in the past I compared the download
MSI installation defaults to 1/8 of RAM for the Innodb bufferpool. You
can change this value during the installation, see the screenshot is
under "Other database properties'" section in
https://mariadb.com/kb/en/mariadb/documentation/getting-started/binary-packages/installing-mariadb-msi-packag
, and that’s all I need for the command line clients
From: Peter Laursen [mailto:peter_laur...@webyog.com]
Sent: Freitag, 27. September 2013 19:15
To: Vladislav Vaintroub
Cc: Maria Developers; Maria Discuss
Subject: Re: [Maria-developers] MySQL bug affects mariaDB
Thanks wlad for explanation
break it, I see no real alternative.
From: Justin Swanhart [mailto:greenl...@gmail.com]
Sent: Freitag, 27. September 2013 19:54
To: Vladislav Vaintroub
Cc: Peter Laursen; Maria Developers; Maria Discuss
Subject: Re: [Maria-discuss] [Maria-developers] MySQL bug affects mariaDB
Please
The command line clients are not services, and they are not started with
--defaults-file, this is correct.
But
1.We install shortcut to mysql client and shortcut does have --defaults-file ,
and the default-file points to the right place, i.e whenever you installed the
mysql server insta
From: Maria-developers
[mailto:maria-developers-bounces+wlad=montyprogram@lists.launchpad.net] On
Behalf Of Peter Laursen
Sent: Donnerstag, 6. Juni 2013 15:40
To: Sergei Golubchik
Cc: Maria Discuss; Maria Developers
Subject: Re: [Maria-developers] [Maria-discuss] Clear-text plugin
>"no suppo
>From: maria-discuss-bounces+wlad=montyprogram@lists.launchpad.net
[mailto:maria-discuss-bounces+wlad=montyprogram@lists.launchpad.net] On
Behalf Of Bruce Kirkpatrick
>Sent: Montag, 4. Februar 2013 20:32
>To: maria-discuss@lists.launchpad.net
>Subject: Re: [Maria-discuss] Reading a field'
>Hi !
Hi Vineet,
>At present, I am using MySQL noinstall version (which doesn't require ANY
>installation). Just copy & paste the folder & start.
>Is there any way to use MariaDB without installing? (Maybe replace MySQL
>folder containing the binaries with MariaDB folder?
Yes , and yes .
C
Hi Guido,
See my comments below.
> Hi,
>
> I'm having some problems switching one of our Java/Glassfish-based web
> applications over from MySQL to to MariaDB.
>
> Since the MariaDB project advertises the software as a fully compatible
drop-
> in replacement for MySQL, the first thing I did wa
> -Original Message-
> From: maria-discuss-
> bounces+wlad=montyprogram@lists.launchpad.net [mailto:maria-
> discuss-bounces+wlad=montyprogram@lists.launchpad.net] On Behalf
> Of Michael Widenius
> Sent: Freitag, 28. September 2012 16:04
> To: Peter Laursen; i...@askmonty.org; tim
> -Original Message-
> From: maria-discuss-
> bounces+wlad=montyprogram@lists.launchpad.net [mailto:maria-
> discuss-bounces+wlad=montyprogram@lists.launchpad.net] On Behalf
> Of Colin Charles
> Sent: Donnerstag, 12. April 2012 01:03
> To: Richard Dunn
> Cc: maria-discuss@lists.laun
I'm forwarding this to Ansgar, as a feature request for HeidiSQL. May be
tricky to add it as Aria-specific option, currently CREATE TABLE
options/checkboxes in HeidiSQL seem to be not engine dependent to me.
> -Original Message-
> From: maria-discuss-
> bounces+wlad=montyprogram@lis
> -Original Message-
> From: maria-discuss-
> bounces+wlad=montyprogram@lists.launchpad.net [mailto:maria-
> discuss-bounces+wlad=montyprogram@lists.launchpad.net] On Behalf
> Of Brian Evans
> Sent: Montag, 1. August 2011 16:47
> To: maria-discuss@lists.launchpad.net
> Subject: [Ma
From: maria-discuss-bounces+wlad=montyprogram@lists.launchpad.net
[mailto:maria-discuss-bounces+wlad=montyprogram@lists.launchpad.net] On
Behalf Of Jake Drew
Sent: Montag, 23. Mai 2011 18:34
To: maria-discuss@lists.launchpad.net
Subject: [Maria-discuss] XtraDB using the Windows Installe
Hi Peter
From: maria-discuss-bounces+wlad=montyprogram@lists.launchpad.net
[mailto:maria-discuss-bounces+wlad=montyprogram@lists.launchpad.net] On
Behalf Of Peter Laursen
Sent: Samstag, 14. Mai 2011 15:02
To: maria-develop...@lists.launchpad.net; maria-discuss@lists.launchpad.net
Subject:
> -Original Message-
> From: maria-discuss-
> bounces+wlad=montyprogram@lists.launchpad.net [mailto:maria-
> discuss-bounces+wlad=montyprogram@lists.launchpad.net] On Behalf
> Of Jake Drew
> Sent: Montag, 4. April 2011 21:52
> To: maria-discuss@lists.launchpad.net
> Subject: [Mari
> -Original Message-
> From: Arjen Lentz [mailto:ar...@openquery.com]
> Sent: Freitag, 1. April 2011 03:58
> To: Vladislav Vaintroub
> Cc: 'Haidong Ji'; 'Maria Discuss'
> Subject: Re: [Maria-discuss] Bundle more relevant cnf files in MariaDB
>
> -Original Message-
> From: maria-discuss-
> bounces+wlad=montyprogram@lists.launchpad.net [mailto:maria-
> discuss-bounces+wlad=montyprogram@lists.launchpad.net] On Behalf
> Of Arjen Lentz
> Sent: Donnerstag, 31. März 2011 02:33
> To: Haidong Ji
> Cc: Maria Discuss
> Subject: Re
> -Original Message-
> From: Sergei Golubchik [mailto:s...@askmonty.org]
> Sent: Montag, 28. März 2011 10:46
> To: Vladislav Vaintroub
> Cc: mo...@askmonty.org; maria-discuss@lists.launchpad.net
> Subject: Re: [Maria-discuss] client library shared library version c
> -Original Message-
> From: Sergei Golubchik [mailto:s...@askmonty.org]
> Sent: Sonntag, 27. März 2011 21:26
> To: mo...@askmonty.org
> Cc: MARK CALLAGHAN; maria-discuss@lists.launchpad.net;
> w...@montyprogram.com
> Subject: Re: [Maria-discuss] client library shared library version chan
ug
btw, as they are not bound to support Maria.
From: maria-discuss-bounces+wlad=montyprogram@lists.launchpad.net
[mailto:maria-discuss-bounces+wlad=montyprogram@lists.launchpad.net] On
Behalf Of Vladislav Vaintroub
Sent: Freitag, 18. Februar 2011 14:18
To: 'Jake Drew&
Jake, I tried to do instance setup on my machine using your description.
Workbench brings a nicely designed popup "has encountered a bug, please
report", during "Management and OS" step. So I did, reported it here
http://bugs.mysql.com/bug.php?id=60167
From: maria-discuss-bounces+wlad=montyp
72 matches
Mail list logo
