Questions tagged [mysql5.5]
MySQL RDBMS version 5.5
134
questions
0
votes
0
answers
45
views
Recovery a table in MySQL but it [Err] 1030 - Got error -1 from storage engine
I have a MySQL with InnoDB engine on a legacy Windows, MySQL version is really old is 5.5,I have a table is really big like 90Gigabytes, it disrupted its MySQL database ,when the restful API read ...
0
votes
1
answer
906
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` ...
- 202
0
votes
2
answers
1k
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 ...
- 113
0
votes
1
answer
238
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 ...
- 167
0
votes
1
answer
5k
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 ...
- 125
0
votes
1
answer
174
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-...
- 111
1
vote
2
answers
58
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 ...
- 111
0
votes
1
answer
1k
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]
...
- 11
2
votes
3
answers
4k
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 ...
- 171
0
votes
0
answers
282
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 ...
- 101
1
vote
2
answers
596
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 ...
- 213
0
votes
1
answer
2k
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. ...
- 1
0
votes
1
answer
309
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 ...
- 808
1
vote
3
answers
1k
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 ...
- 121
0
votes
2
answers
3k
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 ...
- 131
0
votes
1
answer
86
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(...
- 83
-1
votes
1
answer
60
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:
...
- 113
2
votes
0
answers
6k
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 ...
- 213
0
votes
1
answer
225
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 - ...
- 318
12
votes
4
answers
44k
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 ...
- 397
0
votes
1
answer
5k
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 ...
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 ...
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
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 ...
- 1,187
0
votes
0
answers
87
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....
- 11
0
votes
0
answers
107
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 ...
- 101
0
votes
1
answer
447
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 (...
- 1,162
8
votes
4
answers
19k
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 ...
- 537
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 ...
- 537
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
...
- 445
1
vote
2
answers
3k
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 ...
1
vote
0
answers
658
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.
$ ...
- 121
2
votes
1
answer
134
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....
- 1,132
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 ...
- 569
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 ...
- 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 ...
- 135
0
votes
1
answer
236
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 ...
- 85
1
vote
2
answers
4k
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 ...
- 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 ...
3
votes
0
answers
95
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....
- 31
-5
votes
2
answers
99
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) ...
- 205
0
votes
1
answer
406
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 ...
- 121
0
votes
0
answers
34
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 ...
-2
votes
1
answer
273
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 ...
0
votes
1
answer
129
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 ...
- 1
1
vote
1
answer
35
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;
...
- 11
0
votes
1
answer
211
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] ...
- 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 ...
- 483
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 ...
- 185
1
vote
0
answers
219
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....
- 11