MySQL Community Server 5.7.12 has been released

Dear MySQL users, MySQL Server 5.7.12, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.12 is recommended for use on production systems. Starting with MySQL Server 5.7.12, we are introducing the concept of Rapid Plugins. Out of the box, 5.7.12

MySQL Shell 1.0.3 m1 Development Release has been released

Dear MySQL users, Today we are excited to announce for the first time the MySQL Shell, a new component for the MySQL Server. The MySQL Shell is an interactive JavaScript and Python command-line interface, supporting development and administration for the MySQL Server. The MySQL Shell enables

[ANN] QxOrm 1.4.2 & QxEntityEditor 1.1.9 released : support JSON serialization

Hello, QxOrm 1.4.2 and QxEntityEditor 1.1.9 just released : http://www.qxorm.com/ QxOrm library 1.4.2 changes log : - Support JSON serialization : each C++ class registered in QxOrm context can be serialized/deserialized in JSON format (JSON feature requires Qt5) - For more details about JSON

Re: threads in cleaning up mode

Can it be a consequence of slow disk also? Best Regards, Geetanjali Mehra Senior Database Administrator On Tue, Apr 5, 2016 at 10:50 AM, geetanjali mehra < mailtogeetanj...@gmail.com> wrote: > Thanks to everyone for response. Any other views from any one is always > welcome. > > Best

Re: threads in cleaning up mode

Thanks to everyone for response. Any other views from any one is always welcome. Best Regards, Geetanjali Mehra Senior Database Administrator On Mon, Apr 4, 2016 at 7:51 PM, shawn l.green wrote: > > > On 4/2/2016 10:36 AM, geetanjali mehra wrote: > >> Hi to all, >>

Re: threads in cleaning up mode

On 4/2/2016 10:36 AM, geetanjali mehra wrote: Hi to all, For many days, I am struggling with the problem of increasing history list length on mysql 5.6.29. Application that this server is running IOT based. Also, this server has so many threads running in sleeping mode. SHOW ENGINE INNODB

test - ignore

ignore

failed to decrypt log block

hi everybody.. would you know how to recover from such a problem: InnoDB: ok header, but checksum field contains 792537472, should be 1776874443 2016-04-04 12:41:15 140333716928640 [ERROR] InnoDB: Redo log crypto: failed to decrypt log block. Reason could be that requested key version is not

Re: threads in cleaning up mode

Hi, It sounds like a bad case of transactions handling by the application. If you have transactions/statements open for very long time, the list which contains the unflushed changes, grows. These unflushed changes will slow down the purge and in extreme cases, will also affect the DMLs. So,

Re: need help from the list admin

- Am 1. Apr 2016 um 21:56 schrieb shawn l.green shawn.l.gr...@oracle.com: > Correct. MyISAM is not a transactional storage engine. It has no concept > of COMMIT or ROLLBACK. Changes to it are controlled by a full table lock > and as soon as the change is complete, the table is unlocked and

Re: need help from the list admin

- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com: >> Is the mix of MyISAM and InnoDB a problem with Row-Based-Logging or >> with Statement-Based-Logging or with both ? >> >> > > Both. > > >> >> I don't understand the example: >> Does "begin transaction" and

threads in cleaning up mode

Hi to all, For many days, I am struggling with the problem of increasing history list length on mysql 5.6.29. Application that this server is running IOT based. Also, this server has so many threads running in sleeping mode. SHOW ENGINE INNODB STATUS shows all these threads in *cleaning up*

Re: need help from the list admin

Am 01.04.2016 um 21:09 schrieb Lentes, Bernd: - Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com: You said, "This is done on the master, written in the log and then replicated to the slave, " The INSERT would not appear in the Binary log until after session 1

Re: need help from the list admin

Sorry for pm ! - Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com: >>> You would be better served by first converting your MyISAM tables to >>> InnoDB to stop mixing storage engine behaviors (transactional and >>> non-transactional) within the scope of a single

Re: need help from the list admin

