@scottalanmiller said in Wordpress on Vultr 768:
Which OS is this? What is the source of MariaDB?
This is CentOS7. I set this server up a few months ago following this guide: https://jaredbusch.com/2014/08/11/how-to-install-wordpress-on-centos-7-minimal/
As far as I remember, I don't remember deviating from it.
@scottalanmiller said in Wordpress on Vultr 768:
This might be a silly question but just to be 100% sure.... what is the disk space usage?
df -h
[root@web01 mariadb]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 15G 3.1G 11G 22% /
devtmpfs 362M 0 362M 0% /dev
tmpfs 371M 0 371M 0% /dev/shm
tmpfs 371M 9.6M 361M 3% /run
tmpfs 371M 0 371M 0% /sys/fs/cgroup
tmpfs 75M 0 75M 0% /run/user/1000
@scottalanmiller said in Wordpress on Vultr 768:
So a few things to get started:
- You need to configure your swap space, Vultr does not do this for you. So you are swapless and running with much less memory than you should be in that regard.
- 768MB is not very good for web serving. It can work, but you need to tune things, Apache especially as it will sprawl instantly.
- You need to look in the logs and see why the services said that they stopped.
- You need to look at the SAR reports to see what memory is doing. Move SAR up to every minute instead of every ten minutes for better info.
free -m
total used free shared buff/cache available
Mem: 740 255 247 1 237 369
Swap: 1023 195 828
I figured this was too low, but thought it might be manageable, especially just for testing and/or low usage.
161107 11:04:55 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
161107 11:05:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161107 11:05:52 [Note] /usr/libexec/mysqld (mysqld 5.5.47-MariaDB) starting as process 4727 ...
161107 11:05:52 InnoDB: The InnoDB memory heap is disabled
161107 11:05:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161107 11:05:52 InnoDB: Compressed tables use zlib 1.2.7
161107 11:05:52 InnoDB: Using Linux native AIO
161107 11:05:52 InnoDB: Initializing buffer pool, size = 32.0M
161107 11:05:52 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 8388608 bytes!
InnoDB: Possible causes for this error:
(a) Incorrect log file is used or log file size is changed
(b) In case default size is used this log file is from 10.0
(c) Log file is corrupted or there was not enough disk space
In case (b) you need to set innodb_log_file_size = 48M
161107 11:05:52 [ERROR] Plugin 'InnoDB' init function returned error.
161107 11:05:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
161107 11:05:52 [Note] Plugin 'FEEDBACK' is disabled.
161107 11:05:52 [ERROR] Unknown/unsupported storage engine: InnoDB
161107 11:05:52 [ERROR] Aborting
161107 11:05:52 [Note] /usr/libexec/mysqld: Shutdown complete
161107 11:05:52 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
[root@web01 mariadb]# sar -r 2 20
Linux 3.10.0-327.18.2.el7.x86_64 (web01) 11/07/2016 _x86_64_ (1 CPU)
11:36:42 AM kbmemfree kbmemused %memused kbbuffers kbcached kbcommit %commit kbactive kbinact kbdirty
11:36:44 AM 101484 657248 86.62 804 38136 1221556 67.59 263708 321164 4
11:36:46 AM 60488 698244 92.03 140 55864 1595136 88.26 292536 333572 20
11:36:48 AM 68760 689972 90.94 2140 81072 1627604 90.06 287536 332852 24
11:36:50 AM 88352 670380 88.36 144 44408 1619720 89.62 307504 294980 96
11:36:52 AM 52684 706048 93.06 80 20128 1649120 91.25 314700 325640 0
11:36:54 AM 56232 702500 92.59 88 8924 1716380 94.97 318116 318592 4
11:36:56 AM 59236 699496 92.19 112 14368 1801240 99.66 317428 315804 0
11:36:58 AM 57804 700928 92.38 84 28560 1844356 102.05 317084 317404 0
11:37:00 AM 56908 701824 92.50 84 15028 1924244 106.47 317200 317500 0
11:37:02 AM 60052 698680 92.09 84 3912 2013736 111.42 314188 315084 0
11:37:04 AM 57332 701400 92.44 84 24492 2090780 115.69 303708 324764 0
11:37:06 AM 57672 701060 92.40 100 23932 2132812 118.01 311100 316180 0
11:37:08 AM 49352 709380 93.50 84 28520 2311044 127.87 308568 320432 0
11:37:10 AM 42416 716316 94.41 80 21308 2379376 131.65 318500 316644 0
11:37:12 AM 59104 699628 92.21 84 17616 2515080 139.16 306896 309736 0
11:37:14 AM 56912 701820 92.50 88 26100 2626604 145.33 307340 310396 0
11:37:16 AM 75388 683344 90.06 1192 32580 2726348 150.85 282232 314996 0
11:37:18 AM 52532 706200 93.08 324 16052 2226088 123.17 304344 313860 0
11:37:20 AM 41032 717700 94.59 1296 18176 2335440 129.22 306512 318952 0
11:37:22 AM 40488 718244 94.66 120 19404 2517688 139.31 305460 320248 20
Average: 59711 699021 92.13 361 26929 2043718 113.08 305233 317940 8````@thwr said in Wordpress on Vultr 768:
So you need to check out other possible causes for this
That's what I thought too. It's 1 site with currently no traffic at all. Any performance tuning I need to do on Apache, or mariaDB?
Is anyone running a Wordpress site on a 768 MB instance of Vultr?
For a couple of days after initial setup, I was able to install MariaDB, Wordpress, etc, install a theme and some other plugins, and do some other site config. The site was working without issue. Now, almost all the time, the site just gives a "Error connecting to database" error. Upon further investigation, and watching the console, I figured out that the error is happening because the processes keep terminating (mysqld and httpd). Restarting the services fixes the problem for a couple of seconds, but then the server kills them again. When checking memory, the free available memory right after restarting the database server is extremely low. I'm assuming this is why the servers keeps killing the processes.
Is this just a resource issue? Is a 768 MB server too small for a 1 site wordpress site?
@brianlittlejohn said in Internet Pricing Poll:
@fuznutz04 said in Internet Pricing Poll:
@brianlittlejohn said in Internet Pricing Poll:
I pay $50 for 200/20
I'm assuming that is fiber? Where are you located?
That's also my home. At work I have 30/30 Fiber... but it is way more expensive... $400ish
Yeah, my 15/2 is for my home as well. At work, I have 50/50 Enterprise fiber from Comcast. That stuff is expensive.
@brianlittlejohn said in Internet Pricing Poll:
@fuznutz04 said in Internet Pricing Poll:
@brianlittlejohn said in Internet Pricing Poll:
I pay $50 for 200/20
I'm assuming that is fiber? Where are you located?
Nope, Cable. I'm in Texas
Oh wow, then that further proves that the download and upload speeds provided by my carrier are just ridiculous. 15 down is fine for me, but man, just give me a few more upload! </rant>
@brianlittlejohn said in Internet Pricing Poll:
I pay $50 for 200/20
I'm assuming that is fiber? Where are you located?
I'm curious as to what we all pay for Internet around the world. For example, in my area, I only have 1 decent choice for Internet, and I pay about $68 for 15/2.
I used pfsense before I was introduced to the edgerouters. Once I learned it was s fork of VYOS and saw how easy it was to learn, and how inexpensive it was, I switched from pfsense and never looked back.
@scottalanmiller said in StatusCake:
Wait, this isn't actually a service that makes cakes?
Imagine my surprise when I visited the site. Total let down.
Just stumbled upon this service. I'm just playing with the free version right now, which does basic availability checks for http, smtp, ssh, tcp, dns, ping, and push. Unlimited number of endpoints and even sends alerts.
It looks like they also offer server monitoring (cpu,memory, etc) as well with the paid plans. But without signing up for paid, you can't see exactly what it does, or how it does it.
Has anyone used them before?
@JaredBusch said in FreePBX, SelfSigned Certs, & Let's Encrypt:
Circling back on this. FreePBX now includes Let's Encrypt in the Certificate Manager module.
Right, and automatically attempts to renews the let's encrypt certs a few weeks before expiration. No need to write a job yourself!
Thanks for producing these. Now to find some time to watch them all.
@scottalanmiller So since I posted the OP, I found out what the issue was. (or at least eliminated it by changing a setting.) On old versions of FreePBX, in Advanced SIP settings, in order to enable TCP connections, you had to manually type:
tcpenable =yes
In new versions, there is now a button to enable TCP. Having both settings enabled seems to cause these issues. Most likely, the config file for sip.conf gets messed up having these similar/identical settings. Removing the old entry eliminates the errors.
I just upgraded a PBX from the old track 6.12 to the new FreePBX track 10.13. The upgrade went smoothly, but there is one remote softphone (using Linphone) that has intermittent call issues and the logs are full of the errors below. There are other softphone users that do not have any issues. Has anyone ever experience any messages like these?
[2016-10-18 10:48:31] ERROR[2323]: chan_sip.c:4261 __sip_reliable_xmit: Serious Network Trouble; __sip_xmit returns error for pkt data
[2016-10-18 10:48:45] WARNING[2323]: chan_sip.c:3775 __sip_xmit: sip_xmit of 0x7f835037ea70 (len 1038) to xxx.xxx.xxx.xxx:56332 returned -2: No such file or directoryExcellent. BTW, the UI for the EdgeSwitch on the latest firmware is pretty nice. A lot nicer than the Dell switches I'm used to configuring in the past.
OK good, some confirmation. That's what the documentation eluded to, but it wasn't 100% clear for me. Thanks.
For a 7 person office, It will probably be fine. Would you recommend making any adjustments in the EdgeSwitch that is in line as well?
Has anyone used the "Smart Queue" feature on EdgeOS? I have a client with a 50/5 connection, and they are getting some VoIP phones, going to a cloud based PBX. There are no VLANs, and I just want to ensure VoIP gets priority over everything else.
The latest firmware on the ERL has Smart Queue and the only parameters are download and upload, and which interface to apply these rules to.
How does the Smart Q work? Are you supposed to put in your actual maximum speeds (50/5 in this case) and the ERL takes care of the rest, or something else?
