Unfortunately not with the standard configuration.
You're best bet going forward would be to look at
MySQL Enterprise Audit -
https://www.mysql.com/products/enterprise/audit.html
On Tue, Oct 10, 2017 at 3:54 PM, Gone, Sajan wrote:
> Hi,
>
>We have a MySQL instance which is currently runnin
Depending on the version of MySQL and InnoDB engine, the max key length can
be 3072 for InnoDB..
On Wed, Aug 12, 2015 at 9:21 AM, Johan De Meersman
wrote:
>
> - Original Message -
> > From: "geetanjali mehra"
> > Subject: Changing storage engine in dump file.
> >
> > Is there any implic
;"}}
error 1064
On Wed, Jun 24, 2015 at 11:40 AM, Tomasz Chmielewski
wrote:
> Normal general log also logs everything including bad queries (i.e. SLCECT
> BLAH BLAH;) - although does not say if it was an error (i.e. syntax) or not.
>
> Does the audit plugin log the actual error?
&
The performance hit of the Percona Audit is 15% for disk logging and for
remote syslog we found it is lower. It logs everything including bad
queries (eg. select fark from fark from fark fark fark from frak). You
should be able to write a JSON parser that extracts what you want based on
the log (eg
You could log all queries using the audit plugin, 15% hit..
On Tue, Jun 23, 2015 at 4:54 AM, Johan De Meersman
wrote:
> - Original Message -
> > From: "Tomasz Chmielewski"
>
> >> It would be a mild security risk; a malicious
> >> (or just stupid, see Hanlon's razor) user could spam your
What's your technology stack?
On Mon, Jun 2, 2014 at 10:21 AM, Jatin Davey wrote:
> On 6/2/2014 7:18 PM, Reindl Harald wrote:
>
>>
>> Am 02.06.2014 15:35, schrieb Jatin Davey:
>>
>>> I am no expert with mysql and databases. Hence seeking out some help on
>>> this forum.
>>>
>>> Basically i got
O
On 2013-07-02 5:31 PM, "Andy Wallace" wrote:
> We are on a quest to improve the overall performance of our database. It's
> generally
> working pretty well, but we periodically get big slowdowns for no apparent
> reason. A
> prime example today - in the command line interface to the DB, I tried
There are queries that works with 5.1/5.0 that do not work with 5.5, I
would test extensively..
S
On Thu, Feb 14, 2013 at 5:22 PM, Mihail Manolov <
mihail.mano...@liquidation.com> wrote:
> You could jump from 5.0 directly to 5.5 and skip 5.1. I have without any
> issues. There are some configur
that are no longer permitted must be
rewritten. (Bug #27525)
On Thu, Feb 14, 2013 at 6:11 PM, Rick James wrote:
> Singer, do you have some examples?
>
> > -Original Message-
> > From: Singer Wang [mailto:w...@singerwang.com]
> > Sent: Thursday, February 14, 201
Are you using all InnoDB?
S
On Thu, Feb 14, 2013 at 5:55 PM, Robert Citek wrote:
> On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui
> wrote:
> > 2013/2/13 Robert Citek
> >>
> >> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
> >> wrote:
> >> > Any other possibilities? Do other scenarios bec
Lol! Good point Karen!
On Tue, Dec 4, 2012 at 1:02 PM, Karen Abgarian wrote:
> A touch of realism: we are all dying. For some, it may take a while,
> hopefully.
>
> On 04.12.2012, at 9:53, Tim Pownall wrote:
>
> > Mysql is used by just about every web host and is one of the most common
> > da
once a week)
S
S
On Thu, Nov 1, 2012 at 11:41 AM, Reindl Harald wrote:
>
>
> Am 01.11.2012 16:36, schrieb Singer Wang:
> > On Thu, Nov 1, 2012 at 11:34 AM, Rick James rja...@yahoo-inc.com>> wrote:
> >
> > Full backup:
> > * Xtrabackup (Backu
On Thu, Nov 1, 2012 at 11:34 AM, Rick James wrote:
> Full backup:
> * Xtrabackup (Backup: slight impact on source; more if you have MyISAM (as
> mentioned))
> * Slave (Backup: zero impact on Master -- once replication is set up)
> * LVM -- a minute of server down; see below
>
Why do you need down
Hey,
I'm looking to combine the benefits of the MySQL Thread Pool Plugin and
Percona-Server. All the benchmarks show that the Thread Pool Plugin handles
higher concurrency much better then just setting innodb_thread_concurrency.
Alas Percona server has many tweaks that improve performance.
Does a
Of course...
There's many libraries for REGEX which you can use, link it with an UDF and
boom!
http://dev.mysql.com/doc/refman/5.1/en/adding-udf.html
S
On Fri, Oct 12, 2012 at 12:56 PM, Neil Tompkins <
neil.tompk...@googlemail.com> wrote:
> Hi,
>
> Is there such a way in a MySQL query to extr
My bad actually, the MySQL Enterprise Audit is available in MySQL 5.5
S
On Fri, Oct 5, 2012 at 2:14 AM, Singer Wang wrote:
> Mellow greetings,
>
> Enhance your calm. Lets get our facts straight and not go off our
> rockers. MySQL 5.6 Enterprise edition will be able to do t
ow (thanks Keith for actually trying
to help!)
3) Write your own plugin using the MySQL Plugin APIs
4) use the McAfee Audit Plugin for MySQL (Free:
http://www.devshed.com/c/a/MySQL/McAfee-Releases-Audit-Plugin-for-MySQL-Users-86548/
)
Singer Wang
(yes, I just watched Demolition Man)
On Thu, Oct
It is possible in MySQL 5.6
S
On Thu, Oct 4, 2012 at 11:30 AM, List Man wrote:
> There is no such thing. Your application has to deal with such info.
>
> LS
>
>
> On Oct 4, 2012, at 11:28 AM, Aastha wrote:
>
> > Hello,
> >
> > I want to find the last time the given list of users logged in.
>
Also check for any firewall or NAT
On Sep 5, 2012 5:17 PM, "indrani gorti" wrote:
> Hi all,
> I am a newbie to work with the settings in mysql although I have used in
> very small applications before
> I am currently experimenting with very large tables and a few complicated
> queries. I am usin
RAM is Cheap, so is a faster processor.. (InnoDB requires more RAM/Processor then
the simpler MyISAM)..
but your data and downtime is probably a lot more expensive. Its well worth it
going with InnoDB.
For most of what I do, I use a combination of InnoDB and HEAP Tables.
On Tue, Jul 20, 2004
hello,
reading the documentation I'm confused to as which is better:
SELECT *
FROM T1,T2
where T1.K1 = T2.K2 AND T1.K2=T2.K2 AND ...otherconditions...
or should I do
SELECT *
FROM T1 NATURAL JOIN T2
WHERE ..other conditions..
or should I
SELECT *
FROM T1 JOIN T2 USING (K1,K2)
WHERE ..other c
Hello,
I'm tempted to use the AES_ENCRYPT/AES_DECRYPT function in MySQL; as
documentation says the implementation is 128-bit AES. Thus the keys
are 16bytes in length. Now the 'key_str' in the manual can be
any length; how is the key generated from that?
also, for multi block encryptions what mode
22 matches
Mail list logo
