Calling a stored procedure is much slower than calling an insert, and bulk inserts are basically the same, why?

I have a table and a stored procedure as shown below, CREATETABLE`inspect_call`(`id`bigint(20)unsignedNOTNULLA...

From [MySQLdiscussion group] 2024-03-30 12:42:40 0  1  410

Dockerfile CMD does not support multiple commands for mysql image

Try running the mysql5.7 image with the datadir flag and include the bash script in CMD. CMD["--datadir=/...

From [MySQLdiscussion group] 2024-03-30 11:20:42 0  1  431

Calculation using 2 tables in MySQL

I have 2 tables games and transactions I'm using this formula sum(EntryFee*Rake/(100+Rake)*TotalEntry) in the ...

From [MySQLdiscussion group] 2024-03-30 11:32:48 0  2  432

Get the values ​​of all rows in the left join

I have 3 tables. The first table is the main table, the second table I leave joins it with the main table, and...

From [MySQLdiscussion group] 2024-03-30 11:12:36 0  1  422

How can we capture the resource usage of a specific stored procedure in mysql server

How to capture the resource usage of a specific stored procedure in MYSQL server and how to get the query for ...

From [MySQLdiscussion group] 2024-03-30 09:59:56 0  1  495

SQL Inner Join Performance Data Duplication

table-->qtqstnId tag id1112232422 table-->question qid12 qid primary key, qstnId is Fk now when i run th...

From [MySQLdiscussion group] 2024-03-30 09:17:19 0  1  484

Is there any benefit to establishing multiple database connections for SQL inserts?

I'm writing a project related to massive data acquisition. Currently I'm using .NETFramework4.8 and the Mysql ...

From [MySQLdiscussion group] 2024-03-30 08:39:46 0  1  339

Will selecting specific columns affect the number of rows in MySQL?

I have a simple query with a few joins, but when I add columns to my select from the same set of joins, simply...

From [MySQLdiscussion group] 2024-03-29 22:53:26 0  1  341

The rewritten title is: Retrieving records in increments of 30 days

I have the following query to get appointments that need to be reminded once a month if they haven't been comp...

From [MySQLdiscussion group] 2024-03-29 22:31:21 0  2  370

SQL query to get users who are both followed by someone and follow that person

I have a scenario where I want to find users who are following user X and user X is following them. Look at th...

From [MySQLdiscussion group] 2024-03-29 22:20:07 0  1  339

Failed to install mysql-operator in Kubernetes

So, I followed the guide (https://dev.mysql.com/doc/mysql-operator/en/mysql-operator-installation-kubectl.html...

From [MySQLdiscussion group] 2024-03-29 22:12:09 0  2  468

How to remove all strings after question mark in MySQL query

I have a column of urls like http://mydomain/app?u=asdfa&b=fnsn with different number of parameters. I wan...

From [MySQLdiscussion group] 2024-03-29 21:23:16 0  1  363

MYSQL (WAMP SERVER): Error 1064 when creating table column with AUTO_INCRMENT=1000?

I have this code: CREATETABLECompany(Comp_CodeINT(5)NOTNULLAUTO_INCRMENT=1000,Comp_NameVARCHAR(15)NOTNULL,Prim...

From [MySQLdiscussion group] 2024-03-29 20:35:14 0  1  407

Scrapy INSERT into 'new_table' only if no record exists in 'current table'

I tried some website scraping. I successfully scraped the data from the current database table. But I want to ...

From [MySQLdiscussion group] 2024-03-29 19:36:16 0  1  388

MySQL - complex hierarchical relationships - multiple M:N?

I have a MySQL query that I use with PHP to build hierarchical JSON for a d3.js tree/dendrogram. Fiddle to vie...

From [MySQLdiscussion group] 2024-03-29 18:28:45 0  1  467