Re: Last established connection timestamp by a specific user

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

Re: Changing storage engine in dump file.

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 vegiv...@tuxera.be wrote: - Original Message - From: geetanjali mehra mailtogeetanj...@gmail.com Subject: Changing storage engine in

Re: server-side logging of query errors?

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

Re: server-side logging of query errors?

the actual error? Tomasz On 2015-06-25 00:32, Singer Wang wrote: 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

Re: server-side logging of query errors?

You could log all queries using the audit plugin, 15% hit.. On Tue, Jun 23, 2015 at 4:54 AM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: Tomasz Chmielewski man...@wpkg.org It would be a mild security risk; a malicious (or just stupid, see Hanlon's

Re: SHOW FULL COLUMNS QUERIES hogging my CPU

What's your technology stack? On Mon, Jun 2, 2014 at 10:21 AM, Jatin Davey jasho...@cisco.com 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 a

Re: database perfomance worries

O On 2013-07-02 5:31 PM, Andy Wallace awall...@ihouseweb.com 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

Re: slave replication with lots of 'duplicate entry' errors

Are you using all InnoDB? S On Thu, Feb 14, 2013 at 5:55 PM, Robert Citek robert.ci...@gmail.comwrote: On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui man...@tuenti.com wrote: 2013/2/13 Robert Citek robert.ci...@gmail.com On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

that are no longer permitted must be rewritten. (Bug #27525) On Thu, Feb 14, 2013 at 6:11 PM, Rick James rja...@yahoo-inc.com wrote: Singer, do you have some examples? -Original Message- From: Singer Wang [mailto:w...@singerwang.com] Sent: Thursday, February 14, 2013 2:59 PM

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

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

Re: MySQL dying?

Lol! Good point Karen! On Tue, Dec 4, 2012 at 1:02 PM, Karen Abgarian a...@apple.com 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

Re: Mysql backup for large databases

On Thu, Nov 1, 2012 at 11:34 AM, Rick James rja...@yahoo-inc.com 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

Re: Mysql backup for large databases

a week) S S On Thu, Nov 1, 2012 at 11:41 AM, Reindl Harald h.rei...@thelounge.netwrote: Am 01.11.2012 16:36, schrieb Singer Wang: On Thu, Nov 1, 2012 at 11:34 AM, Rick James rja...@yahoo-inc.commailto: rja...@yahoo-inc.com wrote: Full backup: * Xtrabackup (Backup: slight

MySQL Thread Pool Plugin + Percona Server?

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

Re: Extract text from string

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 extract

Re: user last activity and log in

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 4, 2012

Re: user last activity and log in

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 w...@singerwang.com 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

Re: user last activity and log in

It is possible in MySQL 5.6 S On Thu, Oct 4, 2012 at 11:30 AM, List Man list@bluejeantime.com 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

Re: Help with mysql connect_timeout

Also check for any firewall or NAT On Sep 5, 2012 5:17 PM, indrani gorti indrani.go...@gmail.com 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

Re: Relational Integrity

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

join synatx

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

AES_Encrypt

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