Recalculating because the numbers got changed to 45 now!
Odds of matching 5: Prize is 1 million dollars and shiny volanian 1 in 1,221,759
Odds of matching 4: Prize is 1 thousand dollars and normal volcanian 1 in 6109
Odds of matching 3: Prize is 50 dollars plus a chance at a volcanian 1 in 157 (since the chance of winning is 25 percent, you should multiply that by 4
Server Move 2019
- 49ER
- Posts: 1063
- Joined: December 11th, 2011, 9:01 pm
-
- Posts: 8
- Joined: January 22nd, 2019, 7:18 pm
Re: Server Move 2019
I see your server hoster ist hetzner, guessing it's standard webhosting and probably not level 19 so you don't have access to the linux system via console? Is there a way to see the workload and current Upstream in the console? Are you using multi threading php or stacking, I'm using apache I don't know much about nginx. Have you a current value of running time of the click exchange script?yankeesrule3526 wrote: ↑January 26th, 2019, 11:03 pmThey get cached once loaded the first time, so it isn't terrible. But yeah, the site was started 10 years ago and the code is showing its age._Lynx_ wrote: ↑January 26th, 2019, 1:30 pm I wonder why you don't clip the images from the pokedex. It would be much faster, because it needs just one tcp connection for all images. I don't know why the server is slow anyway. There shouldn't be that much workload on the cpu, is there maybe old code which is slowing it down? Is there a way I can see if I can help?
-
- Crazy collecting Chansey
- Posts: 11921
- Joined: September 8th, 2010, 3:14 pm
- Gender: Male
- Contact:
Re: Server Move 2019
Wouldn't the click exchange be even more faster if it worked with an ajax call instead of full page refresh?
My collections:
-
- Posts: 8
- Joined: January 22nd, 2019, 7:18 pm
Re: Server Move 2019
I already thought about suggesting it, but the work to rewrite it would be too big, you cannot reuse almost anything you already did.
But I thought about a shorter way already virtuadopt already uses, the "content" container (which is showing the clicked virtuadopt and the new link) could be loaded with a xml request via javascript, so at least the the whole things around that might slow the page wouldn't slow the clicking.
-
- Crazy collecting Chansey
- Posts: 11921
- Joined: September 8th, 2010, 3:14 pm
- Gender: Male
- Contact:
Re: Server Move 2019
Good idea!_Lynx_ wrote: ↑January 27th, 2019, 11:31 amI already thought about suggesting it, but the work to rewrite it would be too big, you cannot reuse almost anything you already did.
But I thought about a shorter way already virtuadopt already uses, the "content" container (which is showing the clicked virtuadopt and the new link) could be loaded with a xml request via javascript, so at least the the whole things around that might slow the page wouldn't slow the clicking.
My collections:
- yankeesrule3526
- Chief of Operations
- Posts: 4910
- Joined: March 21st, 2009, 1:11 pm
- Gender: Male
- Location: United States
- Contact:
Re: Server Move 2019
Standard webhosting is for babies I am quite certain the slowdowns are caused by MySQL Apache is spitting out files at an acceptable rate. Nginx is okay, but I don't think it makes a noticeable difference as long as neither are passing non-PHP files to PHP for processing. PHP-FPM is what we are using on the backend, but I think it interacting with MySQL due to poor database design in the beginning years of VA is the holdup._Lynx_ wrote: ↑January 27th, 2019, 9:29 am I see your server hoster ist hetzner, guessing it's standard webhosting and probably not level 19 so you don't have access to the linux system via console? Is there a way to see the workload and current Upstream in the console? Are you using multi threading php or stacking, I'm using apache I don't know much about nginx. Have you a current value of running time of the click exchange script?
Yesterday's speed up of the CE was due to me purging 33,364,113 clicks over the last 3 years. I set up a script to automatically archive clicks older than a day to keep the dataset low when determining when you have to answer a question again or how many you have recently answered incorrectly. The thought did occur to me to put in time logging to see where the slowdowns are with it, but that table was screaming at me to be emptied first.
-
- Posts: 8
- Joined: January 22nd, 2019, 7:18 pm
Re: Server Move 2019
It was the first I saw and my first guess why it is so slow. It's rare mysql is slowing down in most cases it's php, but when I read you dumped the database that much it sounds plausible... Are you still with PHP5 or PHP7? Maybe it's time to move some database tables if it's a bit "old school"ed ;-Dyankeesrule3526 wrote: ↑January 27th, 2019, 4:03 pmStandard webhosting is for babies I am quite certain the slowdowns are caused by MySQL Apache is spitting out files at an acceptable rate. Nginx is okay, but I don't think it makes a noticeable difference as long as neither are passing non-PHP files to PHP for processing. PHP-FPM is what we are using on the backend, but I think it interacting with MySQL due to poor database design in the beginning years of VA is the holdup._Lynx_ wrote: ↑January 27th, 2019, 9:29 am I see your server hoster ist hetzner, guessing it's standard webhosting and probably not level 19 so you don't have access to the linux system via console? Is there a way to see the workload and current Upstream in the console? Are you using multi threading php or stacking, I'm using apache I don't know much about nginx. Have you a current value of running time of the click exchange script?
Yesterday's speed up of the CE was due to me purging 33,364,113 clicks over the last 3 years. I set up a script to automatically archive clicks older than a day to keep the dataset low when determining when you have to answer a question again or how many you have recently answered incorrectly. The thought did occur to me to put in time logging to see where the slowdowns are with it, but that table was screaming at me to be emptied first.
- yankeesrule3526
- Chief of Operations
- Posts: 4910
- Joined: March 21st, 2009, 1:11 pm
- Gender: Male
- Location: United States
- Contact:
Re: Server Move 2019
We are still running PHP5, except for a few cron jobs that can run with PHP7. Anything I have been doing lately has been written to work on PHP7, but it's a huge undertaking getting everything converted.
-
- Posts: 8
- Joined: January 22nd, 2019, 7:18 pm
Re: Server Move 2019
PHP7 is much faster, maybe that would be a good thing first. You don't have much to change, there are just a few obsoluente methods you can easily replace such as mysql -> mysqli (with link for sure) don't know how central you made the database functions (I have also problems on old codes from me where I could slap my face how bad it was made for maintenance) but there a ways to fix it faster. it's faster than php5 anyways.
-
- Posts: 642
- Joined: March 13th, 2014, 10:29 am
- Gender: Male
- Location: Ukraine
Re: Server Move 2019
I just noticed at laboratory new "Add memory" tab. Does that mean that we'll be able to apply it to Silvally soon?
- yankeesrule3526
- Chief of Operations
- Posts: 4910
- Joined: March 21st, 2009, 1:11 pm
- Gender: Male
- Location: United States
- Contact:
Re: Server Move 2019
I just enabled a bunch of pages to actually start using it, so we will see. Nothing is centralized, so its a huge task._Lynx_ wrote: ↑January 27th, 2019, 5:51 pm PHP7 is much faster, maybe that would be a good thing first. You don't have much to change, there are just a few obsoluente methods you can easily replace such as mysql -> mysqli (with link for sure) don't know how central you made the database functions (I have also problems on old codes from me where I could slap my face how bad it was made for maintenance) but there a ways to fix it faster. it's faster than php5 anyways.
-
- Posts: 8
- Joined: January 22nd, 2019, 7:18 pm
Re: Server Move 2019
If you need help you know how to contact me
-
- Posts: 8
- Joined: January 22nd, 2019, 7:18 pm
Re: Server Move 2019
One suggestion left to me:yankeesrule3526 wrote: ↑January 27th, 2019, 10:07 pmI just enabled a bunch of pages to actually start using it, so we will see. Nothing is centralized, so its a huge task._Lynx_ wrote: ↑January 27th, 2019, 5:51 pm PHP7 is much faster, maybe that would be a good thing first. You don't have much to change, there are just a few obsoluente methods you can easily replace such as mysql -> mysqli (with link for sure) don't know how central you made the database functions (I have also problems on old codes from me where I could slap my face how bad it was made for maintenance) but there a ways to fix it faster. it's faster than php5 anyways.
Can you limit the own tickets container on the lottery to about 50? Simple to do and I guess above no one will care what exact tickets they have, maybe a simple see all with a reload of all tickets or get-parameter. A simple count command for MySQL for the full amount. The loading and scrolling of the page is awful when you have a serious amount of tickets you need for that low chance.
- Pokemon Knight
- Posts: 928
- Joined: May 31st, 2014, 3:55 pm
- Location: Tumblr
Re: Server Move 2019
Had a lot of matches even a 3 match but didn’t get anything
- Tango
- Posts: 1386
- Joined: October 4th, 2016, 1:55 pm
- Gender: Female
- Location: Canada
- Contact:
Re: Server Move 2019
Haha ^^; Yeah lotto seems super broke. I have a ton of matches and didn't even win any money.
Got 19 singles, 3 pairs, and 1 three match.
Got 19 singles, 3 pairs, and 1 three match.
- Nery
- Coffee Freak
- Posts: 59612
- Joined: July 16th, 2009, 3:32 pm
- Gender: Female
- Location: Südl. Weinstraße (GER)
Re: Server Move 2019
same here... D:
Virtuadopt Click-Box
Collecting: Seel, Dewgong, Houndour, Houndoom, Abandoned Mimikyu and Anpu Houndoom
(Future Gens: Gothorita, Deerling, Klink, Cofagrigus, Archen, Mimikyu)
Collecting: Seel, Dewgong, Houndour, Houndoom, Abandoned Mimikyu and Anpu Houndoom
(Future Gens: Gothorita, Deerling, Klink, Cofagrigus, Archen, Mimikyu)
- Ecco
- ** TROPIUS **
- Posts: 5419
- Joined: December 7th, 2010, 2:17 pm
- Location: Shoebox
Re: Server Move 2019
No cash and prizes payout from lottery ..
- yankeesrule3526
- Chief of Operations
- Posts: 4910
- Joined: March 21st, 2009, 1:11 pm
- Gender: Male
- Location: United States
- Contact:
Re: Server Move 2019
Are you sure there was no cash? I’m just not sure if it didn’t work at all or the counter at the bottom didn’t update.
- Ecco
- ** TROPIUS **
- Posts: 5419
- Joined: December 7th, 2010, 2:17 pm
- Location: Shoebox
Re: Server Move 2019
Money Won From These Tickets: $ 0
- Nery
- Coffee Freak
- Posts: 59612
- Joined: July 16th, 2009, 3:32 pm
- Gender: Female
- Location: Südl. Weinstraße (GER)
Re: Server Move 2019
I got no cash, also no items or volcanions.
I didn't checked all my tickets 'cause I bought so many.. but I already saw a lot 1, 2 and 3 matches. But no prices.
I didn't checked all my tickets 'cause I bought so many.. but I already saw a lot 1, 2 and 3 matches. But no prices.
Virtuadopt Click-Box
Collecting: Seel, Dewgong, Houndour, Houndoom, Abandoned Mimikyu and Anpu Houndoom
(Future Gens: Gothorita, Deerling, Klink, Cofagrigus, Archen, Mimikyu)
Collecting: Seel, Dewgong, Houndour, Houndoom, Abandoned Mimikyu and Anpu Houndoom
(Future Gens: Gothorita, Deerling, Klink, Cofagrigus, Archen, Mimikyu)