oli's blog

Operating System Signals on different platforms

Mon, 2010-03-15 16:21 — oli
Taxonomy upgrade extras: 
operating system
signal
platform
kill
shell> kill -l

Linux

 1) SIGHUP 2) SIGINT 3) SIGQUIT 4) SIGILL
 5) SIGTRAP 6) SIGABRT 7) SIGBUS 8) SIGFPE
 9) SIGKILL10) SIGUSR111) SIGSEGV12) SIGUSR2
13) SIGPIPE14) SIGALRM15) SIGTERM16) SIGSTKFLT
17) SIGCHLD18) SIGCONT19) SIGSTOP20) SIGTSTP
21) SIGTTIN22) SIGTTOU23) SIGURG24) SIGXCPU
25) SIGXFSZ26) SIGVTALRM27) SIGPROF28) SIGWINCH
29) SIGIO30) SIGPWR31) SIGSYS
34) SIGRTMIN35) SIGRTMIN+136) SIGRTMIN+2
37) SIGRTMIN+338) SIGRTMIN+439) SIGRTMIN+540) SIGRTMIN+6
41) SIGRTMIN+742) SIGRTMIN+843) SIGRTMIN+944) SIGRTMIN+10
45) SIGRTMIN+1146) SIGRTMIN+1247) SIGRTMIN+1348) SIGRTMIN+14
49) SIGRTMIN+1550) SIGRTMAX-1451) SIGRTMAX-1352) SIGRTMAX-12
53) SIGRTMAX-1154) SIGRTMAX-1055) SIGRTMAX-956) SIGRTMAX-8
57) SIGRTMAX-758) SIGRTMAX-659) SIGRTMAX-560) SIGRTMAX-4
61) SIGRTMAX-362) SIGRTMAX-263) SIGRTMAX-164) SIGRTMAX

Solaris 10 (x86, Sparc)

 1) SIGHUP 2) SIGINT 3) SIGQUIT 4) SIGILL
 5) SIGTRAP 6) SIGABRT 7) SIGEMT 8) SIGFPE
 9) SIGKILL10) SIGBUS11) SIGSEGV12) SIGSYS
13) SIGPIPE14) SIGALRM15) SIGTERM16) SIGUSR1
17) SIGUSR218) SIGCHLD19) SIGPWR20) SIGWINCH
21) SIGURG22) SIGIO23) SIGSTOP24) SIGTSTP
25) SIGCONT26) SIGTTIN27) SIGTTOU28) SIGVTALRM
29) SIGPROF30) SIGXCPU31) SIGXFSZ32) SIGWAITING
33) SIGLWP34) SIGFREEZE35) SIGTHAW36) SIGCANCEL
37) SIGLOST
41) SIGRTMIN42) SIGRTMIN+143) SIGRTMIN+244) SIGRTMIN+3
45) SIGRTMAX-346) SIGRTMAX-247) SIGRTMAX-148) SIGRTMAX

AIX

 1) HUP 2) INT 3) QUIT 4) ILL
 5) TRAP 6) LOST 7) EMT 8) FPE
 9) KILL10) BUS11) SEGV12) SYS
13) PIPE14) ALRM15) TERM16) URG
17) STOP18) TSTP19) CONT20) CHLD
21) TTIN22) TTOU23) IO24) XCPU
25) XFSZ26) bad trap27) MSG28) WINCH
29) PWR30) USR131) USR232) PROF
33) DANGER34) VTALRM35) MIGRATE36) PRE
37) bad trap38) bad trap39) bad trap40) bad trap
41) bad trap42) bad trap43) bad trap44) bad trap
45) bad trap46) bad trap47) bad trap48) bad trap
49) bad trap50) bad trap51) bad trap52) bad trap
53) bad trap54) bad trap55) bad trap56) bad trap
57) bad trap58) bad trap59) bad trap60) GRANT
61) RETRACT62) SOUND63) SAK

