Re: audit trails

Hi Guys Thank you very much for all the input, I appreciate it. @ Johan Once again glad to deal with you. I do agree that triggers are not the way to go and I personally also do not like using it unless absolutely required. I do feel other solutions may be better, however ,

Re: audit trails

Triggers are not the best way to go about this. Consider: * What is to stop a malicious user from truncating the audit table? * Triggers may fail (corrupt target table, for instance) and a trigger failure may cancel the source statement * Triggers have a performance impact - you're basically

Re: audit trails

2016/12/07 01:26 ... mach...@seworx.co.za: well in essence the following is required. we need to know who made what changes to tables. There is a machination that you can try in every trigger that will add the user-name to the binary log: set @asdfasdfasd = CURRENT_USER(); INSERT

Re: audit trails

Thank you for the reply. well in essence the following is required. we need to know who made what changes to tables. we recently had a case of important data being deleted, however finding it i binary logs proved 2 things : 1. it takes very long to find as we did not know in

Re: audit trails

2016/12/06 02:33 ... mach...@seworx.co.za: The audit table should include the following information: -- Who made the changes (username logged in) -- What type of change (insert,update,delete) -- Date of change including time. -- if update, which fields

audit trails

Good day all I am hoping this mail finds all well... I am in need of some assistance please. We have a few tables that I need to add auditing information for. The idea is that we need to create an audit table that will track the following on the main table : - any

Re: rescue Inno tables from an abandoned data directory?

Hi Martin, On 4/12/2016 07:23, Martin Mueller wrote: I abandoned a MySQL 5.22 database that quite suddenly andthat I wasn’t able to start up again. The data directory consists of a mix of ISAM and Inno tables. I was able to copy the ISAM tables into a new 5.6 version, and they work.

Re: rescue Inno tables from an abandoned data directory?

Hi Martin On 4/12/2016 07:23, Martin Mueller wrote: I abandoned a MySQL 5.22 database that quite suddenly andthat I wasn’t able to start up again. The data directory consists of a mix of ISAM and Inno tables. I was able to copy the ISAM tables into a new 5.6 version, and they work. I

Re: a curse on OS sierra and MySQL?

Well, the command sudo /usr/local/mysql/support-files/mysql.server stop generates the error message: ERROR! MySQL server PID file could not be found! On the other hand, sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist stops the server and sudo

Re: rescue Inno tables from an abandoned data directory?

On 12/3/2016 14:23, Martin Mueller wrote: I abandoned a MySQL 5.22 database There's been 5.0m 5,1, 5,4 (briefly), 5.5, 5.6 and now 5.7. No 5,.2. that quite suddenly andthat I wasn’t able to start up again. The data directory consists of a mix of ISAM and Inno tables. You mean MyISAM?

Re: a curse on OS sierra and MySQL?

On 12/3/2016 13:58, Martin Mueller wrote: I was able to install a version of MySQL 5.6 on OS Sierra. It appears that the “launchdaemon’ method works while the mysql.server start/stop method does not work. In retrospect I should have seen that, but I also think that the official documentation

Re: rescue Inno tables from an abandoned data directory?

Am 03.12.2016 um 21:23 schrieb Martin Mueller: In my case, I can reproduce Time machine backups of data directories at varying times. At one point I was able to replace the non-working installation with an earlier installation, but then it failed unpredictably. Are the Inno tables on Time

rescue Inno tables from an abandoned data directory?

I abandoned a MySQL 5.22 database that quite suddenly andthat I wasn’t able to start up again. The data directory consists of a mix of ISAM and Inno tables. I was able to copy the ISAM tables into a new 5.6 version, and they work. I understand that INNO tables are different because different

Re: a curse on OS sierra and MySQL?

On 12/2/2016 17:58, Martin Mueller wrote: Alas, running the stop and start commands under sudo makes zero difference. ?! The cited page recommends more than sudo starts and stops, eg ... |unset TMPDIR mysql_install_db | Did you try that? Did you check the pid setting in my.cnf, eg

Re: a curse on OS sierra and MySQL?

2016/12/02 18:58 ... Martin Mueller: Alas, running the stop and start commands under sudo makes zero difference. This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s cleary a problem that has been around for years because

Re: a curse on OS sierra and MySQL?

Alas, running the stop and start commands under sudo makes zero difference. This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s cleary a problem that has been around for years because the Web is full of complaints and tips.

Re: a curse on OS sierra and MySQL?

