Home » Forum Home » Development

Topic: database relocation
Replies: 23   Views: 53,888   Pages: 2   Last Post: Jan 2, 2022, 4:25 PM by: rainwolf

Search Forum

Back to Topic List Topics: [ Previous | Next ]
Replies: 23   Views: 53,888   Pages: 2   [ 1 2 | Next ]
rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
database relocation
Posted: Apr 23, 2020, 2:28 PM

The database queries are now run on a different machine from this server. At first glance this has made the more expensive queries a lot more responsive.


tin_can

Posts: 26
Registered: Jun 1, 2019
From: Richardson, TX
Re: database relocation
Posted: Apr 25, 2020, 12:33 AM

Thank you, rainwolf, for all the difficult (and I hope interesting and fun) work that you do to keep Pente.org solid.

karlw

Posts: 968
Registered: Mar 7, 2006
From: Eugene, Oregon
Age: 32
Re: database relocation
Posted: May 12, 2020, 7:39 PM

On the contrary, for me right now the database queries are sometimes taking much, much longer than usual.

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: May 13, 2020, 12:49 AM

I'll take a closer look when I can.
Are there specific parameters to those queries and what is the browser you're using?

karlw

Posts: 968
Registered: Mar 7, 2006
From: Eugene, Oregon
Age: 32
Re: database relocation
Posted: May 13, 2020, 2:31 AM

Using chrome on a dell xps 13 laptop, and no it seems to be happening pretty randomly. Maybe most commonly when I first open the db--I'll often have to wait 30 seconds or more before I can enter moves onto the board or do anything. Then sometimes searches return quickly, sometimes very slowly.

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: May 13, 2020, 2:43 AM

That is going to be trickier to debug, I'll look into it.

I also recently switched to an hourly (instead of daily) offsite backup regimen, so if you find that queries are particularly slow between 0 and 5 (or so) minutes after the hour, then that would be the cause. If that's the case, then let me know and I'll look into making different arrangements for backups.

madmike

Posts: 133
Registered: May 27, 2014
From: Saltillo, Mexico
Age: 67
Re: database relocation
Posted: May 13, 2020, 4:51 AM

I know this is not going to help, but...
db queries were fine before and don't seem any faster now.
I have NOT noticed any slower responses.

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: May 13, 2020, 5:47 AM

Before, queries with rating restrictions in them would be slow for me sometimes, I have the impression that is no longer the case.

I made a change in the network connection between the 2 machines, if there's still lag (notably the one on initial load), let me know.

madmike

Posts: 133
Registered: May 27, 2014
From: Saltillo, Mexico
Age: 67
Re: database relocation
Posted: Sep 18, 2020, 6:08 PM

Dont know if you are still interested or not.
For several weeks now, maybe even a couple of months, database queries have been slow.
Since noticing I have used several machines on several different wifi and wired connections. Seems to be worse if I add any variables.

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: Sep 19, 2020, 3:40 PM

I'm seeing it too now, not sure about the cause but will look into it.

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: Sep 19, 2020, 4:33 PM

What kind of queries are slow?
Preliminary tests show that for me a search where only one player's rating is restricted, and the other not (above 0), those stick out as slow queries.

Which ones are for you consistently slow?

madmike

Posts: 133
Registered: May 27, 2014
From: Saltillo, Mexico
Age: 67
Re: database relocation
Posted: Sep 20, 2020, 4:18 PM

Doesn't seem to matter. But If I immediately run the same query results are pretty quick to come back

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: Sep 22, 2020, 1:39 AM

When I find some time in the coming weeks, I will rent a stronger machine to host the database and see if that makes a difference.

madmike

Posts: 133
Registered: May 27, 2014
From: Saltillo, Mexico
Age: 67
Re: database relocation
Posted: Sep 22, 2020, 5:42 PM

has anybody else commented one way or the other?

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: Sep 23, 2020, 1:52 AM

no, so I'm glad you did, I didn't notice because I don't use it, but I'm seeing the same thing.

Replies: 23   Views: 53,888   Pages: 2   [ 1 2 | Next ]
Back to Topic List
Topics: [ Previous | Next ]


Powered by Jive Software