t admin. I know the game. I will burn you to the ground and
> piss on your ashes" and take the challenge and make this idot my new hobby
> Am 14.05.20 um 19:38 schrieb Jan Steinman:
>
> "Closed: Fixed None Opened 5 years ago by rhughes.”
>
> FIVE YEARS AGO!
>
> Grudge
https://pagure.io/CoC/issue/6
On Thu, May 14, 2020, 1:28 PM Reindl Harald wrote:
> > I had to go on disability for mental health reasons
>
> didn't work well - shut the fuck up!
>
> Am 14.05.20 um 19:20 schrieb Justin Swanhart:
> > I propose we just let it go.
I would ask you restore my pages as a demonstration of good faith.
On Thu, May 14, 2020, 1:20 PM Justin Swanhart wrote:
> I propose we just let it go.
>
> I will never speak of MariaDB again and you stop fucking me over. We both
> win.
>
> Can we please just stop this stu
, 5:57 PM Justin Swanhart wrote:
> MariaDB isn't an honest actor. They repeatedly utilize FUD to push their
> agenda.
>
> I was so frustrated by the columnstore experience that I had to go on
> disability for mental health reasons, and I was fired while on disability
>
riaDB won't respond to this, but you know it is true because there was no
reason other than spite to remove articles about my tools that I did not
even contribute and which are now dead links from other community webpages
and blogs.
On Mon, May 11, 2020, 5:41 PM Justin Swanh
-- Forwarded message -
From: Justin Swanhart
Date: Mon, May 11, 2020, 5:38 PM
Subject: Re: [Maria-discuss] Nosql language with plugins
To: Roberto Spadim
MariaDB relicensed MaxScale from GPL to Business Source License. The
license change effectively extorted customers
*crickets*
On Fri, May 8, 2020, 2:33 PM Justin Swanhart wrote:
> Seems I didn't get Federico's reply. The answer is because:
> War, war never changes...
>
> I made a stink about BSL, and I have shamed Monty in public.
>
> MariaDB recently created a sock puppet Linke
Sigh.
On Friday, May 8, 2020, Daniel Black wrote:
> On Fri, 8 May 2020 14:35:29 -0400
> Justin Swanhart wrote:
>
> > You don't have hardware to work on your own supported platform? Or you
> > can't figure it out?
> >
>
> I didn't have hardwar
You don't have hardware to work on your own supported platform? Or you
can't figure it out?
Smh.
On Mon, Apr 27, 2020, 10:36 PM Daniel Black wrote:
>
> Mac lovers (who can use C/C++ and a debugger),
>
> As your MariaDB developers are hard at work getting 10.5 ready for you,
> unfortunately a bu
Seems I didn't get Federico's reply. The answer is because:
War, war never changes...
I made a stink about BSL, and I have shamed Monty in public.
MariaDB recently created a sock puppet LinkedIn account to attack me for my
religious views.
We are at war
On Wed, Apr 29, 2020, 9:48
MariaDB doesn't have rewrite plugins.
What you want could still not be done with a preparse plugin in MySQL
because there is no way to speak an arbitrary protocol. You could have a
client that speaks the MySQL protocol but sends non-sql text commands that
have some 1:1 match with SQL, for example
https://mariadb.com/kb/en/library/server-system-variables/#lock_wait_timeout
Since metadata operations may be long (an ALTER could take a very long
time, even days) a high wait time is not a problem, but actually a good
thing. Unless you are seeing lock timeouts that you were not seeing
before, y
Hi,
What is the error message from MySQL when you go back to the prior version?
Depending on the error, it is probably possible to simply remove the
logfiles before restarting the old version. I don't have an ubuntu DVD on
hand and am on slow internet so I can't test right now.
On Wed, Oct 16,
Great, thanks!
On Sun, Aug 4, 2019 at 10:27 AM Sergei Golubchik wrote:
> Hi, Justin!
>
> Fixed.
>
> Regards,
> Sergei
>
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchp
Since the PK values are hard coded in your application, provide the PK value in
the INSERT statement instead of using generated values.
> On May 1, 2019, at 4:11 AM, Guillaume Lefranc wrote:
>
> This feature is well known and documented:
>
> https://mariadb.org/auto-increments-in-galera/
>
>
MariaDB already supports authenticating as OS users such as root, when use by
UNIX domain sockets for communications:
https://mariadb.com/kb/en/library/authentication-plugin-unix-socket/
> On Mar 25, 2019, at 6:07 PM, Felipe Gasper wrote:
>
> Hello,
>
>I’ve submitted a proposal to the MySQ
It is possible that the two versions have different query plans, with the new
version requiring more temp space. It is also possible that different
temporary table engines are in use. Check to make sure you are using aria for
temp tables and not innodb.
> On Feb 21, 2019, at 8:31 AM, Benoit P
to "trace" what the query execution is doing in the
> InnoDB engine?
>
> /Conor
> From: Justin Swanhart
> Sent: Tuesday 11 December 2018 12:01
> To: rhys.campb...@swisscom.com
> Cc: conor_mark_mur...@hotmail.com; maria-discuss@lists.launchpad.net
> Subject: Re: [M
r, given that the
> performance is okay with MyISAM, I'd like to understand what the problem with
> InnoDB is.
>
> Is there are any way to "trace" what the query execution is doing in the
> InnoDB engine?
>
> /Conor
> From: Justin Swanhart
&g
You could use Shard-Query (https://mariadb.com/kb/en/library/shard-query/) to
process the query in parallel over the partitions. This will improve the
performance of OLAP type queries.
> On Dec 11, 2018, at 5:27 AM,
> wrote:
>
> Can you put this is a proc and cycle through the list of parti
I wonder if the new value in the `user` table will take effect if you FLUSH
PRIVELEGES. This may be a workaround.
On Tue, Nov 27, 2018, 2:39 PM Staffan I've found a simple repro case so I reported
> https://jira.mariadb.org/browse/MDEV-17852
>
> /Staffan
>
> On Mon, Nov 26, 2018 at 9:14 PM Staff
Hi,
Have you considered using Xtrabackup to create a replication slave? This
is essentially a binary copy kept in sync with the innodb transaction log,
and it works great.
On Wed, Jan 17, 2018 at 12:55 PM, Conor Murphy <
conor_mark_mur...@hotmail.com> wrote:
>
> Hi Marko,
>
>
> I don't think th
Thanks!
On Jun 9, 2017 2:17 PM, "Pavel Ivanov" wrote:
> https://mariadb.com/kb/en/mariadb/annotate_rows_log_event/
>
> On Fri, Jun 9, 2017 at 11:05 AM, Justin Swanhart
> wrote:
> > Hi,
> >
> > I seem to recall reading that MariaDB can annotate th
Hi,
I seem to recall reading that MariaDB can annotate the binary log with the
original SQL statement for a given set of ROW changes in the binary log,
but I can't seem to find documentation on this on the wiki.
Can MariaDB log the original STATEMENT along with the ROW changeset? If
so, can you
You need ADD COLUMN clauses for those other two columns. Perhaps this
ALTER TABLE statement was edited from a CREATE TABLE statement incorrectly?
On Apr 17, 2017 2:48 PM, "Justin Swanhart" wrote:
> I believe there is a missing right parenthesis after the 11. has_children
> is
I believe there is a missing right parenthesis after the 11. has_children
is a third Boolean column.
On Apr 17, 2017 2:29 PM, "David Karr" wrote:
> I've used Mariadb for a couple of small projects. I prefer to
> automate as much of the initial creation and config as possible, using
> SQL scrip
This is indeed odd. The point of the variable is to use myisam temporary
tables when innodb storage is used because there is a huge performance hit
to using innodb temporary tables. The default of null makes MariaDB use
innodb temp tables which will cause a performance degradation. I'd expect
th
I forgot about 'async'. It is a multi-threaded asynchronous (and client
agnostic) SQL queue built entirely from MySQL primitives with no external
dependencies.
On Tue, Nov 8, 2016 at 7:45 AM, Justin Swanhart wrote:
> There are a great many uses for stored procedures. They
There are a great many uses for stored procedures. They can eliminate
round trips, and they can encapsulate logic in the database. It is a pity
that MySQL stored procedures are so limited that hey do not even
encapsulate the full standard, and require difficult constructs by not
implementing "for
on the THD, if they want to use a connection they have to create a new one).
On Mon, Nov 7, 2016 at 4:42 PM, Sergei Golubchik wrote:
> Hi, Justin!
>
> On Nov 07, Justin Swanhart wrote:
> > We discussed it here and it seemed vary popular. WL-820.
>
> I know, right?
>
We discussed it here and it seemed vary popular. WL-820.
On Mon, Nov 7, 2016 at 10:43 AM, Sergei Golubchik wrote:
> Hi, Federico!
>
> On Nov 07, Federico Razzoli wrote:
> > Some good points from Bill Karwin:
> > https://www.quora.com/What-are-the-reasons-not-to-use-or-
> not-use-stored-procedur
Use ProxySQL to rewrite DROP DATABASE to a call to a store proc.
Sent from my iPhone
> On Oct 25, 2016, at 3:43 AM, Lukas Lehner wrote:
>
> Thanks Rhys.
>
> Is there an other way? With your solution the customer can't use standard SQL
> (they are forced to use our procedure), which means much
Doesn't the Bing team port rocks? Obviously there is interest in support for
Windows in Redmond, but apparently not for TokuDB.
The market decides. It has been demonstrated that TokuDB isn't precisely
general purpose, so the desire to port it is lesser.
Plenty of people run Windows and MySQL
I asked about schema and queries to determine which sharding framework makes
the most sense to suggest.
Sent from my iPhone
> On Oct 14, 2016, at 1:05 PM, Clint Byrum wrote:
>
> Excerpts from Jon Foster's message of 2016-10-14 09:33:59 -0700:
>> I have a DB scenario that is very write intensiv
Can you describe your schema and typical queries please?
Sent from my iPhone
> On Oct 14, 2016, at 12:33 PM, Jon Foster wrote:
>
> I have a DB scenario that is very write intensive. Essentially its a
> large scale hit counter of sorts. Currently we're running on a single
> 12core server with 6
Making Percona/MariaDB/MySQL better at sharding, and supporting complex
queries (with MPP capability, window functions, CTE,etc.) would really
compete with an enterprise DB, with RedShift, and with Fabric. Shard-Query
can greatly outperform both the enterprise MySQL Infobright (and MC
ColumnStore)
Wouldn't it be ironic for MariaDB to support java but not MySQL?
Sent from my iPhone
> On Oct 13, 2016, at 3:59 PM, Justin Swanhart wrote:
>
> That is it.
>
> Sent from my iPhone
>
>> On Oct 13, 2016, at 1:17 PM, Roberto Spadim wrote:
>>
>
That is it.
Sent from my iPhone
> On Oct 13, 2016, at 1:17 PM, Roberto Spadim wrote:
>
> you are talking about this?
> https://launchpad.net/mysql-wl820/trunk/5.1.33-wl820
>
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : mari
Antony's work includes a client library change that lets perl/Java/or whatever
run SQL on the THD. The parser was made reentrant, you connect with null
credential and get current THD.
Sent from my iPhone
> On Oct 13, 2016, at 1:01 PM, Andrew Hutchings wrote:
>
>
>
>> On 13/10/16 16:53, Vla
pe there is a plan for foreign key and spatial in MyRocks. There
> isn't one yet. I don't think full text in any MySQL engine is a good use of
> time given how infrequently it is used.
>
>
>
>> On Wed, Oct 12, 2016 at 8:39 AM, Reindl Harald
>> wrote:
>>
s a
consultant during this time, and I can't tell you how many tables I had to
rebuild. Thousands to say the least. Yuck.
--Greenlion
On Wed, Oct 12, 2016 at 10:01 AM, Reindl Harald
wrote:
>
> Am 12.10.2016 um 15:53 schrieb Justin Swanhart:
>
>> Also having to dump/restore
Justin!
>
> On Oct 12, Justin Swanhart wrote:
> >
> > Regarding SET PERSIST, yes, it has dangers. One of them would be to
> > set the buffer pool too large, so I filed a MySQL FR to set the BP to
> > the default size if the malloc fails. It can be increased dynamic
Also having to dump/restore to go from 10.2 to 10.3 tables is a PITA.
Remember how awful it was to migrate all those BDB tables to InnoDB? Or
even just how frustrating it was when UTF8_GENERAL_CI changed the umlaut?
On Wed, Oct 12, 2016 at 9:43 AM, Reinis Rozitis wrote:
> The main reason to dro
Questions comments are inline:
> * InnoDB: InnoDB native partitioning - so MySQL 8 InnoDB? But Monty says
there's next to no changes in InnoDB 8...
Instant add column. New InnoDB deadlock detection (8.0). New
INFORMATION_SCHEMA table (8.0). Dedicated
tablespace for temporary tables (in 5.7 and m
What are your sharding requirements?
Do you plan to report or aggregate the data across shards? Do you need
parallelism when accessing more than one shard (or more than one partition in a
table)? Do you need to push down aggregation, filtering, and joins? Joins
between sharded and un-sharded
It further depends on auto increment lock mode. You can have a big gap between
"buckets" of id values in the non-default mode, if the bulk insert is large and
uses more than one "bucket" of values.
Sent from my iPhone
> On Aug 26, 2016, at 12:46 PM, Justin Swanhart w
Generated id values are not guaranteed to be sequential. The auto_increment
lock is shared by transactions. This code will not always work.
Sent from my iPhone
> On Aug 26, 2016, at 12:33 PM, Diego Dupin wrote:
>
> Hi peter,
>
> Basically, server will return different informations to driver
Hi,
You can not get all of the generated keys from a bulk insert, only the last
one, because the id value is made available through the last_insert_id()
function, and the client API value to return the last insert id works the
same way.
You will either have to do single value (not bulk) inserts,
Hi,
I don't have the email on hand, but it was acknowledged by MariaDB that
this system is inefficient. I'm not the first one to complain about it. I
figure I should keep complaining about it, since there was a promise to fix
it. I'll refrain from characterizing the current situation with an
neg
re is unreasonable.
Sent from my iPhone
> On Aug 25, 2016, at 12:50 PM, Justin Swanhart wrote:
>
> Thanks for your armchair diagnosis, but I'm not "striking out" at anybody.
> I'm outraged by the behavior of MariaDB. I'm passionate about open source,
>
nswered yes to those questions then you don't have ethics
either.
--Justin
Sent from my iPhone
On Aug 25, 2016, at 1:15 AM, Jan Steinman wrote:
>> On 2016-08-24, at 06:22, Justin Swanhart wrote:
>>
>> I'm bipolar
>
> Seems more like Borderline to me. Bip
said he could.
MariaDB is as bad as any FUD said Oracle would be - possibly worse. And that
isn't FUD, I judge actual actions, not potential ones.
Sent from my iPhone
> On Aug 24, 2016, at 7:06 AM, Sergei Golubchik wrote:
>
> Hi, Justin!
>
>> On Aug 24, Justin Swanhar
or morals.
Sent from my iPhone
> On Aug 24, 2016, at 7:06 AM, Sergei Golubchik wrote:
>
> Hi, Justin!
>
>> On Aug 24, Justin Swanhart wrote:
>> I have been fired for speaking out about the GPL and MariaDB actions
>> that have caused great harm to our ecosystem.
ole.us/2008/07/23/on-mysql-forks-and-mysqls-non-open-source-documentation/
Justin Swanhart on July 23, 2008 at 12:09
Brian,
The “thing is” that we shouldn’t have to write it. MySQL may be ‘open source’,
but it isn’t ‘open software’. With all the talk recently of proprietary
extensions, the documentat
When is this system getting fixed? Having to log into web to answer email is
idiotic...
Sent from my iPhone
> On Aug 19, 2016, at 8:52 PM, Justin Swanhart wrote:
>
> Oh yeah, this stupid system where I have to log into the web. So much stupid
> around here.
>
>> On Fr
Oh yeah, this stupid system where I have to log into the web. So much
stupid around here.
On Fri, Aug 19, 2016 at 11:52 PM, Justin Swanhart
wrote:
> If you are using Galera, then aborted transactions due to lock conflict
> are reported as deadlocks.
>
> Temporary tables are not sh
If you are using Galera, then aborted transactions due to lock conflict are
reported as deadlocks.
Temporary tables are not shared between connections and can not cause
deadlocks.
--Justin
On Fri, Aug 19, 2016 at 7:50 PM, AskMonty KB wrote:
> Hello,
>
> A new question has been asked in "MariaD
I have created a GitHub fork of MaxScale which does not include the 2.0
branch. The repository is called GPLScale.
There is a big potential problem with this. Take for example the file
server/core/utils.c, which now has a new license:
https://github.com/mariadb-corporation/MaxScale/blob/2.0/serve
Hi,
The new BSL license was implemented in checkin 196e6ac . All of the source
for MaxScale 2.0 that was checked in prior to that is still GPL and is open
source right now.
The following code changes will not be present in any GPL version of a fork
of MaxScale 2.0:
b709e29 Fix URL typo in relea
Hi,
Does the problem appear if you set the timeout value to 9223372036854775807?
On Fri, Jul 29, 2016 at 3:24 AM, Joseph Glanville wrote:
> Hi Pavel.
>
>
> To describe the setup a little better the master replicates to a semi-sync
> slave, which then replicates to an async slave. This is to en
Hi,
A connection pool should not affect query performance.
My guess is that the a) connection pool doesn't have enough connections, so the
query is waiting in the pool, or b) that the query is slow under concurrency.
The easiest way to debug this is using the "slow query log". It will log each
on_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoi
Hi,
Do you have write-behind caching turned on? Do you have RAID card without BBU?
Did your computer crash? If the OS or hardware (like IDE HDD cache) lies
about actually writing to disk, InnoDB can become corrupted, and this is not
the fault of innodb. Be aware that if this is a VM, many V
You can most easily automate it by writing a shell script using Cygwin.
Hint: The NET SERVICE command can stop and start services.
Sent from my iPhone
> On May 13, 2016, at 9:17 PM, Reindl Harald wrote:
>
>
>
>> Am 13.05.2016 um 19:20 schrieb Irwanto:
>> hi,
>> i have 5-15 pc as server using
The log for changes during the online ALTER goes in the tmp dir. The log is
applied at the end of the statement.
Sent from my iPhone
> On May 4, 2016, at 2:13 AM, Sergei Golubchik wrote:
>
> Hi, Rhys.Campbell!
>
>> On May 04, rhys.campb...@swisscom.com wrote:
>> Hi All,
>>
>> For the follow
Hi,
You can add an md5 of the string and unique on that. You can do this with a
generated column.
Sent from my iPhone
> On Mar 11, 2016, at 10:19 AM, Binarus wrote:
>
>> On 11.03.2016 15:45, Alexander Barkov wrote:
>> FYI, I have added a new task for this:
>>
>> https://jira.mariadb.org/bro
Partitioned tables don't support referential constraints.
Composite partitioning only supports tables partitioned by RANGE or LIST and
sub partitions may only be HASH or KEY.
Sent from my iPhone
> On Mar 14, 2016, at 5:52 AM, Ghazi Btissam wrote:
>
> Hi,
>
> 1- Could a partitioned table cont
Oops. PRIMARY KEY should be just KEY on that second example with RANGE
COLUMNS. :)
Sent from my iPhone
> On Mar 12, 2016, at 11:01 AM, Justin Swanhart wrote:
>
> You can use no primary key, and just put a regular key (not unique key) on
> the auto_increment column. You must ma
You can use no primary key, and just put a regular key (not unique key) on the
auto_increment column. You must make sure that manual insertions don't create
a duplicate if value.
>> CREATE TABLE new (
>> id INT NOT NULL AUTO_INCREMENT,
>> name VARCHAR(50),
>> added DATE,
>> KEY (id),
>> )
>>
Hi,
There is no programmatic way to read a file line by line and write a file line
by line. You could write a udf to do so.
You can take a look at http://github.com/Fastbit_UDF if you like. fb_query()
writes to CSV files and fb_inlist reads a one column file and turns it into an
CSV list for
If you log in via ssh there is no network latency per insert, the latency is to
local host which is negligible. Batch your inserts and you will see improved
performance.
Sent from my iPhone
> On Mar 10, 2016, at 7:52 AM, Federico Razzoli wrote:
>
> That could be a problem if DNS is not relia
Hi,
And generally BOM is implemented using an adjacency model, and
MySQL/MariaDB lack SQL:2003 support for recursive queries, and lack CONNECT
BY .. - thus there is no easy way to access a BOM in MariaDB.
--Justin
On Wed, Mar 9, 2016 at 6:59 AM, Justin Swanhart wrote:
> Hi,
>
> Do
Hi,
Do you mean schema routing? Because that won't allow you to join between
schemata. You generally need to join OE to INV to PO, etc in an ERP
system. Sharding by schema won't help. You would end up having to use
multi-master replication to get all the data back on a single node, then
report
Hi,
I wouldn't try to use MySQL for a 10TB single instance DB unless most of
the data is historical data that isn't accessed frequently. Sharding
generally won't work for such an application, because every table will
likely need partitioned by different keys (ie you have a very large order
table
Hi,
Perhaps try to (excuse me if my Perl is rusty)
$qxid = $dbh->quote($xid)
$sth = $dbh->prepare("XA ROLLBACK " . $xid)
$sth->execute();
If that doesn't work, and you are familiar with C, you could make a
modification to the server so that after it initializes InnoDB to iterate
and rollback all
The server crashes when there is a problem with replicating DDL because the
server is inconsistent. It crashes to initiate an SST or IST in order to
become consistent again.
There have historically been various bugs around foreign keys, and I
generally don't recommend that they be used with the c
results, in the order that the queries were queued.
--Justin
On Wed, Feb 24, 2016 at 11:34 AM, Justin Swanhart
wrote:
> oops, didn't copy the list.
>
> -- Forwarded message --
> From: Justin Swanhart
> Date: Wed, Feb 24, 2016 at 11:34 AM
> Subject:
oops, didn't copy the list.
-- Forwarded message --
From: Justin Swanhart
Date: Wed, Feb 24, 2016 at 11:34 AM
Subject: Re: [Maria-discuss] New Question: Non-blocking calls from PHP
To: Federico Razzoli
Hi,
For now, if you want FIFO, just change the ORDER BY q_id DESC to
oh, it is in the Swanhart Toolkit in the async/ subdir -
http://github.com/greenlion/swanhart-tools
On Wed, Feb 24, 2016 at 10:04 AM, Justin Swanhart
wrote:
> Hi,
>
> It is completely native. It consists of a queue table, a thread state
> table, a settings table, a stored procedur
duler?
>
> bye
> Federico
>
>
> ----
> Mer 24/2/16, Justin Swanhart ha scritto:
>
> Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP
> A: "AskMonty KB"
> Cc: "Maria Discuss"
> Data: Mercole
Replying here in addition to the web page (ugh Frankenstein's monster)...
I just finished the first version of 'async' which runs queries in the
background (in parallel!) using a queue table, a crafty stored procedure
for a worker thread, and an event which executes the workers.
http://swanhart.l
hi,
nice, I was going to suggest trying to prepare an XA RECOVER statement (not
sure if they can be prepared statements) then using HEX() on each
character of the XID field. I don't know if that will work or not,
hexdump is certainly easier.
--Justin
On Tue, Feb 23, 2016 at 11:50 AM, Sergei G
Hi,
Thanks for the fix, and for looking into fixing the system too.
--Justin
On Mon, Feb 22, 2016 at 2:16 PM, Sergei Golubchik wrote:
> Hi, Justin!
>
> On Feb 22, Justin Swanhart wrote:
> > I said it returns a 500!
> >
> > I don't know why it doesn'
thing we get in mail)
too and it is not working for us. This web/mail Frankenstein monster has
not been working for us for a very long time. FIX IT. PRETTY PRETTY
PLEASE!
--Justin
On Mon, Feb 22, 2016 at 10:28 AM, Sergei Golubchik wrote:
> Hi, Justin!
>
> On Feb 22, Justin Swanhart
Hi,
I have tried logging in with google, with linkedin and with github. I
always get a 500 error from mariadb.
So this means I can't reply back to the F*CKING STUPID MAILS THAT COMES TO
THIS LIST THAT REQUIRE A WEB REPLY.
This has been going on years now, this stupid "have to use the web site"
Hi,
I have not tested this, but I think you will need to convert the strings to
hex then do:
xa rollback 0xabcdef <-- where 0xabcdef is the hex representation of the
string.
--Justin
On Sat, Feb 20, 2016 at 5:53 AM, Marc Schöchlin wrote:
> Hi,
>
> i currently have the situation that i cannot m
Hi,
You can always migrate to mysql then drop mariadb in on top. That is the
great thing about being a drop-in replacement.
--Justin
On Wed, Feb 17, 2016 at 8:17 AM, Peter Laursen
wrote:
> Windows ships with a (32 bit) ODBC driver for Paradox. There are several
> tools that may migrate from
Hi,
Happy to help!
--Justin
On Tue, Feb 9, 2016 at 5:28 PM, Roberto Spadim
wrote:
> +1, work
> Thanks again justin! Happy new year :)
>
>
> Em terça-feira, 9 de fevereiro de 2016, Justin Swanhart <
> greenl...@gmail.com> escreveu:
>
>> Hi,
>>
>&g
Hi,
I answered on stackexchange. You can let me know here if you have
questions, that is most convenient for me.
--Justin
On Tue, Feb 9, 2016 at 7:14 AM, Lukas Lehner wrote:
> Hi
>
>
> http://dba.stackexchange.com/questions/128715/mariadb-galera-cluster-with-3-nodes-change-engine-from-myisam-
Hi,
Use a stored procedure to construct the union as from a CSV list of tables
and execute it using a prepared statement. Stored routines can return
resultsets.
Look at sq_helper.sql in Shard-Query for hints:
https://github.com/greenlion/swanhart-tools/blob/master/shard-query/sq_helper.sql
--Ju
Hi,
Actually ps_history (my performance schema periodic capture tool) uses a
constructed UNION to get a consistent snapshot of the performance schema.
It might be more useful to you:
https://github.com/greenlion/ps_history/blob/master/setup.sql
--Justin
On Mon, Feb 8, 2016 at 9:46 PM, Justin
Hi,
If you don't mind corrupting more than just the database (such as open
memory mapped files) then you can also try this in your VM:
sudo dd if=/dev/zero of=/dev/mem
:D
On Tue, Feb 2, 2016 at 9:46 AM, Reindl Harald
wrote:
>
>
> Am 02.02.2016 um 15:12 schrieb Federico Razzoli:
>
>> I am looki
The only time an innodb table is broken is if the computer lost writes to
the system or the media is corrupted. InnoDB is fully transactional. If
you had similar problems and MyISAM "works" it will likely have bad data in
it, because myisam has no checksums. MyISAM is the kiss of death, it is
ol
if mariadb has not updated partitioning like 5.6 did, then any writing
locks all partitions for write, and the append-only functionality won't
work as expected because all partitions are locked, and reads will queue up
because writes to different partitions will block all reads and writes.
On Sun,
Hi,
Queries are always going to pile up with MyISAM because write locks have
higher priority than read locks, though you could try LOW_PRIORITY_UPDATES
which will invert the lock priority, but could starve writes.
MySQL 5.6 changes the way locking works for partitions, and write locks are
held on
I think Percona with Galera has the option to force all tables to innodb.
I seem to recall that, but it has been months since I touched anything Percona
related. What a blessing that turned out to be.
Sent from my iPhone
> On Dec 22, 2015, at 11:02 AM, Federico Razzoli wrote:
>
> I didn't s
Hi,
Well, I would suggest Flexviews. This is exactly what it is designed for.
Or you can roll your own. Assuming the views are based on a single table,
create a trigger on the table that logs the changes. You can automate the
construction of such a log table and appropriate triggers, but you c
Hi,
There is really no formula for predicting MySQL memory size. There are
many factors. But if your estimate uses max_connections, then use
max_connections/threads_in_pool. That gives you the effective number of
queries running at once. There are some things, like number of temporary
tables p
Ack
Sent from my iPhone
> On Nov 8, 2015, at 9:35 AM, Colin Charles wrote:
>
> Best to ask the maxscale list on this -- maxsc...@googlegroups.com
>
>> On Sunday, 8 November 2015, Justin Swanhart wrote:
>> Hi,
>>
>> When I try to compile maxscale, the
Hi,
When I try to compile maxscale, the classifier won't compile because it needs
server headers. How do I tell it where to find the source. It uses multiple
headers in multiple directories so adding the server source via a simple -I to
CXXFLAGS doesn't work.
Am I missing something?
Sent fr
1 - 100 of 247 matches
Mail list logo