On 12/2/2016 16:59, Martin Mueller wrote: I have been trying repeatedly and in vain to install the community edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the instructions for uninstalling previous versions found at

a curse on OS sierra and MySQL?

I have been trying repeatedly and in vain to install the community edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the instructions for uninstalling previous versions found at http://community.jaspersoft.com/wiki/uninstall-mysql-mac-os-x, and installation

Re: Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again

Am 01.12.2016 um 08:26 schrieb Götz Reinicke - IT Koordinator: it happend again and I can't fix it, may be someone has a working solution and information on that: surely -> man systemd LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 I installed the most recent mysql 5.6

Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again

Hi, it happend again and I can't fix it, may be someone has a working solution and information on that: I installed the most recent mysql 5.6 community on a server and do get a lot of "errno: 24 - Too many open files". There are suggestions to increase the open_files_limit, change/add that to

[ANN] Mroonga 6.11 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 6.11 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

Re: [ANN] Mroonga 6.10 - Fast fulltext search for all languages on MySQL

Hi, sorry for late response. Currently we have NO RECENT benchmark for direct comparison of Mroonga vs Elasticsearch. However, there are some helpful benchmarks. 1) Groonga 4.0.1 vs Elasticsearch 1.1.1 at 2014 http://blog.createfield.com/entry/2014/04/21/120023 (Japanese) (Note: Groonga

Fwd: Unknown system variable

Hi All, I am getting below error when executing one of my script. File "build/bdist.freebsd-7-amd64/egg/MySQLdb/cursors.py", line 173, in execute File "build/bdist.freebsd-7-amd64/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler _mysql_exceptions.OperationalError: (1193,

Re: [ANN] Mroonga 6.10 - Fast fulltext search for all languages on MySQL

Can you post some benchmarks or comparison with elasticsearch? Sent from ProtonMail mobile Original Message On 29 ott 2016 05:03, Kentaro Hayashi wrote: Hi, Mroonga 6.10 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and

[ANN] Mroonga 6.10 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 6.10 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

MySQL Connector/NET 7.0.6 m5 development has been released

Dear MySQL users, MySQL Connector/Net 7.0.6 is the third development release that expands cross-platform support to Linux and OS X when using Microsoft's .NET Core framework. Now, .NET developers can use the X DevAPI with .NET Core and Entity Framework Core (EF Core) 1.0 to create server

MySQL Connector/Python 2.0.5 GA has been released

Dear MySQL users, MySQL Connector/Python 2.0.5 GA is a new GA version of 2.0 release series of the pure Python database driver for MySQL. It can be used for production environments. MySQL Connector/Python version 2.0.5 is compatible with MySQL Server versions 5.5 and greater. Python 2.6 and

RE: 5.7.16 compilation fails due to libevent references in xplugin

Sorry, I should have specified this is on RHEL 6.7 -Original Message- From: Pitts, Matthew W. Sent: Wednesday, October 26, 2016 12:13 PM To: 'mysql@lists.mysql.com' Subject: 5.7.16 compilation fails due to libevent references in xplugin I am trying to compile mysql-boost 5.7.16 from

5.7.16 compilation fails due to libevent references in xplugin

I am trying to compile mysql-boost 5.7.16 from source to run it from a specific account/directory but I am running into an error [1] that seems to indicate that a libevent symbol cannot be found. I'm not very familiar with the mysql source, but it seems to include its own copy of libevent, so this

ANN: DAC for MySQL 3.0.7 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.

MySql installer for windows 7

Hi all—   I am new to the list and to MYSql. I downloaded MySqlcommunity and I tried to installing it using MySql installer. I am stuck whereMYSql needs to manually connect to Python 3.4 which I had already installed onmy computer. But for some reason, the installer cannot connect to Pythin

MySQL Connector/C++ 2.0.3 m3 Development Release has been released

Dear MySQL users, MySQL Connector/C++ 2.0.3 is the next development milestone of the MySQL Connector/C++ 2.0 series, and the first public release. Apart from covering more X DevAPI features, it adds a new, plain C API, called XAPI, that offers functionality similar to X DevAPI to applications

MySQL Cluster 7.3.15 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides: - In-Memory storage - Real-time performance (with optional checkpointing to disk) - Transparent Auto-Sharding - Read & write scalability - Active-Active/Multi-Master

MySQL Community Server 5.7.16 has been released

Dear MySQL users, MySQL Server 5.7.16, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.16 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see

