I recently had to upgrade my server because my forum has grew heres the specs for the new server i have
Inteeeps happen everytime say 300-400 online at once
Get a unlimited hosting package? its only about 4-10 bucks a month~!
Put mybb_sessions into memory. You have enough RAM, so you can make good use of it.
i have a dedicated host i don't need a shared environment it would crash even more if i used a shared host
can you show me how todo that
Run this query on the database:
alter table `mybb_sessions` engine = memory;
It will use more RAM, but with the amount you have you'll be fine.
#1114 - The table '#sql-f55_1602' is full
Run this query via SSH:
df -h
What's the output?
/dev/mapper/sys--ane4-root
219G 23G 185G 12% /
/dev/mapper/sys--ane4-vartmp
2.0G 68M 1.8G 4% /var/tmp
/dev/mapper/sys--ane4-tmp
2.0G 68M 1.8G 4% /tmp
/dev/sda1 99M 20M 75M 21% /boot
tmpfs 2.0G 0 2.0G 0% /dev/shm
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/before-local
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/before-queue
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/before-remote
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/info
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/spool
Ok, well you have enough disk space free.
How many records are currently in mybb_sessions?
18,012 i don't know if that's bad or good