Questions tagged [mysql5]
The mysql5 tag has no summary.
135 questions
0 votes
1 answer
2k 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 ...
- 113
1 vote
2 answers
707 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 ...
- 11
1 vote
1 answer
4k 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 ...
3 votes
0 answers
6k 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] [...
- 163
0 votes
1 answer
126 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)...
- 21
1 vote
1 answer
7k 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 ...
- 411
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 ...
- 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 ...
- 113
0 votes
0 answers
245 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
1 answer
788 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-...
- 322
0 votes
2 answers
4k 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. ...
- 169
0 votes
0 answers
46 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 ...
- 227
1 vote
1 answer
889 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 ...
- 23
0 votes
1 answer
2k 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 ...
- 101
1 vote
2 answers
4k 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 ...
- 113
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 ...
- 2,415
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 ...
- 23
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 --...
- 11
0 votes
1 answer
188 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/...
- 1
0 votes
0 answers
807 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 ...
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 ...
- 483
0 votes
1 answer
268 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. ...
- 103
0 votes
1 answer
191 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 ...
- 3
0 votes
1 answer
727 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 ...
user262448
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 ...
- 123
3 votes
2 answers
50k 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 ...
- 151
-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 ...
20 votes
3 answers
47k 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 ...
- 303
0 votes
1 answer
261 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/...
- 115
0 votes
1 answer
866 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 when ...
- 568
3 votes
1 answer
9k 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/...
- 131
1 vote
0 answers
2k 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 ...
- 11
0 votes
1 answer
516 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 ...
- 1,184
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 ...
- 1,184
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-...
- 5,738
0 votes
1 answer
72 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?
- 1,184
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 ...
- 261
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 ...
- 220
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 ...
- 297
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 ...
- 537
3 votes
3 answers
11k 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 ...
- 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 ...
- 23
0 votes
1 answer
874 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 ...
- 113
2 votes
1 answer
758 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 # ...
- 754
0 votes
2 answers
732 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 ...
- 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) ...
- 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 ...
- 1,341
0 votes
1 answer
657 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 ...
- 730
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 -...
- 121
1 vote
1 answer
7k views
MySQL 5.6 Upgrade - Incorrect definition of table mysql.proc
After upgrading MySQL to version 5.6.10 from version 5.5 I'm getting the following errors when starting MySQL server: 2013-03-19 05:32:38 2666 [Note] /usr/sbin/mysqld: ready for connections. Version: ...
- 23