MySQL Community Server 5.6.34 has been released

Dear MySQL users, MySQL Server 5.6.34, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.34 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see

MySQL Connector/Node.js 1.0.4 m3 Development Release has been released

Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the X DevAPI. This release, v1.0.4 M3, is the third development release of the MySQL Connector/Node.js 1.0 series. The X DevAPI enables application developers to write code that combines the strengths of the

Starting MySQL takes a long long time

Hello all, Had a normal MySQL shutdown, reboot and then this happens: 161010 10:58:30 [Note] Plugin 'FEDERATED' is disabled. 161010 10:58:31 InnoDB: The InnoDB memory heap is disabled 161010 10:58:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions 161010 10:58:31 InnoDB:

Re: Mystery error in GRANT statement

> Date: Monday, October 03, 2016 23:18:14 -0700 > From: James Moe > > On 10/03/2016 08:16 PM, Richard wrote: >> If you want/need to use it I believe you need to use the >> "backtick" to quote the name >> > Yes, that worked. Thank you. > Is there an easy way to rename a

Re: Mystery error in GRANT statement

On 10/03/2016 08:16 PM, Richard wrote: > If > you want/need to use it I believe you need to use the "backtick" to > quote the name > Yes, that worked. Thank you. Is there an easy way to rename a database? -- James Moe moe dot james at sohnen-moe dot com 520.743.3936 Think. signature.asc

Re: Mystery error in GRANT statement

> Date: Monday, October 03, 2016 18:39:22 -0700 > From: James Moe > > opensuse v42.1 > linux 4.1.31-30-default x86_64 > 10.0.26-MariaDB > > I have a database named "sma-v4-01". The GRANT statement does not > like that database name: > > MariaDB [sma-v4-01]> GRANT ALL ON

Re: Mystery error in GRANT statement

Nothing. But you opened your quote 27th a " and tried to close it with a ' Quote mismatch. Get Outlook for Android On Mon, Oct 3, 2016 at 9:45 PM -0400, "James Moe" > wrote: opensuse v42.1 linux 4.1.31-30-default

Mystery error in GRANT statement

opensuse v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I have a database named "sma-v4-01". The GRANT statement does not like that database name: MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (42000): You have an

Mystery error in GRANT statement

opensuse v42.1 linux 4.1.31-30-default x86_64 10.0.26-MariaDB I have a database named "sma-v4-01". The GRANT statement does not like that database name: MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO ''@'sma-station14l' IDENTIFIED BY 'xx'; ERROR 1064 (42000): You have an

Init script fails.

TLDR = /etc/init.d/mysql start fails after the following line (line 22), and I would like to fix it so that init starts mysqld automatically. Problem line: |./lib/lsb/init-functions| This is included in nearly all init scripts, and other init scripts work just fine. Putting breadcrumbs in

[ANN] Mroonga 6.09 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 6.09 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

Re: Update to Percona CVE-2016-6662 Vulnerability Communication

Am 16.09.2016 um 00:21 schrieb Johan De Meersman: - Original Message - From: "Reindl Harald" Sent: Friday, 16 September, 2016 00:12:26 frankly - mysqld_safe needs to go away and life is beautiful without for years here and yes taht worked for mysql too before

Re: Update to Percona CVE-2016-6662 Vulnerability Communication

- Original Message - > From: "Reindl Harald" > Sent: Friday, 16 September, 2016 00:12:26 > > frankly - mysqld_safe needs to go away and life is beautiful without for > years here and yes taht worked for mysql too before switch to MariaDB > > to say it clear:

Re: Update to Percona CVE-2016-6662 Vulnerability Communication

Am 16.09.2016 um 00:05 schrieb Johan De Meersman: This is probably of interest to many of you, and I've not seen it on the list yet. Kenny Gryp's blog about the vulnerability is at https://www.percona.com/blog/2016/09/12/database-affected-cve-2016-6662/ . For those who use it, there's an

Fwd: Update to Percona CVE-2016-6662 Vulnerability Communication

This is probably of interest to many of you, and I've not seen it on the list yet. Kenny Gryp's blog about the vulnerability is at https://www.percona.com/blog/2016/09/12/database-affected-cve-2016-6662/ . For those who use it, there's an ansible playbook to patch the workaround into

Re: MySQL Platform Migration

Right... if even a fraction of that is true (I have no reason to doubt you, but I can also not verify any of it, obviously), that is imo certainly something to take up with a list moderator (Shawn ?). That kind of behaviour is unacceptable. - Original Message - > From: "Reindl Harald"

