cheat-sheet articles are about code
snippets that I need every once in a while, and which I constantly forget
about.
From the MySQL
manual:
The binary log contains “events” that describe database changes such as
table creation operations or changes to table data. It also contains events
for statements that potentially could have made changes (for example, a
DELETE which matched no rows), unless row-based logging is used. The
binary log also contains information about how long each statement took that
updated data.
The binary log is primarily needed for master-slave-setups and data recovery
operations. Files are never deleted and pile up in the datadir
(e.g. /var/lib/mysql), named mysqld-bin.000001, mysqld-bin.000002, …
(Alternatively, the files might be named hostname-bin.000001, …)
To get rid of them, run the following two commands as MySQL’s admin user:
mysql> FLUSH LOGS;
mysql> RESET MASTER;
The first command flushes unsaved transactions to the database, and the second
one deletes all binary logs.
If you do not need the binary logs at all, you can also disable them entirely
by removing the log-bin option from your my.cnf configuration file.
cheat-sheet articles are about code
snippets that I need every once in a while, and which I constantly forget
about.
First, register your nickname if you haven’t done so yet:
/msg NickServ REGISTER my_password my.email.address@example.com
Login (“identify”) with NickServ:
/msg NickServ IDENTIFY my_nick my_password
Next, register your channel:
/msg ChanServ REGISTER #my-channel
Change the channel’s topic:
/msg ChanServ TOPIC #my-channel my_topic
If the channel is not very frequented, you might want to set the KEEPTOPIC
flag. Otherwise, you have to re-set the topic every time:
/msg ChanServ SET #my-channel KEEPTOPIC ON
Hide information about the channel from other users:
/msg ChanServ SET #my-channel PRIVATE ON
Restrict the channel to user’s who are on the channel’s access list:
/msg ChanServ SET #my-channel RESTRICTED ON
Add and remove users to the access list—only registered user accounts are
allowed:
/msg ChanServ ACCESS #my-channel ADD other_user
/msg ChanServ ACCESS #my-channel DEL bugging_user
Display access list:
/msg ChanServ ACCESS #my-channel LIST
cheat-sheet articles are about code
snippets that I need every once in a while, and which I constantly forget
about.
Examples
# three newest (by mtime) files
print *(.om[1,3])
# files larger than 50 kiB
print *(.Lk+50)
# files modified within the last hour
print *(.mh-1)
# files not accessed for six months or longer
print *(.aM+6)
# change ownership of anything that is owned by `alice` to `bob`
chown bob **/*(u:alice:)
Full List
| Qualifier |
Description |
/ |
directory |
F |
non-empty directory (empty: (/^F)) |
. |
plain file |
@ |
symbolic link |
* |
executable plain file |
r/A/R |
readable by owner/group/world |
w/I/W |
writable by owner/group/world |
x/E/X |
executable by owner/group/world |
s/S/t |
setuid/setgid/sticky bit |
fspec |
has chmod style permissions spec |
u:name: |
owned by user name |
g:name: |
owned by group name |
a[Mwhms][-+]n |
access time in given units (see below) |
m[Mwhms][-+]n |
modification time in given units |
L[kmp][-+]n |
size in given units (see below) |
^ |
negate following qualifiers |
- |
toggle following links (first one turns on) |
N |
whole pattern expands to empty if no match |
D |
leading dots may be matched |
n |
sort numbers numerically |
o[nLamd] |
order by given code (see below; may repeat) |
O[nLamd] |
order by reverse of given code |
[num] |
select num-th file in current order |
[num1,num2] |
select num1-th to num2-th file |
- Time units: Month, week, hour, minute, second; default: day.
- Size units: kilobytes, megabytes; default: bytes
- Order codes: name (default), size, atime, mtime, directory depth