Questions tagged [mysql5]
137 questions
3
votes
2 answers
MySQL PID file missing
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 updating PID file (/[FAILED]mysqld/mysqld.pid).
If I…
MattRogowski
- 151
- 1
- 1
- 4
3
votes
1 answer
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/mysqld/mysqld.pid). ... failed!
After a lot of…
Test
- 131
- 1
- 4
3
votes
1 answer
Mysql - innoDb - is in the future! Current system log sequence number
I have this error in my syslog. I restored an older dump to solve this problem, after some reading. Now The errors in syslog are far less than before.
But still a few times an hour I get
Sep 1 14:23:29 homer mysqld: 120901 14:23:29 InnoDB: Error:…
Ward Loockx
- 205
- 1
- 3
- 11
3
votes
2 answers
could not start the service MySQL. Error:0 how to get mysql 5.5 server running?
I tried to upgrade to MySQL 5.5 from 5.1. When I try to run Instance Configuration Wizard I get this error:
Could not start the service MySQL. Error:0
I am to the point now that I would be happy just to have a fresh install of MySQL 5.5. I can…
Richard
- 141
- 1
- 1
- 6
3
votes
4 answers
mysql 5.0.23 vs 5.5 performance benefits and upgrade issues?
I have been told that mysql 5.5 has a significant performance boost compared to 5.0
Our server handles a lot of data (around 30 million records processed per 5-10 seconds) and requires every drop of performance boost we can give. Will it be…
YD8877
- 325
- 1
- 5
- 11
3
votes
1 answer
what is a mysql 'packet', anyway
Mysql 5.1: if we want to use very large blobs, apparently we need very large packets, configured identically on both ends. How large can we go before something explodes?
See this.
bmargulies
- 2,333
- 3
- 17
- 20
3
votes
0 answers
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] [Server] Received SHUTDOWN from user
Inglebard
- 153
- 3
- 7
2
votes
2 answers
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 not allow A insert anything. I googled this…
Firechaser
- 23
- 3
2
votes
2 answers
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 from the MySQL Yum repository. When I try to…
curtisdf
- 251
- 1
- 3
- 13
2
votes
1 answer
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
instead. How do I configure the connection to use the…
Roy Hinkley
- 527
- 4
- 13
- 20
2
votes
3 answers
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 on {IP}"
I have already done the follow:
*…
Rees
- 121
- 1
- 1
- 5
2
votes
1 answer
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
# service mysqld start
# /usr/bin/mysqladmin -u root…
Alexander Farber
- 714
- 4
- 17
- 38
2
votes
2 answers
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 currently stored in ibdata1/default ibdata file will…
nulltek
- 1,251
- 3
- 14
- 22
2
votes
3 answers
MySQL specific database replication (Master - Master)
We have a MySQL server at one location, replicating to another in a Master->Slave configuration. There are about 5-7 different databases on this server. We are wanting to do this...
We have a second site that we are wanting to move all our web…
C. Baker
- 21
- 1
2
votes
3 answers
Rebuild mysql slave from scratch
I'm having a master/slave mysql setup. This night I had some problems with the master. I needed to recreate all databases again because they were corrupt.
Now I stopped my mysql slave but want to start it again and rebuild everything from scratch.…
Ward Loockx
- 205
- 1
- 3
- 11