Disk is full
Pirate Praveen Sat 21 Jun 2014 9:36AMPublicSeen by 62diaspora@poddery:~$ df -h
Filesystem Size Used Avail Use% Mounted on
rootfs 76G 72G 0 100% /
I'm moving bakup folder from the server.
Should we switch to postgresql?
proposal by Pirate Praveen Closed Tue 2 Sep 2014 1:35PM
We'll move out services using mysql before we switch. We are in the process of freeing up mysql.
Looks like there is big performance improvement switching to postgresql. See https://poddery.com/posts/1305296
What do you think?
Results
| Results | Option | Votes | % of votes cast | % of eligible voters | |
|---|---|---|---|---|---|
| Agree | 4 | 80 | 10 |   | |
| Abstain | 1 | 20 | 2 |  | |
| Disagree | 0 | 0 | 0 | ||
| Block | 0 | 0 | 0 | ||
| Undecided | 36 | 88 |          |
5 of 41 votes cast (12% participation)
Pavithran S
Fri 22 Aug 2014 6:28PM
Postgres obviously will give good performance over MariaDB , if its easy and wont affect anything please make the switch.
Pirate PraveenSat 23 Aug 2014 6:49AM
I have given more RAM to mysql for caching and if we see performance problems again, we'll switch immediately.
Balasankar CSat 23 Aug 2014 7:31AM
I don't know about any comparison b/w databases. If the knowledgable see postgresql as a better choice, we must switch immediately.
Manu Krishnan T V
Sat 23 Aug 2014 4:04PM
I am fine to move to Postgresql, but only after moving all other sites using mysql to somewhere else, so that we could stop MySQL. Running MySQL alongside with Postgresql for the diaspora instance will increase the memory usage.
Balasankar CSat 21 Jun 2014 10:00AM
Are we hosting any other websites like SMC's or fosscommunity.in? If so, we can ask them to migrate.
Juan SantiagoSat 21 Jun 2014 10:23AM
apparently everything is fixed :)
Pirate PraveenSat 21 Jun 2014 10:28AM
@balasankarchelamat , yes that would save us some space.
Manu Krishnan T VSun 22 Jun 2014 4:57PM
Seems like log files are the major culprits. Almost 27G in Diaspora logs.
Also, the old files from the migration still exists in server, which counts to around 10G.
Pirate Praveen ·Sat 21 Jun 2014 9:41AM
We should setup monitoring in the server for future issues like this.
@juansantiago thanks for the heads up. @manukrishnantv nagios?