Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql5]

137 questions
2
votes
2 answers

MySQL server database log

I have a website with MySQL database. Someone deleted 1,000 records from a table. Is there any way to find out who have deleted the records and when from the website? And from where the records were deleted: from website or from phpmyadmin? It will…
Jagat Sheth
  • 71
  • 1
  • 5
2
votes
1 answer

MySQL ERROR 2026 (HY000): SSL connection error

I have enabled SSL on MySQL 5.1.52 on CentOS 6.0 using the following guide: http://www.madirish.net/node/244 I have followed the instructions correctly but I am running into the following error when I try to connect from the client server: [root@mta…
Meisam Mulla
  • 127
  • 1
  • 1
  • 10
2
votes
2 answers

Broken Slave (MySQL replication)

Last night one of the developer ran a wrong mySQL statement (Query inserting a row with duplicate primary key) on master machine. Suddenly the replication to its slave stopped. Slave started writing it to mysql_relay_logs and before we could monitor…
Sparsh Gupta
  • 1,127
  • 7
  • 21
  • 31
2
votes
1 answer

Mysql performance, understanding top

We have a 64 bit mac os x server running mysql. The machine has 48 GB of ram. Top shows as below. MemRegions: 12053 total, 16G resident, 12M private, 76M shared. PhysMem: 2072M wired, 17G active, 29G inactive, 48G used, 21M free. Top output for…
Boolean
  • 533
  • 1
  • 4
  • 10
2
votes
1 answer

Anyone have issues with a MySQL 5.1 to 5.5 in-place Upgrade in Production?

We are about to upgrade our MySQL boxes from 5.1 to 5.5 and because of the size, would prefer to do this as an in-place upgrade. Are there any issues with this? From my research, I noticed that the MySQL manuals for 5.0 and 5.1 mention that they…
David Hall
  • 123
  • 4
2
votes
1 answer

why SET timestamp in Slow query logs?

I use mysql Ver 14.12 Distrib 5.0.86, for unknown-linux-gnu (x86_64) using readline 5.1, I am seeing below query in the slow query logs: # Time: 110907 7:00:09 # User@Host: XXX[XXX] @ [10.1.10.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 …
user79483
  • 411
  • 1
  • 7
  • 9
2
votes
2 answers

mysqlcheck doesn't support multiple contradicting commands

Any idea why I am seeing this error message? This script works fine on a ever so slightly older version of MySQL running on a different server with a similar config. :: check/analyze/repair/optimize @echo. @echo Check Tables %MYSQL_BIN%\mysqlcheck…
Chris
  • 299
  • 2
  • 4
  • 9
2
votes
2 answers

Upgrade from MySQL 4 to Mysql 5 - same my.cnf - lots of random disconnects

I've recently moved from MySQL4 to MySQL5 (we had apps that required MySQL4 which we'd finally replaced) Since then, I've been having LOTS of issues similar to:- connect() failed: Lost connection to MySQL server at 'reading initial communication…
Mez
  • 457
  • 1
  • 5
  • 15
2
votes
1 answer

MySQL writing to net

I have a server that has been running at high CPU load due to MySQL activity, when i run the command mysqladmin pr i often see a few queries with the state "writing to net". I had a look around and couldn't find much out about this other than the…
robjmills
  • 990
  • 9
  • 26
1
vote
1 answer

MySQL "bad handshake" after entering password

I'm having problem to connect to the remote DB from the terminal as follow mysql -u db_user -p -h 10.100.1.100 Enter password: afer entering password I'm getting that error: ERROR 1043 (08S01): Bad handshake and I can connect to the DB from a PC…
JackTheKnife
  • 371
  • 1
  • 6
  • 24
1
vote
0 answers

MySQL's innodb_buffer_pool_size doesn't seem to have any effect on RAM usage

(I have checked similar questions, none of them cover my situation) I'm trying to increase MySQL 5.7 memory usage on my Ubuntu 16.04. Before my changes mysqld was using about 8% of RAM out of 8GB available which means the InnoDB buffer pool was…
mojuba
  • 121
  • 6
1
vote
1 answer

Mysqld shuts down "Can't create thread to handle new connection"

I have a PHP based web application which used MySQL as DBMS. Every few minutes (specially when number of users of web application are more that is around 15 at a time), MySQL shuts down. Here's a log entry from one of the shutdown times. How I can…
user3563059
  • 113
  • 4
1
vote
1 answer

mysql keeps crashing corrupt databases

I have been trying to solve this for about 8 hours now. Due to unrelated issues, I had to remove mysql and re-install it. since then, mysql crashes and restarts every 2-3seconds with the below in the mysql log. 170425 3:52:53 InnoDB: Assertion…
Ben
  • 23
  • 4
1
vote
2 answers

MySQL automatically restarts under heavy load

I am doing a performance test. When I reach 100-200 concurrent users, MySQL simply shuts down and starts again without any errors in the log files. Very, very strange. MySQL version is 5.6.34, running on CentOS 6. Here is how I have configured…
Martin Dimitrov
  • 113
  • 1
  • 8
1
vote
1 answer

Table column's auto_increment flag not preserved by backup?

After dumping a database on MySQL-5.1.73 and loading it into MySQL-5.5, I notice, that at least one table's primary key didn't have its auto_increment flag transferred... The describe table on the original reads…
Mikhail T.
  • 2,338
  • 1
  • 24
  • 55
1 2
3
…
9 10