Questions tagged [mysql-5.5]
MySQL version 5.5 - please also tag with mysql for search purposes.
1,179 questions
0
votes
1
answer
121
views
Migrating Large MySQL Database to New Server
I have a large Windows MyMSQL 5.5 database that I need to migrate to a new server. While I have some knowledge of MySQL it's not extensive so could use some advise on the best way to migrate the data....
- 101
0
votes
1
answer
195
views
How to join on "replace and substract"?
Using MySQL 5.5, no need to upgrade since it's on an old server and only used for Grafana.
I have two tables, foo, and bar. Foo has id and the title is null. I want to get the titles from bar and ...
- 159
1
vote
1
answer
330
views
MySQL : Huge table truncation in replication environment
We have 2 tables of size 186G and 63G that are no longer in use and needs to be truncated from the database.
I cannot directly run the truncate table statement on the master DB as it has 14 replicas ...
- 21
0
votes
1
answer
781
views
Select all rows where table1.column1 = table2.column1 where at least one value table2.column2 = 1 [closed]
I have two tables in a MySQL database
table1:
column1 column2
table2:
column1 column2
I want to select all rows where table1.column1 = table2.column1 if at least one row table2.column2 = 1
table1
12 ...
- 1
-1
votes
1
answer
456
views
In MySQL query, VARCHAR(100) gets output as "[partnumber]" although in a query with more columns, it is still shown as 'p-12345'
This is a bad question since I only made a mistake in selecting by chance a client that had garbage data and must have changed the where condition during tests, and it was also a problem of a join ...
- 366
0
votes
0
answers
631
views
Order by id is slow
So I've read the same issues here that people experience, I could find at least a few topics talking about how ORDER BY is slow.
However, it looks like I have all the indexes necessary. But still with ...
- 101
-1
votes
1
answer
536
views
How to improve performance of a stored procedure called from a web page?
This is my first SQL stored procedure
$sql = ("CALL Login_Details($ID);");
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_array($result);
mysqli_next_result($conn);
When I run ...
0
votes
1
answer
117
views
Mysql 5.5 Master > Slave/Master > Slave Not working
I am trying to get a database that is the main database but replicates one database from another server to replicate both the replicated database and the local database to another slave.
SERVER1: ...
0
votes
2
answers
83
views
Does anyone know how to make two two-column foreign keys from a single table?
I tried the following, but I am receiving an error message.
Table goleo
mysql> create table goleo(
-> id int,
-> nombre varchar(30),
-> goles int,
-> primary key (nombre,...
1
vote
1
answer
3k
views
Force kill long running index creation
I have a 192GB table that I started adding an index to over night.
This was still going several hours later.
At the time the alter table started the database was very quiet.
There were other queries ...
- 283
0
votes
2
answers
320
views
Help needed in tuning mysql version 5.5 [closed]
I just migrated a 32 bits MySQL 5.5 to a 64 bit version of MySQL 5.5. I would like to upgrade it to 8.0. But my company has some ancient instruments. I can not do it right now before I check the ...
- 105
0
votes
0
answers
662
views
Mysql query browser not showing schemata (databases)
Hello, people, I'd appreciate it if you could assist me with this problem. I'm using workbench and mysql, and I have a few schemata (databases) in my sql. However, when I log in using Mysql Query ...
3
votes
2
answers
695
views
Apply nth occurrence number on each distinct value in a column
I have a table with a column of values where each value occurs a variable number of times (i.e., one value may occur 1 time, and another value may occur 3 times). I need to add a column that ...
- 133
0
votes
1
answer
102
views
How to speed up query which takes ~5s on Mysql5, but longer than 10mins on Mysql8
My company went through a database upgrade recently, from Mysql5 to Mysql8, and some of our queries have slowed down massively. (Going from taking in the order of a few seconds, to timing out after ...
- 1
0
votes
1
answer
228
views
MySQL Replication from On-Premises to AWS
I have an on-premises DB server running MySQL 5.5.37 with multiple databases.
I created database on the AWS RDS.
The idea is to set the replication from on-premises to the AWS, but for only one ...
- 111