Questions tagged [mysql5]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
83 views

MySQL 8 InnoDB taking a long time to start

I upgrade some month ago from Ubuntu 18.04 to 20.04. So MySQL upgrade from 5.7.33 to 8.0.23. I notice after the upgrade that MySQL is slow to start. 2021-02-24T09:20:16.972632Z 0 [System] [MY-013172] [...
0
votes
1answer
24 views

free server monitoring tool for Java based application

I have applied couple of options like Nagios [which lead to problem after installation]-- Apache went irresponsive with lots of segmentation faults child pid 32507 exit signal Segmentation fault (11)...
1
vote
1answer
4k views

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 ...
1
vote
0answers
859 views

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 ...
1
vote
1answer
910 views

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 ...
0
votes
0answers
185 views

MySQL socket disappears

I am running Ubuntu 16.04 LTS, with MySQL server for MediaWiki 1.30.0 along with Apache2 and PHP7.0. The installation was successful for everything, I managed to get it all running. Then I start ...
0
votes
1answer
368 views

MySQL Authentication against OpenLDAP Failure

I'm trying to set up OpenLDAP authentication on a MySQL Commercial Server (5.7.21) I've followed all the steps described on MySQL web https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-...
0
votes
2answers
3k views

High CPU from MySQL process

We have a Magento website on a dedicated server (Xeon E5-1620, 64Gb RAM, SSD), we don't generate high traffic, it is a rather small site, around 30000 page views/month, an average of 100 orders/day. ...
0
votes
0answers
25 views

I cannot get data from the same database on different hosts with different versions of mysql-server

I have a web site that has moved to a new server. I moved the site to a web-server running apache24 and php56. It came from a server with apache24 and php55. When I use the old external (different ...
1
vote
1answer
477 views

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 ...
0
votes
1answer
964 views

Large database table queries return empty set

I'm trying to understand a weird problem with a MySQL database on one of my websites. When I loaded a big set of data from a CSV file (2,200,000 records with a single column, using LOAD DATA) into a ...
0
votes
2answers
1k views

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 ...
1
vote
1answer
2k views

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 ...
1
vote
2answers
652 views

MySQL limiting user disk space by tablespace

I am trying to figure out how to set a limit of disk space for users in MySQL. What I want is, for example, administrator assign 1G disk space for user A, if A used up the 1G disk space, MySQL would ...
0
votes
1answer
2k views

what causing an error about 'lc-messages-dir' how can i fix it

./mysqld --initialize --user=mysql --basedir=/opt/mysql/mysql --datadir=/opt/mysql/mysql/data [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --...

15 30 50 per page
1
2 3 4 5
9