Performance measurement

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
User avatar
UksusoFF
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 29 Aug 2013, 14:07
Location: Russia, Samara
Contact:

Performance measurement

Postby UksusoFF » 01 Sep 2015, 22:23

Hi! Anyone have any information about count feeds which can be checked by one instance tt-rss.
I understand that direct depends on system requirements VPS/VDS.
Now i'm have 600+ feeds and sometimes mysql server going down (yes on vds also some sites too).

JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: Performance measurement

Postby JustAMacUser » 03 Sep 2015, 03:44

Do you know for sure that MySQL is crashing? I ask because if your system is running low on RAM the out of memory manager (OMM) will start killing processes and usually databases use a lot of memory so are one of the first things to go (i.e. something else could be using all the remaining memory).

I would check your logs to see how things are running. If you're running low on RAM, the OMM should log what's going on in the system log.

If you can keep MySQL running for a few days (or hours) connect as root (MySQL user, not the system root) and run

Code: Select all

SHOW ENGINE INNODB STATUS\G
to see how much memory it's using (reported as "pages" of RAM). Also look for anything unusual such as I/O waits, etc.

InnoDB is pretty memory hungry but MySQL shouldn't actually crash (unless you really are out of RAM, which means set TT-RSS's purge to a shorter duration or add more memory).

User avatar
UksusoFF
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 29 Aug 2013, 14:07
Location: Russia, Samara
Contact:

Re: Performance measurement

Postby UksusoFF » 04 Sep 2015, 21:58

I'm sure because sometimes getting errors from cron:

Code: Select all

PHP Fatal error: Query INSERT INTO ttrss_error_log
                                (errno, errstr, filename, lineno, context, owner_uid, created_at) VALUES
                                (256, 'Query SELECT name, content FROM ttrss_plugin_storage\n WHERE owner_uid = \'1\' failed: Lost connection to MySQL server during query', 'classes/db/mysqli.php', '33', '', NULL, NOW()) failed: MySQL server has gone away in FILE_PATH_REMOVED/classes/db/mysqli.php on line 33
PHP Fatal error: Query INSERT INTO ttrss_error_log
                                (errno, errstr, filename, lineno, context, owner_uid, created_at) VALUES
                                (256, 'Query INSERT INTO ttrss_error_log\n (errno, errstr, filename, lineno, context, owner_uid, created_at) VALUES\n (256, \'Query SELECT name, content FROM ttrss_plugin_storage\\n WHERE owner_uid = \\\'1\\\' failed: Lost connection to MySQL server during query\', \'classes/db/mysqli.php\', \'33\', \'\', NULL, NOW()) failed: MySQL server has gone away', 'classes/db/mysqli.php', '33', '', NULL, NOW()) failed: MySQL server has gone away in FILE_PATH_REMOVED/classes/db/mysqli.php on line 33


Code: Select all

mysql> SHOW ENGINE INNODB STATUS\G
*************************** 1. row ***************************
  Type: InnoDB
  Name:
Status:
=====================================
150904 22:54:26 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 39 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 28790 1_second, 28785 sleeps, 2730 10_second, 1988 background, 1987 flush
srv_master_thread log flush and writes: 28944
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 4526, signal count 6056
Mutex spin waits 21974, rounds 65188, OS waits 264
RW-shared spins 5316, rounds 134288, OS waits 3853
RW-excl spins 417, rounds 16165, OS waits 270
Spin rounds per wait: 2.97 mutex, 25.26 RW-shared, 38.76 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 2622AB15
Purge done for trx's n:o < 2622AB09 undo n:o < 0
History list length 3390
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 21068, OS thread handle 0x7f263bc3bb00, query id 2844783 localhost root
SHOW ENGINE INNODB STATUS
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
757898 OS file reads, 315481 OS file writes, 149452 OS fsyncs
3.69 reads/s, 16384 avg bytes/read, 1.85 writes/s, 0.85 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 3743 merges
merged operations:
 insert 3098, delete mark 5601, delete 213
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 276671, node heap has 185 buffer(s)
963.10 hash searches/s, 694.14 non-hash searches/s
---
LOG
---
Log sequence number 199023757173
Log flushed up to   199023757173
Last checkpoint at  199023755648
0 pending log writes, 0 pending chkp writes
133359 log i/o's done, 0.54 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 137363456; in additional pool allocated 0
Dictionary memory allocated 5485980
Buffer pool size   8191
Free buffers       0
Database pages     8006
Old database pages 2935
Modified db pages  13
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1150799, not young 0
3.77 youngs/s, 0.00 non-youngs/s
Pages read 760495, created 13817, written 242791
3.69 reads/s, 0.10 creates/s, 1.56 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8006, unzip_LRU len: 0
I/O sum[283]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 12881, id 139802139412224, state: sleeping
Number of rows inserted 28246, updated 131006, deleted 22709, read 125398510
0.15 inserts/s, 0.10 updates/s, 0.13 deletes/s, 1110.54 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

1 row in set (0.09 sec)

JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: Performance measurement

Postby JustAMacUser » 04 Sep 2015, 22:37

So based on the log MySQL is definitely crashing, but the point I was trying to get to is why is it crashing... I was suggesting you check your system logs to see if there was an out of memory problem with another process, which could in turn cause MySQL to be terminated.

