Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [mysql5.5]

MySQL RDBMS version 5.5

Filter by
Sorted by
Tagged with
0 votes
1 answer
19 views

How to remove orphaned foreign key constraint in MySQL?

Using MySQL 5.5. I have a table for which I can't add a foreign key: ALTER TABLE `SOURCE_TABLE` ADD CONSTRAINT `ConstraintFK` FOREIGN KEY (`otherTableID`) REFERENCES `OTHER_TABLE` ...
user avatar
0 votes
2 answers
549 views

Why the length of tinyint seems to make no difference?

I've been searching for what the length in the tinyint declaration means (e.g. tinyint(5)). And the answers seem to be that it should just be a rule for how MySQL displays the data. But in my case ...
user avatar
0 votes
1 answer
64 views

MySQL 8.0 replica going out of sync with error on executing statements

I have this configuration: Master running MySQL 5.5 with log file format: STATEMENT Slave running MySQL 8.0 - connected to (1) master. Log file format: ROW Another Slave running MySQL 8.0 - connected ...
user avatar
  • 167
0 votes
1 answer
2k views

MySQL copy temp table filled disk, how do I remove temp files?

What is the safest way to clean up? MySQL server 5.5.62-0 on Debian 8 with no replication. I made a mistake and created a new column on a 26GB table. SHOW PROCESSLIST showed MySQL was copying the ...
user avatar
0 votes
1 answer
102 views

After Migration from MYSQL to Maria DB, query returns different cases for a result sets column names

Were attempting to migrate mysql servers to MariaDB on a new AWS (amazon-linux-2) instance. After creating a new instance and installing mariadb we've dumped the old database via mysqldump ... --add-...
user avatar
  • 111
1 vote
2 answers
55 views

Should we upgrade MySQL, move to PostgreSQL, or go cloud?

We use an internal MySQL 5.5 server for our ERP system. Issue things are getting slow, and bosses are getting annoyed our SLA with our infrastructure service provider is ending soon. our small dev ...
user avatar
  • 111
0 votes
1 answer
763 views

Master- Master Replication breaks after server Reboot

I have a Master-Master Replication with the following Configuration. Due to some patches, we have to Reboot the both the masters. But when i check the replication i s broken. MASTER 1: [mysqld] ...
user avatar
2 votes
3 answers
3k views

MySQL Service Stop although Restart=Always

I've an Amazon t2.small EC2 - 1 Core and 2GB RAM it's more than the minimum requirements for CentOS and Virtualmin My System: CentOS 7.5.1804 Virtualmin MySQL 5.5.60-MariaDB Apache 2.4.6 The ...
user avatar
0 votes
0 answers
219 views

Django cannot find libmysqlclient after upgrade MySQL from 5.1 to 5.5

I have a Server with Debian 6 squeeze. I've made some upgrade to Debian 7 wheezy. MySQL is upgraded from 5.1 to 5.5. Now I have an application developed with Django, and it got me an error, cannot ...
user avatar
  • 1
1 vote
2 answers
468 views

What would cause mysqlcheck to incorrectly report a table as undamaged?

We are administering a MySQL server for one of our customers that has >100 databases with about 50 tables each, many of them InnoDB tables. The server crashed and I'm trying to find the culprit. When ...
user avatar
0 votes
1 answer
1k views

mysqldump --single-transaction on slave (without stopping replication)

Is it okay to run mysqldump --single-transaction on Slave DB without stopping replication (stop slave;)? This is for regular daily backup so we can restore Master DB in case of a storage disaster. ...
user avatar
  • 1
0 votes
1 answer
148 views

PHP site on new server can't connect after authenticating user

I'm moving an existing PHP/MySQL website application to a new server and for some reason I'm getting a "ERR_CONNECTION_REFUSED" error after I login. I've installed PHP and MySql and copied the ...
user avatar
  • 696
1 vote
3 answers
896 views

How to speed up final stage of xtrabackup with lots of tables?

I have a MySQL 5.5 database with thousands of tables and heavy write workload. I need to use xtrabackup to take online backup (create a slave from production server with minimum downtime), but the ...
user avatar
0 votes
2 answers
2k views

MySQL Server won't start on non-standard port

I am trying to allow external clients to access my database server through a extremely strict college firewall i.e. only ports 80 & 443 open. To allow clients to communicate with the server, I ...
user avatar
  • 131
0 votes
1 answer
83 views

Mysql crashes - plugin library

