M
M
MixLtv2020-05-21 05:29:05
PHP
MixLtv, 2020-05-21 05:29:05

Why does mysql crash when editing tables via phpmyadmin?

Sometimes when editing tables in the mysql database through Phpmyadmin, an error occurs, and as a result, the database freezes. To resume its work, you need to reboot it. And here's another trick is that if you copy the generated sql query for editing and execute it through the console, then everything works. Are there any options why this is happening?
Versions : Database server
:
Server: Localhost via UNIX socket
Server type: MariaDB
Server version: 10.1.44-MariaDB-0+deb9u1 - Debian 9.11
Protocol version: 10
User: [email protected]
Server encoding: UTF-8 Unicode (utf8)
- ---- Apache
Web Server
/2.4.25 (Debian)
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: b5
PHP extension: mysqli curl mbstring
PHP version: 7.0.33-0+deb9u7
-----
phpMyAdmin
Version info: 4.6.6deb4

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Chernykh, 2020-05-21
@sashkets

All your software is old. I would start with an update

V
Vitaly Karasik, 2020-05-21
@vitaly_il1

1) Look in the MariaDB log - you might find something interesting.
2) how much memory is on the server? what does 'free -m' say?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question