Re: MySQL Platform Migration

Am 13.09.2016 um 13:47 schrieb Ryan Coleman: Right... I don't like seeing people being shredded by a high strung personality because they simply don't understand things at your level, Reiny. the message where you responded with "jackasses" was actually nice and you are hardly at the

Re: MySQL Platform Migration

Right... I don't like seeing people being shredded by a high strung personality because they simply don't understand things at your level, Reiny. Be nice to people and I won't say anything. Be an ass and I will. > On Sep 13, 2016, at 06:39, Reindl Harald wrote: > >

Re: MySQL Platform Migration

Am 13.09.2016 um 12:13 schrieb Johan De Meersman: - Original Message - From: "Ryan Coleman" Subject: Re: MySQL Platform Migration Because they want to be belittled by european jackasses online. The thing is, while he has a bit of a rough edge, his technical

Re: MySQL Platform Migration

- Original Message - > From: "Reindl Harald" > Subject: Re: MySQL Platform Migration > > we discussed this multiple times here True; but new people on the list may not have seen that. > when you *copy* the datadir on the target machine nobody eats your data >

Re: MySQL Platform Migration

- Original Message - > From: "Matthias Schmidt" > Subject: Re: MySQL Platform Migration > > I had to make certain adjustements to the config file thou. Interesting - what changes did you have to make? I would expect most things to just keep working as they are, unless

Re: MySQL Platform Migration

Am 13.09.2016 um 12:09 schrieb Johan De Meersman: - Original Message - From: "Reindl Harald" Subject: Re: MySQL Platform Migration why shouldn't it when the identical software is running? it's just a bunch of files used by mysql Little/big endianness, for

Re: MySQL Platform Migration

- Original Message - > From: "Ryan Coleman" > Subject: Re: MySQL Platform Migration > > Because they want to be belittled by european jackasses online. The thing is, while he has a bit of a rough edge, his technical advice is always solid. What has your

Re: MySQL Platform Migration

- Original Message - > From: "Reindl Harald" > Subject: Re: MySQL Platform Migration > > why shouldn't it when the identical software is running? > it's just a bunch of files used by mysql Little/big endianness, for one, although I seem to recall, and your later

MySQL Community Server 8.0.0-dmr has been released (part 3/3)