I would like to ask if from below log we can say that crash of Mysql was because of our custom library for Mysql? Sep 26 15:24:30 mysqld: /usr/lib/mysql/plugin/my_lib_discounts.so(...
user avatar
  • 83
-1 votes
1 answer
57 views

Why can root still login remotly?

I have a very strange issue I'm hoping someone may have seen before and might be kind enough to help me resolve. On MySQL, I took away the ability for the root user to login from any remote host: ...
user avatar
  • 101
2 votes
0 answers
5k views

Child process still did not exit

My LAMP server recently froze and I rebooted it. I ran into some memory issues with MySQL after that that I was able to determine indicated my swapfile got disabled during the reboot. I re-enabled my ...
user avatar
0 votes
1 answer
219 views

AWS RDS mysql upgrade 5.5 to 5.6

What is the best/easiest way to upgrade and RDS instance running mysql 5.5 to 5.6. I have seen two potential methods: modifying the instance - this seems the easiest method - have people done it - ...
user avatar
  • 318
12 votes
3 answers
28k views

Slave replication stops with Last_SQL_Errno: 1032

I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the ...
user avatar
  • 397
0 votes
1 answer
4k views

Centos 7 Postfix install using MYSQL 5.7 which replaced mariadb

Sorry to disturb you, but I've a problem I can't seem to get around. I'm trying to install Postfix on a new server which was needed to move to for more space/memory, the old server had 256MB of RAM ...
user avatar
0 votes
2 answers
2k views

Percona-Server-shared my.cnf file conflicts with file from package mysql-community-server-5.5

I'm trying to install Percona Toolkit on the server where there is already mysql-community-server5.5.52 is running. I require pt-table-checksum and pt-table-snc utility, so I ran: yum install ...
user avatar
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 ...
user avatar
  • 101
7 votes
1 answer
4k views

MySQL Slave stuck on a single bin log + bin log position for 17+ hours

tl;dr: Replication is stalled on a specific binlog and position, and I'm not sure why I have a MySQL Replication setup with MySQL 5.5. This replication setup has no history of ever falling behind ...
user avatar
0 votes
0 answers
83 views

pt-pmp fails to run on percona 5.5 ubuntu 12.04

Command: [mysql] root:/mnt# pt-pmp --pid 16898 Wed Dec 7 18:41:51 UTC 2016 warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7fffd4126000 18 libaio::??(libaio....
user avatar
  • 11
0 votes
0 answers
105 views

apache php server weird logout issue

we have recently moved PHP application on new server,but we are facing weird session out issue on new server, the session.gc_maxlifetime = 86400 in php.ini but the application goes logout in between ...
user avatar
  • 101
0 votes
1 answer
432 views

Why can I not re-create a dropped database?

I'm on a Debian host, and dropped a database from a Django project and then tried to re-create it. I've tried variations on a same basic theme from mysqladmin and mysql to create a database, and (...
user avatar
7 votes
4 answers
14k views

enabling ssl connection from wordpress to mysql

I have been searching on how to configure wordpress to connect to mysql db over ssl, however most of the example are about three to five years old e.g. this wordpress support topic my wordpress ...
user avatar
5 votes
0 answers
3k views

Invalid key length error when trying to connect phpmyadmin to remote MySql over SSL

I get these error messages when logging in to phpmyadmin instance Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ...
user avatar
0 votes
1 answer
1k views

Configuring remote access to mysql via puppet

The problem: I want to connect to mysql from another host I have a mysql instance that I configure with puppet. I want to be able to access the instance from host 1.2.3.4. Part 1: I start by hand ...
user avatar
  • 405
0 votes
1 answer
2k views

MySql Server does not start with innodb_force_recovery set to value 1-6

I have an ubuntu 14.04 KVM that was running as server LAMP till today when I have installed a Wordpress Plugin and the MySql Server 5.5 stopped working. I have tried to start the server multiple ...
user avatar
1 vote
0 answers
598 views

Mysql query log is empty after boot

I can't figure out why is general and slow query log empty after computer restart. After restarting the server with systemctl the logs get populated. After reboot the files are created just empty. $ ...
user avatar
2 votes
1 answer
129 views

Bugzilla migration from ubuntu 10.04 to 14.04 with Mysql 5.1 to Mysql 5.5

I am running Bugzilla 4.0 on Ubuntu 10.04.4 LTS running on physical server & thought of upgrading it to Ubuntu 14.04 on Hyper-V for testing. After migration of bugzilla webroot 4.0 to Ubuntu 14....
user avatar
  • 1,122
1 vote
1 answer
3k views

Why can't I uninstall mysql-5.5 & install mysql-5.6 on Amazon Linux machine?

I'm on a 64-bit Amazon Linux machine. I had previously installed mysql-server 5.5. (using sudo yum install) However, I soon found out that my application requires MySql-serve 5.6. So I uninstalled ...
user avatar
  • 499
1 vote
0 answers
1k views

Apache is using 100% CPU even with one user

Apache is using 100% CPU even with one user Apache (or should I say PHP through Apache?) is using 100% CPU for few seconds every time somebody search bugs at our bug tracker or just reload the search ...
user avatar
  • 21
1 vote
1 answer
8k views

Import MySQL 5.6 database into 5.5 using MySQL 5.6 client tools

My local dev environment currently uses MySQL Server 5.5. However, one of my clients hosts decided to upgrade their server to 5.6. I sync my clients databases remotely using mysqldump over ssh. I have ...
user avatar
0 votes
1 answer
201 views

Is MySQL using up all the memory? [duplicate]

I need help with reading this output of free -m. This server has a total of 32 GB of ram but it shows 9383 used and 290 free. The rest seems to be in the buff/cache. I am running mysql on this server ...
user avatar
1 vote
2 answers
3k views

Accidentally delete ibdata1, ib_logfile1 and ib_logfile0

Actually i have problems with the database always down due to log. Usually when I restart it will work just fine. But recently the database cannot start and make me think to simply delete those ...
user avatar
  • 111
1 vote
2 answers
2k views

Cannot upgrade mySql on a Debian 6 server using apt-get

I run a Debian 6 server and use it to host a dozen of LAMP based websites. I configured it to email me whenever a software update becomes available, and this morning I received the notification for 6 ...
user avatar
3 votes
0 answers
93 views

script cannot connect to Mysql server Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Mysql server seems working properly and running also i can connect to the database via ssh command, here's the my.cnf file directives: [mysqld] #port=3306 datadir=/home/mysql socket=/home/mysql/mysql....
user avatar
  • 31
-5 votes
2 answers
95 views

MySQL crashes running but not working [closed]

Mysql is running but it not responding when using phpmyadmin when i check mysqld.log it tells: [root@dc /]# tail /var/log/mysqld.log 151111 8:58:21 [Note] /usr/libexec/mysqld (mysqld 5.5.46) ...
user avatar
0 votes
1 answer
362 views

MySQL creates huge files every night, bringing down the server

I have an Ubuntu 12.04 LEMP server with shop app ontop, running MySQL 5.5 as DB (currently since this problem started I've already switched to Percona with no success). So, current facts: every night ...
user avatar
  • 111
0 votes
0 answers
33 views

mysql keeps lossing user permisions

We have a mysql database on ubuntu 14.04 server. It was working really fine for months until some weeks ago, when it started with this thing. It suddenly losses all user permisions and we have to set ...
user avatar
-1 votes
1 answer
218 views

Ubuntu Mysql stop working after outofmemory in a clamscan, mysqld.sock

I'm having daily problems with postman with autentification througth mysql on my Ubuntu14LTS Server. I think the problem arrise after a clamscan scron that breaks in an Out of Memory. In some way ...
user avatar
0 votes
1 answer
113 views

Why is the MYSQL variable innodb_file_per_table changed to OFF automatically in a OPENSHIFT online gear?

My application is on openshift online gear with mySQL 5.5. Recently I found that my mySQL database become very big quickly (few days increase 1G) without many operations. This made me try to do ...
user avatar
  • 1
1 vote
1 answer
28 views

Examine MySQL INNODB folder

Consider the following situation. I currently have an Ubuntu installation installed in my Virtual Machine. This installation has mysql installed in it. Data for the mysql-server can be found under; ...
user avatar
0 votes
1 answer
207 views

Warning while upgrading MySql 5.5 to 5.6

I'm trying to upgrade MySql from 5.5 to 5.6 in my Ubuntu machine. While running command sudo apt-get install mysql-server-5.6 we encountered with warning like : 2015-07-01 18:47:58 0 [Warning] ...
user avatar
  • 115
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 ...
user avatar
  • 473
2 votes
3 answers
2k views

MySQL keeps crashing [closed]

So a little background, a few weeks ago I brought a new CentOS dedicated server in Melbourne, however it seems beside the number of attackers I get, there also seem to be an issue with the MySQL ...
user avatar
1 vote
0 answers
189 views

Possible have 2 php.ini file or 2 extension_dir in php.ini?

i got Fatal error: Class 'mysqli' not found in C:\apache2triad\htdocs\index.php on line 8 error. I checked php.ini file and saw extension=php_mysql.dll is uncommented.Everything is normal. But in php....
user avatar
2 votes
1 answer
2k views

Special characters in mysql password using mysqldump

I have the following ssh script: #Here I am getting the mysql password for the root user password=$(cat /root/.my.cnf | grep "password" | awk -F\" '{print $2}') #here I am trying to dump the ...
user avatar