If MySQL show MySQL uuid repeat with slave server, how we can fix this problem?

|
piterden 2022-01-26 17:23:53
ChildProcessError 2022-01-26 17:13:13
im gonna store every message in every single telegram group in a row and i need to get them every few minutes
its a lot of data and a lot of request
what is the best database for this type of use?
im using psql for now
should i change it?

Postgres is fine for that if you know how to use it correct

ChildProcessError 2022-01-26 17:24:23
piterden 2022-01-26 17:23:53
Postgres is fine for that if you know how to use it correct

im using sql alchemy

ChildProcessError 2022-01-26 17:24:41
sqlalchemy-postgresql+asyncpg driver
piterden 2022-01-26 17:26:11
ChildProcessError 2022-01-26 17:24:23
im using sql alchemy

No matter which ORM you like more

ChildProcessError 2022-01-26 17:27:20
piterden 2022-01-26 17:26:11
No matter which ORM you like more

so what do you mean if you know how to use it correct

ChildProcessError 2022-01-26 17:27:24
how can i use it correct
piterden 2022-01-26 17:28:28
ChildProcessError 2022-01-26 17:27:20
so what do you mean if you know how to use it correct

I mean the structure of you database. Tables, columns, their relations and indexes

Suri 2022-01-27 07:58:24
How to fix MySQL uuid repeat with slave server??
MasterZiv 2022-01-27 08:48:41
Suri 2022-01-27 07:58:24
How to fix MySQL uuid repeat with slave server??

Describe your problems in details

Suri 2022-01-27 08:51:49
If MySQL show MySQL uuid repeat with slave server, how we can fix this problem?
PriyaJeevan18 2022-01-27 08:56:29
Hi all,

I want to upgrade MySQL 5.7.31 to 5.7.36 on windows

Can anyone please help me with the steps?

Khushi Hura 2022-01-27 09:01:07
Firstly u will have to uninstall the old version I think🤔
Ken 2022-01-27 13:55:45
I have a slave MySQL server, powered off two weeks’ time. If I turn it on again, do I need to do anything to sync the BINLOG? Thanks a lot!
Ishu Gupta 2022-01-27 20:52:56
Can anyone tell me how to optimized MySQL count(*) query using innodb storage engine
MasterZiv 2022-01-28 11:00:36
Ishu Gupta 2022-01-27 20:52:56
Can anyone tell me how to optimized MySQL count(*) query using innodb storage engine

send your table DDL and the query,
You can’t optimize a query without the query

madno 2022-01-28 11:17:46
What are the prerequisites of partition in mysqL
MasterZiv 2022-01-28 12:16:55
madno 2022-01-28 11:17:46
What are the prerequisites of partition in mysqL

It seems there is no any specific requirements.
I can only say you should have some field in each record by value of which the record can be prescribed to one or another partition, uniquely

madno 2022-01-28 12:27:46
MasterZiv 2022-01-28 12:16:55
It seems there is no any specific requirements.
I can only say you should have some field in each record by value of which the record can be prescribed to one or another partition, uniquely

Do i need to have partition key in every update delete or select?

MasterZiv 2022-01-28 12:29:03
madno 2022-01-28 12:27:46
Do i need to have partition key in every update delete or select?

AFAIR no, this will only determine if it is going to be one partition operation or all partitions.

Ishu Gupta 2022-01-28 13:01:31
MasterZiv 2022-01-28 11:00:36
send your table DDL and the query,
You can’t optimize a query without the query

mysql_en-16698.jpg

Ishu Gupta 2022-01-28 13:02:02
See DDL query of table and query execution time
MasterZiv 2022-01-28 13:03:12
Ishu Gupta 2022-01-28 13:02:02
See DDL query of table and query execution time

send text please, I can’t see a thing

sensitivehead 2022-01-28 17:51:13
mysql_en-16703.jpg
hi can anyone help me to solve this problem
sensitivehead 2022-01-28 17:51:50
mysql_en-16704.jpg
Erd is as above
sensitivehead 2022-01-28 17:51:56
I am new to SQL.
sensitivehead 2022-01-28 17:51:58
please help
sensitivehead 2022-01-28 18:05:35
anyone ???
SKP 2022-01-28 18:32:23
SQL tutorial for beginners

