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 to dump tablespaces mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL server has gone away (2006) I regulary hav this problem with the command-line client (mysql.exe) and when I asked R H gave this answer (and with the command-line client it is much less imporant): Forwarded Message Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query Date: Mon, 06 Jan 2014 17:07:45 +0100 From: Reindl Harald Am 06.01.2014 15:36, schrieb h...@tbbs.net: > Now that I installed 5.6.14 on our Vista machine, when using "mysql" I often see that error-message, which under 5.5.8 I never saw. What is going on? what about look in the servers logfiles most likely "max_allowed_packet" laughable low -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Connections from mysql8.0 to mysql5.1 - bad handshake
2018/10/31 15:15 ... Jim: Given the following bug report, what I am trying to do does not sound hopeful: https://bugs.mysql.com/bug.php?id=90994 ... Any thoughts or do I need to accept that what I'm attempting just isn't going to work? From the same bug report, id=90994: [24 Oct 20:17] Brad Jackson Version 8.0.13 was released on 10/22 and the change list says: "Support for MySQL 5.5 by MySQL Workbench 8.0 was removed. If you still need to use MySQL Workbench on a MySQL 5.5 server, you can use MySQL Workbench 6.3" I guess we're all stuck on the old version until we upgrade our servers. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: info on open tables
2018/09/28 07:48 ... Machiel Richards: During the times when it experiences issues, I found that there is always about 4-5 processes on mysql that gets stuck on "closing table" state and once the software (opensips) is restarted due to a sigfault, then these queries are killed as well. Based on information found we added grafana graphs and did notice that the table_open_cache is fully used during the time of the sigfaults and the queries getting stuck so we tested by increasing the table_open_cache. This did however not resolve the issue as we simply saw table_open_cache using the full value of 3000 and once again the same behaviour. When running "Show open tables" though, we find that the amount of open tables is only 283 and a count of all tables returned that there is only 381 tables on the server. However when running "Show global status like 'open_tables' we get a value of 2900. So my questions are as follows : 1. Why is the table_open_cache used up if there are not even that many tables. 2. Why does these values differ so much? or do they provide different info. These occur to me: "If you have no privileges for a table, it does not show up in the output from SHOW OPEN TABLES." If an table is kept open, but there is no action, does it stay in the cache? One shows really only the tables, the other shows a table with its user. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql