Bitcoin Forum
May 26, 2024, 05:09:05 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
  Home Help Search Login Register More  
  Show Posts
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 [37] 38 39 40 41 42 43 44 45 46 47 48 49 50 51 »
721  Bitcoin / Pools / Re: [5gh/s]Bitcoinmonkey.com(3BTC Bonus for current block, no fees, API, LP, Full 8) on: August 28, 2011, 09:34:42 PM
Bad news:  We are currently shut down for maintenance.  Website is up (edit: down right now), but pushpoold is down, meaning you can't get or submit work.

Good news:  We found a block and you *will* get paid.
722  Bitcoin / Project Development / Re: Cheaper In Bitcoins [Target beta date: September 1st] on: August 23, 2011, 10:10:44 PM
Keep the baht symbol, it's the best thing we have.
723  Bitcoin / Pools / Re: NameCoin Mining pool Open for the Brave [20+ GHs] on: August 23, 2011, 04:20:45 PM
Because MySQL is a single threaded system try not to hammer the system with queries until I get it fixed.
Huh?  MySQL is multi threaded.  It takes up all 8 cores on our server.  I think you may have an installation problem.  I saw you bashed MySQL a couple times saying that it can't handle the load of large databases and that you were looking for something other than free.  There are 10TB+ MySQL databases on huge NetApp systems with tons of processors in front that scream!
724  Bitcoin / Pools / Re: NameCoin Mining pool Open for the Brave [20+ GHs] on: August 19, 2011, 01:25:03 AM
Yes I have and I will be providing merge mining 1 month before it's actually available but taking huge loses, effectively buying the miners.  But there are MANY hurdles, currently my script is WAY to slow as it is.  Second the free version of MySQL can not handle the kind of load Deepbit has in shares.  3rd this means I must scale back on the features I would have wanted to add.  I will sacrifice the namecoin client and maybe the affiliate program.

The code is a mess it does to many slow queries on data that can be static!  Like the previous round, all it's data is collected from the shares the don't change!!!  CRAZY.
Once our pool got above about a couple million shares I had to do major database tweaking.  The 3 things that helped the most were COUNT(*) instead of mysql_num_rows, indexing the columns in a table that get the most action based on the statements after a SELECT - WHERE xxx, and then trying to fit the whole database in RAM with huge buffer pools.  mySQL locks a table from read and write if you try to add an index, but there is a tool to do it without any disruption in service called oak online alter table.  I did a million other tweaks to my ext4 mount options, php code and to mySQL variables that all add up too, but that would take a novel to explain.

Thanks man you are a life saver I was wondering about taking the system down to do some alters.   I'll check out oak as for buffer pools how do I do that?

You put the db on an ext4 drive?  Why what tweaks can you do to a filesystem?  Give me a few more hints and I'll send you a bitcoin.
This is one of the guides I used for tweaking mySQL - http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/.  I'll save you the hours of tuning options and restarting mysql and tell you that innodb_buffer_pool_size is the only variable that made a difference and right now we have it set to 75% of our server's RAM.  This assumes you have your main shares table as innodb, which most of us do.

I didn't choose ext4 for the database, and I understand there are some other filesystems that may be better for raw mysql performance.  I think XFS is arguably better.  Anyway, changed mount options in fstab to "commit=60" and "noatime" to reduce the overhead on write operations.  This frees up the drive for more iops for mysql if it has to go to disk.  This reduced my await times by a lot.
725  Bitcoin / Pools / Re: NameCoin Mining pool Open for the Brave [20+ GHs] on: August 18, 2011, 11:13:13 PM
Yes I have and I will be providing merge mining 1 month before it's actually available but taking huge loses, effectively buying the miners.  But there are MANY hurdles, currently my script is WAY to slow as it is.  Second the free version of MySQL can not handle the kind of load Deepbit has in shares.  3rd this means I must scale back on the features I would have wanted to add.  I will sacrifice the namecoin client and maybe the affiliate program.

