Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql5]

137 questions
0
votes
0 answers

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 installing extensions for MediaWiki. Everything is…
Christian Sirolli
  • 101
  • 3
0
votes
1 answer

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…
Abel
  • 322
  • 3
  • 13
0
votes
2 answers

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. Our store has been running for years, we never had…
feub
  • 169
  • 1
  • 2
  • 9
0
votes
0 answers

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 host/server) database that runs mysql57 all goes…
Lexib0y
  • 227
  • 3
  • 14
0
votes
1 answer

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 table, my application started to misbehave. After…
Zorgatone
  • 101
  • 5
0
votes
1 answer

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/defrag This is a necessary specification for the…
Eric.Rkt
  • 1
0
votes
0 answers

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 to 5.5. After upgrade I cannot login to…
user2027175
  • 1
0
votes
1 answer

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 database C_database Currently Server A and B are…
user50946
  • 483
  • 2
  • 7
  • 18
0
votes
1 answer

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. Commands end with ; or \g. Your MySQL connection…
user805627
  • 103
  • 3
0
votes
1 answer

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 to about 80% of available connections. After 10-30…
radoo
  • 3
  • 3
0
votes
1 answer

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 restart the server it works normally, but after a time…
user262448
0
votes
2 answers

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 specifically tell apt-get the package I'm trying to…
Volkan Ulukut
  • 123
  • 2
  • 9
0
votes
1 answer

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/Downloads/MySQL-client-5.1.73-1.glibc23.x86_64.rpm…
stefun
  • 115
  • 4
0
votes
1 answer

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 no mysqlnd was enabled. Since enabling it all…
Spacedust
  • 568
  • 5
  • 13
  • 28
0
votes
1 answer

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 exact version. Thanks!
blizz
  • 1,134
  • 1
  • 26
  • 47
1 2 3
…
9 10