How do you import to SQL? What's the problem in iterating through JSON and adding fields that you need? Unless you are not writing a code yourself and using some tool that does it for you. P.S. I also have some questions then  In global JSON https://whattomine.com/coins.json, what hashrate is used for estimated_rewards/estimated_rewards24 (I assume these are based on current/24 diff)? And also why changing hr param in API call for particular coin is not changing estimated_rewards accordingly? E.g. for 10 MH/s it's 636 coins, but for 1000 MH/s it's 62102? 2.35% seems to be a huge rounding error. I hope estimated_rewards there is based on 24h average diff? Inconsistent field names  P.P.S. ?eth=true&factor[eth_hr]=50 works with global API, default hr must be from some presets... At least write an API docs with all the available params or using it is trial and error. At the moment I am using PowerShell to grab the JSON, works perfect. Where I run in to trouble is the SQL query to import the JSON file. Coins is the first property name, good, but there is no Coin Name property (the coin names are just listed), so the query blows up. Like I said I am a noob at this and possibly I need to manipulate the JSON and add the coin name property, but I am not sure how. Below is an example of the JSON, see how the coin name is not under a property? {
"coins": {
"Cannabiscoin": {
"id": 188,
"tag": "CANN",
"algorithm": "X11",
"block_time": "44.0",
"block_reward": 70,
"block_reward24": 70,
"last_block": 3030623,
"difficulty": 159943.13453935,
"difficulty24": 160679.297308647,
"nethash": 15612512092414,
"exchange_rate": 0.00000265,
"exchange_rate24": 0.00000240881924198251,
"exchange_rate_vol": 1.78501334098998,
"exchange_rate_curr": "BTC",
"market_cap": "$2,845,033.74",
"estimated_rewards": "298.68986",
"estimated_rewards24": "297.32436",
"btc_revenue": "0.00079153",
"btc_revenue24": "0.00078791",
"profitability": 115,
"profitability24": 114,
"lagging": false,
"timestamp": 1531882963
} |
|
|
|
Hello, super noob SQL import question. I'd like to import the JSON output in to SQL, but I am struggling with the structure. I can select "coins", but none of the other headers seems available. Anyone done this that might have tips or pointers? Edit to be a bit more clear.I am struggling with the structure of the JSON output. Coins is declared as the top level, but then it gets tough to find the fields and headers so I can properly import them in to columns. Coinwarz is easy to import, but your data and site is MUCH better Is this just the state of things or am I not referencing the JSON correctly? As a reference https://www.coinwarz.com/content/images/profitability-api-output.png |
|
|
|
hi anyone can help....
my miner have a problem,
on the SYSTEM
CGMiner Version : Unknow(waiting cgminer to start)
i have restart and reboot still same, what should i do ?
should i upgrade firmware ? and how to upgrade firmware on M3 ?
My M3s would do that every so often when the pool was misconfigured. Go to the main page and restart cgminer a couple of times if you are sure your pool info is right. Also, it can take several minutes for an M3 to get going so I'd walk away for 15 min or so then check. |
|
|
|
Nothing You're good, I thought you might have been thinking you actually had 4 circuits and were going to try to run 4 miners! But you got it! |
|
|
|
Yes I have one 12-2 wire with the black wire connected to one 110v leg and a 20 amp fuse and then the red wire connected to the other 110v leg and another 20 amp fuse. This is connected to a dual 20 amp outlet.
I just want to make sure you understand that you will need to replace that outlet with a single outlet, you do not have 2x 220v outlets. You've got 1 220v or 2 110v |
|
|
|
Yes one 12-2 wire run from the panel to a dual outlet. So I’m limited to 2 miners per lead. Thanks for the response, much appreciated!
Hold up, you're using 220v so both wires carry current. If you physically only have one piece of wire that is 2 conductor 12 gauge then you need to change the outlet to a single as you have a SINGLE 220v 20A circuit. Previously you had 2 110v 20A outlets |
|
|
|
Hello people,
I am installing miners at work with a few colleagues. We got 5 miners.
we install the computers in a self-made closet made of wood. We can't have to much noise in the building because of the work we do.
So my question is does anybody know the best way to mute the noise and letting the heat escape?
I'm new on this forum and I'm in for all advice.
thanks for the comments!
I'm continually amazed at how people spend so much money with zero thought. Did you even read anything here? Have you read anything since making your account and this post? Anyway, what "miners" do you have? GPU, ASIC, what? |
|
|
|
|
You want to run no more than 80% continuous capacity on each circuit. So if the circuits are 20A then no more than 16A continuous each. So 2 Antminers per. Are you saying each outlet has a separate wire run? Or are you saying 2 outlets using one run of 12-2 wire? If it's the latter then you're limited to 2 miners period. If it's one run of 12-2 wire to each outlet then 2 per or 4 total if you have 2 circuits.
|
|
|
|
|
Sigh, it has been moved, which I believe is a mistake...
|
|
|
|
At this time still pure fundraising PR as on-chip photonics is still a long ways out. As expected they hold up the Evil Bitmain as their reason, despite the fact that there are several sha256d miner makers with the #2 being Canaan with their Avalon series. More to the point regarding this area, they are talking about making an alternative to the sha256 PoW algo aka BTC and as such this becomes an altcoin discussion and should be moved to the altcoin areas. I think it's too soon to call this an altcoin discussion. Because this is a speculation area, the speculation could be argued that BTC's algo could possibly change. BTC core devs have already spoken out against Bitmain's dominance and as much as we all would like companies like Canaan to break that, the sad fact is Bitmain has a firm grip on BTC global hashrate. |
|
|
|
I find this hashrate and electrical consumption asterisk curious. * It could operate as the same conditions as GMO miner B2.
And then on the B3 page there's this. Operating Environment
Temperature: 0°C to 30°C
Humidity: 30% to 80% RH, prevent condensation
Altitude: Below 2,000m
|
|
|
|
I think Cloudflare had an issue, no bitcointalk, tried bitmain, and Kano.
They're all back now.
I don't use cloudflare - all web access is direct to the web server. As I mentioned on discord, there has been a (very slow) botnet doing password guessing for the last few hours - but each bot's IP gets banned VERY quickly. So unless your IP has a virus and is trying to guess passwords - I doubt that's the problem either. There was a 10-15 PH drop in mining (no specific large user) for quite a few hours earlier today, then it came back for 2 hours then jumped up and down again for an hour - but seems to be back again now. So there may be some general internet connectivity problems somewhere that's affecting miners. The mining servers haven't been showing any obvious drops in SPS other than the DE server (but not a drop to zero - just lower) Interesting, it looked like some kind of DNS issue as I was getting name resolution errors, (I use Google's DNS servers)but only for specific websites. Weird. Looked at my miner's hashrate and they never had issues. Odd indeed. |
|
|
|
|
I think Cloudflare had an issue, no bitcointalk, tried bitmain, and Kano.
They're all back now.
|
|
|
|
People are in denial if they don't include all charges... My last elec bill was $968.89 total with 11778 kWh used, delivery charge, and tax. That comes out to 0.082/kWh cost. Straight copy and paste from bill. Energy Charge 11,778 kWh @ $0.045000/kWh 530.01
Electric Delivery Charges 410.50
Gross Receipts Tax Reimbursement 18.78
Sales Tax 1.00% 9.60
Current Charges $968.89
|
|
|
|
Guys I have a $420.00 Bitmain coupon that sadly I am not going to be able to use.
So Kano users get 1st shot, I paid 100$ for it I will take $100 for it. No problem to use escrow.
Coupon has been sold to a Kano member who put it to good use |
|
|
|
|
Guys I have a $420.00 Bitmain coupon that sadly I am not going to be able to use.
So Kano users get 1st shot, I paid 100$ for it I will take $100 for it. No problem to use escrow.
|
|
|
|
How you like dem squeezes
It hurts for sure! Ever searching to improve efficiencey, I've been able to reclaim a large amount of wattage by improving the airflow in my mining room/garage. I noticed during the heat of the day my S9's with APW3++ were using 1533W each, and my M3's were using 2300W each!! Getting the room cooled down the S9s dropped to 1366W each, and the M3s have dropped down to 21-2200W. I am going to have to sell the M3s. I don't want to because they are solid, but I need to accept the reality. I have all the miners ducted which helps, but I have a GPU rig as well, plus just the radiated heat is keeping the room 4-5* above ambient. I installed a 3000 CFM exhaust fan that has helped quite a bit. It's 102*F today I'll let it go for a few more days to get a good idea on the overall effect. |
|
|
|
If you are looking for a high number of breakers the geist metered PDUs can support 6x 20 amp breakers for 2 miners each at 240V, so up to 12 miners per PDU.
It's funny I just started looking at these guys for our data center at work. They have great prices and are super configurable. Never occurred to me to look at them for my ASICs |
|
|
|
well I may be considered by some to be a rich (wet) pussy but I think my DIY skills are above average.
Anybody else care to comment on the electrical code conformity of the aforementioned wiring technique ?
OK, call me a pussy (nobody's ever called me rich...), but I prefer my house to not burn down, I also prefer cleaner wiring, and peace of mind. The challenge with PDUs is finding low outlet count higher breaker PDUs. Most will have many outlets, but very low on-board breakers which is just the opposite of what ASICs need. Here's some info from philipma1957 that has helped me out a lot. I have found a couple of these on eBay for cheap. Hp makes a four socket pdu for 30 amp circuits
Runs 4 s9s with ease.
I get them on eBay for 35-50 dollars.
Hp 228481-002
|
|
|
|
|
Show Posts
