Reputation
5,372
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
12 35
Newest
 Announcer
Impact
~317k people reached

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
answered Mysql - Performance improvement of “ORDER BY” with index
Aug
23
answered Would Sphinx be a good solution to solve server getting bogged with heavy MySQL reads?
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
answered How does a VM hosted on xen knows that it is in a virtualized environment
Aug
23
comment How can I scroll back the output in FreeBSD's console without Scroll Lock?
No, it will not.
Aug
23
answered How can I scroll back the output in FreeBSD's console without Scroll Lock?
Aug
23
answered Is it possible to configure CPanel to run only eith Nginx
Aug
22
answered Setup two NICs, one public and one private
Aug
22
answered With HTTPS-Enforcer chrome extension, a normal ping is answered by different site
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
answered Does apache apply directives sequentially?
Aug
22
answered Analysing Disk IO Traffic
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
answered PHP occasionally fails to connect to mysql server
Aug
21
answered Unable to boot Rackspace Cloud image on KVM
Aug
21
answered Replicate GIT repository over multiple geolocations
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.