Questions tagged [mysql5]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
23 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)...
0
votes
1answer
3k 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
676 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
854 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
156 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
342 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
23 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
426 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
921 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
956 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
598 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 --...
0
votes
1answer
143 views

how to add kernel command before mysql startup in linux

I want to add these commands to the Linux kernel before mysql startup (at boot time): echo never> /sys/kernel/mm/transparent_hugepage/enabled echo never> /sys/kernel/mm/transparent_hugepage/...

15 30 50 per page
1
2 3 4 5
9