OpenBSD

 1) HUP 2) INT 3) QUIT 4) ILL
 5) TRAP 6) ABRT 7) EMT 8) FPE
 9) KILL10) BUS11) SEGV12) SYS
13) PIPE14) ALRM15) TERM16) URG
17) STOP18) TSTP19) CONT20) CHLD
21) TTIN22) TTOU23) IO24) XCPU
25) XFSZ26) VTALRM27) PROF28) WINCH
29) INFO30) USR131) USR2

HP-UX

 1) HUP 2) INT 3) QUIT 4) ILL
 5) TRAP 6) ABRT 7) EMT 8) FPE
 9) KILL10) BUS11) SEGV12) SYS
13) PIPE14) ALRM15) TERM16) USR1
17) USR218) CHLD19) PWR20) VTALRM
21) PROF22) IO23) WINCH24) STOP
25) TSTP26) CONT27) TTIN28) TTOU
29) URG30) LOST31) RESERVED32) ?
33) XCPU34) XFSZ35) ?36) ?
37) RTMIN38) RTMIN+139) RTMIN+240) RTMIN+3
41) RTMAX-342) RTMAX-243) RTMAX-144) RTMAX

Quick links to the MySQL documentation

Mon, 2010-03-15 15:50 — oli
Taxonomy upgrade extras: 
documentation
general query log

MySQL Statement Syntax

Data Definition Language (DDL) Statements

ALTER DATABASEALTER EVENTALTER LOGFILE GROUPALTER FUNCTION
ALTER PROCEDUREALTER SERVERALTER TABLEALTER TABLESPACE
ALTER VIEWCREATE DATABASECREATE EVENTCREATE FUNCTION
CREATE INDEXCREATE LOGFILE GROUPCREATE PROCEDURECREATE FUNCTION
CREATE SERVERCREATE TABLECREATE TABLESPACECREATE TRIGGER
CREATE VIEWDROP DATABASEDROP EVENTDROP FUNCTION
DROP INDEXDROP LOGFILE GROUPDROP PROCEDUREDROP FUNCTION
DROP SERVERDROP TABLEDROP TABLESPACEDROP TRIGGER
DROP VIEWRENAME DATABASERENAME TABLE

Data Manipulation Language (DML) Statements

CALLDELETEDOHANDLER
INSERTLOAD DATA INFILEREPLACESELECT
TRUNCATE TABLEUPDATE

MySQL Utility Statements

DESCRIBEEXPLAINHELPUSE

MySQL Transactional and Locking Statements

START TRANSACTIONCOMMITROLLBACKSAVEPOINT
ROLLBACK TO SAVEPOINTLOCK TABLESUNLOCK TABLESSET TRANSACTION
XA Transactions

Account Management Statements

CREATE USERDROP USERGRANTRENAME USER
REVOKESET PASSWORD

Table Maintenance Statements

ANALYZE TABLEBACKUP TABLECHECK TABLECHECKSUM TABLE
OPTIMIZE TABLEREPAIR TABLERESTORE TABLE

Plugin and User-Defined Function Statements

CREATE FUNCTIONDROP FUNCTIONINSTALL PLUGINUNINSTALL PLUGIN

SHOW Statements

SHOW AUTHORS

MySQL Cluster overview

Mon, 2010-03-15 14:19 — oli
Taxonomy upgrade extras: 
mysql cluster

This is a chaotic collection of my MySQL Cluster experience…

MySQL Cluster memory sizing

Mon, 2010-03-15 13:53 — oli
Taxonomy upgrade extras: 
mysql cluster
memory
sizing

MySQL Cluster is pretty fast. The reason for this is, that it is completely memory based. Nowadays memory is still, in contrary to disk, limited to your systems. Thus, before installing a MySQL Cluster you have to calculate the amount of memory you need.

MySQL hints

Mon, 2010-03-15 13:38 — oli
Taxonomy upgrade extras: 
mysql
migration
innodb
hint
primary key
index
prefixed index
sequence
temporary
keyword
auto_increment
memory table