Nevertheless, your InnoDB buffers are too low. What is your innodb_buffer_pool_size set to? This is the single, biggest factor for performance of InnoDB and should always be set to a higher value than you need (you also need to consider growth, so when you first install TT-RSS you won't need as high of a value as you will after two months of 600+ feeds). Your buffer is too low because you have 0 pages free. This should not cause MySQL to crash, but performance is going to be impacted noticeably.

You also have some disk I/O waits. This, combined with the lack of InnoDB buffers and process termination, makes me wonder if your server is under powered for the number of feeds your processing (plus other sites, as you originally said). Without more information it's difficult to determine though. Do you mind if I ask what CPU and RAM you have available (total, not free)?

(As an aside, your databases probably need to be checked for integrity since crashing could be causing data loss or corruption, but the crashing issue needs to be addressed first.)

What do your system and MySQL logs show at the time you get that cronjob email?

e: Looks like you have 128 MB for buffers based on the report you posted, that's WAY too low for the size of your database. Let us know how much RAM the system has total.

User avatar
UksusoFF
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 29 Aug 2013, 14:07
Location: Russia, Samara
Contact:

Re: Performance measurement

Postby UksusoFF » 05 Sep 2015, 12:00

I can't find innodb_buffer_pool_size value in SHOW STATUS or /etc/mysq/my.cnf

Code: Select all

mysql> SHOW STATUS\G
*************************** 1. row ***************************
Variable_name: Aborted_clients
        Value: 0
*************************** 2. row ***************************
Variable_name: Aborted_connects
        Value: 47
*************************** 3. row ***************************
Variable_name: Binlog_cache_disk_use
        Value: 0
*************************** 4. row ***************************
Variable_name: Binlog_cache_use
        Value: 0
*************************** 5. row ***************************
Variable_name: Binlog_stmt_cache_disk_use
        Value: 0
*************************** 6. row ***************************
Variable_name: Binlog_stmt_cache_use
        Value: 0
*************************** 7. row ***************************
Variable_name: Bytes_received
        Value: 137
*************************** 8. row ***************************
Variable_name: Bytes_sent
        Value: 181
*************************** 9. row ***************************
Variable_name: Com_admin_commands
        Value: 0
*************************** 10. row ***************************
Variable_name: Com_assign_to_keycache
        Value: 0
*************************** 11. row ***************************
Variable_name: Com_alter_db
        Value: 0
*************************** 12. row ***************************
Variable_name: Com_alter_db_upgrade
        Value: 0
*************************** 13. row ***************************
Variable_name: Com_alter_event
        Value: 0
*************************** 14. row ***************************
Variable_name: Com_alter_function
        Value: 0
*************************** 15. row ***************************
Variable_name: Com_alter_procedure
        Value: 0
*************************** 16. row ***************************
Variable_name: Com_alter_server
        Value: 0
*************************** 17. row ***************************
Variable_name: Com_alter_table
        Value: 0
*************************** 18. row ***************************
Variable_name: Com_alter_tablespace
        Value: 0
*************************** 19. row ***************************
Variable_name: Com_analyze
        Value: 0
*************************** 20. row ***************************
Variable_name: Com_begin
        Value: 0
*************************** 21. row ***************************
Variable_name: Com_binlog
        Value: 0
*************************** 22. row ***************************
Variable_name: Com_call_procedure
        Value: 0
*************************** 23. row ***************************
Variable_name: Com_change_db
        Value: 0
*************************** 24. row ***************************
Variable_name: Com_change_master
        Value: 0
*************************** 25. row ***************************
Variable_name: Com_check
        Value: 0
*************************** 26. row ***************************
Variable_name: Com_checksum
        Value: 0
*************************** 27. row ***************************
Variable_name: Com_commit
        Value: 0
*************************** 28. row ***************************
Variable_name: Com_create_db
        Value: 0
*************************** 29. row ***************************
Variable_name: Com_create_event
        Value: 0
*************************** 30. row ***************************
Variable_name: Com_create_function
        Value: 0
*************************** 31. row ***************************
Variable_name: Com_create_index
        Value: 0
*************************** 32. row ***************************
Variable_name: Com_create_procedure
        Value: 0
*************************** 33. row ***************************
Variable_name: Com_create_server
        Value: 0
*************************** 34. row ***************************
Variable_name: Com_create_table
        Value: 0
*************************** 35. row ***************************
Variable_name: Com_create_trigger
        Value: 0
*************************** 36. row ***************************
Variable_name: Com_create_udf
        Value: 0
*************************** 37. row ***************************
Variable_name: Com_create_user
        Value: 0
*************************** 38. row ***************************
Variable_name: Com_create_view
        Value: 0
*************************** 39. row ***************************
Variable_name: Com_dealloc_sql
        Value: 0
*************************** 40. row ***************************
Variable_name: Com_delete
        Value: 0
*************************** 41. row ***************************
Variable_name: Com_delete_multi
        Value: 0
*************************** 42. row ***************************
Variable_name: Com_do
        Value: 0
*************************** 43. row ***************************
Variable_name: Com_drop_db
        Value: 0
*************************** 44. row ***************************
Variable_name: Com_drop_event
        Value: 0
*************************** 45. row ***************************
Variable_name: Com_drop_function
        Value: 0
*************************** 46. row ***************************
Variable_name: Com_drop_index
        Value: 0
*************************** 47. row ***************************
Variable_name: Com_drop_procedure
        Value: 0
*************************** 48. row ***************************
Variable_name: Com_drop_server
        Value: 0
*************************** 49. row ***************************
Variable_name: Com_drop_table
        Value: 0
*************************** 50. row ***************************
Variable_name: Com_drop_trigger
        Value: 0
*************************** 51. row ***************************
Variable_name: Com_drop_user
        Value: 0
*************************** 52. row ***************************
Variable_name: Com_drop_view
        Value: 0
*************************** 53. row ***************************
Variable_name: Com_empty_query
        Value: 0
*************************** 54. row ***************************
Variable_name: Com_execute_sql
        Value: 0
*************************** 55. row ***************************
Variable_name: Com_flush
        Value: 0
*************************** 56. row ***************************
Variable_name: Com_grant
        Value: 0
*************************** 57. row ***************************
Variable_name: Com_ha_close
        Value: 0
*************************** 58. row ***************************
Variable_name: Com_ha_open
        Value: 0
*************************** 59. row ***************************
Variable_name: Com_ha_read
        Value: 0
*************************** 60. row ***************************
Variable_name: Com_help
        Value: 0
*************************** 61. row ***************************
Variable_name: Com_insert
        Value: 0
*************************** 62. row ***************************
Variable_name: Com_insert_select
        Value: 0
*************************** 63. row ***************************
Variable_name: Com_install_plugin
        Value: 0
*************************** 64. row ***************************
Variable_name: Com_kill
        Value: 0
*************************** 65. row ***************************
Variable_name: Com_load
        Value: 0
*************************** 66. row ***************************
Variable_name: Com_lock_tables
        Value: 0
*************************** 67. row ***************************
Variable_name: Com_optimize
        Value: 0
*************************** 68. row ***************************
Variable_name: Com_preload_keys
        Value: 0
*************************** 69. row ***************************
Variable_name: Com_prepare_sql
        Value: 0
*************************** 70. row ***************************
Variable_name: Com_purge
        Value: 0
*************************** 71. row ***************************
Variable_name: Com_purge_before_date
        Value: 0
*************************** 72. row ***************************
Variable_name: Com_release_savepoint
        Value: 0
*************************** 73. row ***************************
Variable_name: Com_rename_table
        Value: 0
*************************** 74. row ***************************
Variable_name: Com_rename_user
        Value: 0
*************************** 75. row ***************************
Variable_name: Com_repair
        Value: 0
*************************** 76. row ***************************
Variable_name: Com_replace
        Value: 0
*************************** 77. row ***************************
Variable_name: Com_replace_select
        Value: 0
*************************** 78. row ***************************
Variable_name: Com_reset
        Value: 0
*************************** 79. row ***************************
Variable_name: Com_resignal
        Value: 0
*************************** 80. row ***************************
Variable_name: Com_revoke
        Value: 0
*************************** 81. row ***************************
Variable_name: Com_revoke_all
        Value: 0
*************************** 82. row ***************************
Variable_name: Com_rollback
        Value: 0
*************************** 83. row ***************************
Variable_name: Com_rollback_to_savepoint
        Value: 0
*************************** 84. row ***************************
Variable_name: Com_savepoint
        Value: 0
*************************** 85. row ***************************
Variable_name: Com_select
        Value: 1
*************************** 86. row ***************************
Variable_name: Com_set_option
        Value: 0
*************************** 87. row ***************************
Variable_name: Com_signal
        Value: 0
*************************** 88. row ***************************
Variable_name: Com_show_authors
        Value: 0
*************************** 89. row ***************************
Variable_name: Com_show_binlog_events
        Value: 0
*************************** 90. row ***************************
Variable_name: Com_show_binlogs
        Value: 0
*************************** 91. row ***************************
Variable_name: Com_show_charsets
        Value: 0
*************************** 92. row ***************************
Variable_name: Com_show_collations
        Value: 0
*************************** 93. row ***************************
Variable_name: Com_show_contributors
        Value: 0
*************************** 94. row ***************************
Variable_name: Com_show_create_db
        Value: 0
*************************** 95. row ***************************
Variable_name: Com_show_create_event
        Value: 0
*************************** 96. row ***************************
Variable_name: Com_show_create_func
        Value: 0
*************************** 97. row ***************************
Variable_name: Com_show_create_proc
        Value: 0
*************************** 98. row ***************************
Variable_name: Com_show_create_table
        Value: 0
*************************** 99. row ***************************
Variable_name: Com_show_create_trigger
        Value: 0
*************************** 100. row ***************************
Variable_name: Com_show_databases
        Value: 0
*************************** 101. row ***************************
Variable_name: Com_show_engine_logs
        Value: 0
*************************** 102. row ***************************
Variable_name: Com_show_engine_mutex
        Value: 0
*************************** 103. row ***************************
Variable_name: Com_show_engine_status
        Value: 0
*************************** 104. row ***************************
Variable_name: Com_show_events
        Value: 0
*************************** 105. row ***************************
Variable_name: Com_show_errors
        Value: 0
*************************** 106. row ***************************
Variable_name: Com_show_fields
        Value: 0
*************************** 107. row ***************************
Variable_name: Com_show_function_status
        Value: 0
*************************** 108. row ***************************
Variable_name: Com_show_grants
        Value: 0
*************************** 109. row ***************************
Variable_name: Com_show_keys
        Value: 0
*************************** 110. row ***************************
Variable_name: Com_show_master_status
        Value: 0
*************************** 111. row ***************************
Variable_name: Com_show_open_tables
        Value: 0
*************************** 112. row ***************************
Variable_name: Com_show_plugins
        Value: 0
*************************** 113. row ***************************
Variable_name: Com_show_privileges
        Value: 0
*************************** 114. row ***************************
Variable_name: Com_show_procedure_status
        Value: 0
*************************** 115. row ***************************
Variable_name: Com_show_processlist
        Value: 0
*************************** 116. row ***************************
Variable_name: Com_show_profile
        Value: 0
*************************** 117. row ***************************
Variable_name: Com_show_profiles
        Value: 0
*************************** 118. row ***************************
Variable_name: Com_show_relaylog_events
        Value: 0
*************************** 119. row ***************************
Variable_name: Com_show_slave_hosts
        Value: 0
*************************** 120. row ***************************
Variable_name: Com_show_slave_status
        Value: 0
*************************** 121. row ***************************
Variable_name: Com_show_status
        Value: 1
*************************** 122. row ***************************
Variable_name: Com_show_storage_engines
        Value: 0
*************************** 123. row ***************************
Variable_name: Com_show_table_status
        Value: 0
*************************** 124. row ***************************
Variable_name: Com_show_tables
        Value: 0
*************************** 125. row ***************************
Variable_name: Com_show_triggers
        Value: 0
*************************** 126. row ***************************
Variable_name: Com_show_variables
        Value: 0
*************************** 127. row ***************************
Variable_name: Com_show_warnings
        Value: 0
*************************** 128. row ***************************
Variable_name: Com_slave_start
        Value: 0
*************************** 129. row ***************************
Variable_name: Com_slave_stop
        Value: 0
*************************** 130. row ***************************
Variable_name: Com_stmt_close
        Value: 0
*************************** 131. row ***************************
Variable_name: Com_stmt_execute
        Value: 0
*************************** 132. row ***************************
Variable_name: Com_stmt_fetch
        Value: 0
*************************** 133. row ***************************
Variable_name: Com_stmt_prepare
        Value: 0
*************************** 134. row ***************************
Variable_name: Com_stmt_reprepare
        Value: 0
*************************** 135. row ***************************
Variable_name: Com_stmt_reset
        Value: 0
*************************** 136. row ***************************
Variable_name: Com_stmt_send_long_data
        Value: 0
*************************** 137. row ***************************
Variable_name: Com_truncate
        Value: 0
*************************** 138. row ***************************
Variable_name: Com_uninstall_plugin
        Value: 0
*************************** 139. row ***************************
Variable_name: Com_unlock_tables
        Value: 0
*************************** 140. row ***************************
Variable_name: Com_update
        Value: 0
*************************** 141. row ***************************
Variable_name: Com_update_multi
        Value: 0
*************************** 142. row ***************************
Variable_name: Com_xa_commit
        Value: 0
*************************** 143. row ***************************
Variable_name: Com_xa_end
        Value: 0
*************************** 144. row ***************************
Variable_name: Com_xa_prepare
        Value: 0
*************************** 145. row ***************************
Variable_name: Com_xa_recover
        Value: 0
*************************** 146. row ***************************
Variable_name: Com_xa_rollback
        Value: 0
*************************** 147. row ***************************
Variable_name: Com_xa_start
        Value: 0
*************************** 148. row ***************************
Variable_name: Compression
        Value: OFF
*************************** 149. row ***************************
Variable_name: Connections
        Value: 46212
*************************** 150. row ***************************
Variable_name: Created_tmp_disk_tables
        Value: 0
*************************** 151. row ***************************
Variable_name: Created_tmp_files
        Value: 83
*************************** 152. row ***************************
Variable_name: Created_tmp_tables
        Value: 0
*************************** 153. row ***************************
Variable_name: Delayed_errors
        Value: 0
*************************** 154. row ***************************
Variable_name: Delayed_insert_threads
        Value: 0
*************************** 155. row ***************************
Variable_name: Delayed_writes
        Value: 0
*************************** 156. row ***************************
Variable_name: Flush_commands
        Value: 1
*************************** 157. row ***************************
Variable_name: Handler_commit
        Value: 0
*************************** 158. row ***************************
Variable_name: Handler_delete
        Value: 0
*************************** 159. row ***************************
Variable_name: Handler_discover
        Value: 0
*************************** 160. row ***************************
Variable_name: Handler_prepare
        Value: 0
*************************** 161. row ***************************
Variable_name: Handler_read_first
        Value: 0
*************************** 162. row ***************************
Variable_name: Handler_read_key
        Value: 0
*************************** 163. row ***************************
Variable_name: Handler_read_last
        Value: 0
*************************** 164. row ***************************
Variable_name: Handler_read_next
        Value: 0
*************************** 165. row ***************************
Variable_name: Handler_read_prev
        Value: 0
*************************** 166. row ***************************
Variable_name: Handler_read_rnd
        Value: 0
*************************** 167. row ***************************
Variable_name: Handler_read_rnd_next
        Value: 0
*************************** 168. row ***************************
Variable_name: Handler_rollback
        Value: 0
*************************** 169. row ***************************
Variable_name: Handler_savepoint
        Value: 0
*************************** 170. row ***************************
Variable_name: Handler_savepoint_rollback
        Value: 0
*************************** 171. row ***************************
Variable_name: Handler_update
        Value: 0
*************************** 172. row ***************************
Variable_name: Handler_write
        Value: 0
*************************** 173. row ***************************
Variable_name: Innodb_buffer_pool_pages_data
        Value: 8014
*************************** 174. row ***************************
Variable_name: Innodb_buffer_pool_bytes_data
        Value: 131301376
*************************** 175. row ***************************
Variable_name: Innodb_buffer_pool_pages_dirty
        Value: 37
*************************** 176. row ***************************
Variable_name: Innodb_buffer_pool_bytes_dirty
        Value: 606208
*************************** 177. row ***************************
Variable_name: Innodb_buffer_pool_pages_flushed
        Value: 522822
*************************** 178. row ***************************
Variable_name: Innodb_buffer_pool_pages_free
        Value: 0
*************************** 179. row ***************************
Variable_name: Innodb_buffer_pool_pages_misc
        Value: 177
*************************** 180. row ***************************
Variable_name: Innodb_buffer_pool_pages_total
        Value: 8191
*************************** 181. row ***************************
Variable_name: Innodb_buffer_pool_read_ahead_rnd
        Value: 0
*************************** 182. row ***************************
Variable_name: Innodb_buffer_pool_read_ahead
        Value: 7232
*************************** 183. row ***************************
Variable_name: Innodb_buffer_pool_read_ahead_evicted
        Value: 323
*************************** 184. row ***************************
Variable_name: Innodb_buffer_pool_read_requests
        Value: 507942396
*************************** 185. row ***************************
Variable_name: Innodb_buffer_pool_reads
        Value: 1759237
*************************** 186. row ***************************
Variable_name: Innodb_buffer_pool_wait_free
        Value: 0
*************************** 187. row ***************************
Variable_name: Innodb_buffer_pool_write_requests
        Value: 2651189
*************************** 188. row ***************************
Variable_name: Innodb_data_fsyncs
        Value: 334155
*************************** 189. row ***************************
Variable_name: Innodb_data_pending_fsyncs
        Value: 0
*************************** 190. row ***************************
Variable_name: Innodb_data_pending_reads
        Value: 0
*************************** 191. row ***************************
Variable_name: Innodb_data_pending_writes
        Value: 0
*************************** 192. row ***************************
Variable_name: Innodb_data_read
        Value: 29057896448
*************************** 193. row ***************************
Variable_name: Innodb_data_reads
        Value: 1766185
*************************** 194. row ***************************
Variable_name: Innodb_data_writes
        Value: 690107
*************************** 195. row ***************************
Variable_name: Innodb_data_written
        Value: 17832398336
*************************** 196. row ***************************
Variable_name: Innodb_dblwr_pages_written
        Value: 522822
*************************** 197. row ***************************
Variable_name: Innodb_dblwr_writes
        Value: 17198
*************************** 198. row ***************************
Variable_name: Innodb_have_atomic_builtins
        Value: ON
*************************** 199. row ***************************
Variable_name: Innodb_log_waits
        Value: 0
*************************** 200. row ***************************
Variable_name: Innodb_log_write_requests
        Value: 1137278
*************************** 201. row ***************************
Variable_name: Innodb_log_writes
        Value: 292919
*************************** 202. row ***************************
Variable_name: Innodb_os_log_fsyncs
        Value: 299846
*************************** 203. row ***************************
Variable_name: Innodb_os_log_pending_fsyncs
        Value: 0
*************************** 204. row ***************************
Variable_name: Innodb_os_log_pending_writes
        Value: 0
*************************** 205. row ***************************
Variable_name: Innodb_os_log_written
        Value: 696994816
*************************** 206. row ***************************
Variable_name: Innodb_page_size
        Value: 16384
*************************** 207. row ***************************
Variable_name: Innodb_pages_created
        Value: 27669
*************************** 208. row ***************************
Variable_name: Innodb_pages_read
        Value: 1773287
*************************** 209. row ***************************
Variable_name: Innodb_pages_written
        Value: 522822
*************************** 210. row ***************************
Variable_name: Innodb_row_lock_current_waits
        Value: 0
*************************** 211. row ***************************
Variable_name: Innodb_row_lock_time
        Value: 69
*************************** 212. row ***************************
Variable_name: Innodb_row_lock_time_avg
        Value: 17
*************************** 213. row ***************************
Variable_name: Innodb_row_lock_time_max
        Value: 57
*************************** 214. row ***************************
Variable_name: Innodb_row_lock_waits
        Value: 4
*************************** 215. row ***************************
Variable_name: Innodb_rows_deleted
        Value: 45863
*************************** 216. row ***************************
Variable_name: Innodb_rows_inserted
        Value: 55495
*************************** 217. row ***************************
Variable_name: Innodb_rows_read
        Value: 234777496
*************************** 218. row ***************************
Variable_name: Innodb_rows_updated
        Value: 292960
*************************** 219. row ***************************
Variable_name: Innodb_truncated_status_writes
        Value: 0
*************************** 220. row ***************************
Variable_name: Key_blocks_not_flushed
        Value: 0
*************************** 221. row ***************************
Variable_name: Key_blocks_unused
        Value: 12918
*************************** 222. row ***************************
Variable_name: Key_blocks_used
        Value: 10129
*************************** 223. row ***************************
Variable_name: Key_read_requests
        Value: 17763933
*************************** 224. row ***************************
Variable_name: Key_reads
        Value: 25003
*************************** 225. row ***************************
Variable_name: Key_write_requests
        Value: 1202520
*************************** 226. row ***************************
Variable_name: Key_writes
        Value: 1139373
*************************** 227. row ***************************
Variable_name: Last_query_cost
        Value: 0.000000
*************************** 228. row ***************************
Variable_name: Max_used_connections
        Value: 18
*************************** 229. row ***************************
Variable_name: Not_flushed_delayed_rows
        Value: 0
*************************** 230. row ***************************
Variable_name: Open_files
        Value: 110
*************************** 231. row ***************************
Variable_name: Open_streams
        Value: 0
*************************** 232. row ***************************
Variable_name: Open_table_definitions
        Value: 400
*************************** 233. row ***************************
Variable_name: Open_tables
        Value: 400
*************************** 234. row ***************************
Variable_name: Opened_files
        Value: 17341
*************************** 235. row ***************************
Variable_name: Opened_table_definitions
        Value: 0
*************************** 236. row ***************************
Variable_name: Opened_tables
        Value: 0
*************************** 237. row ***************************
Variable_name: Performance_schema_cond_classes_lost
        Value: 0
*************************** 238. row ***************************
Variable_name: Performance_schema_cond_instances_lost
        Value: 0
*************************** 239. row ***************************
Variable_name: Performance_schema_file_classes_lost
        Value: 0
*************************** 240. row ***************************
Variable_name: Performance_schema_file_handles_lost
        Value: 0
*************************** 241. row ***************************
Variable_name: Performance_schema_file_instances_lost
        Value: 0
*************************** 242. row ***************************
Variable_name: Performance_schema_locker_lost
        Value: 0
*************************** 243. row ***************************
Variable_name: Performance_schema_mutex_classes_lost
        Value: 0
*************************** 244. row ***************************
Variable_name: Performance_schema_mutex_instances_lost
        Value: 0
*************************** 245. row ***************************
Variable_name: Performance_schema_rwlock_classes_lost
        Value: 0
*************************** 246. row ***************************
Variable_name: Performance_schema_rwlock_instances_lost
        Value: 0
*************************** 247. row ***************************
Variable_name: Performance_schema_table_handles_lost
        Value: 0
*************************** 248. row ***************************
Variable_name: Performance_schema_table_instances_lost
        Value: 0
*************************** 249. row ***************************
Variable_name: Performance_schema_thread_classes_lost
        Value: 0
*************************** 250. row ***************************
Variable_name: Performance_schema_thread_instances_lost
        Value: 0
*************************** 251. row ***************************
Variable_name: Prepared_stmt_count
        Value: 0
*************************** 252. row ***************************
Variable_name: Qcache_free_blocks
        Value: 824
*************************** 253. row ***************************
Variable_name: Qcache_free_memory
        Value: 3867776
*************************** 254. row ***************************
Variable_name: Qcache_hits
        Value: 3139714
*************************** 255. row ***************************
Variable_name: Qcache_inserts
        Value: 1724872
*************************** 256. row ***************************
Variable_name: Qcache_lowmem_prunes
        Value: 528957
*************************** 257. row ***************************
Variable_name: Qcache_not_cached
        Value: 92280
*************************** 258. row ***************************
Variable_name: Qcache_queries_in_cache
        Value: 3650
*************************** 259. row ***************************
Variable_name: Qcache_total_blocks
        Value: 8762
*************************** 260. row ***************************
Variable_name: Queries
        Value: 6017227
*************************** 261. row ***************************
Variable_name: Questions
        Value: 2
*************************** 262. row ***************************
Variable_name: Rpl_status
        Value: AUTH_MASTER
*************************** 263. row ***************************
Variable_name: Select_full_join
        Value: 0
*************************** 264. row ***************************
Variable_name: Select_full_range_join
        Value: 0
*************************** 265. row ***************************
Variable_name: Select_range
        Value: 0
*************************** 266. row ***************************
Variable_name: Select_range_check
        Value: 0
*************************** 267. row ***************************
Variable_name: Select_scan
        Value: 0
*************************** 268. row ***************************
Variable_name: Slave_heartbeat_period
        Value: 0.000
*************************** 269. row ***************************
Variable_name: Slave_open_temp_tables
        Value: 0
*************************** 270. row ***************************
Variable_name: Slave_received_heartbeats
        Value: 0
*************************** 271. row ***************************
Variable_name: Slave_retried_transactions
        Value: 0
*************************** 272. row ***************************
Variable_name: Slave_running
        Value: OFF
*************************** 273. row ***************************
Variable_name: Slow_launch_threads
        Value: 0
*************************** 274. row ***************************
Variable_name: Slow_queries
        Value: 0
*************************** 275. row ***************************
Variable_name: Sort_merge_passes
        Value: 0
*************************** 276. row ***************************
Variable_name: Sort_range
        Value: 0
*************************** 277. row ***************************
Variable_name: Sort_rows
        Value: 0
*************************** 278. row ***************************
Variable_name: Sort_scan
        Value: 0
*************************** 279. row ***************************
Variable_name: Ssl_accept_renegotiates
        Value: 0
*************************** 280. row ***************************
Variable_name: Ssl_accepts
        Value: 0
*************************** 281. row ***************************
Variable_name: Ssl_callback_cache_hits
        Value: 0
*************************** 282. row ***************************
Variable_name: Ssl_cipher
        Value:
*************************** 283. row ***************************
Variable_name: Ssl_cipher_list
        Value:
*************************** 284. row ***************************
Variable_name: Ssl_client_connects
        Value: 0
*************************** 285. row ***************************
Variable_name: Ssl_connect_renegotiates
        Value: 0
*************************** 286. row ***************************
Variable_name: Ssl_ctx_verify_depth
        Value: 0
*************************** 287. row ***************************
Variable_name: Ssl_ctx_verify_mode
        Value: 0
*************************** 288. row ***************************
Variable_name: Ssl_default_timeout
        Value: 0
*************************** 289. row ***************************
Variable_name: Ssl_finished_accepts
        Value: 0
*************************** 290. row ***************************
Variable_name: Ssl_finished_connects
        Value: 0
*************************** 291. row ***************************
Variable_name: Ssl_session_cache_hits
        Value: 0
*************************** 292. row ***************************
Variable_name: Ssl_session_cache_misses
        Value: 0
*************************** 293. row ***************************
Variable_name: Ssl_session_cache_mode
        Value: NONE
*************************** 294. row ***************************
Variable_name: Ssl_session_cache_overflows
        Value: 0
*************************** 295. row ***************************
Variable_name: Ssl_session_cache_size
        Value: 0
*************************** 296. row ***************************
Variable_name: Ssl_session_cache_timeouts
        Value: 0
*************************** 297. row ***************************
Variable_name: Ssl_sessions_reused
        Value: 0
*************************** 298. row ***************************
Variable_name: Ssl_used_session_cache_entries
        Value: 0
*************************** 299. row ***************************
Variable_name: Ssl_verify_depth
        Value: 0
*************************** 300. row ***************************
Variable_name: Ssl_verify_mode
        Value: 0
*************************** 301. row ***************************
Variable_name: Ssl_version
        Value:
*************************** 302. row ***************************
Variable_name: Table_locks_immediate
        Value: 3108271
*************************** 303. row ***************************
Variable_name: Table_locks_waited
        Value: 2
*************************** 304. row ***************************
Variable_name: Tc_log_max_pages_used
        Value: 0
*************************** 305. row ***************************
Variable_name: Tc_log_page_size
        Value: 0
*************************** 306. row ***************************
Variable_name: Tc_log_page_waits
        Value: 0
*************************** 307. row ***************************
Variable_name: Threads_cached
        Value: 7
*************************** 308. row ***************************
Variable_name: Threads_connected
        Value: 1
*************************** 309. row ***************************
Variable_name: Threads_created
        Value: 296
*************************** 310. row ***************************
Variable_name: Threads_running
        Value: 1
*************************** 311. row ***************************
Variable_name: Uptime
        Value: 85560
*************************** 312. row ***************************
Variable_name: Uptime_since_flush_status
        Value: 85560
312 rows in set (0.00 sec)

mysql>

Code: Select all

[email protected]:~# cat /etc/mysql/my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
tsocket         = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
innodb_use_native_aio   = 0
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = XXX.XXX.XXX.XXX
#
# * Fine Tuning
#
key_buffer              = 16M
max_allowed_packet      = 32M
thread_stack            = 189K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
log-error=/var/log/mysql-errors.log
log-slow-queries
log_slow_queries=/var/log/mysql-slow-noindex.log
slow_query_log_file=/var/log/mysql-slow-noindex.log
long_query_time=120
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
#log_slow_queries       = /var/log/mysql/mysql-slow.log
#long_query_time = 2
log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id              = 1
#log_bin                        = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
#binlog_do_db           = include_database_name
#binlog_ignore_db       = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
[email protected]:~#

Top output for

Code: Select all

[email protected]:~# uptime
 12:47:47 up 16 days, 14:37,  1 user,  load average: 0.34, 0.28, 0.24

Code: Select all

top - 12:47:26 up 16 days, 14:37,  1 user,  load average: 0.41, 0.28, 0.24
Tasks:  56 total,   1 running,  55 sleeping,   0 stopped,   0 zombie
%Cpu(s): 21.8 us,  5.5 sy,  0.0 ni, 72.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1048576 total,   824220 used,   224356 free,        0 buffers
KiB Swap:        0 total,        0 used,        0 free,   409004 cached

  PID USER      PR  NI  VIRT  RES  SHR S  %CPU %MEM    TIME+  COMMAND
22660 uksusoff  20   0  249m  25m 4944 S   8.0  2.5   0:00.24 apache2
22661 uksusoff  20   0  250m  26m 4952 S   6.7  2.6   0:00.20 apache2
12881 mysql     20   0  543m 226m 4540 S   2.0 22.2  26:34.40 mysqld
21903 root      20   0  235m 9180  556 S   0.3  0.9   0:00.03 apache2
21993 root      20   0  235m 9180  556 S   0.3  0.9   0:00.03 apache2
22482 root      20   0  235m 9180  556 S   0.3  0.9   0:00.01 apache2
    1 root      20   0 30184  984  284 S   0.0  0.1   0:01.68 init
    2 root      20   0     0    0    0 S   0.0  0.0   0:00.00 kthreadd/5272
    3 root      20   0     0    0    0 S   0.0  0.0   0:00.00 khelper/5272
   86 root      20   0 16988  204    4 S   0.0  0.0   0:00.00 upstart-udev-br
   89 root      20   0 21300  560    4 S   0.0  0.1   0:00.00 udevd
  113 root      20   0 21296  560    4 S   0.0  0.1   0:00.00 udevd
  114 root      20   0 21296  560    4 S   0.0  0.1   0:00.00 udevd
  145 root      20   0 14936  188    4 S   0.0  0.0   0:00.00 upstart-socket-
 1577 root      20   0  111m 4848  524 S   0.0  0.5   0:44.71 rsyslogd
 1678 root      20   0 49888  876  264 S   0.0  0.1   0:05.76 sshd
 1710 root      20   0 19520  208    4 S   0.0  0.0   0:00.00 xinetd
 1746 root      20   0  235m 9000  392 S   0.0  0.9   1:36.71 apache2
 1789 root      20   0 18836  432  184 S   0.0  0.0   0:11.39 cron
 1841 root      20   0  4136  328  180 S   0.0  0.0   0:00.03 mysqld_safe
 2390 bind      20   0  185m  14m 1072 S   0.0  1.5   0:01.11 named
 2677 Debian-e  20   0 97156 1396  260 S   0.0  0.1   0:00.92 exim4
 2726 root      20   0 69748 1076  424 S   0.0  0.1   0:11.10 nmbd
 2741 root      20   0 99916 1608  664 S   0.0  0.2   0:02.91 smbd
 2777 root      20   0 98.1m  948   12 S   0.0  0.1   0:00.00 smbd
 2834 root      20   0 14532  160    4 S   0.0  0.0   0:00.00 getty
 2840 root      20   0 14532  156    4 S   0.0  0.0   0:00.00 getty
 6589 root      20   0  396m  17m 8232 S   0.0  1.7   4:20.25 core
 6750 root      20   0  227m 6580 3072 S   0.0  0.6   1:49.64 core
12660 root      20   0 81204 2012  984 S   0.0  0.2   0:00.08 ihttpd
20498 root      20   0 71216 4020 3204 S   0.0  0.4   0:00.06 sshd
20506 root      20   0 71220 3684 2880 S   0.0  0.4   0:00.00 sshd
20508 root      20   0 12500  948  772 S   0.0  0.1   0:00.00 sftp-server
20509 root      20   0 18516 2864 1684 S   0.0  0.3   0:00.07 bash
20896 root      20   0  235m 9180  556 S   0.0  0.9   0:00.04 apache2
22094 root      20   0  235m 9180  556 S   0.0  0.9   0:00.01 apache2
22151 root      20   0  235m 9180  556 S   0.0  0.9   0:00.01 apache2
22481 root      20   0  235m 9180  556 S   0.0  0.9   0:00.00 apache2
22509 root      20   0  235m 9180  556 S   0.0  0.9   0:00.00 apache2

Now mysql going down infrequently (near one time at month). Here some part of logs near crash:

Code: Select all

[email protected]:~# cat /var/log/mysql-errors.log
150827 18:02:27 mysqld_safe Number of processes running now: 0
150827 18:02:27 mysqld_safe mysqld restarted
150827 18:02:27 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
150827 18:02:27 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
150827 18:02:27 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
150827 18:02:27 [Note] /usr/sbin/mysqld (mysqld 5.5.44-0+deb7u1-log) starting as process 29575 ...
150827 18:02:27 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150827 18:02:27 [Note] Plugin 'FEDERATED' is disabled.
150827 18:02:27 InnoDB: The InnoDB memory heap is disabled
150827 18:02:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150827 18:02:27 InnoDB: Compressed tables use zlib 1.2.7
150827 18:02:27 InnoDB: Initializing buffer pool, size = 128.0M
150827 18:02:27 InnoDB: Completed initialization of buffer pool
150827 18:02:27 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 194280549255
150827 18:02:27  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 194281032354
150827 18:02:28  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
150827 18:02:28  InnoDB: Waiting for the background threads to start
150827 18:02:29 InnoDB: 5.5.44 started; log sequence number 194281032354
/usr/sbin/mysqld: File '/var/log/mysql-slow-noindex.log' not found (Errcode: 13)
150827 18:02:29 [ERROR] Could not use /var/log/mysql-slow-noindex.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
150827 18:02:29 [Note] Server hostname (bind-address): 'XXX.XXX.XXX.XXX'; port: 3306
150827 18:02:29 [Note]   - 'XXX.XXX.XXX.XXX' resolves to 'XXX.XXX.XXX.XXX';
150827 18:02:29 [Note] Server socket created on IP: 'XXX.XXX.XXX.XXX'.
150827 18:02:29 [Note] Event Scheduler: Loaded 0 events
150827 18:02:29 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.44-0+deb7u1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)

JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: Performance measurement

Postby JustAMacUser » 05 Sep 2015, 19:14

Does the MySQL error log show anything just before that 18:02:27 time?

What does system.log show around the same time?

Which MPM are you using in Apache? (If Prefork, post the max. children setting from Apache's conf file.)

The InnoDB buffer size was in the engine status earlier, it's set to its default of 128 MB. It should be set to about 80% of the system RAM (according to the MySQL docs), but that might not leave you enough RAM for Apache. Given that you have a large TT-RSS install, you'll definitely need to increase the value, you could even start with 256 MB.

I don't have anywhere near 600 feeds but my install with 50+ causes MySQL to need about 192 MB for InnoDB buffers. So... A 1 GB system that's also serving other web sites might not be enough.

Experience has shown me PostgreSQL is a lot better with memory and performance, you may want to consider that if your other sites don't need a database (or MySQL specifically). Migration will suck, but the end result will be worth it.

In general, it looks like the machine needs to be optimized a bit, but it would still be nice to isolate the cause of the MySQL crash. Post the answers to the above questions and we'll go from there.

User avatar
UksusoFF
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 29 Aug 2013, 14:07
Location: Russia, Samara
Contact:

Re: Performance measurement

Postby UksusoFF » 08 Sep 2015, 09:18

I'll waiting next crash for providing syslog.

Code: Select all

[email protected]:~# cat /etc/php5/apache2/php.ini | grep max
; max_input_time
; Turning on this setting and managing its maximum buffer size can yield some
;   Integer = Enables the buffer and sets its maximum size in bytes.
; http://php.net/max-execution-time
max_execution_time = 60
; http://php.net/max-input-time
max_input_time = 60
; http://php.net/max-input-nesting-level
;max_input_nesting_level = 64
; max_input_vars = 1000
; Set maximum length of log_errors. In error_log information about the source is
; added. The default is 1024 and 0 allows to not apply any maximum length at all.
; http://php.net/log-errors-max-len
log_errors_max_len = 1024
; http://php.net/post-max-size
post_max_size = 100M
; http://php.net/upload-max-filesize
upload_max_filesize = 100M
max_file_uploads = 100
; http://php.net/odbc.max-persistent
odbc.max_persistent = -1
; http://php.net/odbc.max-links
odbc.max_links = -1
;birdstep.max_links = -1
ibase.max_persistent = -1
ibase.max_links = -1
; http://php.net/mysql.max-persistent
mysql.max_persistent = -1
; http://php.net/mysql.max-links
mysql.max_links = -1
; http://php.net/mysqli.max-persistent
mysqli.max_persistent = -1
; http://php.net/mysqli.max-links
mysqli.max_links = -1
; Connection: The maximum number of persistent OCI8 connections per
; http://php.net/oci8.max-persistent
;oci8.max_persistent = -1
; Connection: The maximum number of seconds a process is allowed to
; http://php.net/pgsql.max-persistent
pgsql.max_persistent = -1
; http://php.net/pgsql.max-links
pgsql.max_links = -1
; http://php.net/sybct.max-persistent
sybct.max_persistent = -1
; http://php.net/sybct.max-links
sybct.max_links = -1
; The maximum time in seconds to wait for a connection attempt to succeed before returning failure.
; http://php.net/session.gc-maxlifetime
session.gc_maxlifetime = 1440
;       setting session.gc_maxlifetime to 1440 (1440 seconds = 24 minutes):
mssql.max_persistent = -1
mssql.max_links = -1
; Specify max number of processes. -1 = library default
;mssql.max_procs = -1
; Sets the maximum number of open links or -1 for unlimited.
ldap.max_links = -1
[email protected]:~#

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Performance measurement

Postby fox » 08 Sep 2015, 09:46

i don't see how crashing mysql is relevant to this forum

please go somewhere else for support

User avatar
UksusoFF
Bear Rating Trainee
Bear Rating Trainee
Posts: 14
Joined: 29 Aug 2013, 14:07
Location: Russia, Samara
Contact:

Re: Performance measurement

Postby UksusoFF » 08 Sep 2015, 18:39

fox wrote:i don't see how crashing mysql is relevant to this forum

please go somewhere else for support

So I only want to hear about performance requirements for tt-rss if anyone have much more feeds in one instance. :(


Return to “Support”

Who is online

Users browsing this forum: No registered users and 8 guests