Questions tagged [mysql5]
The mysql5 tag has no usage guidance.
136
questions
0
votes
1
answer
49
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
...
- 101
0
votes
0
answers
80
views
mysql_upgrade / mysql_check fails with unknown database; where are database names stored (capitalization inconsistency)?
Just upgraded my server machine from freebsd 11.4 to freebsd 12.4.
Then ungraded the installed packages, in particular mysql57-server.
The server is started from a particular user account.
When I try ...
- 23
0
votes
2
answers
229
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 ...
- 1
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 ...
2
votes
0
answers
3k
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] [...
- 143
0
votes
1
answer
37
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
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 ...
- 371
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
220
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 ...
- 101
0
votes
1
answer
516
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
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. ...
- 169
0
votes
0
answers
30
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
753
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
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 ...
- 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 ...
- 113
1
vote
1
answer
3k
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,282
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
0
votes
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 --...
0
votes
1
answer
151
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
755
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 ...
- 473
0
votes
1
answer
261
views
Can't connect to local MySQL via TCP (Error 1045)
root@127.0.0.1 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
91
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
319
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
48k
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 ...
18
votes
3
answers
36k
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 ...
- 283
0
votes
1
answer
183
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
712
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 ...
- 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/...
- 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 ...
- 11
0
votes
1
answer
470
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,124
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,124
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,248
0
votes
1
answer
62
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,124
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 ...
- 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 ...
- 190
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 ...
- 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
...
- 527
2
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 ...
- 121
0
votes
2
answers
1k
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
854
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
727
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
# ...
- 714
0
votes
2
answers
607
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,241
0
votes
1
answer
417
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 ...
- 660
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