Would my mysql connection timeout if i dont use it and dont execute any queries on it for a few hours?

|
ChildProcessError 2021-09-27 09:08:16
ilia are you from iran?
MasterZiv 2021-09-27 09:09:21
ChildProcessError 2021-09-27 09:07:58
to prevent disconnecting from mysql server

Bad Network, iddle disconnects, deadlocks – all can lead to disconnect you must be ready to re-connect always

MasterZiv 2021-09-27 09:09:40
ChildProcessError 2021-09-27 09:08:16
ilia are you from iran?

no i am from Albaniya

ChildProcessError 2021-09-27 09:09:43
MasterZiv 2021-09-27 09:09:21
Bad Network, iddle disconnects, deadlocks – all can lead to disconnect you must be ready to re-connect always

Lost connection to MySQL server during query

ChildProcessError 2021-09-27 09:09:57
ChildProcessError 2021-09-27 09:09:43
Lost connection to MySQL server during query

i dont think its about the network

ChildProcessError 2021-09-27 09:10:08
error says during query
MasterZiv 2021-09-27 09:10:20
ChildProcessError 2021-09-27 09:09:43
Lost connection to MySQL server during query

this can be for example a deadlock

ChildProcessError 2021-09-27 09:12:32
ok
ill see what i can do
ty
MasterZiv 2021-09-27 09:15:37
ChildProcessError 2021-09-27 09:09:57
i dont think its about the network

it doesn’t matter what it is , your application just have to be ready to reconnect

TechGuyHelp 2021-09-27 14:10:21
MasterZiv 2021-09-27 06:20:56
It is only for installing MySQL plugin for Visual Studio, obviously VS must be installed to install a plugin into it, but this plugin is not needed for MySQL to work, this must be one of possible ways to develop apps with MySQL. If you prefer developing in VS, then install it, but this is not needed for MySQL itself

ok, then mysql installation can still be completed without the VS and those plugin, right? if not VS, what you use to develop the sql script and how to connect it to mysql?

MasterZiv 2021-09-27 14:13:03
TechGuyHelp 2021-09-27 14:10:21
ok, then mysql installation can still be completed without the VS and those plugin, right? if not VS, what you use to develop the sql script and how to connect it to mysql?

mysql installation can still be completed without the VS and those plugin, right?

Yes, right.

if not VS, what you use to develop the sql script and how to connect it to mysql?

You can use anything, native vanilla MySQL utilities, SQLDeveloper, DBeaver, Data Grip, Squirell, Toad, — ANYTHING!

TechGuyHelp 2021-09-27 14:48:50
tq llia. will try as suggested
Me 2021-09-28 16:50:00
mysql_en-13069.jpg
Can any one help me with this..?
ChildProcessError 2021-09-28 17:25:49
would my mysql connection timeout if i dont use it and dont execute any queries on it for a few hours?
SSH 2021-09-28 21:24:37
Hi pls help me
How to import CSV file using load data infile method I am facing invalid data format occur inbetween column and data is not uploading

I need to skip the invalid column data and reaming data to upload to database

MasterZiv 2021-09-28 21:29:49
SSH 2021-09-28 21:24:37
Hi pls help me
How to import CSV file using load data infile method I am facing invalid data format occur inbetween column and data is not uploading

I need to skip the invalid column data and reaming data to upload to database

https://dev.mysql.com/doc/refman/8.0/en/load-data.html

Look at “Duplicate-Key and Error Handling” chapter

thanosphan 2021-09-30 01:52:07
ChildProcessError 2021-09-28 17:25:49
would my mysql connection timeout if i dont use it and dont execute any queries on it for a few hours?

Yes but how long depends on the TTL and which side (client/server) you are approaching this from

Futurist_J1776 2021-09-30 15:05:20
Hi everyone! Happy to be here and help and ask some questions
JAtieno 2021-09-30 16:16:37
Hello guys, I’m new to sql. Can anyone help me on how to create a table using from a text file within the training set. I used the ‘source’ statement but I keep getting errors.
MasterZiv 2021-09-30 16:48:45
JAtieno 2021-09-30 16:16:37
Hello guys, I’m new to sql. Can anyone help me on how to create a table using from a text file within the training set. I used the ‘source’ statement but I keep getting errors.

