Skip to main content

Questions tagged [mysql]

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

Filter by
Sorted by
Tagged with
-4 votes
0 answers
15 views

Incorrect number of bindings supplied. The current statement uses 1, and there are 54 supplied

def add(self): con=sqlite3.connect(database=r'ims.db') cur=con.cursor() try: if self.var_cat.get()=="Select" or self.var_cat.get()=="Empty" or self.var_sup.get()...
Atittaya Parasuwanno's user avatar
0 votes
1 answer
28 views

I created an event, but it is never executed. Why?

I need to call a stored procedure every 10 minutes and I am using a recurring event, the problem is that it is not executed or I don't know how I can see if there is an error Procedure: CREATE DEFINER=...
Johnny Urdin's user avatar
0 votes
0 answers
14 views

Can MySQL Accept DDNS for Group Replication Setup?

I'm currently setting up MySQL Group Replication between a local server and a cloud server. However, the local server doesn't have a static IP address, so I'm considering using Dynamic DNS (DDNS) for ...
medAmineRg's user avatar
0 votes
1 answer
34 views

Designing a schema with non-enumerable, unpredictable public ids in MySQL

I'm building a REST API, backed by MySQL. Normally for every table I will have at least one: id UNSIGNED INT NOT NULL PRIMARY KEY AUTO_INCREMENT field as a default, but the issue with this is that it ...
Evert's user avatar
  • 151
1 vote
0 answers
41 views

Mysql Crashing on: [FATAL] Semaphore wait has lasted > 600 seconds

Once a day or two we get the bellow error and the mysql crashingt: 2024-07-14T05:31:59.327696Z 0 [ERROR] [MY-012872] [InnoDB] [FATAL] Semaphore wait has lasted > 600 seconds. We intentionally crash ...
idan ahal's user avatar
  • 111
0 votes
1 answer
12 views

Using mysqldump on remote server in rsnapshot returns code 127 while the very same command used locally works fine

As said in the title, I want to backup my remote mysql database with rsnapshot, using mysqldump. I don't have any syntax error, but get a "WARNING 'command" returned 127", and the sql ...
Bernard Grosperrin's user avatar
0 votes
0 answers
20 views

MYSQL Replication But While the backup is being uploaded to the slave, the changes in the master are not received

I am trying to do mysql replication. But I want to while the backup is being uploaded to the slave server, the changes in the master are not received. For example: I have a user table on my X db. And ...
user avatar
0 votes
1 answer
44 views

mysql reuse of deleted rows

