← prev | next →
2020-07-08 14:05:23
Wait our Dev join in this group
MasterZiv 2020-07-08 14:29:03
2020-07-07 19:14:43
Hi, anyone can help me out with what is the best practice to take the backup of production MySQL database ?
yes, it is very good practice
MasterZiv 2020-07-08 14:30:55
2020-07-08 13:13:13
we are using mysql on ubuntu ( Digital ocean).
we are using a transaction table and it gets records inserted/updated/deleted/select with a speed of 200 requests per second. we have few custom functions used.
we are facing issue with ram, the ram keeps on increasing and doesnt decrease untill we restart server, how can we make this limited or restricted, this increased ram is killing the performance of CURD operations with are creating wait time out.
this is working perfectly when the ram is upto 30%, once it cross 30 it is slowly increasing the timeout queries which again increase the ram.
RAM used by MySQL is not an issue, a DBMS is expected to use lots of RAM
MasterZiv 2020-07-09 00:18:13
2020-07-08 13:13:13
we are using mysql on ubuntu ( Digital ocean).
we are using a transaction table and it gets records inserted/updated/deleted/select with a speed of 200 requests per second. we have few custom functions used.
we are facing issue with ram, the ram keeps on increasing and doesnt decrease untill we restart server, how can we make this limited or restricted, this increased ram is killing the performance of CURD operations with are creating wait time out.
this is working perfectly when the ram is upto 30%, once it cross 30 it is slowly increasing the timeout queries which again increase the ram.
How much memory is taken by mySQL?
Deb_575 2020-07-10 18:58:56
Hello all am facing an issue while trying to restore mysqldump of selective tables from a community edition mysql server to enterprise one.
Firstly it’s possible to restore dump from community to enterprise right?
2ndly what I can do for this error : “ERROR 1213 (40001) at line 22 : Deadlock found when trying to get lock; try restarting transaction”
Can anyone please help?
MasterZiv 2020-07-10 20:39:06
Deb_575 2020-07-10 18:58:56
Hello all am facing an issue while trying to restore mysqldump of selective tables from a community edition mysql server to enterprise one.
Firstly it’s possible to restore dump from community to enterprise right?
2ndly what I can do for this error : “ERROR 1213 (40001) at line 22 : Deadlock found when trying to get lock; try restarting transaction”
Can anyone please help?
This is not related at all to the difference in “editions” of MySQL.
This is simply because you do something else with the DB while you resorting the dump.
This will not do never
Deb_575 2020-07-10 20:40:29
That was my thought as well I restarted the service and tried and again same when I checked processlist those queries are again there even after restart. Any soultion for this
button_idli 2020-07-10 21:51:31
Deb_575 2020-07-10 20:40:29
That was my thought as well I restarted the service and tried and again same when I checked processlist those queries are again there even after restart. Any soultion for this
Save those queries as a new file as an excel sheet after that import them as you like. I think that might be the solution.
MasterZiv 2020-07-10 22:47:43
Deb_575 2020-07-10 20:40:29
That was my thought as well I restarted the service and tried and again same when I checked processlist those queries are again there even after restart. Any soultion for this
Cut the MySQL instance off the net by means of IP tables or similar or restart mysql listening only the local host.
sixpeteunder 2020-07-11 13:53:21
Hello, I’m trying to avoid polymorphic relationships in my table structure for something like this:
There are four table that a user can express a reaction on (example “like”, “dislike”).
I have tried creating a parent table that they all inherit from, but that doesn’t really fix it. Any help?
sixpeteunder 2020-07-11 14:01:23
The only thing I can think of that would work without breaking foreign key constraints is to have four “reactions ” tables: entity_1_reactions, entity_2_reactions, entity_3_reactions, …
MasterZiv 2020-07-11 23:48:40
sixpeteunder 2020-07-11 13:53:21
Hello, I’m trying to avoid polymorphic relationships in my table structure for something like this:
There are four table that a user can express a reaction on (example “like”, “dislike”).
I have tried creating a parent table that they all inherit from, but that doesn’t really fix it. Any help?
This SHOULD fix it. If it does not, you obviously do something wrong
MasterZiv 2020-07-11 23:51:11
sixpeteunder 2020-07-11 13:53:21
Hello, I’m trying to avoid polymorphic relationships in my table structure for something like this:
There are four table that a user can express a reaction on (example “like”, “dislike”).
I have tried creating a parent table that they all inherit from, but that doesn’t really fix it. Any help?
Can you show more details?
What do you mean by polimorphic rel? Why you want to avoid this, what is done exactly for this (show code)?
sixpeteunder 2020-07-12 01:54:21
MasterZiv 2020-07-11 23:51:11
Can you show more details?
What do you mean by polimorphic rel? Why you want to avoid this, what is done exactly for this (show code)?
I will share database structure tomorrow
sixpeteunder 2020-07-12 01:54:21
MasterZiv 2020-07-11 23:48:40
This SHOULD fix it. If it does not, you obviously do something wrong
I did it like this. I had done it wrong at first.
BeaterBSD 2020-07-12 01:59:36
HI, sorry, i need help whith error 1524 Plugin ” is not loaded and equal error when try mysql_upgrade. It’s mysql 5.7.30 on centos 7.8
MasterZiv 2020-07-12 02:13:59
BeaterBSD 2020-07-12 01:59:36
HI, sorry, i need help whith error 1524 Plugin ” is not loaded and equal error when try mysql_upgrade. It’s mysql 5.7.30 on centos 7.8
What plugin was it?
Actually this may be not an error at all, sometimes some configurations don’t use some plugins and they are not loaded because of mySQL configuration.
BeaterBSD 2020-07-12 02:16:59
ERROR 1524 (HY000): Plugin ‘2147483647’ is not loaded
HlebR 2020-07-12 15:12:53
How to export mysql db files to sql (mysql server don’t works) ?
piterden 2020-07-12 15:16:19
HlebR 2020-07-12 15:12:53
How to export mysql db files to sql (mysql server don’t works) ?
Make dump for MSSQL
HlebR 2020-07-12 15:16:36
how to do it?
piterden 2020-07-12 15:19:44
HlebR 2020-07-12 15:16:36
how to do it?
mysqldump –help
piterden 2020-07-12 15:22:58
Try to keep it out meta speeches pls
But hello))
HlebR 2020-07-12 15:56:40
piterden 2020-07-12 15:19:44
mysqldump –help
os with db don’t works, i have only files, what should I do with they to get sql for importing to db on working server?
2020-07-12 16:25:46
piterden 2020-07-12 15:22:58
Try to keep it out meta speeches pls
But hello))
I’m just started
MasterZiv 2020-07-12 16:55:39
HlebR 2020-07-12 15:12:53
How to export mysql db files to sql (mysql server don’t works) ?
Impossible then.
You must first start mysqld.
MasterZiv 2020-07-12 16:58:06
HlebR 2020-07-12 15:56:40
os with db don’t works, i have only files, what should I do with they to get sql for importing to db on working server?
You can also do a cold restore, set up a new mySQL instance somewhere and replace its files with the ones from you old server.
Read in the docs about how to do this.
BlackshadowR1 2020-07-13 14:25:03
Hi guys,
I have started learning the SQL over W3Schools
BlackshadowR1 2020-07-13 14:25:27
Please suggest of that’s a good platform to learn the same or if there is any other platform from where I can learn
Tekipeps 2020-07-14 02:41:53
hello im having this error in using sequelize Dialect needs to be explicitly supplied as of v4.0.0
Tekipeps 2020-07-14 02:42:11
ive dug the internet and cant still fix this
piterden 2020-07-14 04:25:38
Tekipeps 2020-07-14 02:41:53
hello im having this error in using sequelize Dialect needs to be explicitly supplied as of v4.0.0
Which version do you have?
Tekipeps 2020-07-14 04:25:55
piterden 2020-07-14 04:25:38
Which version do you have?
I have fixed it
piterden 2020-07-14 04:26:01
And which driver
piterden 2020-07-14 04:26:03
Ok
2020-07-14 07:52:13
Access denied for user manoj’@’10.20.10.0 ( using password:YES) (SQL:SET FOREIGN_KEY_CHECKS=0;)
2020-07-14 07:52:36
Hello I am having this error
2020-07-14 08:18:08
Can anyone help me ?
piterden 2020-07-14 08:18:17
So, do you need translation to your native language?
piterden 2020-07-14 08:18:31
Wrong password
2020-07-14 08:24:53
Hi Denis, I have double checked it, password is correct.
piterden 2020-07-14 08:26:15
How do you know it?
piterden 2020-07-14 08:27:20
It not displaying
piterden 2020-07-14 08:28:55
Look it can’t be miracle
piterden 2020-07-14 08:30:11
If it tell you access denied than you doing something wrong. You do not give any information! What do you want from chat?
piterden 2020-07-14 08:31:07
What you show definitely means you have pass wrong password
piterden 2020-07-14 08:31:45
Or maybe you have some customized login behavior
piterden 2020-07-14 08:32:08
But you tell nothing about it
2020-07-14 08:32:59
Okay got it
2020-07-14 08:34:27
I am completely new to database so could not figured it out what exactly went wrong.
← prev | next →