The code is a mess it does to many slow queries on data that can be static!  Like the previous round, all it's data is collected from the shares the don't change!!!  CRAZY.
Once our pool got above about a couple million shares I had to do major database tweaking.  The 3 things that helped the most were COUNT(*) instead of mysql_num_rows, indexing the columns in a table that get the most action based on the statements after a SELECT - WHERE xxx, and then trying to fit the whole database in RAM with huge buffer pools.  mySQL locks a table from read and write if you try to add an index, but there is a tool to do it without any disruption in service called oak online alter table.  I did a million other tweaks to my ext4 mount options, php code and to mySQL variables that all add up too, but that would take a novel to explain.
726  Bitcoin / Mining / Re: [GUIDE] How to prevent 100% CPU usage in Windows when mining on: August 18, 2011, 10:48:33 PM
GUIMiner has this feature built in and it saves your settings so you never have to do anything manually again.
727  Alternate cryptocurrencies / Altcoin Discussion / Re: I0 Guild - I0Coin Pool from BTC Guild on: August 18, 2011, 10:41:33 PM
I like how now the logo changes to lolcoin and trollcoin randomly hehe


728  Bitcoin / Pools / Re: [5gh/s]Bitcoinmonkey.com(3BTC Bonus for current block, no fees, API, LP, Full 8) on: August 18, 2011, 04:16:11 PM
Well this sucks.
729  Bitcoin / Project Development / Re: [Hack-A-Thon: In-Progress] Hack my site (Server Back up) on: August 18, 2011, 04:28:39 AM
While in any category, such as "http://www.cheaperinbitcoins.com/showcategory.php?cateId=25", the "Grid" and "List" icon links are broken.

Grid:
Code:
Not Found

The requested URL /listing_4.html was not found on this server.

Apache/2.2.14 (Ubuntu) Server at www.cheaperinbitcoins.com Port 80

List:
Code:
Not Found

The requested URL /listing_3.html was not found on this server.

Apache/2.2.14 (Ubuntu) Server at www.cheaperinbitcoins.com Port 80

Sitemap link is 404 also.
730  Bitcoin / Project Development / Re: [Hack-A-Thon: In-Progress] Hack my site (Server Back up) on: August 18, 2011, 04:22:56 AM
Chrome 14.0.835.35.  Item title goes behind BTC price.  I believe the offending div is "s_item_clearfix".  Repeats on many other items.




Are you looking for layout quirks like that also, or only security holes?
731  Bitcoin / Bitcoin Discussion / Re: Are you using the binaries from sourceforge or did you compile Bitcoin yourself? on: August 17, 2011, 11:35:24 PM
I compiled the QT version and it was easy peasy.
+1 I really like the bitcoin-qt project.
732  Economy / Speculation / Re: Quick math question. on: August 12, 2011, 01:08:54 AM
What's funny is I have been using the dang Windows calculator do this for weeks and I have been wondering: "I wonder if someone has made an online app for this?"  Prayer answered!  Thank you sir
733  Bitcoin / Bitcoin Discussion / Re: Bitcoin Nodes on 3D Globe on: August 11, 2011, 09:44:22 PM
Whoah, this is awesome!  Who's got the big ass node in the middle of the US?
734  Alternate cryptocurrencies / Announcements (Altcoins) / Re: [ANNOUNCE] Ixcoin - a new Bitcoin fork on: August 11, 2011, 04:26:40 PM
This is a cool project.  It has exploded like no other thing I've seen on these forums.  Well, besides the 150 page thread for a pool hopping script.
735  Bitcoin / Wallet software / Re: Bitcoin-Qt, the future Bitcoin client GUI [user input needed] on: August 10, 2011, 06:56:25 PM
Cool beans
736  Other / Beginners & Help / Re: Best bitcoin "Craiglist" alternative? on: August 10, 2011, 04:03:11 AM
Did you check out BitcoinHarbor?
737  Economy / Trading Discussion / Re: Transit time of a BTC on: August 10, 2011, 04:01:22 AM
I transferred 0.1 BTC with no transaction fee from my Windows box to my Ubuntu box.  Took about a half second...plus a few hours for the confirms to go through.
738  Economy / Trading Discussion / Re: [ANNOUNCE] BTC Trader - opensource live charting and tech-analysis application on: August 10, 2011, 03:53:55 AM
I keep losing the feed in BTC Trader also.  Is this a Chartsy problem or the customizations done to it?  We want to see a new version!
739  Bitcoin / Bitcoin Discussion / Re: [EDITORIAL] Don't Count on Bitcoin for Safe Haven in Recessionary Economy on: August 10, 2011, 02:40:41 AM
I love Daily Tech, but you can't pay much attention to the stories Jason Mick publishes.
740  Bitcoin / Bitcoin Discussion / Re: Bitcoin Harbor 2.0 on: August 09, 2011, 11:20:19 PM
Might want to stop advertising MyBitcoin on the Buying 101 page  Wink
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 [37] 38 39 40 41 42 43 44 45 46 47 48 49 50 51 »
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!