- Am 1. Apr 2016 um 17:52 schrieb shawn l.green shawn.l.gr...@oracle.com: >> What is true ? when the transaction started or when the first read is >> performed ? > Until you need to establish a snapshot of the data, then you don't need > a snapshot position. > > The transaction

Re: need help from the list admin

On 4/1/2016 10:08 AM, Lentes, Bernd wrote: - On Apr 1, 2016, at 3:12 PM, Bernd Lentes bernd.len...@helmholtz-muenchen.de wrote: Btw: i read about isolation levels. REPEATABLE READ is the default for InnoDB. http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:

Re: need help from the list admin

On 4/1/2016 9:12 AM, Lentes, Bernd wrote: - On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote: "Unsafe" in that sense replies to the fact that certain commands can have a different effect when processed from the Binary Log than they did when they were executed

Re: need help from the list admin

- On Apr 1, 2016, at 3:12 PM, Bernd Lentes bernd.len...@helmholtz-muenchen.de wrote: Btw: i read about isolation levels. REPEATABLE READ is the default for InnoDB. http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says: "...so that all queries within a transaction

RE: need help from the list admin

- On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote: > "Unsafe" in that sense replies to the fact that certain commands can > have a different effect when processed from the Binary Log than they did > when they were executed originally on the system that wrote the

Re: need help from the list admin

On 3/30/2016 1:26 PM, Lentes, Bernd wrote: - On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote: So i should use the default (autocommit=1)? no, you should what is appropriate for your application if you don't care about inserts/updates triggered by let say a

Re: need help from the list admin

Am 30.03.2016 um 19:26 schrieb Lentes, Bernd: - On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote: So i should use the default (autocommit=1)? no, you should what is appropriate for your application if you don't care about inserts/updates triggered by let say a

RE: need help from the list admin

- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote: >> So i should use the default (autocommit=1)? > > no, you should what is appropriate for your application > > if you don't care about inserts/updates triggered by let say a > webrequest are half written due a crash

Re: need help from the list admin

Am 30.03.2016 um 18:56 schrieb Lentes, Bernd: - On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote: I read that the converting is not difficult. But has the code of our webapp to be changed ? It's written in php and perl. What i understand is that

Re: need help from the list admin

- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote: >> >> I read that the converting is not difficult. But has the code of our webapp >> to >> be changed ? It's written in php and perl. >> What i understand is that inserts/updates/deletions in InnoDB tables have to

ANN: DAC for MySQL 3.0.4 is out!

MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll.

Re: need help from the list admin

Am 28.03.2016 um 21:36 schrieb Lentes, Bernd: - On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: You would be better served by first converting your MyISAM tables to InnoDB to stop mixing storage engine behaviors

Re: need help from the list admin

Hello Bernd, On 3/28/2016 3:36 PM, Lentes, Bernd wrote: - On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: You would be better served by first converting your MyISAM tables to InnoDB to stop mixing storage engine

Re: need help from the list admin

- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote: > Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: >>> You would be better served by first converting your MyISAM tables to >>> InnoDB to stop mixing storage engine behaviors (transactional and >>> non-transactional)

Re: need help from the list admin

Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: You would be better served by first converting your MyISAM tables to InnoDB to stop mixing storage engine behaviors (transactional and non-transactional) within the scope of a single transaction. But if you cannot convert them, using MIXED will be

Re: need help from the list admin

- Am 25. Mrz 2016 um 21:54 schrieb shawn l.green shawn.l.gr...@oracle.com: > Hello Bernd, > > Sorry for the delay, I wanted to make sure I had enough time to address > all of your points. >> He proposed to have two hosts, and on each is running a MySQL instance >> as master AND slave.

Re: mysql query for current date accounting returns NULL

On 3/26/2016 4:36 PM, shawn l.green wrote: On 3/25/2016 6:39 AM, JAHANZAIB SYED wrote: I have Freeradius 2.x with MySQL 5.5 in Ubuntu. I want to query user quota for current date. I am using following code SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM radacct where

