quattro
Member
Offline
Activity: 67
Merit: 10
|
|
December 29, 2013, 08:51:03 PM |
|
There are still issues, showing cloudflare for the website here ... I appreciate your efforts, but this is really unacceptable given the amount of fees that are collected.
|
PM me if you need hosting for your FPGA or ASIC miner. Secure, air conditioned facility... will beat competitor pricing. Over 15 years in the hosting industry.
|
|
|
stevegee58
Legendary
Offline
Activity: 916
Merit: 1003
|
|
December 29, 2013, 08:52:17 PM |
|
I seem to still be mining on BTC Guild but the web site appears to still be down.
|
You are in a maze of twisty little passages, all alike.
|
|
|
eleuthria (OP)
Legendary
Offline
Activity: 1750
Merit: 1007
|
|
December 29, 2013, 09:00:24 PM |
|
The joy of errors that can't be reproduced in a test environment. Going to be spending the rest of the day staring at scripts and turning them on one by one. Website will be back in a few minutes once I confirm we didn't have another repeat of the multiple block payout.
|
RIP BTC Guild, April 2011 - June 2015
|
|
|
mdude77
Legendary
Offline
Activity: 1540
Merit: 1001
|
|
December 29, 2013, 09:05:17 PM |
|
There are still issues, showing cloudflare for the website here ... I appreciate your efforts, but this is really unacceptable given the amount of fees that are collected.
Maybe a little patience is in order? El is as good as they good for pool ops. M
|
I mine at Kano's Pool because it pays the best and is completely transparent! Come join me!
|
|
|
Ridicuss
|
|
December 29, 2013, 09:10:18 PM |
|
There are still issues, showing cloudflare for the website here ... I appreciate your efforts, but this is really unacceptable given the amount of fees that are collected.
Maybe a little patience is in order? El is as good as they good for pool ops. M Agreed!
|
Man, I wish I could change my avatar!
|
|
|
eleuthria (OP)
Legendary
Offline
Activity: 1750
Merit: 1007
|
|
December 29, 2013, 09:14:21 PM Last edit: December 29, 2013, 09:30:38 PM by eleuthria |
|
Mining is confirmed to still be operational. Future fixes should not require any additional restarts of the mining server. Unless something goes wrong, the only thing that will have intermittent service is the website itself. Shutting off the website provides a SIGNIFICANT boost to how fast operations can be done on the database, mostly because the website is essentially under 24/7 attack these days so there is a lot of database load all the time.
UPDATE: Problem has definitely been found, now working on fixing it. Pool servers are still online and functional, just keeping the website off a little bit longer.
|
RIP BTC Guild, April 2011 - June 2015
|
|
|
centove
|
|
December 29, 2013, 09:33:06 PM |
|
Mining is confirmed to still be operational. Future fixes should not require any additional restarts of the mining server. Unless something goes wrong, the only thing that will have intermittent service is the website itself. Shutting off the website provides a SIGNIFICANT boost to how fast operations can be done on the database, mostly because the website is essentially under 24/7 attack these days so there is a lot of database load all the time.
UPDATE: Problem has definitely been found, now working on fixing it. Pool servers are still online and functional, just keeping the website off a little bit longer.
WAAAAA I can't obsessively click on the dashboard to watch my stats!!!
|
|
|
|
eleuthria (OP)
Legendary
Offline
Activity: 1750
Merit: 1007
|
|
December 29, 2013, 09:41:57 PM |
|
Mining is confirmed to still be operational. Future fixes should not require any additional restarts of the mining server. Unless something goes wrong, the only thing that will have intermittent service is the website itself. Shutting off the website provides a SIGNIFICANT boost to how fast operations can be done on the database, mostly because the website is essentially under 24/7 attack these days so there is a lot of database load all the time.
UPDATE: Problem has definitely been found, now working on fixing it. Pool servers are still online and functional, just keeping the website off a little bit longer.
WAAAAA I can't obsessively click on the dashboard to watch my stats!!! The API is still running during the website maintenance/update, just an FYI.
|
RIP BTC Guild, April 2011 - June 2015
|
|
|
BrandonMcPherson
|
|
December 29, 2013, 10:45:48 PM |
|
Looks like I picked the right weekend to have to RMA my Cube.
GL getting everything stabilized, eleuthria, and thanks for the excellent communication.
|
|
|
|
Xian01
Legendary
Offline
Activity: 1652
Merit: 1067
Christian Antkow
|
|
December 29, 2013, 10:52:08 PM |
|
Feels surreal needing to mine out a deficit * Xian01 returns to starting at stats and graphs
|
|
|
|
mdopro1
|
|
December 29, 2013, 10:57:56 PM |
|
My KNCMiner is on a circuit that's loaded nearly 100% of it's capacity but today my breaker tripped as the website was down, other miners fans spun down and KNCMiner overloaded the circuit. Drove to work to fix the problem, couldn't connect to the pool after that. Now mining at backup pool.
|
New Bitcoin fund doubling platform has launched! Receive Automated Payment Every 2 Hours Appealing alternative with Sophisticated algorithms. https://Btc-Funds.com
|
|
|
Ridicuss
|
|
December 29, 2013, 10:58:05 PM |
|
Feels surreal needing to mine out a deficit * Xian01 returns to starting at stats and graphs I'm with you Brother! I'm almost out of the negative now.
|
Man, I wish I could change my avatar!
|
|
|
Ridicuss
|
|
December 29, 2013, 11:00:02 PM |
|
My KNCMiner is on a circuit that's loaded nearly 100% of it's capacity but today my breaker tripped as the website was down, other miners fans spun down and KNCMiner overloaded the circuit. Drove to work to fix the problem, couldn't connect to the pool after that. Now mining at backup pool.
I really haven't had any trouble mining, just could not see web page. Been submitting shares all day. Currently connected and all looks well for me.
|
Man, I wish I could change my avatar!
|
|
|
eleuthria (OP)
Legendary
Offline
Activity: 1750
Merit: 1007
|
|
December 29, 2013, 11:04:17 PM Last edit: December 29, 2013, 11:23:51 PM by eleuthria |
|
Alright, everything has been running smooth for about 30 minutes now. I think I've killed off all the offending queries, and there's some extra work being done in the background to hopefully prevent it from happening again.
== Below This Line May Be Useless If You're Not Familiar with Databases ==
The problem stemmed from a JOIN based query used in looking up PPLNS Stats. This query was not a problem until just recently, and was caused by the growth of the pool making the result set from this query become too large for a memory table. As a result, the query was forcing the result set to be written to a temporary disk based table. This query executes a LOT, and it's unique per user because it's the query which displays a user's stats for recent shifts on both the Dashboard and PPLNS Stats page. This ended up causing table deadlocks if too many instances were accessing the table at once.
It took a while to diagnose because I was operating under the assumption the writes to that table were causing it (block rewards, shifts being closed, etc). However, in this case it was the reads causing the root problem. The writes were just the catalyst to cause the eventual table deadlock.
Once I confirmed the specific queries that were causing it, I was able to get in and rewrite those queries to use smaller result sets and multiple queries, rather than a single query to get all of the data at once.
== End Technical Explanation ==
So far it's looking great, but I'm leaving the monitors up for the rest of the day to check for any abnormally long queries, so hopefully if it is not fully fixed, I will be able to pause the website again before it creates an actual deadlock. I'm also adding a new external alarm to set off my phone if a similar error happens in the future, since this particular failure did not trigger any of the already existing alarms.
|
RIP BTC Guild, April 2011 - June 2015
|
|
|
eleuthria (OP)
Legendary
Offline
Activity: 1750
Merit: 1007
|
|
December 29, 2013, 11:05:44 PM |
|
My KNCMiner is on a circuit that's loaded nearly 100% of it's capacity but today my breaker tripped as the website was down, other miners fans spun down and KNCMiner overloaded the circuit. Drove to work to fix the problem, couldn't connect to the pool after that. Now mining at backup pool.
The EU filtering server was suffering during the outages. This was fixed shortly after the website was restored. As of this post, all servers (including the DDoS/Botnet filters) are running optimally.
|
RIP BTC Guild, April 2011 - June 2015
|
|
|
Icon
|
|
December 30, 2013, 03:54:02 AM |
|
at BTCGuild i get best payoff for my hasing power. not sure why, but it beats other pools.
good fee rate I would disagree only on this one. I find the 3% fee disproportionately high to what the pool offers. And the higher the hashrate you have the more disproportionate it is. For someone who is making 1BTC a month that might be OK, but for people who mine 100BTC monthly I see no real reason why this service should cost them 3BTC. Pool luck is irrelevant as it is in no way controlled by the owner, so please do not use it as a reason to justify the fee. Does anyone know of any other btc mining pool that does pay for orphan blocks and transfer fees back to the miners? Just asking. Icon
|
|
|
|
eleuthria (OP)
Legendary
Offline
Activity: 1750
Merit: 1007
|
|
December 30, 2013, 04:16:37 AM Last edit: December 30, 2013, 04:52:09 AM by eleuthria |
|
at BTCGuild i get best payoff for my hasing power. not sure why, but it beats other pools.
good fee rate I would disagree only on this one. I find the 3% fee disproportionately high to what the pool offers. And the higher the hashrate you have the more disproportionate it is. For someone who is making 1BTC a month that might be OK, but for people who mine 100BTC monthly I see no real reason why this service should cost them 3BTC. Pool luck is irrelevant as it is in no way controlled by the owner, so please do not use it as a reason to justify the fee. Does anyone know of any other btc mining pool that does pay for orphan blocks and transfer fees back to the miners? Just asking. Icon Only Deepbit (3% prop) and BitMinter (if you pay at least a 2.5% fee). If you want the same features, BitMinter is the same fee (Orphans+Idle Warnings require a 2% "donation" on top of the 1% fee). Slush is effectively higher fee (orphaned blocks + namecoins are worth much more than the 1% fee difference). Leaving you with Eligius and GHash.io as your only alternatives if you don't want to deal with extremely small pools. EDIT: Forgot Deepbit doesn't pay transaction fees.
|
RIP BTC Guild, April 2011 - June 2015
|
|
|
Ren13B
Newbie
Offline
Activity: 48
Merit: 0
|
|
December 30, 2013, 11:16:22 PM |
|
Anyone know if it is possible to get or calculate the PPLNS Pool Luck via the API?
|
|
|
|
CYPER
|
|
December 30, 2013, 11:31:02 PM |
|
at BTCGuild i get best payoff for my hasing power. not sure why, but it beats other pools.
good fee rate I would disagree only on this one. I find the 3% fee disproportionately high to what the pool offers. And the higher the hashrate you have the more disproportionate it is. For someone who is making 1BTC a month that might be OK, but for people who mine 100BTC monthly I see no real reason why this service should cost them 3BTC. Pool luck is irrelevant as it is in no way controlled by the owner, so please do not use it as a reason to justify the fee. Does anyone know of any other btc mining pool that does pay for orphan blocks and transfer fees back to the miners? Just asking. Icon Only Deepbit (3% prop) and BitMinter (if you pay at least a 2.5% fee). If you want the same features, BitMinter is the same fee (Orphans+Idle Warnings require a 2% "donation" on top of the 1% fee). Slush is effectively higher fee (orphaned blocks + namecoins are worth much more than the 1% fee difference). Leaving you with Eligius and GHash.io as your only alternatives if you don't want to deal with extremely small pools. EDIT: Forgot Deepbit doesn't pay transaction fees. I don't think the main idea behind the 1.5% perk is to get paid for the orphaned block. If it was nobody would have paid the fee because for the last 1600 blocks there were only 3 orphaned. That's only 0.1875% I know I don't pay it, because I am OK with waiting 120 confirmations for a new block.
|
|
|
|
CYPER
|
|
December 30, 2013, 11:33:48 PM |
|
Anyone know if it is possible to get or calculate the PPLNS Pool Luck via the API?
I spoke with eleuthria and the local math wizard organofcorti and they both confirmed there is no easy way to precisely confirm the pool luck, which is a deal braker for me. I guess it is just a psychological barrier for me to join a pool, where I cannot verify one of the main factors that determine how much I earn.
|
|
|
|
|