Re: mysql V 8.0.12 and mysqdump

2019-02-14 Thread Walter Harms
> Halaasz Saandor hat am 9. Februar 2019 um 10:01 geschrieben: > > > 2019/02/08 10:32 ... Walter Harms: > > Hello list, > > i run into an unexpected problem with mysqldump: > > > > mysqldump --version > > mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) > > > > > >

Re: mysql V 8.0.12 and mysqdump

2019-02-09 Thread Walter Harms
> Halaasz Saandor hat am 9. Februar 2019 um 10:01 geschrieben: > > > 2019/02/08 10:32 ... Walter Harms: > > Hello list, > > i run into an unexpected problem with mysqldump: > > > > mysqldump --version > > mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) > > > > > >

Re: mysql V 8.0.12 and mysqdump

2019-02-09 Thread Halaasz Saandor
2019/02/08 10:32 ... Walter Harms: Hello list, i run into an unexpected problem with mysqldump: mysqldump --version mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) when i try it results in: mysqldump: Error: 'Lost connection to MySQL server during query' when trying to

Re: MySQL optimization for testing purpose

2018-04-04 Thread Sebastien FLAESCH
On 04/03/2018 06:15 PM, Sebastien FLAESCH wrote: On 04/03/2018 05:59 PM, Sebastien FLAESCH wrote: Hi all, Looking for some configuration tips to speed execution of our non-regression tests with MySQL. We do pure functional testing, data persistence is not critical. Our tests are not using a

Re: MySQL optimization for testing purpose

2018-04-03 Thread Sebastien FLAESCH
On 04/03/2018 05:59 PM, Sebastien FLAESCH wrote: Hi all, Looking for some configuration tips to speed execution of our non-regression tests with MySQL. We do pure functional testing, data persistence is not critical. Our tests are not using a lot of data, but we create and drop a lot of test

Re: MySQL Community Server 8.0.3-rc has been released (part 1/2)

2017-09-28 Thread Sebastien FLAESCH
Can you please stop using C++ comments in header files designed for C programming? /opt3/dbs/mys/8.0/include/mysql.h:36:1: error: C++ style comments are not allowed in ISO C90 [-Werror] // Small extra definitions to avoid pulling in my_inttypes.h in client code. ^ /opt3/dbs/mys/8.0/include/my

Re: MySQL Cluster Manager 1.4.3 has been released

2017-07-10 Thread daniel so
Hi, Sree, I'm taking care of the release now. Docs should be up soon. Daniel On 10/07/2017 6:53 AM, Sreedhar S wrote: Dear MySQL Users, MySQL Cluster Manager 1.4.3 has been released and can be downloaded from the My Oracle Support (MOS) website. It will also be available on Oracle Software

Re: MySQL server has gone away

2017-04-04 Thread Reindl Harald
Am 03.04.2017 um 21:22 schrieb Mahmood N: well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! on a proper server you have a local smtpd like postfix listening on 127.0.0.1 and hence you can send thousands of messages within seconds f

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! Anyway, thanks.  Regards, Mahmood On Monday, April 3, 2017 11:37 PM, Reindl Harald wrote: Am 03.04.2017 um 20:41 schrieb Mahmood N: > Good news! > > I changed wait_timeout=30 t

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 20:41 schrieb Mahmood N: Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. well, who did set it that low? https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_wait_ti

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. Regards, Mahmood On Monday, April 3, 2017 10:32 PM, Mahmood N wrote: Dear reindl, I tested with both 5 and 1 and see the log files are empty. I am reall

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Dear reindl, I tested with both 5 and 1 and see the log files are empty. I am really confused about that error and it is taking more than 2 weeks about that! Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 19:45 schrieb Mahmood N: So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty WTF - you had it set to 5 seconds 2 hours ago i am out here... Am 03.04.2017 um 18:11 schrieb Mahmood N: > The my.conf file contains > >

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty.  Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>since when is phpinfo() - the *real* active configuration be it changed >by some config snippet, vhost-configuration or even ini_set() - the same >than a random file in /etc? Sorry I totally didn't understand that sentence... Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 19:26 schrieb Mahmood N: given that a reasonable server should be able to handle hunredts to thousands of requests per second anything above 1 second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit th

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>given that a reasonable server should be able to >handle hunredts to thousands of requests per second anything above 1 >second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit the email test, the refresh time for that pa

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 18:11 schrieb Mahmood N: The my.conf file contains log_error=/var/log/mysql/error.log slow_query_log=1 slow_query_log_file=/var/log/mysql/error_slow.log max_connections=200 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5 character-set-client-ha

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
The my.conf file contains log_error=/var/log/mysql/error.log slow_query_log=1 slow_query_log_file=/var/log/mysql/error_slow.log max_connections=200 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5 character-set-client-handshake = FALSE thread_concurrency = 8 query_ca

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 17:52 schrieb Mahmood N: Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one te

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one terminal and at the same time, submit a test em

