Categories
Database Development

Methods for tracking processing time for long running ADD INDEX call in MySQL

I’ve set off index creation on a very large table in MySQL and while I expected it to take a long time, I’m 5 days in and wondering if there’s any way to debug potential issues or simply let it run. I don’t have a precise row count but to estimate, it’s in the 100s […]

Categories
Mastering Development

Iterate over two list and set element from first list

I have two ArrayList as below – certificates=[CERT1, CERT2] promotions=[{type}, {type, promotionCode}, {type, promotionCode}] promotions list size is not confirm but certificates list size is confirmed. So consider first list size is 2 and second list size is 3 I want to set promotionCode in second list from certificates but in second list some time […]

Categories
Mastering Development

Python multiprocessing, ThreadPool. ThreadPool stops at the end

I wrote a script that “parses” all domains from the file. After the launch, everything works as it should. But when there are several domains left at the end, it gets stuck. Sometimes it takes a long time to parse the last couple of domains. I can’t figure out what the problem is. Who has […]

Categories
User Help

I would like a simpler Excel formula for a searching three sets of cells that produce one of two results

I have 3 columns of a larger array – Old-names, Type, New-names. . Each Old-name is unique. A search for Old-name is expected to succeed. . Rows can be re-sorted but these three cells must remain in the same row. . Columns may be rearranged. This array is the master array and is searched from […]

Categories
Database Development

Update large number of row in MySQL table

I’m using relational database(MySQL 5.7). On this database i have a table called customer_transaction. On this table i have 4 columns: id, customer_id, type, amount |id|customer_id |type |amount| |–|————|———|——| |1 |44 |Credit |50 | |2 |44 |Credit |20 | |3 |44 |Debit |30 | |4 |10 |Credit |30 | now i am introduce a new […]

Categories
Mastering Development

Count distinct dates if 2 additional criteria is met

I have 5 columns: Quarter, Item, Type, Count, Date I am trying to pull a UNIQUE count of date for each Quarter & Item combination ie. FY20Q3-AU has 2 different dates, FW20Q3-GLW has 1 unique date, FY20Q3-GLE also has only 1 unique date Does anyone have any idea how I can accomplish this? I have […]

Categories
Mastering Development

Tidying up after unhandled exception in Python asyncio task

In a python aysncio application comprising multiple tasks, what is the correct way to report an unhandled exception in one of the tasks then exit the application? I have looked at several related questions, this one in particular: How to shutdown the loop and print error if coroutine raised an exception with asyncio? … but […]

Categories
Database Development

How to determine or predict space on disk per table row? [duplicate]

I’m very new to Postgres so my math could be off here … This is my table: CREATE TABLE audit ( id BIGSERIAL PRIMARY KEY, content_id VARCHAR (50) NULL, type VARCHAR (100) NOT NULL, size bigint NOT NULL, timestamp1 timestamp NOT NULL DEFAULT NOW(), timestamp2 timestamp NOT NULL DEFAULT NOW() ); I want to make […]

Categories
Cryptocurrency Ethereum Mastering Development

How to determine the uniqueness of an internal transaction

How to determine the uniqueness of an internal transaction Example is this transaction: https://rinkeby.etherscan.io/tx/0xc756517a69239bddffe3e0cb07eba98d3ad0fae1b44fc936a0119dbaf7008942#internal they are exact identical of each other (including tx-hash, type, traceId), and I need a way to differentiate those transactions to know if I’ve already processed the transaction or not. I’m using etherscan.io to detect internal transactions by iterating block by […]

Categories
Database Development

How to determine how much space 1 row will take in postgres db?

I’m very new to postgres so my math could be off here… This is my table: CREATE TABLE audit ( id BIGSERIAL PRIMARY KEY, content_id VARCHAR (50) NULL, type VARCHAR (50) NOT NULL, size bigint NOT NULL, timestamp1 timestamp NOT NULL DEFAULT NOW(), timestamp2 timestamp NOT NULL DEFAULT NOW()); I want to make some estimations […]