Search results

  1. 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.
  2. 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.
  3. Skillz

    Database design optimization - MariaDB (MySQL)

    It means the user wishes to remain anonymous.
  4. 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...
  5. 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...
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. Skillz

    Database design optimization - MariaDB (MySQL)

    You can find most all the active projects here: https://www.boincgames.com/marathons.php
  14. 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+.
  15. 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...
  16. 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.
  17. 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.
  18. Skillz

    Database design optimization - MariaDB (MySQL)

    The download process takes longer than 15 minutes. I'm not sure on the actual time, but it checks all the projects. If the project files are changed/altered since the last check, it downloads the files. If its not, it goes to the next one. This gives users who, like me, check their stats...
  19. Skillz

    Database design optimization - MariaDB (MySQL)

    I don't have the level of knowledge on this to answer your questions, but AI has helped me a lot with this setup. Specifically with converting the php files to work with PHP 7+ as it was all coded for PHH5 and wouldnt work in 7. It also tried to help me speed up the process by changing the table...
  20. Skillz

    Database design optimization - MariaDB (MySQL)

    It adds up all the BOINC credits for the user and then ranks them based on others scores. Running three databases is faster. While one is being updated the other one is being read by the web server. Then it flips when the update process is completed. This ensures the database being updated...
Become a Patron!
Back
Top