it is CREATE TABLE statement.

MasterZiv 2021-09-30 16:50:33
JAtieno 2021-09-30 16:16:37
Hello guys, I’m new to sql. Can anyone help me on how to create a table using from a text file within the training set. I used the ‘source’ statement but I keep getting errors.

You have simple choice: either publish your data/DDL/query/diagnostics or investigate your problems yourself

adinath_kamode 2021-09-30 21:01:33
Guys, I have a strange situation.
Some time back a DBA created schema in uppercase , could be on older my sql version. Now that schema has no tables , objects but mysql says schema does not exist while drooping it, but I can see it in information_schema.schemata as well as in workbench. I tried “schemaname ” but no use. I have lower case table name 1 in setup. Due to this mysql8 upgrade is failing, saying that upper case schema name not allowed. Any pointers?
MasterZiv 2021-09-30 21:38:03
adinath_kamode 2021-09-30 21:01:33
Guys, I have a strange situation.
Some time back a DBA created schema in uppercase , could be on older my sql version. Now that schema has no tables , objects but mysql says schema does not exist while drooping it, but I can see it in information_schema.schemata as well as in workbench. I tried “schemaname ” but no use. I have lower case table name 1 in setup. Due to this mysql8 upgrade is failing, saying that upper case schema name not allowed. Any pointers?

well at last you can make a full text dump of your DB and restore the dump to the new server of the new version

madno 2021-09-30 22:53:54
How does a where clause work? Imagine a query select a,b from table where c=1 and d= 2;.
1. How does the optimizer decides if it wants do full table scan or index scan.
2. If “d” in above query is index. How does the predicate comparison works with table data.
adinath_kamode 2021-10-01 07:25:28
MasterZiv 2021-09-30 21:38:03
well at last you can make a full text dump of your DB and restore the dump to the new server of the new version

Difficult as this is RDS,I have to launch new servers and do it and agin exporting import changes strategy.
Can I delete entey from information_schema or will mysqladmin drop help

MasterZiv 2021-10-01 07:30:48
adinath_kamode 2021-10-01 07:25:28
Difficult as this is RDS,I have to launch new servers and do it and agin exporting import changes strategy.
Can I delete entey from information_schema or will mysqladmin drop help

This gonna be hard to do and of unpredictable result

MasterZiv 2021-10-01 07:33:12
madno 2021-09-30 22:53:54
How does a where clause work? Imagine a query select a,b from table where c=1 and d= 2;.
1. How does the optimizer decides if it wants do full table scan or index scan.
2. If “d” in above query is index. How does the predicate comparison works with table data.

1 based on IO prediction and statistics on the table
2) question is unclear.

jamarapini 2021-10-01 17:18:25
Hello Friends,
Please help me on this error message, I am getting below error message while restore MySQL Dump
jamarapini 2021-10-01 17:18:33
ERROR 1215 (HY000) at line 28285: Cannot add foreign key constraint
jamarapini 2021-10-01 17:18:43
and I am using the below restore script for that
jamarapini 2021-10-01 17:18:52
mysql –init-command=”SET SESSION FOREIGN_KEY_CHECKS=0;” -uroot -p -hhostname DBNAme < dump_DBname.sql
jamarapini 2021-10-01 17:19:01
still failing with foreign key constraint issue.
jamarapini 2021-10-01 18:15:53
Note: both Source and destination servers are ServerLess Aurora Instances
SSH 2021-10-01 20:33:16
hello Friends! pls help me “Sep 30-2021 05:05:20.156325469 IST”
SSH 2021-10-01 20:35:57
hello Friends! pls help me how to convert this datetime format to naormal ISO datetime format to upload mariyadb
“Sep 30-2021 05:05:20.156325469 IST” into “30/09/2021 05:05:20”
|