SQL tutorial for beginners | MySQL Tutorial for beginners – YouTubeYouTube
Ishu Gupta 2022-01-28 19:46:51
MasterZiv 2022-01-28 13:03:12
send text please, I can’t see a thing

mysql> show create table tbl_campdataG
***** 1. row *****
Table: tbl_campdata
Create Table: CREATE TABLE tbl_campdata (
id int(11) NOT NULL AUTO_INCREMENT,
msisdn varchar(20) DEFAULT NULL,
entrydate datetime NOT NULL,
campid int(11) DEFAULT NULL,
status int(11) DEFAULT NULL,
lastupdatedate datetime DEFAULT NULL,
callerid varchar(20) DEFAULT NULL,
sms_template_answer varchar(500) DEFAULT NULL,
sms_template_answer_keypressed varchar(500) DEFAULT NULL,
sms_template_answer_keypressed_2 varchar(500) DEFAULT NULL,
sms_template_noanswer varchar(500) DEFAULT NULL,
priority int(11) DEFAULT ‘1’,
PRIMARY KEY (id,entrydate),
KEY indx_campid (campid),
KEY entrydate (entrydate),
KEY indx_msisdn (msisdn),
KEY indx_status (status),
KEY test_id (id)
) ENGINE=InnoDB AUTO_INCREMENT=130791169 DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (day(entrydate))
PARTITIONS 31 */
1 row in set (0.00 sec)

mysql>
mysql> select count(1) FROM tbl_campdata nolock WHERE DATE(entrydate) < DATE(DATE_ADD(NOW(),INTERVAL -15 DAY));
+———-+
| count(1) |
+———-+
| 5925646 |
+———-+
1 row in set (2.32 sec)

nikhil02220 2022-01-28 20:40:21
Ishu Gupta 2022-01-28 19:46:51
mysql> show create table tbl_campdataG
***** 1. row *****
Table: tbl_campdata
Create Table: CREATE TABLE tbl_campdata (
id int(11) NOT NULL AUTO_INCREMENT,
msisdn varchar(20) DEFAULT NULL,
entrydate datetime NOT NULL,
campid int(11) DEFAULT NULL,
status int(11) DEFAULT NULL,
lastupdatedate datetime DEFAULT NULL,
callerid varchar(20) DEFAULT NULL,
sms_template_answer varchar(500) DEFAULT NULL,
sms_template_answer_keypressed varchar(500) DEFAULT NULL,
sms_template_answer_keypressed_2 varchar(500) DEFAULT NULL,
sms_template_noanswer varchar(500) DEFAULT NULL,
priority int(11) DEFAULT ‘1’,
PRIMARY KEY (id,entrydate),
KEY indx_campid (campid),
KEY entrydate (entrydate),
KEY indx_msisdn (msisdn),
KEY indx_status (status),
KEY test_id (id)
) ENGINE=InnoDB AUTO_INCREMENT=130791169 DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (day(entrydate))
PARTITIONS 31 */
1 row in set (0.00 sec)

mysql>
mysql> select count(1) FROM tbl_campdata nolock WHERE DATE(entrydate) < DATE(DATE_ADD(NOW(),INTERVAL -15 DAY));
+———-+
| count(1) |
+———-+
| 5925646 |
+———-+
1 row in set (2.32 sec)

Function is used inside the where clause. Hence this is slow. The query has to first cast all of the values in the entrydate column to date and then do the comparison.

nikhil02220 2022-01-28 20:47:10
Rewrite your query as
nikhil02220 2022-01-28 20:47:13
select count(1) FROM tbl_campdata nolock WHERE entrydate < concat(date(date_add(now(), interval 15 day)),” “, “00:00:00”);
nikhil02220 2022-01-28 20:47:22
and check
PS 2022-01-28 23:19:48
Hey guys, may I ask you a very simple question? I am very new with MySQL. Today I installed MySQL from MS website and tried to start the server. I put mysqld in the command line but I had a error that it could not connect to server. How do I proceed? Can someone help me?
MasterZiv 2022-01-29 00:54:57
nikhil02220 2022-01-28 20:40:21
Function is used inside the where clause. Hence this is slow. The query has to first cast all of the values in the entrydate column to date and then do the comparison.

Yes, I agree

|