Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
15 37
Impact
~352k people reached

Aug
23
comment Is it possible to configure CPanel to run only eith Nginx
I'm not exactly sure I've only used CPanel once and from my experience it's coupled with Apache very tight. So I guess even if it is possible it's not so easy.
Aug
23
comment Would Sphinx be a good solution to solve server getting bogged with heavy MySQL reads?
Are you absolutely sure these queries use indexes properly? You can check this using the EXPLAIN command in mysql console. If they do you should probably extend max MySQL key buffer size in the config.
Aug
23
comment Is it possible to configure CPanel to run only eith Nginx
There should be an application server behind them, like Apache or PHP-FPM, nginx is only a reverse proxy by nature. It uses HTTP or FastCGI to talk to backends.
Aug
23
comment With HTTPS-Enforcer chrome extension, a normal ping is answered by different site
Okay it's obvious now that your system uses a custom DNS server installed on it (namserver is set to the default local address 127.0.0.1). Again, 67.215.65.132 is NOT a github site of that plugin, it is one of the OpenDNS IP addresses according to its whois info (you can check this using whois 67.215.65.132). The easiest way to fix it temporarily is to edit /etc/resolv.conf manually and to replace nameserver 127.0.0.1 with nameserver 8.8.8.8 (8.8.8.8 is a Google public DNS). To make this fix permanent you should consult resolvconf manual, I'm not a big expert here.
Aug
23
comment Apache virtual host configured with a sym-link to a folder in my user directory fails with 403 Forbidden
Could you please post the output of ls -alFd /home/your_user_name and ls -alFd /home/your_user_name/apache_subfolder?
Aug
23
comment Apache virtual host configured with a sym-link to a folder in my user directory fails with 403 Forbidden
Apache should have at least x permission on your folder to be able to work with its subfolder.
Aug
23
comment Apache virtual host configured with a sym-link to a folder in my user directory fails with 403 Forbidden
Does Apache user have rights to access this subfolder in your home folder? You can check using sudo su - your-apache-user and then using ls /home/your_user/path/to/your/subfolder
Aug
23
comment Mysql - Performance improvement of “ORDER BY” with index
No it won't be useful then, the only optimization I can think of in that case is to select not * but primary keys only and use a LIMIT clause (I guess a user never needs the whole table). When you get the primary keys you will be able to get everything else in separate query like SELECT * FROM t1 WHERE pk IN (.., .., ..). Queries like SELECT * WHERE some_complex_expression ORDER BY ... effectively kill MySQL sorting buffers, it's always better to sort less data and * can be a lot of data.
Aug
23
comment Would Sphinx be a good solution to solve server getting bogged with heavy MySQL reads?
Why do you need to repair the database tables every time? What storage engine do you use?
Aug
23
comment How can I scroll back the output in FreeBSD's console without Scroll Lock?
No, it will not.
Aug
22
comment With HTTPS-Enforcer chrome extension, a normal ping is answered by different site
This is weird, could you please post the content of your /etc/resolv.conf?
Aug
22
comment Nginx + Unicorn
There should be a staging.log file somewhere (I guess in /data/appname/staging/current/log/staging.log), it looks like your application fails before producing any output. It's also good to check unicorn.stderr.log too.
Aug
22
comment Nginx + Unicorn
What version of nginx are you using?
Aug
22
comment Nginx + Unicorn
Is there anything relevant in /data/appname/staging/current/log/unicorn-staging-error.log?
Aug
21
comment MySQL: 5000 core users, 2GB Table Heavy Write / Read: How to Prevent Crashing
When InnoDB crashes it just replays transaction log records on restart, this is much faster than rechecking all the table. A number of transaction log records to replay after crash depends on write load only, not on the total DB size.
Aug
21
comment MySQL: 5000 core users, 2GB Table Heavy Write / Read: How to Prevent Crashing
I never use MyISAM in production especially for large setups because it's non-transactional and requires the recheck and repair procedure almost every time it crashes so I am not a big expert here. But there should be something relevant in the MySQL error log or maybe even in /var/log/syslog, many distributions log MySQL events right there.
Aug
21
comment Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) on subsequent connection through terminal
Well if the server is running and if you can connect to it after editing the [client] section of /etc/mysql/my.cnf you should probably leave everything as is.
Aug
21
comment MySQL: 5000 core users, 2GB Table Heavy Write / Read: How to Prevent Crashing
Is there anything useful in MySQL error log and slow log? Basically I would recommend you to convert everything to InnoDB but this implies a certain downtime which can be quite high (well, it should be comparable to the full check time). But if you use native MySQL full text search the conversion won't be possible because InnoDB does not support FTS.
Aug
21
comment MySQL: 5000 core users, 2GB Table Heavy Write / Read: How to Prevent Crashing
Please post your my.cnf somewhere. What storage engine do you use, MyISAM or InnoDB?
Aug
21
comment Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) on subsequent connection through terminal
I recommend you to perform a full database dump and reinstall MySQL from packages.