Forums

Slow and slugging performance of consoles

The bash consoles are extremely slow and constantly freezing so I'm forced to shut them down. Even the pages for the site such as web/dashboard are loading very slow. I checked my internt connection and everything seems fine. Other websites have no problems.

Are you having performance issues?

Even this post took about a minute to be published.

Another problem that I am facing is this - "User 'rupeshthakare' has exceeded the 'max_user_connections' resource (current value: 24)"

Can you suggest something for this? I have closed all the dashboard consoles and closed connections on my end. If anything is open, can you let me know from where these connections are coming? That would be of great help. Thanks

Is it possible that you used all your CPU and got tarpitted? and How do you manage your database connections? Do you do it manually or some ORM is doing that for you?

no I have not been tarpitted ever. Mostly i have seen CPU usage reach a max of 20%. Even at the moment, it was reset about 3 hours ago and is at 0% use and I am still unable to download a large file from the files page. It is mysqldump file that is about 170MB. The download starts and then speed drops off to 0. Also, bash console is still slow. I type a command and it takes about 5 seconds to reflect or even more. Can you please figure out why I am experiencing this sluggishness?

Databse connections are handled by SQLAlchemy. I have 4 flask applications running. They are all connecting to the different databases.

It is getting a bit frustrating. I have not experienced this issue before so I understand if its a one time glitch. Just want to understand if there is something that is performing poorly at your end or mine.

I was able to download the file now. Worked on its own after multiple attempts. ---> Well it turns out that I expressed my happiness prematurely. The download started at a nice speed, downloaded about 50MB quickly and then dropped off to 0. Still stuck.

There are other options for downloading files that you can try: https://help.pythonanywhere.com/pages/UploadingAndDownloadingFiles/

We are not experiencing any general issues at the moment. The most likely cause from what you've described is the network between you and PythonAnywhere.

SFTP is also not working. Filezilla keeps timing out and simple sftp shows 'stalled'

Then it really seems like it's a network issue - the machine that you connect to for SCP is entirely different to the one that you would download the file from through the web interface.