Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.
Disable Query Cache at runtime when querying MySQL database
Answer:
When you want MySQL to execute a SQL statement without looking at the query cache first, you can use the keyword SQL_NO_CACHE
E.g.
mysql> SELECT SQL_NO_CACHE name FROM user;
That's all.
How to make desktop icons snap to grid on Mac OSX
Answer:
To make desktop icons on Mac OSX snap to grid, follow the steps below:
1. Click anywhere on the desktop
2. Select "Show View Options"
3. At the row "Arrange By", select "Snap to Grid"
That's all what you need.
Suggested Mercurial .hgignore settings for XCode projects
Answer:
Save the following lines as .hgignore and put it under the root of your project root directory, Mercurial will ignore them automatically.
^build/*
\.mode1v3
\.pbxuser
\.DS_Store
^\.*Adding the missing ignore function to Mercurial
Answer:
The following script add the ignore function to the Mercurial
#!/usr/bin/env python
"""Ignore pathnames and patterns"""
import os
def ignore(ui, repo, *pathnames):
"""Ignore the given pathnames and patterns."""
outf = open(os.path.join(repo.root, ".hgignore"), "a")
for p in pathnames:
outf.write(p + "\n")
outf.close()
return
cmdtable = {
'ignore': (ignore, [], "hg ignore pathname [pathname]"),
}
Save the script as ignore.py (e.g. ~/hg/ignore.py), and add the following line in your own ~/.hgrc
[extensions]
ignore = ~/hg/ignore.py
Reference: http://dmoonc.com/blog/?p=266
How to diff two remote files over ssh?
Answer:
Assume you have two files on two different machine, how do you do a diff of them?
Simply use the command below:
# diff <(ssh server_1 'cat foo1') <(ssh server_2 'cat foo2')