[This is part 3 of the announcement] Bugs Fixed * Important Change: The empty string value is now accepted as a key when used with JSON functions such as JSON_EXTRACT(). In such cases, it must be quoted. (Bug #79643, Bug #22366102) * MySQL Cluster: Previously,

MySQL Community Server 8.0.0-dmr has been released (part 2/3)

[This is part 2 of the announcement] Performance Schema Notes * Incompatible Change: The Performance Schema now instruments server errors (and warnings), and exposes statistical information about them through a set of summary tables: + The error instrument

Re: MySQL Platform Migration

Hello, I’m quite new to this list and I’m surprised about the vocabulary used on this list by certain people, who besides that do not add any productive idea to the problem asked by the OT. Besides that I upgraded just from MacOS10.6 -> 10.11 and copying just the data folder did the job. As I

Re: MySQL Platform Migration

Am 12.09.2016 um 15:06 schrieb Ryan Coleman: Dear sir, You do not realize that there aren’t always sys admins on these lists how does that change the fact that it just works and it did work from day one as described long before i became a sysadmin and that it now works over 15 years from

Re: MySQL Platform Migration

Dear sir, You do not realize that there aren’t always sys admins on these lists. Your proven track record of asshole first, kid gloves later drives people away. Your fight to change mailing lists is one which only you seem to share. Goodnight. > On Sep 12, 2016, at 7:27 AM, Reindl Harald

Re: MySQL Platform Migration

first: get rid of "reply-all"o n mailing-lists, you break others "reply-list" button with the second copy which arrives usually faster the the list one Am 12.09.2016 um 13:35 schrieb Harrie Robins: It is bad practice to do so in my eyes (and yes that is an *opinion*). When you advice people,

Re: MySQL Platform Migration

Hi, . It is bad practice to do so in my eyes (and yes that is an *opinion*). When you advice people, instruct them to take the proven route, as described in the mysql documentation. Second, mastering mysqldump should be golden standard for any DBA. Telling someone that asks for guidance to simply

Re: MySQL Platform Migration

Am 12.09.2016 um 10:48 schrieb Harrie Robins: Ok let's drop this. Simply copying files to migrate a server is not the approach to take (in my humble opinion) And why? When you start with "Get the same release-version of mysql running on the target platform" and dump/load what's the point

Re: MySQL Platform Migration

Ok let's drop this. Simply copying files to migrate a server is not the approach to take (in my humble opinion). First asses the situation, a platform migration? Get the same release-version of mysql running on the target platform. Dump your mysql database the with the excellent tool mysqldump

Re: MySQL Platform Migration

Am 11.09.2016 um 20:27 schrieb Ryan Coleman: Because they want to be belittled by european jackasses online. if you insist in not get any mail from me just shut up when nobody asked you - mind your own business On Sep 10, 2016, at 11:56 PM, Reindl Harald wrote:

Re: MySQL Platform Migration

Not very helpful rhetoric on either side of the fence. Every time an unnecessary comment is made, some time cost is imposed on the folks who make the mistake of opening the email thinking there was some useful advice. Civilization and good manners consist very largely of bitten tongues. And

Re: MySQL Platform Migration

Because they want to be belittled by european jackasses online. On Sep 10, 2016, at 11:56 PM, Reindl Harald wrote: > > > Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal: >> Is the mysql datafile compatible with different operation system ? I have >> not done this in

Re: MySQL Platform Migration

Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal: Is the mysql datafile compatible with different operation system ? I have not done this in the past. why shouldn't it when the identical software is running? it's just a bunch of files used by mysql as said copy it to the new machine and you

Re: MySQL Platform Migration

Hi Reindl, Is the mysql datafile compatible with different operation system ? I have not done this in the past. Regarding cross-post, mysql list was bouncing due to html email format. Didn't realize until today. That's why posted in mariadb. Thanks Suresh - Original Message - From:

Re: MySQL Platform Migration

Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal: Is there any documentation for migrating mysql 5.0 database from darwin to Linux what do you need to migrate? shutdown mysqld, copy the datadir to the new machine, stat mysqld with adopted configuration ion the new machine - done P.S:

MySQL Platform Migration

Hi, Is there any documentation for migrating mysql 5.0 database from darwin to Linux. Thanks Suresh Rajagopal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

ANN: Database Workbench 5.2 now includes PostgreSQL support

Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.2 " This release includes support for PostgreSQL and adds several other features. Database Workbench 5 comes in multiple editions with different

Re: MySql Swapping issues

Hi Machiel, On 8/09/2016 05:24, Machiel Richards wrote: ... Biggest issue at the moment is mysql taking all physical memory until nothing left, the starts swapping as well until that is completely used up. Since you are using MySQL 5.7, you can consider enabling memory instrumentation in

Re: MySql Swapping issues

- Original Message - > From: "Machiel Richards" > Subject: Re: MySql Swapping issues > > When I monitor the MySQL processlists, there is constantly about 30-35 > processes > and half of them never change simply showing as : > > Connect | 124678 | Waiting for

Re: MacOS Server 5 problem after upgrade

> Am 04.09.2016 um 23:35 schrieb Reindl Harald : > > > > Am 04.09.2016 um 16:17 schrieb Matthias Schmidt: >>> Am 04.09.2016 um 16:29 schrieb Reindl Harald : >>> >>> Am 04.09.2016 um 08:40 schrieb Matthias Schmidt: 2016-09-04 15:25:19 85518

Re: MySql Swapping issues

In terms of the amount of processes, that is the max amount ever seen. The servers are monitored 24/7 so it is constantly under hawk eye from both staff and monitoring systems. The other memory values I was referring to are things like the open-table cache, and other buffers as you assumed yes.

Re: MySql Swapping issues

- Original Message - > From: "Machiel Richards" > Subject: MySql Swapping issues > >I had a look at the settings and the innodb buffer pool on one server > is set to about 70% of the physical memory and the others to about 30% of > physical memory. Not

MySql Swapping issues

Hi Guys I am hoping this mail find everyone to be good. I am looking for some more info or perhaps some advice on an issue that I am busy investigating. There are 4 databases that I am busy looking at that seems to be building up memory usage over the course of 3 to 4 days and once

MySQL Community Server 5.7.15 has been released

Dear MySQL users, MySQL Server 5.7.15, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.15 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see

MySQL Community Server 5.6.33 has been released

Dear MySQL users, MySQL Server 5.6.33, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.33 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see

Re: MacOS Server 5 problem after upgrade

Am 04.09.2016 um 16:17 schrieb Matthias Schmidt: Am 04.09.2016 um 16:29 schrieb Reindl Harald : Am 04.09.2016 um 08:40 schrieb Matthias Schmidt: 2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file

Re: MacOS Server 5 problem after upgrade

> Am 04.09.2016 um 16:29 schrieb Reindl Harald : > > > > Am 04.09.2016 um 08:40 schrieb Matthias Schmidt: >> 2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't >> create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102 >> -

Re: MacOS Server 5 problem after upgrade

Am 04.09.2016 um 08:40 schrieb Matthias Schmidt: 2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102 - Operation not supported on socket) 2016-09-04 15:25:19 85518 [ERROR] Can't start server: can't

