Search results

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...

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.

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...

<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...

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...

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...

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...

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

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+.

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...

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.

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.

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...

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...

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...

Not familiar with that mutator, but it might be the FatBoy mutator, but I think that makes your whole body swell up if you're doing good and shrink to skin and bones if you're doing bad. Wont be running that. Trying to keep it as close to vanilla game play as possible. Just deathmatch and...

5 days until this event kicks off. I'll be on all day, morning, day, evening and night. Just a reminder that it's probably a good idea to get the game downloaded, installed and connect to the server to make sure everything works before the day of. Juts in case something isn't right you'll...

Director of Call of Duty is who he is. Elon Musk made a claim that his AI can make a full blown game in a year. Glen called bullpoop.

Oh crap. Thats a lot of media! My metadata directory.

Not too shabby. I'm not sure how much media my Plex takes up. Let me check on that real quick. Safe to say I need to get my new server up and running soon. Almost out of space. Those are 2x 12TB drives mounted on that server. I have 6x 12TB drives that I intend to setup in my new server.