Questions tagged [mysql-5.5]

MySQL version 5.5 - please also tag with mysql for search purposes.

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

calling mysql procedure return empty result

when i call procedure it gives me empty result call hussian('prstate','table_1','column1,column2,column3',1) it run but gives empty result, please help me... DELIMITER // CREATE PROCEDURE ...
0
votes
0answers
8 views

MySQL replication - intermittently report ~4600 sec behind

I have a master/slave (MySQL 5.5.62) setup, with 1 master and 2 slaves, where someting strange occurs intermittently (but quite often) - normally, the slaves reports 0 seconds behind, then suddenly it ...
0
votes
2answers
80 views

Why is this SELECT creating temp tables?

When I run the following SELECT, it takes quite long, typically 30 or 40 minutes (I'm on Debian, MySQL 5.5.62): SELECT ga.currency, o.organisation_name, os.hostname, g.global_name, SUM(IF(ga....
0
votes
0answers
16 views

MySQL: why is the time reported at the end of a query different from real time?

I have recently been running some fairly slow select statements, and what I notice is that the time reported at the end is typically much less than the time it actually ran. Is that to be expected - ...
-3
votes
0answers
14 views

mysql str_to_date() produces invalid timestamp?

(MySQL 5.5.62) Am I doing something wrong here? I want to convert a string to a TIMESTAMP: mysql> select str_to_date('2020-02-01 23:59:59','%Y-%m-%s %H:%i:%s'); +-----------------------------------...
0
votes
1answer
45 views

I have to delete over 90 million records, do I remove or maintain the transaction's SQLWARNING?

SQL Server: mysql Ver 15.1 Distrib 5.5.65-MariaDB, for Linux (x86_64) using readline 5.1 OS: Slackware 14.1 That's 90 million old radius bank records I want to remove, leaving only those this month....
0
votes
1answer
23 views

How to avoid index_merge in a query?

I have multiple queries using index_merge but for put an example, I show you the following query EXPLAIN select count(*) From Clientes Where id_campana='1849' and id_empresa='55' and (...
0
votes
0answers
28 views

How to get statistics by query in a range of dates

I have the following query: select SUBSTRING(VARIABLE_NAME, 5) as tipo_consulta, VARIABLE_VALUE as numero_total_operaciones, round(VARIABLE_VALUE / ( select VARIABLE_VALUE ...
0
votes
0answers
12 views

issues with temporary table with proxysql using mysql replication

I have the following stage, we are implementing a database with 3 nodes with proxysql, this database is using percona xtradbcluster, inside the code is created a temporary table and is successful its ...
0
votes
1answer
11 views

garbd with proxysql and mysql replication

Can be configured garbd with proxysql + MySQL Replication?, I installed proxysql with 1 master and two slaves using MySQL replication but I was disputed about to connect garb with proxysql how I was ...
0
votes
1answer
16 views

How to login into mysql shell from localhost instead of '%'?

I need to grant a permission to a newly created user. I have access to root. But, i can't grant a permission to a new user. When I run: grant all privileges on 'newuser'.* to 'newuser'@localhost; I ...
0
votes
0answers
10 views

alien fails when trying to install mysql-server 5.5.54

I'm trying to install mysql server 5.5.54 to recover a database which exists as .frm, .MYD, and .MYI-files. I'm working on a totally fresh ec2 instance of ubuntu 18.04 I've gotten rpm-files for ...
0
votes
1answer
134 views

Is it possible to run multiple versions of MySQL Workbench?

I'm doing an application migration from MySQL 5.5 to workbench v8... 5.5 supports MySQL Workbench up to version 6.3... However, MySQL server 5.5 only supports up to version 6.3 of the workbench. I ...
-1
votes
1answer
24 views

MYSQL Trigger: Update before insert

I want to increment the order of every video by one every time a video gets inserted so that the new video takes its place UPDATE services SET orders = orders + 1 This doesn't work, I get this error,...
2
votes
2answers
93 views

After upgrade from MySQL 5.5 to 5.7 queries are more frequently encountering deadlock

Recently we migrated our production DB to Amazon RDS with version upgrade from 5.5 to 5.7 using AWS DMS service. After that, we are frequently getting deadlock issues for our insert...on duplicate key ...
0
votes
0answers
35 views

Why query mysql 8.0 response too slow with respect to mysql 5.5

I have the following query which in mysql 5.5, original server runs in approximately 3 seconds but all the opposite with respect to mysql 8.0, which runs in about 3 minutes, a big difference!!!. This ...
0
votes
0answers
8 views

Can't discard tablespace for partitioned table?

[Percona Server for MySQL 5.5 on Debian Stretch]: I have created a partitioned table in preparation to importing an existing tablespace: CREATE TABLE `rgs_transaction_log` ( `rgs_transaction_id` ...
0
votes
0answers
13 views

Problems importing innodb tablespaces

I am struggling with restoring a backup of a MySQL 5.5 database, which has been created with innobackupex --databases .... These are the steps to set up mysql and prepare the backup for restore: # ...
1
vote
2answers
123 views

Mysql: Is it possible to handle 1000 concurrent while having low cpu? [closed]

We're running Centos 7, we're in the process Mariadb 5.5, upgrading to 10.3 today. PHP 5. The queries are bad, and there are far too many of them to optimize, but I'm trying what I can, the database ...
-1
votes
1answer
30 views

Unable to declare user-defined variable in MySQL

I'm creating procedure called min_max to find minimum and maximum for every column in a table. But I'm encountering an error for declaring the variable. See below: DELIMITER // DROP PROCEDURE IF ...
0
votes
0answers
29 views

Does mysqlfrm work with partitioned tables?

I have inherited a large number of backups (MySQL 5.5) created with innobackupex as partial backups. In order to restore one of them, I have to do it table by table; as part of this process, I need to ...
0
votes
0answers
25 views

How to change datetime system timezone to other zones in SQL Query using CONVERT_TZ() SQL Function

I have two times timeA & timeB stored in database, I am using SQL Query to extract data from DB as: SELECT ID, timeA, timeB, CREATED_AT, IS_ACTIVE FROM datatable WHERE IS_ACTIVE = TRUE AND NOW(...
0
votes
1answer
23 views

Get 2 counts in single query

I need to get count of 2 columns with group by This is my sample data I need to get count of persons from particular state and count of persons from particular country My output should be like I ...
1
vote
1answer
212 views

MySQL load data infile ERROR 1064

I am using MySQL version 5.5 and I am trying to use load data infile and I am getting errors. I've looked at the documentation and it looks like I am doing exactly what the docs specify. Running ...
3
votes
2answers
105 views

What happens when MySQL/InnoDB buffer pool size is small and a large transaction is run causing the buffer pool overflow?

Let's say we have a transaction running 50,000 inserts which dirties approximately 600 MB of the database. If the buffer pool size is 128 MB, there will be dirty pages in the buffer pool while the ...
0
votes
0answers
76 views

can delete manually a .ibd file and .frm file?

I have the following trouble in a mysql server database: 190919 17:35:30 [ERROR] Cannot find or open table abril2017/mexico from the internal data dictionary of InnoDB though the .frm file for ...
0
votes
0answers
17 views

How to select and order by id and get multiple results?

I have one database clients and two tables: business and categories. The site is a classified ads placement, business contains: Field Type Collation Null Key ...
0
votes
1answer
93 views

Show Processlist state “Statistics”

Please note that it's not a duplicate thread because I already set variable optimizer_search_depth and didn't have any impact. Sometimes, our database/application services crashed due to max ...
1
vote
2answers
21 views

GRANT permission ON database TO user not working on AWS

I'm having trouble granting a user permission on AWS. mysql> GRANT CREATE ON *.* TO 'hmrex_db'@'%'; Query OK, 0 rows affected (0.01 sec) mysql> SHOW GRANTS FOR 'hmrex_db'@'%'; +----------------...
0
votes
1answer
30 views

Mysql Query Optimization [Match Against] [closed]

I have tried all the possible option to optimize the query, but no luck. Query 1: SELECT *, ( 3959 * acos ( cos( radians(51.5073509) ) * cos( radians(...
0
votes
1answer
35 views

Query to select specific columns based on current date

I have a table named 'mrtg' that has four columns: mysql> select * from mrtg; +----------+------+------+------+ | city | day1 | day2 | day3 | +----------+------+------+------+ | Delhi | ...
0
votes
1answer
23 views

MariaDB 5.5 — how to customize password rules

I am using RHEL 7, which includes MariaDB 5.5. I want to set up minimum requirements for passwords: minimums length 15, 1 lowercase, 1 uppercase, 1 symbol, 1 number. I figure that I am probably ...
0
votes
1answer
32 views

In MySQL, how to execute two different SELECT statements depending on a condition?

SET @input1=123; SET @input2='foobar'; IF @inout1>0 THEN SELECT @result := col12 FROM table1 WHERE col11=@input1; ELSE IF @input2 != '' SELECT @result := col21 FROM table2 ...
0
votes
0answers
14 views

Mysql query take more time when use sub query [duplicate]

CREATE TABLE `tbl_temp_numbers` ( `win_digit` varchar(10) NOT NULL, `amount` int(11) NOT NULL, `session` varchar(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for ...
0
votes
1answer
117 views

Endless Query Loop In Mysql

I will delete millions records from a table in mysql dbms, but i don't want to delete all records at one time not to force database server cpu. That's why i want to use my query many times. My whille ...
0
votes
2answers
77 views

How to display the dates without DUPLICATE and ORDER by MAX DATE

I just want to ask that how can I display the null values along with the MAX date. SELECT MEMB.MEMB_N, MEMB.LAST_M, PrintDate FROM MEMB INNER JOIN tblPrint ON MEMB.MEMB_N = tblPrint....
0
votes
1answer
57 views

How to reduce the response time of a query that yields ~4.9 million rows in ~12-13 seconds

I have the following doubt about the execution performance of a query. This query takes about 12-13 seconds, and brings a total of 4,879,049 rows. Could I lessen this query's response time? The query ...
0
votes
0answers
21 views

Create User in MySQL

Is it possible to create an user without create user command? I mean just by make an entry(framing insert query) in mysql.user table? Will it cause any crash in system tables?
1
vote
0answers
57 views

Multiple join with self join in MySQL and split column in row

I have four tables "Commission" , "Vendors", "Accounts" and "comsplitconfig" like commission Table commissionid vendorid accountid sales commission 1 V1 A2 ...
0
votes
0answers
48 views

How do I use the .ibd/.frm files to recover an InnoDB table that went missing when MySQL crashed during OPTIMIZE TABLE?

I have seen How to Recover an InnoDB table whose files were moved around but I am not sure if it's relevant, since MySQL renamed the files and there was no tablename.frm afterwards. I ran OPTIMIZE ...
0
votes
0answers
30 views

The USE-Statement breaks on MySQL-Server

running webadmin for years now - and having troubles for months - and posting here for weeks. But the support seems to be not the best... want to run sql-commands on the newest version - but it fails ...
0
votes
0answers
23 views

How can I resolve the `package mysql-server is not installed` issue?

I have just upgraded MySQL from version 5.5.55 to version 5.6, via SSH. I have managed to successfully start the MySQL, however I am experiencing the 500 Internal Server Error when trying to access ...
2
votes
1answer
443 views

Unable to downgrade MySQL from version 8 to 5.6 nor start MySQL (MySQL Error Log Included)

I run a Plesk VPS (OS: Centos 6/Linux (Final)), whereby I recently tried to upgrade the MySQL from version 5.5.55 to version 5.6. Being relatively new to this area, I strictly followed this Plesk ...
0
votes
2answers
58 views

SQL query to list all student users, add column to show who were logged in at least once

I have a query, which lists those users, which are students: SELECT * FROM mdl_user as u JOIN mdl_role_assignments as ra ON u.id = ra.userid WHERE ra.roleid = 5 /* is student */ I have a table ...
1
vote
1answer
29 views

Mysql Query Optimisation For Joining a BETWEEN Date and Date query

I have some instagram API data sitting across two tables. One with post_data, and one with profile_data. The profile_data table has a timestamp of when the account was checked through the API to get ...
0
votes
2answers
52 views

Why MySQL is ignoring my indexes in a query?

I have the following query in a production database server(master): SELECT * FROM Enlace_llamadas where id_empresa IN (1,5,33,36,40,44,48,53,55,111,115,125,127,151,167,175,181,185,187,189,195,199,...
1
vote
1answer
24 views

executing single query in loop increase time every time

Am executing one query which is the same as below. Now here the problem is as limit increasing its increasing execution of time. I am adding limit using a PHP script. So anyone likes to suggest to ...
0
votes
0answers
20 views

Master- Master 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] ...
0
votes
0answers
30 views

How can I convert the version of a MySQL database from 5.5 to 5.6? [duplicate]

everybody. I need, please, to convert the version of a MySQL database from 5.5 to 5.6. It's the database for my wordpress site and it's a requirement from my new hosting provider (the old one is ...
0
votes
1answer
143 views

CONCAT_WS causes “Data too long” which works partially?

I've got a simple table with several columns and I'm trying to merge two of them into one. I'm working with MySQL 5.5 and I can reproduce the error one a specific data set by running the following (...