Table of Contents

DBA wisdoms

Mon, 2010-03-15 13:29 — oli
Taxonomy upgrade extras: 
backup
dba
tuning
database administrator

Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook

MySQL trouble shooting

Mon, 2010-03-15 11:46 — oli
Taxonomy upgrade extras: 
trouble shooting
open_files_limit
table_open_cache
limitnofile

Table of Contents

MySQL Questions & Answers

Mon, 2010-03-15 11:15 — oli
Taxonomy upgrade extras: 
backup
restore
recovery
mysql cluster
innodb
monitoring
lvm
myisam
snapshot
compiling
swap

Table of Contents

Search with special characters

This Question has been moved to the Forum.

Limitations of MySQL

Mon, 2010-03-15 11:01 — oli
Taxonomy upgrade extras: 
mysql
mysql cluster
limitation
limitations
galera
general query log

Often asked but informations are spread around: The limitations of MySQL.

MySQL User Defined Function (UDF) collection

Sat, 2010-03-13 21:16 — oli
Taxonomy upgrade extras: 
udf
user-defined function

I really like this new toy called UDF. So I try to provide some more, hopefully useful, functionality.

The handler_read_* status variables

Sat, 2010-03-13 21:06 — oli
Taxonomy upgrade extras: 
mysql
handler
handler interface
status variables
status

Because I do a lot of Performance Tuning gigs I get often in contact with these status variables. In the beginning I had a problem to understand them and now I have a problem to memorize the relation of the name and the meaning. Therefore I wrote this little summary:

Performance Tuning Key for MySQL

Sat, 2010-03-13 20:40 — oli
Taxonomy upgrade extras: 
mysql
performance
tuning

This MySQL Performance Tuning Key should give you a guide how to best tune you MySQL database systematically… It should also work similar for other RDBMS.

Hunting the core

Sat, 2010-03-13 20:32 — oli
Taxonomy upgrade extras: 
debug
trace
core

Core files under Linux

When dealing with MySQL crashes it is very useful to get the core files for further debugging. I have collected all the informations I found about it and wrote it together here:

Reading other processes memory

Sat, 2010-03-13 20:15 — oli
Taxonomy upgrade extras: 
process
memory
debug
trace

As you probably have experienced yet MySQL does not always provide all internal information as you might want to have them and as you are used to have from other RDBMS.

MySQL Monitoring solutions

Sat, 2010-03-13 19:49 — oli
Taxonomy upgrade extras: 
performance tuning
mysql
monitoring
performance monitoring
mytop
innotop

Basic solutions (CLI)

Those solutions are run from the command line (CLI):

FromDual sitemap

Sat, 2010-03-13 19:42 — oli
Taxonomy upgrade extras: 
document
article
summary
overview
content

Performance Tuning, Benchmarking, Capacity Planning and Monitoring

MySQL Database Health Check for MySQL/MariaDB

Profiling MySQL with oprofile

Sat, 2010-03-13 14:26 — oli
Taxonomy upgrade extras: 
mysql
profiling
oprofile
profile

Why is is data load with LOAD DATA INFILE so much faster?

Materialized Views with MySQL

Sat, 2010-03-13 13:55 — oli
Taxonomy upgrade extras: 
mysql
trigger
materialized views
materialised views
sql/psm

Table of Contents

MySQL Federated Storage Engine

Sat, 2010-03-13 13:32 — oli
Taxonomy upgrade extras: 
storage engine
federated tables
general query log

What is a Federated Table?

A Federated Table is a table which points to a table in an other MySQL database instance (mostly on an other server). It can be seen as a view to this remote database table. Other RDBMS have similar concepts for example database links.

FromDual consulting tool collection

Sat, 2010-03-13 11:37 — oli
Taxonomy upgrade extras: 
tool
consulting
memory
san
general query log

The following tools we use sometimes for our consulting engagements…

Pages

Subscribe to RSS - oli's blog