i have mysql master with 3 replicas in windows with lot of data (10-20 terabyte), we want to move to linux. how should i do that?
Yeah I understand that this might not work but worth the try :) Just to understand - You stop winslave3 —> export structure,tables(1by1) from winslave3 —> import in linslave1 ...
ok ok so the only reason taking winslave3 off (stop slave) is to reduce load and make sure this node is safe?
i dump data like the following: FIELDS TERMINATED BY '~' ENCLOSED BY '' ESCAPED BY '' LINES TERMINATED BY '\n' but when i have string column that has '~' inside it the whole l...
Anyone has experience with percona xtrabackup?
Because charset might be diff?
i have table that looks like this ``` CREATE TABLE public.vendor_category ( vendor_category_id serial4 NOT NULL, vendor_id int4 NULL, category_id int4 NULL, vendor_catego...
i have a list of 800k id’s that I need to update a single column for each of them? what’s the best approach doing this? create 800k update statments and run them? update table...
I tried to run dump on my replica (running on GCP) but I got this error - mysqldump: Couldn't execute 'SHOW FIELDS FROM `view_active_opportunities`': SELECT command denied t...
my user is defined like this: GRANT all PRIVILEGES ON *.* TO 'lirany’@‘%’ I am unable to connect to this if my VPN is off - why is that if it’s defined with %??? PLEASE SEND ...
is there a way to make this delete in a procedure but delete in chunks? delete from tb_opportunity__allowed_feed_types where opportunity_id in (select opp_id from delete_m1_op...
Hi maybe someone can help me understand the log file? ***returned rows*** 2021-08-26 12:11:59.283 UCT [11831] LOG: execute S_1: BEGIN 2021-08-26 12:11:59.287 UCT [11831] LOG:...
I have mySQL 5.7 - is it possible to cache VIEW results?
how can I check if a query is causing a lock? and how can I kill other process/query to let me query run without locks?
does postgresql has sharding architecture like mongo’s sharding? or it only has postgres_fdw?
how can I get all the tables that their first column is “id”? i would like to add those PK
How can I know if query results came from cache/buffer pool or the query is being run and retrive data from disk?
I am having troubles partitioning with pg_partman. when creating partition all partition key needs to be part of the primary key, so if i partition by datetime my primary key ...
How can I know when a query was running by reading mysql slow log? Time: 2022-06-25T23:22:12.134584Z User@Host: user[user] @ [1.1.1.1] thread_id: 12631872 server_id: 34534534...
i have issue with one of my users - it has those privs = GRANT USAGE ON *.* TO 'noamc'@'%' + GRANT SELECT, INSERT, UPDATE ON `smallstage_grouponi_groupon`.`tb_orders_items_csa...