A query to be executed regularly for clean up?

|
roipeker 2020-03-29 00:52:02
Im on a shared server
MasterZiv 2020-03-29 00:52:22
roipeker 2020-03-29 00:52:02
Im on a shared server

This doesn’t matter

roipeker 2020-03-29 00:52:30
Resources matter, so idk how many connections will open in the pool
roipeker 2020-03-29 00:52:37
Doesnt impact the mysql performance
roipeker 2020-03-29 00:52:44
So many updates/inserts?
roipeker 2020-03-29 00:52:54
I think im under mariadb now
roipeker 2020-03-29 00:53:48
If its irrelevant, then ok
roipeker 2020-03-29 00:54:07
Second question: any way to have like a cron job inside the mysql engine?
roipeker 2020-03-29 00:54:15
A query to be executed regularly for clean up?
MasterZiv 2020-03-29 00:54:49
roipeker 2020-03-29 00:54:07
Second question: any way to have like a cron job inside the mysql engine?

It’s not the responsibility of rdbms…

roipeker 2020-03-29 00:55:25
Then no…
roipeker 2020-03-29 00:56:07
As the db itself knows when it will be “unlocked” from processes i thought there was a way to run some basic query on a predefined period
roipeker 2020-03-29 00:56:52
Im thinking mostly if i have multiple microservices hitting the same db…
MasterZiv 2020-03-29 00:57:19
roipeker 2020-03-29 00:54:15
A query to be executed regularly for clean up?

If you need something like this, use from our similar services.
Many dbms have task schedulers , MySQL don’t.
Though, I may not know…

roipeker 2020-03-29 00:58:03
I wish i knew some postgress to run the system there, but i have no clie
MasterZiv 2020-03-29 00:58:12
roipeker 2020-03-29 00:56:07
As the db itself knows when it will be “unlocked” from processes i thought there was a way to run some basic query on a predefined period

From which processes?

roipeker 2020-03-29 00:58:14
Anyway might be similar in that regard
roipeker 2020-03-29 00:58:30
MasterZiv 2020-03-29 00:58:12
From which processes?

From the insertion/update of records

MasterZiv 2020-03-29 00:59:30
roipeker 2020-03-29 00:58:30
From the insertion/update of records

It doesn’t know.

MasterZiv 2020-03-29 01:01:07
roipeker 2020-03-29 00:58:30
From the insertion/update of records

mySQL is a client-server dbms, server is always passive, the count is active.
If

roipeker 2020-03-29 01:01:58
i think i understood u
roipeker 2020-03-29 01:02:09
anyway, i have no way to optimize this system beforehand.
roipeker 2020-03-29 01:02:10
no ?
roipeker 2020-03-29 01:02:24
the concept is pretty basic and shuold scale well?
MasterZiv 2020-03-29 01:03:03
roipeker 2020-03-29 01:02:24
the concept is pretty basic and shuold scale well?

In general, yes,

roipeker 2020-03-29 08:36:26
If i have a users table and a company table and both have address, email, phone…
roipeker 2020-03-29 08:36:44
Should i create another table to store that?
MasterZiv 2020-03-29 09:52:15
roipeker 2020-03-29 08:36:44
Should i create another table to store that?

Yes, that is a good idea

MasterZiv 2020-03-29 10:44:05
roipeker 2020-03-29 08:36:26
If i have a users table and a company table and both have address, email, phone…

Beware, address is a very complex and versatile entity

roipeker 2020-03-29 10:44:56
Im aware
roipeker 2020-03-29 10:45:24
Just need the city id, raw address and lat lon
roipeker 2020-03-29 10:46:37
Even if 2 people have the same address it will be a unique row… i just wanted to debloat the user/store entities
roipeker 2020-03-29 10:47:05
I dont have for multiple addresses
2020-03-30 02:31:34
can someone help me set up this file? mysql is using a lot of cpu. My vps has 30GB ram and 8 cpu and is not supporting 4,000 users online
2020-03-30 02:31:36
mysql_en-2480.jpg

2020-03-30 02:31:45
http://51.83.249.125/mysqld.cnf
piterden 2020-03-30 02:52:16
2020-03-30 02:31:45
http://51.83.249.125/mysqld.cnf

What service is it? What programming language do you use at back-end?

piterden 2020-03-30 02:52:49
Why do you think it is sql issue?
piterden 2020-03-30 02:53:22
Why do you use 30gb if htop shows 2,5 only
piterden 2020-03-30 02:54:15
What kind of interaction happens between users in your app?
2020-03-30 03:10:21
piterden 2020-03-30 02:52:16
What service is it? What programming language do you use at back-end?

is a movie app

2020-03-30 03:10:24
piterden 2020-03-30 02:52:16
What service is it? What programming language do you use at back-end?

Laravel

2020-03-30 03:10:47
piterden 2020-03-30 02:52:49
Why do you think it is sql issue?

on htop it is using 173% of the cpu

2020-03-30 03:11:12
piterden 2020-03-30 02:53:22
Why do you use 30gb if htop shows 2,5 only

precisely because of this problem, a smaller server does not work

2020-03-30 03:11:34
piterden 2020-03-30 02:54:15
What kind of interaction happens between users in your app?

every interaction uses the web panel api

piterden 2020-03-30 03:17:52
2020-03-30 03:11:34
every interaction uses the web panel api

Okay. And what do you want?

2020-03-30 03:21:39
2020-03-30 02:31:45
http://51.83.249.125/mysqld.cnf

optimize this standard file maximum possible standard connection

piterden 2020-03-30 03:25:46
Man, you should optimize your code at first. It is not MySQL causing that, but the shitcode was written for your app
piterden 2020-03-30 03:26:48
Also you shouldn’t use apache
piterden 2020-03-30 03:28:07
And also php has bad performance for parallel tasks
|