Using MySql and innodb with innodb_file_per_table flag ON. We have a table with a size of ~100GB. We delete the data and insert fresh data (approx same size) every day (the delete is in chunks by a ...
Amichay Miara's user avatar
0 votes
1 answer
16 views

InnoDB Cluster ALTER large tables without causing lag

We need to run an ALTER TABLE command to add a new modified column to all servers in a InnoDB ClusterSet (Two clusters) Example: ALTER TABLE DB.tableA add column modified varchar(30) GENERATED ALWAYS ...
Jesus Uzcanga's user avatar
-5 votes
0 answers
16 views

Notification: "No such column :name" error when adding product information

from tkinter import* from PIL import Image,ImageTk #pip install pillow from tkinter import ttk,messagebox import sqlite3 class productClass: def init(self,root): self.root=root self.root.geometry(&...
Atittaya Parasuwanno's user avatar
0 votes
1 answer
27 views

MySQL - how to update only some characters in a column value - longtext (DC2Type:array)

MySQL: 8.0.35 - Source distribution I have longtext (DC2Type:array) column and incorrect some characters values in a column string, so i want to replace this data format: a:2:{s:7:"content";...
Pawel W's user avatar
  • 27
0 votes
0 answers
10 views

Error uninstalling MySQL Shell, Config.Msi/b1a0340.rbf

I'm trying to uninstall MySQL Shell 8.0 from my Windows 2019 Server but I get the following error when I attempt to uninstall / update the program: 1: Error writing to file: C:\Config.Msi\b1a0340.rbf. ...
Harold's user avatar
  • 101
1 vote
1 answer
35 views

MySQL 8.4 community version and replication process setup using caching_sha2_password and secure connection

Trying to setup a replication process between two MySQL Server 8.4.1 servers using a replication user with 'caching_sha2_password' I received the following error using the command "start replica ...
Sotiris Liras's user avatar
0 votes
2 answers
42 views

How to down size the storage of AWS RDS MySQL instance?

I have an RDS MySQL instance db.m5.4xlarge with 8.3TB of data, and I want to shrink it to 4TB to save costs because it actually has 4TB of data. What are the viable options? I've tried several methods,...
user26127523's user avatar
0 votes
1 answer
30 views

Manage the amount of data on tables

I can have several tables with 10+ millions rows in by year. I would to know what's the best approach to maintain responsiveness with this amount of datas and I have two ideas. Don't touch these ...
Matt's user avatar
  • 1
0 votes
0 answers
39 views

Random long writes (waiting for handler commit)

I have some INSERT/UPDATE queries who takes a long time randomly. I try to launch the same INSERT several times with profiling enable. And I remark that the duration is always in waiting for handler ...
Matt's user avatar
  • 1
0 votes
0 answers
27 views

Cannot reset password for the root user in MySQL

I’m trying to install and setup MySQL on my Machine (MacBook Pro M3 Max with Sonoma 14.5 OS) but it is not being possible to login anymore. The root password keep being changed after I shut down the ...
Victor Cordeiro Costa's user avatar
0 votes
1 answer
50 views

best set of indices

This is a MySQL case with 5,000,000 records in trade table, and 5,000,000 records in registries table. little cases exist where uni is duplicate. i.e. values of uni is almost different. same comment ...
Ali Tavakol's user avatar
0 votes
1 answer
30 views

mysql - show all users/hosts with privileges to access a certain database

Is there a way to list all users/hosts that have been granted access to a database? I know I can do this: > show grants for someuser; +---------------------------------------------------------------...
eftshift0's user avatar
  • 115
0 votes
1 answer
24 views

WSREP_SST: [ERROR] Possible timeout in receiving first data from donor in gtid stage

I have deployed Alma Linux 9 and MariaDB 10.11.7 with Galera 4 on two AWS instances and all the ports and firewall rules are open between 2 instances, I set the proper wsrep options and I am still ...
Sandeep's user avatar
  • 101
0 votes
1 answer
27 views

Mysql problem not valid syntax

reason:Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'почта VARCHAR(50), тип травмы ENUM('...
Godelisk's user avatar
0 votes
2 answers
143 views

How do I upgrade MySQL from 8.0 to 8.4?

I'm on Windows. I installed MySQL 8.4, stopped all services and copied the Data folder and my.ini files into the 8.4 folder but now the 8.4 services does not start and does not produce any logs. I can'...
user avatar
0 votes
0 answers
22 views

Intermittent AWS RDS Connection Spikes Causing Production DB Outages

I'm new to AWS, and we're using a db.r7g.2xlarge instance running MySQL with default configurations. Typically, CPU usage and database connections are normal until "something" causes the DB ...
Mohamed Akram's user avatar
0 votes
0 answers
18 views

How to replace users passwords with yaml variables?

I am writing a MySQL script defining users and roles, but I don't want to upload the password to the repository. So I was guessing if I can replace those passwords with yaml variables. USE test; DROP ...
Eduardo Jiménez's user avatar
0 votes
2 answers
39 views

Making mysql write more to ram and less to SSD

What are some tunning options that could make MySQL (8.0.36) write more to ram memory and less to SSD ? To have less SSD wear not to optimize performance. Do these two affect amount of bytes written ...
adrianTNT's user avatar
  • 194
0 votes
1 answer
29 views

Importing mysql file fails printing last line and I find ^@^@^@^@^@^@^@^@^@^ on that line

I am trying to import some relatively large databases, over 100 GB dump file. When I try to import the dump files with a command like: mysql -h localhost -u username -p dbname < backup.sql after ...
adrianTNT's user avatar
  • 194
0 votes
0 answers
29 views

Should one stick to 1NF (and higher NF) rules for SQL even while using ORMs?

I am currently making a database in MySQL using the SQLAlchemy ORM. I followed the principles of 1NF until this point (atomised Data, no redundancy) but now I am tempted to add a few useful (though ...
Arya Vishe's user avatar
0 votes
1 answer
18 views

Merge two queries to avoid looping over each lines one by one?

I have the following two tables Agents - id - name - email - organization_id Messages - id - message - agent_id - organization_id (And the "organizations" table with some fields, ...
Cyril N.'s user avatar
0 votes
1 answer
34 views

Questions get answered by a user, how to store historical data alongside the answer?

I'm building a database where a User can answer Questions, each Question belongs to a Category. Now what if someone changes a question or category name later, I need to store the historical data of ...
Miguel Stevens's user avatar
0 votes
2 answers
24 views

MySQL 5.1 Time format of the 6-digit string

What time format is the 6-digit string in? Or is a transaction ID of some sort? MySQL server is 5.1. Errors log 240110 9:00:01 [ERROR] /usr/libexec/mysqld: Deadlock found when trying to get lock; try ...
supmethods's user avatar
-1 votes
1 answer
56 views

Database Design for Attendance Management [closed]

Although this question has been asked many times on stackoverflow but none of them fit my situation. I have an application which possibly going to have 2-3 million student records. Each student is ...
KAVYA SHARMA's user avatar
-1 votes
1 answer
24 views

How do we optimize a transaction-log VIEW in MySQL that will use a LIMIT when executed?

Problem / Observation A query that performs well outside of a view (with a limit 20), uses a suboptimal query plan when placed inside of a view if the limit 20 is not included in the view definition ...
Rob R's user avatar
  • 9
1 vote
1 answer
17 views

Multiple parents for AspNetUsers table for Asp.Net Core 3.1 app

I have the following table in MySQL.: CREATE TABLE `aspnetusers` ( `Id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `UserName` varchar(256) CHARACTER SET utf8mb4 ...
Hello World's user avatar
0 votes
0 answers
15 views

I have created a blue green deployment for my AWS RDS MySQL Database as I need to update the version. But I can't connect to the green instance?

I have an old MySQL database on AWS RDS that I need to upgrade to a newer version. I have created a blue green deployment, in order to test out the upgraded version of MySQL before switching over. But ...
Jesper's user avatar
  • 1
0 votes
3 answers
46 views

in Relational database, will index accelerator query: select count(*) from table where score >= number

Let's say we use MySQL With 100 million records Table schema: userid(pk), score score ranges from 0 to 10^6 score has duplicates So the question is when adding a index on score, will it accelerate ...
ma ky's user avatar
  • 11
0 votes
1 answer
42 views

Conditional update

I would like to create a conditional update on an audit table, such that if the update on the main table succeeds, then the update on the audit table is performed. Right now I have this CREATE DEFINER=...
tcelvis's user avatar
1 vote
0 answers
9 views

mysql build error on Raspberry Pi Model 3A+ with Raspbian

I am building MySQL version 8.0.37 on a Raspberry Pi Model 3A+ with the Raspbian OS. I have encountered several build errors regarding missing dependancies and resolved them. I am now faced with an ...
user10709800's user avatar
1 vote
0 answers
10 views

How would I skip test compilation in a MySQL build?

As the title suggests, I am building MySQL version 8.0.37 from source on a Linux machine and would like to skip test compilation. I have attempted adding the flag: -DINSTALL_MYSQLTESTDIR= which, ...
user10709800's user avatar
1 vote
1 answer
21 views

MySQL instant drop column on an old table

I'm trying to use MySQL's instant column drop functionality on a large/high traffic table and it's not working the way I expect. My database is hosted in AWS RDS on MySQL version 8.0.34. Here is the ...
user avatar
0 votes
1 answer
96 views

mysqldump: Error in field count for table: aborting

My Environment Azure Flexible Server MySQL MySQL version 8.0 mysqldump Ver 10.14 Distrib 5.5.68-MariaDB, for Linux (x86_64) I am trying to backup a MySQL database using mysqldump, and I am having a ...
Roberto Hernandez's user avatar
-1 votes
0 answers
76 views

Mysql Replication Lag

I am using mysql 5.7 in both master & slave on ubuntu 18.04 LTS. After the replication setup, slave catchup was very slow. when io thread and sql thread access the same relay log, both thread ...
Jai Prakash's user avatar
0 votes
0 answers
10 views

mysql router crashes what is the solution

we have a MySQL Router with 12 GB of RAM which must pass traffic to 3 databases. So it happens that the router crashes and does not process any traffic, we don't know why.
abdoul rachid's user avatar
0 votes
0 answers
19 views

Linking records through multiple tables?

I'm writing a game server. Similar to the Sims. Players can own furniture items they purchase from the catalog. There can also be rooms. Players can be in a room. A room can have furniture items of ...
jacks's user avatar
  • 121
0 votes
0 answers
35 views

SSIS Dataflow Task issue, moving data from any Source to MySQL via ADO.Net

Can you please help me in getting this problem solved.. I'm trying to build a SSIS package where I'm moving the data from any Source to MySQL. However I'm getting a weird problem in dataflow task. [...
Ho Ka's user avatar
  • 1
0 votes
3 answers
3k views

Failure to initialise MySQL Server 5.7 due to mysqlx_port=0.0

I'm migrating a legacy system to a more recent server and I am having issues installing MySQL Server 5.7. When I try I get the error unknown variable mysqlx_port=0.0. I've tried updating the my.ini ...
Harold's user avatar
  • 101
0 votes
0 answers
44 views

Where is my memory leaked?

I'm running Percona MySQL 8.0.36-28 on Kubernetes (GKE) and I am suffering of a constant memory leak I am not able to identify. MySQL reports the memory usage is 1.8G, while when I check the memory ...
Dani Lou's user avatar
0 votes
0 answers
36 views

Install MySQL offline on Windows server

I created a batch file to install MySQL Server on our offline machine. The service is up and running, but apparently it is unable to create the root password and is therefore unable to perform the ...
user avatar
0 votes
0 answers
17 views

Table Query From MySql 8.4 Command Line Client Returns "Empty Set" While Perl script query returns the called item

Using Mysql 8.4 mysql> SELECT * FROM jobs; Empty set (0.00 Sec) After connecting to the database this Perl script returns a file "supposedly posted to the table 'jobs' in jobs_db $sth = $dbh-&...
user3135388's user avatar
0 votes
1 answer
51 views

Removing partitions from MySQL table

I have table containing 3.2TB data in partition named default_partition, & all writes/read goes to this partition, as we have defined partitions on table like below : PARTITION BY RANGE (to_days(...
tusharRawat's user avatar
0 votes
0 answers
19 views

Galera Cluster: All Nodes Slowed Down After Update Query and Too Many Connections Error

I met a disability while using galeracluser and I have a question. It is an active-active 3-node structure and maintains replication through log_slave_updates=ON. I'm using MariaDB 10.5.13 version ...
samsamsamsmasma's user avatar

1
2 3 4 5
450