Search results

  1. Skillz

    Yet Another Sapphire Nitro+ 9070XT Becomes Victim of Burnt 12V-2×6 Power Connector

    They need to just start shipping those high end GPUs with mini nuclear reactors in them. No more melting of connectors then. ...notice I didn't say no more melting cleanly. LOL
  2. Skillz

    Which DOS games do you remember playing in the 90s?

    I don't recall ever playing any DOS games. By the time I got a PC towards the end of 1999, the only game I played was mostly just Unreal Tournament.
  3. Skillz

    Weekly DC Stats - TeAm AnandTech edition

    Thanks for the stats. I should note that I am working on getting FAH back on Free-DC. ;)
  4. Skillz

    Reaction Score on posts

    Can we get the reaction score to show under the post count? I'd venture to say it can just replace points with reaction score, since the points maxes out and isn't really a good indicator of anything, unless their are future plans to add more trophies users can earn.
  5. Skillz

    The 10 Most Influential CPUs of All Time

    Let's see that keychain. Even the Wiki says the Pentium was launched in March of 1993.
  6. Skillz

    Database design optimization - MariaDB (MySQL)

    It means the user wishes to remain anonymous.
  7. Skillz

    Database design optimization - MariaDB (MySQL)

    The merged data is the total BOINC credits across all the projects. Having the application do this, on the fly every time totaling all these will just move the computation to the web server which would then definitely get overwhelmed with the number of bots that have grown exponentially over the...
  8. Skillz

    Database design optimization - MariaDB (MySQL)

    I'm not, todays total gets moved to the "yesterdays" column at the end of the day. The only thing that gets updated is the current update. That gets added to the todays total. The historical data doesn't get updated, it just gets moved to the appropriate location. IE: Todays total gets moved to...
  9. Skillz

    Database design optimization - MariaDB (MySQL)

    MariaDB (and most other database engines) can already run multiple parallel jobs concurrently without a problem. My dual database design already solves the biggest problem with tables being locked during updates. While that database has its tables locked for updates, the other database is free...
  10. Skillz

    Database design optimization - MariaDB (MySQL)

    Correct. That is how I get the totals for the current update, the days total, yesterdays total, week total, etc... This is done for each user, host and team.
  11. Skillz

    Database design optimization - MariaDB (MySQL)

    Not sure how that would help. There are already two databases that flip/flop depending on what its doing. While one database is being updated, the other one is being read from the web server. When the update is complete, the flip. The one that just got updated is now being read from the web...
  12. Skillz

    Database design optimization - MariaDB (MySQL)

    <id>1</id> The Project ID for this user at this specific project <name>S C</name> The users name <country>Sweden</country> The country they selected <create_time>1483633404</create_time> The date they created this account <total_credit>72451572.864025</total_credit> The total credits they...
  13. Skillz

    Database design optimization - MariaDB (MySQL)

    Yes and no. Each project does have it's own update frequencies and times, but I don't necessarily follow them. The download script just runs in a continuous loop. It runs through checking all the projects files to see if they've been changed since the last check, if different, it downloads...
  14. Skillz

    Database design optimization - MariaDB (MySQL)

    Yes, that is the latest files that was updated. I think Amicable numbers updates around 4 times a day. Every time those files get updated, my stats collection system downloads the file. Extracts it. Moves it to a /stat/project directory, over writes the previous one, then the system processes...
  15. Skillz

    Database design optimization - MariaDB (MySQL)

    Stats folder? If its the folder containing the XML files, then no. Nothing gets added or subtracted from this. This is what the system utilizes to populate/update the database. Those files just don't get deleted I keep the latest copy on the server at all times. When a new/updated version of...
  16. Skillz

    Database design optimization - MariaDB (MySQL)

    You can find most all the active projects here: https://www.boincgames.com/marathons.php
  17. Skillz

    Database design optimization - MariaDB (MySQL)

    I sent you a PM with it. Its the same as MySQL. You just use the --no-data flag with the mysqldump command. Which I gave you in a PM to download. Its tiny, less than 1MB lol Much better than 65GB+.
  18. Skillz

    Database design optimization - MariaDB (MySQL)

    Oh I need to wait on my reply. You keep editing your post when I reply. HAHA! Doing a myslqdump of one of the databases will be over 65GB in size. That's not really feasible for me to upload that anywhere. So what are you asking for specifically? The database structure without all the data? As...
  19. Skillz

    Database design optimization - MariaDB (MySQL)

    Not sure what you are asking here, so I had to ask AI again. Haha. And I'm still a little lost on what this means. Let me read it over a few more times, maybe it'll get it. Give me a few minutes to figure this out please.
  20. Skillz

    Database design optimization - MariaDB (MySQL)

    Yes it uses Indexes, another reply from AI to help me answer you properly. I do read what it says and try to make sense of it to make sure it's actually telling the right things and from what I can tell, it is correct.
Become a Patron!
Back
Top