## 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 -