Questions tagged [mysql5]

The tag has no usage guidance.

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

Disable auto reconnect for remote client connections in mysql

I use below version of MYSQL in my DB server. root@XXXXXX-test-server:~# mysql -V mysql Ver 14.14 Distrib 5.6.16, for debian-linux-gnu (x86_64) using EditLine wrapper root@XXXXX-test-server:~# ...
Dhanushka Ekanayake's user avatar
0 votes
1 answer
563 views

why mysql bin logs are not expiring even though expiry was set

I am using 5.7.37-log MySQL Community Server. my mysqld.cnf looks below: server_id = 11 log_bin = bin.log log-bin-index = bin-log.index binlog_format = row max_binlog_size = 100M socket = mysql.sock ...
santhosh's user avatar
  • 103
1 vote
2 answers
422 views

There is the warning when I run database backup bash script

My database is 8GB When I run the database backup bash script, there is the warning/failure. They have appeared since 1 month ago Here are my warning/failure mysqldump: Error 2013: Lost connection to ...
Bach Do's user avatar
  • 11
1 vote
1 answer
2k views

Is it possible to install MySQL5.7 on Debian 10/buster?

I have tried two times and it always fails. According to this little guy debian stopped packaging mysql-client as of buster. I tried to cope with it by installing MariaDB but I struggle to find a ...
Revolucion for Monica's user avatar
3 votes
0 answers
4k 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] [...
Inglebard's user avatar
  • 163
0 votes
1 answer
71 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)...
kah's user avatar
  • 21
1 vote
1 answer
6k 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 ...
JackTheKnife's user avatar
1 vote
0 answers
2k 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 ...
mojuba's user avatar
  • 121
1 vote
1 answer
1k 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 ...
user3563059's user avatar
0 votes
0 answers
231 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 ...
Christian Sirolli's user avatar
0 votes
1 answer
648 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-...
Abel's user avatar
  • 322
0 votes
2 answers
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. ...
feub's user avatar
  • 169
0 votes
0 answers
34 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 ...
Lexib0y's user avatar
  • 227
1 vote
1 answer
831 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 ...
Ben's user avatar
  • 23
0 votes
1 answer
1k 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 ...
Zorgatone's user avatar
  • 101
1 vote
2 answers
3k 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 ...
Martin Dimitrov's user avatar
2 votes
1 answer
4k 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 ...
Mikhail T.'s user avatar
  • 2,377
2 votes
2 answers
1k 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 ...
Firechaser's user avatar
1 vote
1 answer
3k 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 --...
Keven.Lee's user avatar
0 votes
1 answer
156 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/...
Eric.Rkt's user avatar
0 votes
0 answers
798 views

Cannot install php-mysql

I have a VPS with CentOS 6.6 x86-64 and ISPManager, PHP 5.4.43, Server version: 5.5.45 MySQL Community Server (GPL) by Remi and an version phpMyAdmin. I upgraded php from 5.3 to 5.4 and mysql from 5.1 ...
user2027175's user avatar
0 votes
1 answer
1k views

different servers different databases replication mysql

I am not sure if this is possible or not but I have 3 servers. Server A, B and C Server A has database A_dataBase, B_database Server B has database A_dataBase, B_database and C_database Server C has ...
user50946's user avatar
  • 483
0 votes
1 answer
262 views

Can't connect to local MySQL via TCP (Error 1045)

[email protected] exists, but still can't connect to local MySQL. It looks like MySQL verifies hostname instead of lo ip(127.0.0.1). root@castle /v/l/mysql# mysql -u root Welcome to the MySQL monitor. ...
user805627's user avatar
0 votes
1 answer
118 views

MySQL connections peak right after restart

I have a fairly busy server, with about 200 qps and a read/write ratio of about 10, running on MySQL 5.1.73 64bit on CentOs 6.6 Most aspects are optimized, however, whenever i restart mysql, it goes ...
radoo's user avatar
  • 3
0 votes
1 answer
495 views

MYSQL - lacked sufficient buffer

I'm getting this error on my MYSQL Server Version is 5.0.4: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full When I ...
user avatar
0 votes
2 answers
4k views

upgrading php 5.3.6 to 5.5 in ubuntu 12.04 LTS requires removing mysql?

I'm trying to upgrade php to latest version (5.5) my current php version is 5.3.6 bundled with ubuntu 12.04 LTS. The problem is I do not want to upgrade anything else just php but although I ...
Volkan Ulukut's user avatar
3 votes
2 answers
49k views

MySQL PID file missing [closed]

Some time ago MySQL stopped working on my server and I've only just got round to looking into it. When I try and start it with service mysqld start I get Starting MySQL.The server quit without ...
MattRogowski's user avatar
-1 votes
1 answer
14k views

my.cnf configuration in mysql 5.6.X [closed]

Server information 64GB RAM Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz Mysql Server version: 5.6.20-log - MySQL Community Server (GPL) I have 20 websites on this server like share hosting my big ...
محمد علی پور فتحکوهی's user avatar
18 votes
3 answers
41k views

Can't find the private IP address for my Amazon-RDS instance

I moved my Master/slave database architecture to Amazon RDS and everything works fine. But I have a slave out of the RDS service which should keep sync with the new Master server, to do so I have to ...
Imad Touil's user avatar
0 votes
1 answer
217 views

Installing mysql using rpm in linux through commandline

I'm trying to install latest version of mysql server. I tried to uninstall mysql 4.1 using rpm -e . Once uninstallation done I tried to download mysql packages: Command : wget http://www.mysql.com/...
stefun's user avatar
  • 115
0 votes
1 answer
802 views

