Questions tagged [mysql5.5]

MySQL RDBMS version 5.5

Filter by
Sorted by
Tagged with
0
votes
2answers
212 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 ...
0
votes
1answer
26 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 ...
0
votes
1answer
610 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 ...
0
votes
1answer
61 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-...
1
vote
2answers
49 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 ...
0
votes
1answer
616 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] ...
2
votes
3answers
2k 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 ...
0
votes
0answers
187 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 ...
1
vote
2answers
315 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 ...
0
votes
1answer
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. ...
0
votes
1answer
109 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 ...
1
vote
3answers
629 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 ...
0
votes
2answers
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 ...
0
votes
1answer
60 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(...
-1
votes
1answer
56 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: ...

15 30 50 per page
1
2 3 4 5
9