Re: mysql V 8.0.12 and mysqdump

> 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

> 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/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

Re: MySQL optimization for testing purpose

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

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)

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. ^

Re: MySQL Cluster Manager 1.4.3 has been released

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

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

Re: MySQL server has gone away

>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

Re: MySQL server has gone away

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?

Re: MySQL server has gone away

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

Re: MySQL server has gone away

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

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

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

>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

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

Re: MySQL server has gone away

>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

Re: MySQL server has gone away

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

Re: MySQL server has gone away

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

Re: MySQL server has gone away

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

Re: MySQL server has gone away

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

Re: MySQL server has gone away

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

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

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

Re: MySQL server has gone away

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

Re: MySQL server has gone away

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

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

Re: MySQL Platform Migration

l Harald" <h.rei...@thelounge.net> > To: "MySql" <mysql@lists.mysql.com> > 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 - >>>

Re: MySQL Platform Migration

rieb Johan De Meersman: - Original Message - From: "Ryan Coleman" <ryan.cole...@cwis.biz> 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 alway

Re: MySQL Platform Migration

gt; wrote: > > > >> Am 13.09.2016 um 12:13 schrieb Johan De Meersman: >> - Original Message - >>> From: "Ryan Coleman" <ryan.cole...@cwis.biz> >>> Subject: Re: MySQL Platform Migration >>> >>> Because they want to

Re: MySQL Platform Migration

Am 13.09.2016 um 12:13 schrieb Johan De Meersman: - Original Message - From: "Ryan Coleman" <ryan.cole...@cwis.biz> 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 edg

Re: MySQL Platform Migration

- Original Message - > From: "Reindl Harald" <h.rei...@thelounge.net> > 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 targe

Re: MySQL Platform Migration

- Original Message - > From: "Matthias Schmidt" <b...@admilon.net> > 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

Re: MySQL Platform Migration

Am 13.09.2016 um 12:09 schrieb Johan De Meersman: - Original Message - From: "Reindl Harald" <h.rei...@thelounge.net> 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 Littl

Re: MySQL Platform Migration

- Original Message - > From: "Ryan Coleman" <ryan.cole...@cwis.biz> > 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

Re: MySQL Platform Migration

- Original Message - > From: "Reindl Harald" <h.rei...@thelounge.net> > 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

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

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 are done - why do people > >>these days not just try out things, look if it

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

g questions? >> >>> - Original Message - >>> From: Reindl Harald <h.rei...@thelounge.net> >>> To: mysql@lists.mysql.com >>> Sent: Saturday, September 10, 2016 7:19 PM >>> Subject: Re: MySQL Platform Migration >>> &

Re: MySQL Platform Migration

t works and when it don't asking > questions? > >> - Original Message - >> From: Reindl Harald <h.rei...@thelounge.net> >> To: mysql@lists.mysql.com >> Sent: Saturday, September 10, 2016 7:19 PM >> Subject: Re: MySQL Platform Migration >> >> Am 11.09.2016

Re: MySQL Platform Migration

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 <h.rei...@thelounge.net> To: mysql@lists.mysql.com Sent: Saturday, September 10, 2016 7:19 PM Subject: Re: MySQL Platform Mig

Re: MySQL Platform Migration

: Reindl Harald <h.rei...@thelounge.net> 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

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:

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" <machiel.richa...@gmail.com> > 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

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

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: 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()

Re: Mysql devel

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

Re: Mysql devel

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). >>>

Re: Mysql devel

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

Re: Mysql devel

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

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

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

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

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 >

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

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\innodb_table_stats.ibd. Cannot open tablespace

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

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

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,

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

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

Re: mysql dump global read lock

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

Re: mysql instance disk quota

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

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

Re: mysql instance disk quota

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

Re: mysql instance disk quota

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

Re: mysql instance disk quota

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-Proxy Return prior to Execution

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

Re: Mysql-Proxy Return prior to Execution

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 Digest 12 Aug 2015 13:08:20 -0000 Issue 5317

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:

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

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

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

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

Re: MySQL 5.5 Slow performance to insert

- Original Message - From: Camilo Vieira camilo.vie...@gmail.com 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 workload

Re: MySQL 5.5 Slow performance to insert

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 ma...@mhtx.net Bug reports, feature requests, and downloads at http://mysqltuner.com/ Run with '--help' for

Re: MySQL 5.5 Slow performance to insert

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

Re: MySQL 5.5 Slow performance to insert

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,

Re: MySQL Variable size usage in shell prompt

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

Re: MySQL 5.7 Innodb performans issue

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

Re: MySQL 5.7 Innodb performans issue

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

Can you share the SHOW ENGINE INNODB STATUS\G ? -- *Wagner Bianchi, +55.31.8654.9510* Oracle ACE Director https://apex.oracle.com/pls/otn/f?p=19297:4:105567988301604::NO:4:P4_ID:4541, MySQL Certified Professional Percona MySQL Forum http://www.percona.com/forums/ Community V.I.P. Email:

Re: MySQL 5.7 Innodb performans issue

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

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 data.

Re: MySQL 5.7 Innodb performans issue

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

Re: MySQL 5.7 Innodb performans issue

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,

Re: MySQL 5.7 Innodb performans issue

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 https://apex.oracle.com/pls/otn/f?p=19297:4:105567988301604::NO:4:P4_ID:4541, MySQL Certified Professional Percona MySQL Forum

Re: MySQL 5.7 Innodb performans issue

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

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-tickets/

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

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

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

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

Re: Mysql Syslog client.

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

Re: Mysql Syslog client.

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',

Re: mysql float data type

From: Lucio Chiappetti lu...@lambrate.inaf.it 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

Re: mysql float data type

On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote: On 16.12.2014 15:16, xiangdongzou wrote: Can anyone tell me why 531808.11 has been changed to 531808.12 ? typical decimal-binary-decimal conversion/rounding error. never used DECIMAL nor intend to, but the issue is typical of precision

Re: mysql float data type

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 lu...@lambrate.inaf.it wrote: On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote: On 16.12.2014 15:16,

Re: mysql float data type

On 17 December 2014 14:21:40 CET, Patrick Sherrill patr...@michael-clarke.com 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

  1   2   3   4   5   6   7   8   9   10   >