UTF-8 encoding gone missing after enabling mysqlnd

I've enabled mysqlnd on my PHP 5.4.26 server using MariaDB 10.0.8. My SQL config contained this: [mysqlnd] character-set-server = utf8 collation-server = utf8_general_ci It was all working fine ...
Spacedust's user avatar
  • 568
3 votes
1 answer
8k views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file (/var/run/...
Test's user avatar
  • 131
1 vote
0 answers
1k views

MySQL rebuild after Corrupt ibdata1

I have a MySQL server that serves a couple of databases including a Magento e-commerce store. We have been suffering with corruption in the ibdata1 file for a while, but it has now reached a critical ...
user211502's user avatar
0 votes
1 answer
486 views

Where to download MySQL server 5.0.77-log

I have MySQL Server version: 5.0.77-log Source distribution on a RHEL6 server. I need to reinstall it on a second RHEL6 server to set up a testing environment but I cannot find where to download this ...
blizz's user avatar
  • 1,154
0 votes
1 answer
2k views

MySQL 5.0 not logging aborted connections in general log

I know there is a bug in MySQL 5.0 which prevents aborted connections from being logged in the error log (http://bugs.mysql.com/bug.php?id=24761). However, aborted connections should still be logged ...
blizz's user avatar
  • 1,154
0 votes
1 answer
3k views

Increase the speed of mysqldump

Are there any flags or tricks to speed up mysqldump for backups? Here is what we are currently using: mysqldump --skip-opt --flush-logs --routines --triggers --allow-keywords --create-options --add-...
Justin's user avatar
  • 5,438
0 votes
1 answer
63 views

Do global logging settings in MySQL5 stick after service restart?

Want to execute this on MySQL 5.0: set global log_warnings = 2; Will the setting stick after a mysqld service restart?
blizz's user avatar
  • 1,154
2 votes
2 answers
11k views

MySQL 5.6 on CentOS 6 silently fails to start

I'm working on a fresh CentOS 6.5 install and trying to get a MySQL 5.6 server daemon running. The server is a fresh droplet on DigitalOcean's infrastructure. 512 MB size. I used the MySQL version ...
curtisdf's user avatar
  • 251
1 vote
0 answers
2k views

MySQL 5.6 Create Table VERY slow

I recently upgraded my MySQL server from 5.1 to 5.6 (running on CentOS 6.x). Ever since the upgrade, when I try to perform certain table tasks the queries take a REALLY long time. This is really ...
Kenny Wyland's user avatar
0 votes
1 answer
4k views

Installed Windows 8.1, MySQL service disappeared and all MySQL data/settings gone [closed]

This weekend, I updated a Windows 8 workstation to Windows 8.1. This was a development workstation that had a locally hosted MySQL 5.6 instance used for web development work. After the update ...
Josh's user avatar
  • 287
2 votes
1 answer
4k views

MySQL Workbench sends computer name with login not IP

I am attempting to connect MySQLWorkbench to a remote MySQL Server. The server has granted access to user@IPAddress However, when I try to connect MySQLWorkbench, it sends user@computername ...
Roy Hinkley's user avatar
3 votes
3 answers
10k views

how to enable remote access to a MySQL server on an AZURE virtual machine

I have an AZURE virtual machine with a MySQL server installed on it running ubuntu 13.04. I am trying to remote connect to the MySQL server however get the simple error "Can't connect to MySQL server ...
Rees's user avatar
  • 131
0 votes
2 answers
2k views

MySQL consuming all system memory on INSERT ... SELECT

The mysql daemon is getting killed because Linux is reaching out of memory: Oct 24 07:41:23 <hostname> kernel: [82297.673701] Out of memory: kill process 13816 (mysqld) score 1839626 or a child ...
siete's user avatar
  • 23
0 votes
1 answer
859 views

Unable to adjust php.ini max upload size directive on Centos 6.3

Currently i'm setting up Centos 6.3 (64 bit) on vm and installing Wordpress: Already adjust /etc/php.ini but seems like overwritten by other settings. Suspect this is due to selinux feature. My goal ...
Ivan Slaughter's user avatar
2 votes
1 answer
742 views

MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

Trying to install MySQL (for WordPress) on a CentOS 6.4 /64 bit server. I have installed the mysql-server-5.1.69-1.el6_4.x86_64 package and executed the following commands: # chkconfig mysqld on # ...
Alexander Farber's user avatar
0 votes
2 answers
668 views

Queries going to mysql server even when no one is connected to it

I have a MySql server which has 2 active databases which are used for a web application and 3 inactive ones (left for archival purpose but not currently used). The problem is that the server seems to ...
coderkane's user avatar
  • 101
0 votes
1 answer
2k views

PHP connection for Mysql is very slow in another server

Few days ago, we moved our mysql database to another host because of some limitations with our current host. Everything is fine (Seem same performance and speed on our PHP framework based website) ...
codelogn's user avatar
  • 103
2 votes
2 answers
1k views

Innodb one file per tablespace

I'm walking into an environment that uses MySQL and Innodb as the storage engine. I'd like to enable innodb_file_per_table to increase performance. Considering all of the databases/tables are ...
nulltek's user avatar
  • 1,281
0 votes
1 answer
528 views

What can I do with corrupted DB in InnoDB format in this case?

guys, I have a big problem. There is one server with CRM database. I corrupted it probably and don't know what to do. ls /var/lib/mysql/sugarcrm/ accounts_audit.frm address_book.ibd ...
Evgenii Iablokov's user avatar
0 votes
2 answers
2k views

Mysql 5.5 is not installed in CentOS 5.7

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum -...
Bathakarai's user avatar