## The service has been successfully running for 24 hours as of posting
[root@DarkServer ~]# systemctl status mysqld.service
mysqld.service - MySQL Server
	  Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
	  Active: active (running) since Mon, 13 Aug 2012 10:27:42 -0700; 24h ago
	Main PID: 234 (mysqld)
	  CGroup: name=systemd:/system/mysqld.service
		  └ 234 /usr/bin/mysqld --user=mysql --pid-file=/run/mysqld/mysqld.pid

Aug 13 10:27:43 DarkServer mysqld[234]: 120813 10:27:42 InnoDB: Completed initialization of buffer pool
Aug 13 10:27:43 DarkServer mysqld[234]: 120813 10:27:43 InnoDB: highest supported file format is Barracuda.
Aug 13 10:27:44 DarkServer mysqld[234]: 120813 10:27:44  InnoDB: Waiting for the background threads to start
Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 InnoDB: 1.1.8 started; log sequence number 1605059
Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 [Note] Recovering after a crash using mysql-bin
Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 [Note] Starting crash recovery...
Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 [Note] Crash recovery finished.
Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 [Note] Event Scheduler: Loaded 0 events
Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 [Note] /usr/bin/mysqld: ready for connections.
Aug 13 10:27:45 DarkServer mysqld[234]: Version: '5.5.27-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  Source distribution

## /run/mysqld Exists
[root@DarkServer ~]# ls /run | grep mysql
mysqld

## I have tmpfile settings for mysql (which come with the aur package)
[root@DarkServer ~]# ls /etc/tmpfiles.d | grep mysql
mysqld.conf

## Contents of my service file
[root@DarkServer ~]# cat /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
After=network.target

[Service]
ExecStart=/usr/bin/mysqld --user=mysql --pid-file=/run/mysqld/mysqld.pid
ExecStop=/bin/kill -15 $MAINPID
PIDFile=/run/mysqld/mysqld.pid
Restart=always

[Install]
WantedBy=multi-user.target


## Contents of my tmpfile config file
[root@DarkServer ~]# cat /etc/tmpfiles.d/mysqld.conf
# systemd tmpfile settings for mysql
# See tmpfiles.d(5) for details

d /run/mysqld 0755 mysql mysql -