Re: mysql query for current date accounting returns NULL

On 3/25/2016 6:39 AM, JAHANZAIB SYED wrote: I have Freeradius 2.x with MySQL 5.5 in Ubuntu. I want to query user quota for current date. I am using following code SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM radacct where (acctstarttime between

Re: need help from the list admin

Hello Bernd, Sorry for the delay, I wanted to make sure I had enough time to address all of your points. On 3/22/2016 7:07 AM, william drescher wrote: sent for Bernd, and to see if it works from another sender -- Lentes, Bernd wrote: Hi, i know

Re: mysql query for current date accounting returns NULL

2016/03/25 06:39 ... JAHANZAIB SYED: I want to query user quota for current date. I am using following code SELECT SUM(acctinputoctets)+SUM(acctoutputoctets) AS Total FROM radacct where (acctstarttime between DATE_FORMAT(NOW(),'%Y-%m-%d') AND NOW() AND acctstoptime between DATE_FORMAT(NOW()

mysql query for current date accounting returns NULL

I have Freeradius 2.x with MySQL 5.5 in Ubuntu. I want to query user quota for current date. I am using following code SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM radacct where (acctstarttime between DATE_FORMAT(NOW(),'%Y-%m-%d') AND NOW() AND acctstoptime between

ANN: PHP Generator for MySQL 16.3 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 16.3, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo: http://demo.sqlmaestro.com/

Re: need help from the list admin

- On Mar 23, 2016, at 11:11 AM, william drescher will...@techservsys.com wrote: >> >> Hi William, >> >> thanks for the try. Good idea ! >> Did you change anything ? >> >> >> Bernd > > Yes, in the original document there were some characters that > were put on the screen as asian

Re: need help from the list admin

On 3/22/2016 7:49 AM, Lentes, Bernd wrote: - On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com wrote: sent for Bernd, and to see if it works from another sender -- Lentes, Bernd wrote: Hi, i know that there is a list

ANN: Upscene releases Database Workbench 5.1.12

Upscene releases Database Workbench 5.1.12 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.12 “ This release adds a few small features and useful enhancements. The full version 5.1.x change log is available here:

Re: Workbench MySQL Enterprise Backup Error

The beauty of running enterprise versions is that you have support from Oracle. I would gently point you in their direction if not to get what you paid for but also because most of us in this list are unequipped to help you because we don't use the software you have problems with. Good luck On 22

Workbench MySQL Enterprise Backup Error

Hello all, I have not run across this problem where Workbench will not let me access the "Online Backup" link and claims that my version of MySQL Enterprise Backup is 0.0.0 (it is 4.0.0). I had backups running and scheduled through Workbench previously. Yesterday I changed my data files to

MySQL Utilities 1.6.3 BETA has been released

Dear MySQL users, This is the BETA release for Utilities 1.6. MySQL Utilities version 1.6.3 is compatible with MySQL Server versions 5.5 and greater. Python v2.6 and v2.7 are supported. MySQL Utilities v1.6.3 BETA is available for download from http://dev.mysql.com/downloads/tools/utilities/ A

Re: need help from the list admin

- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com wrote: > sent for Bernd, and to see if it works from another sender > -- > Lentes, Bernd wrote: > Hi, > > i know that there is a list dedicated to replication, but when >

Re: need help from the list admin

sent for Bernd, and to see if it works from another sender -- Lentes, Bernd wrote: Hi, i know that there is a list dedicated to replication, but when you have a look in the archive it's nearly complete empty. Really not busy. So i hope it's ok if i

Re: does anyone else have problems sending mails to this list ?

Am 22.03.2016 um 02:05 schrieb Jan Steinman: please refrain from answering when you have no clue how DNS blacklists are working and what about others are talking Well, excuse me! Someone put on their bossy pants this morning! A simple “That’s not what’s going on here” would have been

Re: does anyone else have problems sending mails to this list ?

> please refrain from answering when you have no clue how DNS blacklists are > working and what about others are talking Well, excuse me! Someone put on their bossy pants this morning! A simple “That’s not what’s going on here” would have been much nicer. J -- MySQL General Mailing List

Re: Conditional ODER BY Clause HELP

2016/03/18 12:54 ... Don Wieland: Trying to get the correct syntax on this: ORDER BY CASE WHEN tr.Placed = "X" THEN r.Division ASC, FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC WHEN tr.Placed != "X" THEN tr.ride_time ASC END How does

Re: need help from the list admin

- On Mar 19, 2016, at 3:28 PM, Reindl Harald h.rei...@thelounge.net wrote: > Am 19.03.2016 um 15:23 schrieb Reindl Harald: >> >> >> Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: >>> one further question: >>> if some of my e-mails get through (like this one) and others don't, it >>> does not

Re: does anyone else have problems sending mails to this list ?

Am 20.03.2016 um 20:22 schrieb Reindl Harald: Am 20.03.2016 um 20:16 schrieb Jan Steinman: From: Reindl Harald Date: 17 March 2016 at 06:27:22 PDT Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new

Re: does anyone else have problems sending mails to this list ?

Am 20.03.2016 um 20:16 schrieb Jan Steinman: From: Reindl Harald Date: 17 March 2016 at 06:27:22 PDT Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed

Re: does anyone else have problems sending mails to this list ?

> From: Reindl Harald > Date: 17 March 2016 at 06:27:22 PDT > > Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: >> i still can't send my question to the ML. Our outgoing Mailer has a new IP >> which is not listed >>

need help from the list admin

Dear list admin, i need your help. I'm trying to write an e-Mail to the list for already one week. I always get it back because it's classified as spam. The mail is formatted as plain-text, include neither links nor attachments. I don't understand why it's classified as spam. Neither our domain

Conditional ODER BY Clause HELP

Hi gang, Trying to get the correct syntax on this: ORDER BY CASE WHEN tr.Placed = "X" THEN r.Division ASC, FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC WHEN tr.Placed != "X" THEN tr.ride_time ASC END How does one deal with

Conditional ODER BY Clause HELP

Hi gang, Trying to get the correct syntax on this: ORDER BY CASE WHEN tr.Placed = "X" THEN r.Division ASC, FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC WHEN tr.Placed != "X" THEN tr.ride_time ASC END How does one deal with

Re: does mysql alert about all the duplicates?

Maybe this post will help you with your user/config question. http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update > On Mar 16, 2016, at 7:46 AM, Reindl Harald

MySQL Connector/ODBC 5.3.6 has been released

Dear MySQL users, MySQL Connector/ODBC 5.3.6, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need based on

Re: need help from the list admin

Am 18.03.2016 um 14:56 schrieb Chris Knipe: Blah blah blah... Delivery to the following recipient failed permanently: mysql@lists.mysql.com Technical details of permanent failure: Your message was rejected by the server for the recipient domain lists.mysql.com by lists-mx.mysql.com.

Re: need help from the list admin

On Fri, Mar 18, 2016 at 3:43 PM, Lentes, Bernd < bernd.len...@helmholtz-muenchen.de> wrote: > i need your help. I'm trying to write an e-Mail to the list for already > one week. I always get it back because it's classified as spam. > Ditto. I've pretty much given up on this list...

Re: need help from the list admin

Am 19.03.2016 um 15:23 schrieb Reindl Harald: Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has to be that

Re: need help from the list admin

Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has to be that particular e-Mail? both a spamfilter is typically

Re: need help from the list admin

Am 19.03.2016 um 15:08 schrieb Lentes, Bernd: Ok. I tried again: pc53200:~ # nslookup 20.103.107.146.score.senderscore.com. Server: 146.107.8.88 Address:146.107.8.88#53 Non-authoritative answer: Name: 20.103.107.146.score.senderscore.com Address: 127.0.4.62 My result is

Re: need help from the list admin

Hi, one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has to be that particular e-Mail ? Bernd Helmholtz Zentrum Muenchen Deutsches Forschungszentrum fuer

Re: need help from the list admin

- Am 18. Mrz 2016 um 15:34 schrieb Reindl Harald h.rei...@thelounge.net: > Am 18.03.2016 um 15:25 schrieb Lentes, Bernd: >> >> - Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be: >> > > as i already told you offlist > senderscore.com LISTED 127.0.4.67 > > this

update, insert ... gee.. a puzzle

.. that you experts I hope can crack like a digestive biscuit... how does one update, or merge or whatever is right technical term for it - a my.table from my.another table (both are schematically identical, no foreign keys, one primary key) but.. does it a way so when there is a duplicate

Re: need help from the list admin

Am 18.03.2016 um 15:25 schrieb Lentes, Bernd: - Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be: and yet, both of those messages made it through :-p Stick your domain in http://mxtoolbox.com to see if there's any problems that might be worth solving. If the

Re: does anyone else have problems sending mails to this list ?

Hi, i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed (http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20=toolpage#), our domain is not listed

Re: does anyone else have problems sending mails to this list ?

Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed (http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20=toolpage#), our domain is not listed

Re: does mysql alert about all the duplicates?

thanks Rebecca, I'm looking at this examples and still wonder - how do I insert into my.table select * from my.othertable and allow all the updates? Both tables are schematically identical. Seems I cannot get the syntax around it. many thanks On 16/03/16 14:38, Rebecca Love wrote:

Re: need help from the list admin

Ok :-) On Fri, Mar 18, 2016 at 4:34 PM, Reindl Harald wrote: > > > Am 18.03.2016 um 15:25 schrieb Lentes, Bernd: > >> >> - Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman >> vegiv...@tuxera.be: >> >> and yet, both of those messages made it through :-p >>> >>>

Re: need help from the list admin

- Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be: > and yet, both of those messages made it through :-p > > Stick your domain in http://mxtoolbox.com to see if there's any problems that > might be worth solving. If the mailserver classifies you as spam, that's >

does mysql alert about all the duplicates?

hi everybody just another beginner's question. if I insert into table and there are duplicate primary keys - does mysql alert about all the duplicates or just the first one and then exits/abandon the rest of the insert without any alerts for potential further duplicates? And is this a

Re: update, insert ... gee.. a puzzle

2016/03/17 12:47 ... lejeczek: .. that you experts I hope can crack like a digestive biscuit... how does one update, or merge or whatever is right technical term for it - a my.table from my.another table (both are schematically identical, no foreign keys, one primary key) but.. does it a way

Re: does mysql alert about all the duplicates?

Am 16.03.2016 um 13:38 schrieb lejeczek: hi everybody just another beginner's question. if I insert into table and there are duplicate primary keys - does mysql alert about all the duplicates or just the first one and then exits/abandon the rest of the insert without any alerts for potential

Re: need help from the list admin

Blah blah blah... Delivery to the following recipient failed permanently: mysql@lists.mysql.com Technical details of permanent failure: Your message was rejected by the server for the recipient domain lists.mysql.com by lists-mx.mysql.com. [137.254.60.71]. The error that the other server

Re: dump then truncate - in between anything?

On 13/03/16 14:52, Richard wrote: Date: Wednesday, March 09, 2016 14:38:45 + From: lejeczek hi everybody I imagine this is theoretical rather than practical question, albeit I don't have much practice, so I hope experts could comment logical view of the procedure

Re: dump then truncate - in between anything?

> Date: Wednesday, March 09, 2016 14:38:45 + > From: lejeczek > > hi everybody > > I imagine this is theoretical rather than practical question, > albeit I don't have much practice, so I hope experts could comment > logical view of the procedure is: mysqldump &&

time-out with Java connector

I wrote a Java program to connect with MySQL server. As long as it was loose classes in a directory, it worked. As soon as I made it into a JAR file, I had trouble. If I used flag "classpath" to refer to the connector, the connector was not found: with flag "-XshowSettings" I saw that the

dump then truncate - in between anything?

hi everybody I imagine this is theoretical rather than practical question, albeit I don't have much practice, so I hope experts could comment logical view of the procedure is: mysqldump && truncate - what are the chances that something gets in between and I loose it? many thanks L. --

Fwd: Enabled memcached Plugin on mysql

-- Forwarded message -- From: Olivier Morel Date: 2016-03-09 13:35 GMT+01:00 Subject: Enabled memcached Plugin on mysql To: mysql@lists.mysql.com i've installed mysql5.6 on debian 8 , i've also enabled daemon_memcached. After enabled memcached i restart

Re: does anyone else have problems sending mails to this list ?

Am 09.03.2016 um 11:44 schrieb Lentes, Bernd: i tried yesterday several times to send an e-Mail to this list. E-Mail is formatted as plain-text, has no links included and no attachment but is declined as spam. This is what is bounced: : host

Oracle Certified Professional, MySQL 5.6 Database Administrator

Hi when will be the exam "Oracle Certified Professional, MySQL 5.6 Database Administrator" for MySQL 5.7? Lukas

Re: does anyone else have problems sending mails to this list ?

Bernd, > : host lists-mx.mysql.com[137.254.60.71] said: 552 spam > score exceeded threshold (#5.6.1) (in reply to end of DATA command) > > Any ideas ? Whatever provider you are using to send mail has been blacklisted? It happens with some ISP who are not diligent

does anyone else have problems sending mails to this list ?

Hi, i tried yesterday several times to send an e-Mail to this list. E-Mail is formatted as plain-text, has no links included and no attachment but is declined as spam. This is what is bounced: : host lists-mx.mysql.com[137.254.60.71] said: 552 spam score exceeded

Re: can I just encrypt tables? what about the app?

@harald, sure. @shawn, you say FTWRL is very important, tools that backup to text files for now - do those follow this principle? mysqldump eg. does it do FTWRL ? (I'm reading man pages but either I've gone blind or it's not there) On 03/03/16 16:02, shawn l.green wrote: On 3/3/2016 10:40

Re: can I just encrypt tables? what about the app?

On 3/3/2016 10:40 AM, lejeczek wrote: On 02/03/16 00:51, shawn l.green wrote: On 3/1/2016 6:26 PM, lejeczek wrote: On 29/02/16 21:35, shawn l.green wrote: On 2/29/2016 3:13 PM, Reindl Harald wrote: Am 29.02.2016 um 20:54 schrieb Gary Smith: On 29/02/2016 19:50, Reindl Harald

Re: can I just encrypt tables? what about the app?

Am 03.03.2016 um 16:40 schrieb lejeczek: how to backup in a way that this in-database-encryption will be taken advantage of? does any of present backup solutions can do it? many thanks think once again what "transparent encryption" means the most effective backup is anyways running slave

Re: can I just encrypt tables? what about the app?

On 02/03/16 00:51, shawn l.green wrote: On 3/1/2016 6:26 PM, lejeczek wrote: On 29/02/16 21:35, shawn l.green wrote: On 2/29/2016 3:13 PM, Reindl Harald wrote: Am 29.02.2016 um 20:54 schrieb Gary Smith: On 29/02/2016 19:50, Reindl Harald wrote: cryptsetup/luks can achieve that way

Re: characters oddity

On 3/2/2016 11:29 AM, McGranahan, Jamen wrote: Have two virtual machines, both running RedHat 7. Both are also running MySQL 5.6.29 and both have the same data. We have two databases, however, that keep throwing odd characters on one system but it's OK on the other and we've not been able

Re: characters oddity

If you insert new records (or update existing) containing correct UTF-8 data to the production database using a mysql client, does the data save correctly? Could it be your data source for the production database has/is incorrectly handling the charset prior to the data being stored in the

Re: characters oddity

McGranaham, Jamen wrote: Have two virtual machines, both running RedHat 7. Both are also running MySQL 5.6.29 and both have the same data. We have two databases, however, that keep throwing odd characters on one system but it's OK on the other and we've not been able to figure out why. What it

characters oddity

Have two virtual machines, both running RedHat 7. Both are also running MySQL 5.6.29 and both have the same data. We have two databases, however, that keep throwing odd characters on one system but it's OK on the other and we've not been able to figure out why. What it should look like (from

Re: can I just encrypt tables? what about the app?

On 3/1/2016 6:26 PM, lejeczek wrote: On 29/02/16 21:35, shawn l.green wrote: On 2/29/2016 3:13 PM, Reindl Harald wrote: Am 29.02.2016 um 20:54 schrieb Gary Smith: On 29/02/2016 19:50, Reindl Harald wrote: cryptsetup/luks can achieve that way better Only to a degree. no - not

Re: can I just encrypt tables? what about the app?

On 29/02/16 21:35, shawn l.green wrote: On 2/29/2016 3:13 PM, Reindl Harald wrote: Am 29.02.2016 um 20:54 schrieb Gary Smith: On 29/02/2016 19:50, Reindl Harald wrote: cryptsetup/luks can achieve that way better Only to a degree. no - not only to a degree - when the question is

Re: can I just encrypt tables? what about the app?

On 2/29/2016 3:13 PM, Reindl Harald wrote: Am 29.02.2016 um 20:54 schrieb Gary Smith: On 29/02/2016 19:50, Reindl Harald wrote: cryptsetup/luks can achieve that way better Only to a degree. no - not only to a degree - when the question is "not store anything unencrypted on the disk"

Re: can I just encrypt tables? what about the app?

Am 29.02.2016 um 20:54 schrieb Gary Smith: On 29/02/2016 19:50, Reindl Harald wrote: cryptsetup/luks can achieve that way better Only to a degree. no - not only to a degree - when the question is "not store anything unencrypted on the disk" the is no degree, but or if Once the disk

Re: can I just encrypt tables? what about the app?

On 29/02/2016 19:54, Gary Smith wrote: However, if TDE is employed, then you've got another significant obstacle to overcome: The data is only encrypted (aiui) once it's in memory. Apologies, that should read "unencrypted (aiui) once it's in memory" Gary -- MySQL General Mailing List For

Re: can I just encrypt tables? what about the app?

On 29/02/2016 19:50, Reindl Harald wrote: cryptsetup/luks can achieve that way better Only to a degree. Once the disk is unencrypted, you've got access to the filesystem. If you've got physical access to the machine, then anything which gives you console access gives you (potentially) access

Re: can I just encrypt tables? what about the app?

Am 29.02.2016 um 20:30 schrieb shawn l.green: Hi Reindl, On 2/29/2016 2:16 PM, Reindl Harald wrote: Am 29.02.2016 um 20:07 schrieb Jesper Wisborg Krogh: Hi Lejeczek, On 1/03/2016 00:31, lejeczek wrote: hi everybody a novice type of question - having a php + mysql, can one just encrypt

Re: can I just encrypt tables? what about the app?

Hi Reindl, On 2/29/2016 2:16 PM, Reindl Harald wrote: Am 29.02.2016 um 20:07 schrieb Jesper Wisborg Krogh: Hi Lejeczek, On 1/03/2016 00:31, lejeczek wrote: hi everybody a novice type of question - having a php + mysql, can one just encrypt (internally in mysql) tables and php will be

Re: can I just encrypt tables? what about the app?

Am 29.02.2016 um 20:07 schrieb Jesper Wisborg Krogh: Hi Lejeczek, On 1/03/2016 00:31, lejeczek wrote: hi everybody a novice type of question - having a php + mysql, can one just encrypt (internally in mysql) tables and php will be fine? If not, would it be easy to re-code php to work with

<    2   3   4   5   6   7   8   9   10   11   >