Line 113:
Line 113:
nohup ./apache_memory_usage_show_to_database.sh &
nohup ./apache_memory_usage_show_to_database.sh &
−
6.
+
6.Wait 10 minutes or so while data is written to the database, the check whats been written :
+
+
#mysql
+
+
mysql> use apache_stats
+
+
mysql> select * from performance limit 5;
+
+
+-------+----------+--------------+-----------------+---------------------+
+
| index | mem_used | process_size | processors_used | date |
+
+-------+----------+--------------+-----------------+---------------------+
+
| 1 | 195 | 18 | 11 | 2015-08-18 16:26:48 |
+
| 2 | 195 | 18 | 11 | 2015-08-18 16:27:29 |
+
| 3 | 195 | 18 | 11 | 2015-08-18 16:28:48 |
+
| 4 | 195 | 18 | 11 | 2015-08-18 16:29:29 |
+
| 5 | 195 | 18 | 11 | 2015-08-18 16:30:48 |
+
+-------+----------+--------------+-----------------+---------------------+
+
5 rows in set (0.00 sec)