Re: MySQL server has gone away

2017-04-03 Thread shawn l.green
On 4/3/2017 8:15 AM, Mahmood N wrote: When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor. Commands end with ;

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 30912

Re: MySQL server has gone away

2017-04-03 Thread Johnny Withers
I'd suspect the underlying query is poorly designed for the amount of data you have stored. If you have access to the mysql server you could connect to it using any mysql client and run 'show full processlist' to see the query as that page is trying to load. The query is probably in the 'sending da

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Thanks for the quick reply. So, how can I get further information? Thing is that, after 5 minutes, when I refresh the page every thing is normal.  Regards, Mahmood On Monday, April 3, 2017 3:39 PM, Ken D'Ambrosio wrote: Basically, it says that MySQL is not responding to queries. So it

Re: MySQL server has gone away

2017-04-03 Thread Ken D'Ambrosio
Basically, it says that MySQL is not responding to queries. So it likely has died, or perhaps is mis-configured. On April 3, 2017 7:07:25 AM EDT, Mahmood N wrote: >Hi,I am using Moodle which itself uses SQL for the database. Problem is >that, when I run the email plugin and execute the command,

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

2016-12-01 Thread Reindl Harald
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 co

Re: MySQL Platform Migration

2016-09-13 Thread Johan De Meersman
l Harald" > To: "MySql" > Sent: Tuesday, 13 September, 2016 13:39:59 > Subject: Re: MySQL Platform Migration > Am 13.09.2016 um 12:13 schrieb Johan De Meersman: >> - Original Message - >>> From: "Ryan Coleman" >>> Subject: Re:

Re: MySQL Platform Migration

2016-09-13 Thread Reindl Harald
sman: - 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 contribution been, ou

Re: MySQL Platform Migration

2016-09-13 Thread Ryan Coleman
> >> 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. >&g

Re: MySQL Platform Migration

2016-09-13 Thread Reindl Harald
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 advice is al

Re: MySQL Platform Migration

2016-09-13 Thread Johan De Meersman
- 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

2016-09-13 Thread Johan De Meersman
- 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,

Re: MySQL Platform Migration

2016-09-13 Thread Reindl Harald
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 one

Re: MySQL Platform Migration

2016-09-13 Thread 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 advice is always solid. What has your contrib

Re: MySQL Platform Migration

2016-09-13 Thread 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 one, although I seem to recall,

Re: MySQL Platform Migration

2016-09-12 Thread Matthias Schmidt
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

2016-09-12 Thread Reindl Harald
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 m

Re: MySQL Platform Migration

2016-09-12 Thread Ryan Coleman
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 wro

Re: MySQL Platform Migration

2016-09-12 Thread Reindl Harald
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, i

Re: MySQL Platform Migration

2016-09-12 Thread Harrie Robins
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 c

Re: MySQL Platform Migration

2016-09-12 Thread Reindl Harald
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 in

Re: MySQL Platform Migration

2016-09-12 Thread Harrie Robins
7;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 are done - why do people > >>these days not just try out things, look if it works and when it don't > >

Re: MySQL Platform Migration

2016-09-12 Thread Reindl Harald
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: Am 11.09.2016 um 06:36

Re: MySQL Platform Migration

2016-09-11 Thread Martin Mueller
al Message - >>> From: Reindl Harald >>> To: mysql@lists.mysql.com >>> Sent: Saturday, September 10, 2016 7:19 PM >>> Subject: Re: MySQL Platform Migration >>> >>> Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal: >>>> Is ther

Re: MySQL Platform Migration

2016-09-11 Thread Ryan Coleman
gt; questions? > >> - Original Message - >> From: Reindl Harald >> To: mysql@lists.mysql.com >> Sent: Saturday, September 10, 2016 7:19 PM >> Subject: Re: MySQL Platform Migration >> >> Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal: >&g

Re: MySQL Platform Migration