MacOS Server 5 problem after upgrade

Hello, sorry if this question has been asked already - at least google din’t find a sufficient answer :( I have been upgrading a MacOS 10.6 server to serverv5, which is MacOS 10.11 I was running before: mysql-5.5.40-osx10.6-x86_64 upgrade has been always a no-brainer: download the dmg and run

[ANN] Mroonga 6.08 - storage engine, fast fulltext search, CJK ready

Hi, Mroonga 6.08 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

Re: Show master status - "mysqld_multi" - distribution master[SOLVED]

On 23/08/16 11:26, sujeet gupta wrote: Hi Dear, It's not a mysql issue, show me every step you followed to create master slave hierarchy. Its like you missed some steps while configuring server. Show master configuration and slave configuration separately. On Aug 23, 2016 6:45 PM, "Jose Julian

Show master status - "mysqld_multi" - distribution master

Hi, i have a server acting as a replication distribution master(taking from the real master), with several mysql instances (instance 1,instance 2...) with mysqld_multi script, and many replication filters just to avoid using bandwidth to the remote datacenters with useless data. It's working

Re: filename-safe conversion of database-/tablenames

- Original Message - > From: "Simon Fromme" > Subject: filename-safe conversion of database-/tablenames > > I need to convert both the names of databases and tables in a > filename-safe way (escaping "/" and other characters as in [1]). The I don't know what strange

filename-safe conversion of database-/tablenames

Hello, In order to do MySQL-dumps to a file on a Linux system under $BACKUP_DIR/$DB_NAME/$TABLE_NAME.sql I need to convert both the names of databases and tables in a filename-safe way (escaping "/" and other characters as in [1]). The mapping of MySQL database/table name to the

MySQL Utilities 1.6.4 GA has been released

Dear MySQL users, MySQL MySQL Utilities 1.6.4 GA is the first GA version of 1.6 release series. It can be used for production environments. MySQL Utilities version 1.6.4 GA is compatible with MySQL Server versions 5.5 and greater. Python v2.6 and v2.7 are supported. It is available for download

MySQL Utilities 1.6.4 GA has been released

Dear MySQL users, MySQL MySQL Utilities 1.6.4 GA is the first GA version of 1.6 release series. It can be used for production environments. MySQL Utilities version 1.6.4 GA is compatible with MySQL Server versions 5.5 and greater. Python v2.6 and v2.7 are supported. It is available for download

[ANN] Mroonga 6.07 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 6.07 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide

cleaning up

Hi, There are lot mysql transactions with the "cleaning up" state on my Mysql 5.6.31: TRANSACTIONS Trx id counter 26782150 Purge done for trx's n:o < 26774181 undo n:o < 0 state: running but idle History list length 739 LIST OF TRANSACTIONS FOR EACH SESSION:

MySQL Notifier 1.1.7 has been released

Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL Notifier version 1.1.7, the latest addition to the MySQL Installer for Windows. MySQL Notifier enables developers and DBAs to easily monitor, start and stop all their MySQL database instances. It

Re: find any row with NULL

... Now - would searching, saving/storing then removing NULL vs ALLbutNULL in a simple DB with one table wich has only primary key be sa ... What is "removing NULL"? Deleting the record with NULL? It has no bearing on the primary key, because NULL never is allowed in one. It seems to me that

MySQL Community Server 5.7.14 has been released

Dear MySQL users, MySQL Server 5.7.14, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.14 is recommended for use on production systems. Since MySQL Server 5.7.13, we have introduced the concept of Rapid Plugins. Out of the box, 5.7.14 follows

MySQL Community Server 5.6.32 has been released

Dear MySQL users, MySQL Server 5.6.32, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.32 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see

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