DevHeads.net

Postings by walter harms

mysql V 8.0.12 and mysqdump

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 seems it get stuck in this query:

explain SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE,
ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE
_TYPE = 'UNDO LOG' AND FILE_NAME IS NOT NULL A

signal handling in mysql cli

hi list,

when i use CTRL-C to break a query that works fine in interactive mode.

mysql> select sleep(10) ;
^CCtrl-C -- sending "KILL QUERY 24289" to server ...
Ctrl-C -- query aborted.
+-----------+
| sleep(10) |
+-----------+
+-----------+
1 row in set (0.86 sec)

but when i use the noninteractive mode
timeout 5 mysql -BAN -e "select now(); select sleep (100) ; select now() "

i looks like that but "show full processlist;" shows otherwise and that is true
as a list of long running querys showed.

Is there a way to make it behave like the interactive version ?
Now it is a bit confusing fo

open files in mysqld 5.1.53

Hi list,
i am trying to understand the incredible use of filepointers in our mysql server (5.1.53).
under normal condition the server reports 10k-15k open files pointer.
I run a 'flush tables' every 2h to avoid problems, the number of users/connections is constant
It is an automatic system but a few human users, a happy mix of myisam and innodb tables running
with no problems on mysqld 5.0 . But now sometimes i am
hit with an insane increase hitting the ceiling at 60k.

log sequence number InnoDB: is in the future!?

hi list,

i am using mysql 5.1.53.
after a crash i have the follwing error in my log:

130128 10:45:25 InnoDB: Error: page 61 log sequence number 0 2871649158
InnoDB: is in the future! Current system log sequence number 0 2494349480.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files.

ERROR 2013 (HY000): - Why ?

hi List,
i get occasionally the following error:
ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32

I have no clue what is the problem. The script is running fine most times, the computers are not far away.
Is seems that the error occurs more often the more close the boxes are.

anyone an idea how to locate the problem ?

optimize and tmpfiles

hi list,
does someone know under what circumstances ''optimize tables'' will
create a tmpfile ?

we had a strange case of "out of space" that seems related to an "optimize table"
but i was unable to replicate that case exactly as that no tmpfile appeared.
(The table has a lot of partitions if that matters.)

re,
wh

what is stored in /var/lib/mysql_log/ ?

hi list,

on my system this this directory contains ib_logfile0/ib_logfile1, so far no problem.

From the documentation i had the impression that this is everything and
the files size should not change.

but it seems that immodb also uses this space for temp space, do they make
a copy of ib_logfile here ?

re,
wh

restrict Connect Time

Hi list,
is there a switch where i can restrict the connect/execution time for a query ?

re,
wh

different desc for same statement

hi list,
i have a very strange effect.

I have two boxes with the same DB ( same version, same tables, same my.cnf, etc)
I was trying to optimise an sql statement and used desc to see what is going on
and found to my surprise two different results.

Can this be the result of the optimizer ?