2016-09-10 Thread Reindl Harald
ne and you are done - why do people these days not just try out things, look if it works and when it don't asking questions? - Original Message - From: Reindl Harald To: mysql@lists.mysql.com Sent: Saturday, September 10, 2016 7:19 PM Subject: Re: MySQL Platform Migration Am 11.0

Re: MySQL Platform Migration

2016-09-10 Thread Suresh Rajagopal
- From: Reindl Harald To: mysql@lists.mysql.com Sent: Saturday, September 10, 2016 7:19 PM Subject: 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

Re: MySQL Platform Migration

2016-09-10 Thread Reindl Harald
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: don't

Re: MySql Swapping issues

2016-09-08 Thread Jesper Wisborg Krogh
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 the

Re: MySql Swapping issues

2016-09-08 Thread Johan De Meersman
- 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 | Wai

Re: MySql Swapping issues

2016-09-07 Thread Machiel Richards
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. Th

Re: MySql Swapping issues

2016-09-07 Thread Johan De Meersman
- 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 unreasonable, especially given

Re: mysql query for current date accounting returns NULL

2016-03-26 Thread shawn l.green
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 (acc

Re: mysql query for current date accounting returns NULL

2016-03-26 Thread shawn l.green
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 DATE_FORMAT(NOW(),'%Y-%m-

Re: mysql query for current date accounting returns NULL

2016-03-25 Thread Hal.sz S.ndor
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() ,

Re: Mysql devel

2016-02-23 Thread Reindl Harald
Am 23.02.2016 um 13:12 schrieb Larry Martell: On Tue, Feb 23, 2016 at 7:07 AM, Larry Martell wrote: On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote: Am 23.02.2016 um 04:47 schrieb Larry Martell: I am trying to install the mysql devel libs (so I can build MySQLdb). This is on RHEL 6.

Re: Mysql devel

2016-02-23 Thread Larry Martell
On Tue, Feb 23, 2016 at 7:07 AM, Larry Martell wrote: > On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote: >> >> >> Am 23.02.2016 um 04:47 schrieb Larry Martell: >>> >>> I am trying to install the mysql devel libs (so I can build MySQLdb). >>> This is on RHEL 6. It's failing as shown below. Ca

Re: Mysql devel

2016-02-23 Thread Larry Martell
On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote: > > > Am 23.02.2016 um 04:47 schrieb Larry Martell: >> >> I am trying to install the mysql devel libs (so I can build MySQLdb). >> This is on RHEL 6. It's failing as shown below. Can anyone help with >> this? > > > you are mixing remi and other

Re: Mysql devel

2016-02-23 Thread Reindl Harald
Am 23.02.2016 um 04:47 schrieb Larry Martell: I am trying to install the mysql devel libs (so I can build MySQLdb). This is on RHEL 6. It's failing as shown below. Can anyone help with this? you are mixing remi and other repos Package mysql-community-devel.x86_64 0:5.7.11-1.el6 will be inst

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

2016-01-22 Thread shawn l.green
Hello Neil, On 1/22/2016 3:23 PM, Neil Tompkins wrote: 2016-01-22 19:43:48 2556 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_table_stats uses space ID: 1 at filepath: .\mysql\innodb_table_stats.ibd. Cannot open tablespace sportstrader/event w

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

2016-01-22 Thread Neil Tompkins
One point to add, that might be of interest is that the primary key and foreign key for two of related tables is a VARCHAR(255), and my MySQL version is '5.6.12-log' On Fri, Jan 22, 2016 at 8:47 PM, Lisa Smith wrote: > Hi Neil, > > When you say you delete the current database, do you mean the da

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

2016-01-22 Thread Neil Tompkins
Sorry to clarify; I have my database schema, and when the database crashes at the moment, I delete that crashed database, create the new database using the schema, and then restore the data using a import routine I have written in C Sharp, to import data from a CSV file to MySQL tables. The datab

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

2016-01-22 Thread Lisa Smith
Hi Neil, When you say you delete the current database, do you mean the database files only? Are you doing a complete restore? On Fri, Jan 22, 2016 at 1:23 PM, Neil Tompkins wrote: > Hi, > > Hoping someone can help me identify why I keep having to restore my > database. You can see below, that

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

2016-01-22 Thread Steven Siebert
The error is stating that your innodb log sequence is higher that that of the actual data files...any chance your data partition is full after your restore? On Fri, Jan 22, 2016 at 3:23 PM, Neil Tompkins wrote: > Hi, > > Hoping someone can help me identify why I keep having to restore my > datab

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

2016-01-22 Thread Neil Tompkins
My disk drive has about 3 gb free space. The sequence of events is 1. Create database 2. Restore the data 3. Use the database, SELECT data etc 4. Shut down PC 5. When I restart PC I get this error

Re: mysql dump global read lock

2015-12-19 Thread Lisa Smith
Artem, You have --add-locks listed which will run LOCK TABLES prior to each table dump. --single-transaction is for InnoDB tables and ensures that they are copied in a consistent state. I hope this helps! On Thu, Dec 17, 2015 at 4:24 PM, Artem Kuchin wrote: > Hello! > > Hereis my mysqldump com

Re: mysql instance disk quota

2015-09-06 Thread Reindl Harald
Am 06.09.2015 um 12:01 schrieb Ken Peng: How to set OS disk quota? that's hardly a mysql question http://lmgtfy.com/?q=linux+disk+quota On 2015/9/6 17:52, Reindl Harald wrote: set OS disk quota for them signature.asc Description: OpenPGP digital signature

Re: mysql instance disk quota

2015-09-06 Thread Ken Peng
How to set OS disk quota? On 2015/9/6 17:52, Reindl Harald wrote: set OS disk quota for them -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: mysql instance disk quota

2015-09-06 Thread Reindl Harald
Am 06.09.2015 um 11:37 schrieb Ken Peng: If disk quota is reached, an error can be threw out. we can accept this policy. Thanks. and damage will happen - jesus christ the worst thing for a database is "disk full", if you don't care just start the mysql instances as different users and set O

Re: mysql instance disk quota

2015-09-06 Thread Ken Peng
Hi, If disk quota is reached, an error can be threw out. we can accept this policy. Thanks. On 2015/9/6 17:28, Reindl Harald wrote: Am 06.09.2015 um 11:08 schrieb Ken Peng: We have some instances running in a hardware server, each instance has different port. For quota limits, we can adju

Re: mysql instance disk quota

2015-09-06 Thread Reindl Harald
Am 06.09.2015 um 11:08 schrieb Ken Peng: We have some instances running in a hardware server, each instance has different port. For quota limits, we can adjust my.cnf to control each instance's memory usage, also can use cgroups to set CPU quota. But what's the general solution to setup the di

Re: Mysql-Proxy Return prior to Execution

2015-08-29 Thread Stefan Certic
Managed to solve, just in case anyone else needs the same: function read_query( packet ) if string.byte(packet) == proxy.COM_QUERY then condition. if (condition) then print("replaced with " .. query ) proxy.queries:append(1, string.char(proxy.COM_QUERY)

Re: Mysql-Proxy Return prior to Execution

2015-08-29 Thread Stefan Certic
Hi Martin, Application benchmarking purposes - i don't want any latency for updates to complete. Still, data is needed. But i don't want application nor server to handle the logic wether sql went fine or not. The idea is: Fire an update / insert, return ok to application, execute query - while ap

Re: mysql Digest 12 Aug 2015 13:08:20 -0000 Issue 5317

2015-08-12 Thread hsv
On 2015/08/12 10:49, Bob Eby wrote: converting from MyISAM to innodb would certainly pose problems, I guess the main question would be is MyISAM functionality a strict sub-set of innodb? I'm not sure, but maybe someone else here knows better. No, as already said: for one thing, MyISAM allows mor

Re: mysql Digest 12 Aug 2015 13:08:20 -0000 Issue 5317

2015-08-12 Thread Reindl Harald
Am 12.08.2015 um 16:49 schrieb Bob Eby: converting from MyISAM to innodb would certainly pose problems, I guess the main question would be is MyISAM functionality a strict sub-set of innodb? I'm not sure, but maybe someone else here knows better no it is for sure not signature.asc Descri

Re: mysql Digest 12 Aug 2015 13:08:20 -0000 Issue 5317

2015-08-12 Thread Bob Eby
converting from MyISAM to innodb would certainly pose problems, I guess the main question would be is MyISAM functionality a strict sub-set of innodb? I'm not sure, but maybe someone else here knows better. Good luck, Robert -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: MySQL 5.5 Slow performance to insert

2015-07-27 Thread shawn l.green
On 7/24/2015 4:35 PM, Camilo Vieira wrote: Hi, My MySQL server is performing very slow inserts. Does somebody could help me to understand what's happening? ... snip ... ---TRANSACTION 31D6D74, ACTIVE 27107 sec mysql tables in use 8, locked 8 7470 lock struct(s), heap size 801208, 849088 row lo

Re: MySQL 5.5 Slow performance to insert

2015-07-27 Thread Johan De Meersman
- Original Message - > From: "Camilo Vieira" > Subject: Re: MySQL 5.5 Slow performance to insert > $ ./mysqltuner.pl --user root --pass abril@123 Thank you for that password :-) I don't particularly like MySQLtuner myself, it makes assumptions about your workl

Re: MySQL 5.5 Slow performance to insert

2015-07-27 Thread Camilo Vieira
Hi Luis, I have got the output below: $ ./mysqltuner.pl --user root --pass abril@123 [OK] Logged in using credentials passed on the command line >> MySQLTuner 1.5.0 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional

Re: MySQL 5.5 Slow performance to insert

2015-07-25 Thread yoku ts.
Hi, Your INSEERquery status is "Copying to tmp table", this means fetching rows which has to be inserted is slow. You should tune SELECT statement in your insert query. Adding indexes and/or simplifying query and/or .. so on. ``` ---TRANSACTION 31D6D74, ACTIVE 27107 sec mysql tables in use 8, l

Re: MySQL Variable size usage in shell prompt

2015-06-16 Thread wagnerbianchi.com
Not sure about the size of your dump, but, have you tried to set the new value on the server and client side? you can increase max_allowed_packet up to 1G. Let us know after you tried that, and maybe other guys have another solution to share... -- *Wagner Bianchi, +55.31.8654.9510* Oracle ACE Dir

Re: MySQL 5.7 Innodb performans issue

2015-05-21 Thread Morgan Tocker
Hi Jørn, > Found this after I found out what caused it: > > https://www.percona.com/blog/2009/01/21/beware-ext3-and-sync-binlog-do-not-play-well-together/ > > I suspect that this also apply to ext4, or? I would go more specific and say that sync_binlog=1 does not play well with single-threaded

Re: MySQL 5.7 Innodb performans issue

2015-05-21 Thread Jørn Dahl-Stamnes
Found the cause. sync_binlog was set to 1. I suspect that the default value is 5.5 was 0 and that is has changed to 1 sometime after that. Setting it to 0 boosted the performance back to normal (4x speed) and the HD LED indicated much lower stress on the hard disk. Found this after I found o

Re: MySQL 5.7 Innodb performans issue

2015-05-20 Thread Jørn Dahl-Stamnes
On Wednesday, May 20, 2015, wagnerbianchi.com wrote: > I'd like to add to the Morgan's note that if you want to restrict the > number of transactions inside InnoDB kernel to 16, you need at least > configure the tickets... > > => http://www.pythian.com/blog/once-again-about-innodb-concurrency-tick

Re: MySQL 5.7 Innodb performans issue

2015-05-20 Thread Morgan Tocker
Hi Jørn, >> - The data collector system processing jobs, is it multi threaded? > > Sorry, forgot about that. No, it is not multi threaded. It is a PHP bases > system using several > script running sequently in an infinite loop. Each script taking care of part > of the job of > processing the

Re: MySQL 5.7 Innodb performans issue

2015-05-20 Thread wagnerbianchi.com
I'd like to add to the Morgan's note that if you want to restrict the number of transactions inside InnoDB kernel to 16, you need at least configure the tickets... => http://www.pythian.com/blog/once-again-about-innodb-concurrency-tickets/ BTW, leave it as its default, IMHO, innodb_thread_concurr

Re: MySQL 5.7 Innodb performans issue

2015-05-20 Thread Jørn Dahl-Stamnes
On Wednesday, May 20, 2015, Morgan Tocker wrote: > Hi Jørn, > > Wagner’s point about SHOW ENGINE INNODB STATUS is a good one. A couple of > other questions about your workload: > > - The data collector system processing jobs, is it multi threaded? Sorry, forgot about that. No, it is not multi t

Re: MySQL 5.7 Innodb performans issue

2015-05-20 Thread Jørn Dahl-Stamnes
On Wednesday, May 20, 2015, wagnerbianchi.com wrote: > Can you share the SHOW ENGINE INNODB STATUS\G ? Sure, here it is. *** 1. row *** Type: InnoDB Name: Status: = 2015-05-20 20:29:56 0x7f9a4c189700 INNODB

Re: MySQL 5.7 Innodb performans issue

2015-05-20 Thread Morgan Tocker
Hi Jørn, Wagner’s point about SHOW ENGINE INNODB STATUS is a good one. A couple of other questions about your workload: - The data collector system processing jobs, is it multi threaded? - Do you have a sample schema + set of queries we could look at? (We pay close attention to regressions.)

Re: MySQL 5.7 Innodb performans issue

2015-05-20 Thread wagnerbianchi.com
Can you share the SHOW ENGINE INNODB STATUS\G ? -- *Wagner Bianchi, +55.31.8654.9510* Oracle ACE Director , MySQL Certified Professional Percona MySQL Forum Community V.I.P. Email: m...@

Re: MySQL 5.7 Innodb performans issue

2015-05-20 Thread wagnerbianchi.com
Additionally, take a look on this http://wagnerbianchi.com/blog/?p=982 as you're running mysql on SSD -- *Wagner Bianchi, +55.31.8654.9510* Oracle ACE Director , MySQL Certified Professional Percona MySQL Forum

Re: MySQL - SSL - with TLS1.2 cipher AES256-SHA256 / DHE-RSA-AES256-SHA256

2015-03-17 Thread Reindl Harald
Am 17.03.2015 um 14:25 schrieb Bhushan Rane: Thanks for instant reply. As suggested I tried with ECDHE-RSA-AES128-GCM-SHA256 and ECDHE-RSA-AES128-SHA but no luck. Created new certs for EC - configured my.cnf with new certs you *did not* really read my reply > MySQL / MariaDB don't support an

Re: Re: MySQL - SSL - with TLS1.2 cipher AES256-SHA256 / DHE-RSA-AES256-SHA256

2015-03-17 Thread Bhushan Rane
Thanks for instant reply. As suggested I tried with ECDHE-RSA-AES128-GCM-SHA256 and ECDHE-RSA-AES128-SHA but no luck. Created new certs for EC - configured my.cnf with new certs. Below are commands used for cert creation :- /opt/scr-openssl/ssl/bin/openssl ecparam -out ecc_

Re: MySQL - SSL - with TLS1.2 cipher AES256-SHA256 / DHE-RSA-AES256-SHA256

2015-03-17 Thread Reindl Harald
Am 17.03.2015 um 13:21 schrieb Bhushan Rane: I have compiled MySQL with openssl, I am able to connect to MySQL over SSL with TLS1.0 ciphers. But when I tried to connect with TLS1.2 ciphers connection fails with error MySQL / MariaDB don't support anything better than DHE-RSA-AES128-SHA (AES25

Re: Mysql Syslog client.

2015-03-13 Thread Stephan Gomes Higuti
yoku0825, Thanks for answering, I've just find out what happened. I'm using OpenSUSE 13.2, and by default it uses systemdlogger and not syslog, so, my super complex solution for this case was replacing systemdlogger for syslog! :-D Worked like a charm. Regards, Stephan Higuti On 12 March 201

Re: Mysql Syslog client.

2015-03-12 Thread yoku ts.
Hi Stephan, I've already tried syslog but it works fine in my environment. $ /usr/mysql/5.7.6/bin/mysql --syslog -h 192.168.198.214 -u yoku mysql> show databases; Mar 13 11:27:57 dev-personal-04 MysqlClient: SYSTEM_USER:'ttanaka', MYSQL_USER:'yoku', CONNECTION_ID:9, DB_SERVER:'192.168.198.214', D

Re: mysql float data type

2014-12-20 Thread Jan Steinman
> From: Lucio Chiappetti > > never used DECIMAL nor intend to Why would you blow off an important feature of any system? DECIMAL performs "infinite precision math," and should be used in ALL situations where you don't want rounding errors. It should ALWAYS be your first choice for quantities

Re: mysql float data type

2014-12-17 Thread Hartmut Holzgraefe
On 17 December 2014 14:21:40 CET, Patrick Sherrill wrote: >We always store as strings to avoid rounding issues and then convert >for calcs to whatever precision we need. >Pat... So you'll still be affected by rounding errors during conversion and calculation, two problems you'd avoid when us

Re: mysql float data type

2014-12-17 Thread Patrick Sherrill
We always store as strings to avoid rounding issues and then convert for calcs to whatever precision we need. Pat... Sent from my iPhone > On Dec 17, 2014, at 6:24 AM, Lucio Chiappetti wrote: > >> On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote: >>> On 16.12.2014 15:16, xiangdongzou wrote: >>>

  1   2   3   4   5   6   7   8   9   10   >