Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!

MysqlStuff

By: IDarkSniperI on Aug 14th, 2012  |  syntax: None  |  size: 2.23 KB  |  views: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. ## The service has been successfully running for 24 hours as of posting
  2. [root@DarkServer ~]# systemctl status mysqld.service
  3. mysqld.service - MySQL Server
  4.           Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
  5.           Active: active (running) since Mon, 13 Aug 2012 10:27:42 -0700; 24h ago
  6.         Main PID: 234 (mysqld)
  7.           CGroup: name=systemd:/system/mysqld.service
  8.                   └ 234 /usr/bin/mysqld --user=mysql --pid-file=/run/mysqld/mysqld.pid
  9.  
  10. Aug 13 10:27:43 DarkServer mysqld[234]: 120813 10:27:42 InnoDB: Completed initialization of buffer pool
  11. Aug 13 10:27:43 DarkServer mysqld[234]: 120813 10:27:43 InnoDB: highest supported file format is Barracuda.
  12. Aug 13 10:27:44 DarkServer mysqld[234]: 120813 10:27:44  InnoDB: Waiting for the background threads to start
  13. Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 InnoDB: 1.1.8 started; log sequence number 1605059
  14. Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 [Note] Recovering after a crash using mysql-bin
  15. Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 [Note] Starting crash recovery...
  16. Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 [Note] Crash recovery finished.
  17. Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 [Note] Event Scheduler: Loaded 0 events
  18. Aug 13 10:27:45 DarkServer mysqld[234]: 120813 10:27:45 [Note] /usr/bin/mysqld: ready for connections.
  19. Aug 13 10:27:45 DarkServer mysqld[234]: Version: '5.5.27-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  Source distribution
  20.  
  21. ## /run/mysqld Exists
  22. [root@DarkServer ~]# ls /run | grep mysql
  23. mysqld
  24.  
  25. ## I have tmpfile settings for mysql (which come with the aur package)
  26. [root@DarkServer ~]# ls /etc/tmpfiles.d | grep mysql
  27. mysqld.conf
  28.  
  29. ## Contents of my service file
  30. [root@DarkServer ~]# cat /usr/lib/systemd/system/mysqld.service
  31. [Unit]
  32. Description=MySQL Server
  33. After=network.target
  34.  
  35. [Service]
  36. ExecStart=/usr/bin/mysqld --user=mysql --pid-file=/run/mysqld/mysqld.pid
  37. ExecStop=/bin/kill -15 $MAINPID
  38. PIDFile=/run/mysqld/mysqld.pid
  39. Restart=always
  40.  
  41. [Install]
  42. WantedBy=multi-user.target
  43.  
  44.  
  45. ## Contents of my tmpfile config file
  46. [root@DarkServer ~]# cat /etc/tmpfiles.d/mysqld.conf
  47. # systemd tmpfile settings for mysql
  48. # See tmpfiles.d(5) for details
  49.  
  50. d /run/mysqld 0755 mysql mysql -