Падает MariaDB

MySQL, PostgreSQL, InterBaseSQL etc

Модераторы: Art.i, vasya

Падает MariaDB

Сообщение radudu99 » Вт апр 19, 2016 4:32 pm

Добрый день.

Использую сервер FirstVDS - MariaDB Server

Ну вот проблема такова

Если заходят на сайт более 10 человек машка падает и нужно перезагружать.

как ее настроить что-бы не падала?

простой тест http://host-tracker.com/ и все..

Домен для проверки http://best-chisinau.org/


Помогите решить данную задачу...

Ну и прикрепляю лог машы

Код: выделить все
160416 13:08:06 mysqld_safe Number of processes running now: 0
160416 13:08:06 mysqld_safe mysqld restarted
160416 13:08:06 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 14022 ...
160416 13:08:06 InnoDB: The InnoDB memory heap is disabled
160416 13:08:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160416 13:08:06 InnoDB: Compressed tables use zlib 1.2.7
160416 13:08:06 InnoDB: Using Linux native AIO
160416 13:08:06 InnoDB: Initializing buffer pool, size = 128.0M
160416 13:08:06 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
160416 13:09:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160416 13:09:04 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 17015 ...
160416 13:09:04 InnoDB: The InnoDB memory heap is disabled
160416 13:09:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160416 13:09:04 InnoDB: Compressed tables use zlib 1.2.7
160416 13:09:04 InnoDB: Using Linux native AIO
160416 13:09:04 InnoDB: Initializing buffer pool, size = 128.0M
160416 13:09:04 InnoDB: Completed initialization of buffer pool
160416 13:09:04 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
160416 13:09:04  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...
160416 13:09:04  InnoDB: Waiting for the background threads to start
160416 13:09:05 Percona XtraDB (http://www.percona.com) 5.5.43-MariaDB-37.2 started; log sequence number 72174983
160416 13:09:05 [Note] Plugin 'FEEDBACK' is disabled.
160416 13:09:05 [Note] Server socket created on IP: '0.0.0.0'.
160416 13:09:05 [Note] Event Scheduler: Loaded 0 events
160416 13:09:05 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
160416 13:09:24 [ERROR] mysqld: Table './beest1/wp_options' is marked as crashed and should be repaired
160416 13:09:24 [Warning] Checking table:   './beest1/wp_options'
160416 13:17:07 [ERROR] mysqld: Table './beest1/wp_3_options' is marked as crashed and should be repaired
160416 13:17:07 [Warning] Checking table:   './beest1/wp_3_options'
160416 13:30:58 [Warning] IP address '123.57.5.206' could not be resolved: Name or service not known
160416 13:56:37 mysqld_safe Number of processes running now: 0
160416 13:56:37 mysqld_safe mysqld restarted
160416 13:56:37 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 23194 ...
160416 13:56:37 InnoDB: The InnoDB memory heap is disabled
160416 13:56:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160416 13:56:37 InnoDB: Compressed tables use zlib 1.2.7
160416 13:56:37 InnoDB: Using Linux native AIO
160416 13:56:37 InnoDB: Initializing buffer pool, size = 128.0M
160416 13:56:37 InnoDB: Completed initialization of buffer pool
160416 13:56:37 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 72824522
160416 13:56:37  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 72826638
160416 13:56:38  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
160416 13:56:38  InnoDB: Waiting for the background threads to start
160416 13:56:39 Percona XtraDB (http://www.percona.com) 5.5.43-MariaDB-37.2 started; log sequence number 72826638
160416 13:56:39 [Note] Plugin 'FEEDBACK' is disabled.
160416 13:56:39 [Note] Server socket created on IP: '0.0.0.0'.
160416 13:56:39 [Note] Event Scheduler: Loaded 0 events
160416 13:56:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
160416 13:57:06 [ERROR] mysqld: Table './beest1/wp_options' is marked as crashed and should be repaired
160416 13:57:06 [Warning] Checking table:   './beest1/wp_options'
160416 14:04:56 [ERROR] mysqld: Table './beest1/wp_3_options' is marked as crashed and should be repaired
160416 14:04:56 [Warning] Checking table:   './beest1/wp_3_options'
160416 14:04:56 [ERROR] mysqld: Table './beest1/wp_3_comments' is marked as crashed and should be repaired
160416 14:04:56 [Warning] Checking table:   './beest1/wp_3_comments'
160416 14:07:50 mysqld_safe Number of processes running now: 0
160416 14:07:50 mysqld_safe mysqld restarted
160416 14:07:50 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 3261 ...
160416 14:07:50 InnoDB: The InnoDB memory heap is disabled
160416 14:07:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160416 14:07:50 InnoDB: Compressed tables use zlib 1.2.7
160416 14:07:50 InnoDB: Using Linux native AIO
160416 14:07:50 InnoDB: Initializing buffer pool, size = 128.0M
160416 14:07:50 InnoDB: Completed initialization of buffer pool
160416 14:07:50 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 73019746
160416 14:07:50  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 73023895
160416 14:07:50  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
160416 14:07:50  InnoDB: Waiting for the background threads to start
160416 14:07:51 Percona XtraDB (http://www.percona.com) 5.5.43-MariaDB-37.2 started; log sequence number 73023895
160416 14:07:52 [Note] Plugin 'FEEDBACK' is disabled.
160416 14:07:52 [Note] Server socket created on IP: '0.0.0.0'.
160416 14:07:52 [Note] Event Scheduler: Loaded 0 events
160416 14:07:52 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
160416 14:07:52 [ERROR] mysqld: Table './beest1/wp_3_options' is marked as crashed and should be repaired
160416 14:07:52 [Warning] Checking table:   './beest1/wp_3_options'
160416 14:13:06 mysqld_safe Number of processes running now: 0
160416 14:13:06 mysqld_safe mysqld restarted
160416 14:13:06 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 5716 ...
160416 14:13:06 InnoDB: The InnoDB memory heap is disabled
160416 14:13:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160416 14:13:06 InnoDB: Compressed tables use zlib 1.2.7
160416 14:13:06 InnoDB: Using Linux native AIO
160416 14:13:06 InnoDB: Initializing buffer pool, size = 128.0M
160416 14:13:06 InnoDB: Completed initialization of buffer pool
160416 14:13:06 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
160416 14:13:06  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...
160416 14:13:06  InnoDB: Waiting for the background threads to start
160416 14:13:07 Percona XtraDB (http://www.percona.com) 5.5.43-MariaDB-37.2 started; log sequence number 73126026
160416 14:13:07 [Note] Plugin 'FEEDBACK' is disabled.
160416 14:13:07 [Note] Server socket created on IP: '0.0.0.0'.
160416 14:13:07 [Note] Event Scheduler: Loaded 0 events
160416 14:13:07 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
160416 14:13:34 [ERROR] mysqld: Table './beest1/wp_options' is marked as crashed and should be repaired
160416 14:13:34 [Warning] Checking table:   './beest1/wp_options'
160416 14:16:23 [ERROR] mysqld: Table './beest1/wp_3_options' is marked as crashed and should be repaired
160416 14:16:23 [Warning] Checking table:   './beest1/wp_3_options'
160416 14:48:38 [Warning] IP address '122.114.115.69' could not be resolved: Name or service not known
160416 20:01:07 [Warning] IP address '103.38.42.216' could not be resolved: Name or service not known
160416 20:17:59 [Warning] IP address '180.225.203.220' could not be resolved: Name or service not known
160417  2:36:27 [Warning] IP address '58.221.71.102' could not be resolved: Name or service not known
160417  3:12:34 [Warning] IP address '210.16.189.72' could not be resolved: Name or service not known
160417  5:43:45 [Warning] IP address '198.55.103.192' has been resolved to the host name '198.55.103.192.static.quadranet.com', which resembles IPv4-address itself.
160417 13:45:34 [Warning] IP address '114.112.90.54' could not be resolved: Name or service not known
160417 18:13:23 [Warning] IP address '122.192.64.175' could not be resolved: Name or service not known
160417 18:13:25 [Warning] IP address '122.192.64.175' could not be resolved: Name or service not known
160417 18:29:36 [Warning] IP address '4.30.232.20' could not be resolved: Name or service not known
160417 20:28:38 [Warning] IP address '222.186.57.154' could not be resolved: Name or service not known
160418  3:09:43 [Warning] IP address '123.57.5.206' could not be resolved: Name or service not known
160418  3:14:24 [Warning] IP address '59.46.52.150' could not be resolved: Name or service not known
160418 10:04:34 mysqld_safe Number of processes running now: 0
160418 10:04:34 mysqld_safe mysqld restarted
160418 10:04:35 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 15182 ...
160418 10:04:35 InnoDB: The InnoDB memory heap is disabled
160418 10:04:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160418 10:04:35 InnoDB: Compressed tables use zlib 1.2.7
160418 10:04:35 InnoDB: Using Linux native AIO
160418 10:04:35 InnoDB: Initializing buffer pool, size = 128.0M
160418 10:04:35 InnoDB: Completed initialization of buffer pool
160418 10:04:35 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
160418 10:05:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160418 10:05:03 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 16723 ...
160418 10:05:03 InnoDB: The InnoDB memory heap is disabled
160418 10:05:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160418 10:05:03 InnoDB: Compressed tables use zlib 1.2.7
160418 10:05:03 InnoDB: Using Linux native AIO
160418 10:05:03 InnoDB: Initializing buffer pool, size = 128.0M
160418 10:05:03 InnoDB: Completed initialization of buffer pool
160418 10:05:03 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
160418 10:05:03  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...
160418 10:05:06  InnoDB: Waiting for the background threads to start
160418 10:05:07 Percona XtraDB (http://www.percona.com) 5.5.43-MariaDB-37.2 started; log sequence number 73645221
160418 10:05:07 [Note] Plugin 'FEEDBACK' is disabled.
160418 10:05:07 [Note] Server socket created on IP: '0.0.0.0'.
160418 10:05:08 [Note] Event Scheduler: Loaded 0 events
160418 10:05:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
160418 10:05:08 [ERROR] mysqld: Table './beest1/wp_posts' is marked as crashed and should be repaired
160418 10:05:08 [ERROR] mysqld: Table './beest1/wp_posts' is marked as crashed and should be repaired
160418 10:05:08 [ERROR] mysqld: Table './beest1/wp_posts' is marked as crashed and should be repaired
160418 10:05:08 [Warning] Checking table:   './beest1/wp_posts'
160418 10:05:09 [ERROR] mysqld: Table './beest1/wp_postmeta' is marked as crashed and should be repaired
160418 10:05:09 [ERROR] mysqld: Table './beest1/wp_postmeta' is marked as crashed and should be repaired
160418 10:05:09 [Warning] Checking table:   './beest1/wp_postmeta'
160418 10:05:09 [ERROR] mysqld: Table './beest1/wp_options' is marked as crashed and should be repaired
160418 10:05:09 [Warning] Checking table:   './beest1/wp_options'
160418 10:05:45 [ERROR] mysqld: Table './beest1/wp_sitemeta' is marked as crashed and should be repaired
160418 10:05:45 [Warning] Checking table:   './beest1/wp_sitemeta'
160418 10:05:45 [ERROR] mysqld: Table './beest1/wp_usermeta' is marked as crashed and should be repaired
160418 10:05:45 [Warning] Checking table:   './beest1/wp_usermeta'
160418 10:05:45 [ERROR] mysqld: Table './beest1/wp_3_options' is marked as crashed and should be repaired
160418 10:05:45 [Warning] Checking table:   './beest1/wp_3_options'
160418 10:11:59 [ERROR] mysqld: Table './beest1/wp_3_posts' is marked as crashed and should be repaired
160418 10:11:59 [Warning] Checking table:   './beest1/wp_3_posts'
160418 10:32:10 [ERROR] mysqld: Table './beest1/wp_3_comments' is marked as crashed and should be repaired
160418 10:32:10 [Warning] Checking table:   './beest1/wp_3_comments'
160418 12:34:52 [Warning] IP address '103.56.112.155' could not be resolved: Name or service not known
160418 14:42:24 [Warning] IP address '155.94.148.162' has been resolved to the host name '155.94.148.162.static.quadranet.com', which resembles IPv4-address itself.
160418 16:47:57 [Warning] IP address '139.129.93.18' could not be resolved: Name or service not known
160418 17:48:14 [Warning] IP address '122.192.64.175' could not be resolved: Name or service not known
160418 23:57:42 [Warning] IP address '113.10.155.53' could not be resolved: Name or service not known
radudu99
 
Сообщений: 3
Зарегистрирован: Вт апр 19, 2016 4:16 pm

Re: Падает MariaDB

Сообщение ls » Вт апр 19, 2016 4:44 pm

dmesg посмотрите, также top / free -m во время когда создаете нагрузку
Памяти, возможно, свободной нет
* FirstVDS в twitter в facebook и в вконтакте *
ls
Support team
 
Сообщений: 6388
Зарегистрирован: Чт мар 01, 2007 10:36 am
Откуда: FirstVDS

Re: Падает MariaDB

Сообщение radudu99 » Вт апр 19, 2016 4:47 pm

ls писал(а):dmesg посмотрите, также top / free -m во время когда создаете нагрузку
Памяти, возможно, свободной нет


Вот
Код: выделить все
 ~]# dmesg
 OOM killed process 30718 (httpd) score 54 vm:549788kB, rss:27900kB, swap:0kB
[5811229.467987] Out of memory in UB 18574: OOM killed process 28827 (httpd) score 16 vm:528684kB, rss:7804kB, swap:0kB
[5811229.493596] Out of memory in UB 18574: OOM killed process 30721 (httpd) score 18 vm:531148kB, rss:9112kB, swap:0kB
[5811229.530489] Out of memory in UB 18574: OOM killed process 28828 (httpd) score 16 vm:528684kB, rss:7824kB, swap:0kB
[5811994.673458] Out of memory in UB 18574: OOM killed process 31703 (mysqld) score 0 vm:1544424kB, rss:85992kB, swap:0kB
[5811995.407763] Out of memory in UB 18574: OOM killed process 6421 (mysqld) score 0 vm:537492kB, rss:54576kB, swap:0kB
[5813102.951561] Out of memory in UB 18574: OOM killed process 15192 (mysqld) score 0 vm:1209540kB, rss:86136kB, swap:0kB
[5813104.049785] Out of memory in UB 18574: OOM killed process 21285 (httpd) score 0 vm:556520kB, rss:34972kB, swap:0kB
[5813104.703934] Out of memory in UB 18574: OOM killed process 21288 (httpd) score 0 vm:556264kB, rss:34620kB, swap:0kB
[5813105.041002] Out of memory in UB 18574: OOM killed process 21397 (mysqld) score 0 vm:430396kB, rss:41020kB, swap:0kB
[5813105.352565] Out of memory in UB 18574: OOM killed process 21291 (httpd) score 0 vm:556264kB, rss:34764kB, swap:0kB
[5813105.666291] Out of memory in UB 18574: OOM killed process 21297 (httpd) score 0 vm:553700kB, rss:32304kB, swap:0kB
[5813106.069498] Out of memory in UB 18574: OOM killed process 21312 (httpd) score 0 vm:549788kB, rss:28796kB, swap:0kB
[5813535.858086] Out of memory in UB 18574: OOM killed process 22840 (mysqld) score 0 vm:1208956kB, rss:85976kB, swap:0kB
[5813536.733773] Out of memory in UB 18574: OOM killed process 26432 (httpd) score 0 vm:556520kB, rss:35040kB, swap:0kB
[5813536.936572] Out of memory in UB 18574: OOM killed process 26513 (mysqld) score 0 vm:426376kB, rss:36056kB, swap:0kB
[5813537.840914] Out of memory in UB 18574: OOM killed process 26434 (httpd) score 0 vm:556264kB, rss:34920kB, swap:0kB
[5813538.194303] Out of memory in UB 18574: OOM killed process 26437 (httpd) score 0 vm:556264kB, rss:34872kB, swap:0kB
[5813539.058026] Out of memory in UB 18574: OOM killed process 26440 (httpd) score 0 vm:553700kB, rss:32632kB, swap:0kB
[5813539.213118] Out of memory in UB 18574: OOM killed process 26442 (httpd) score 0 vm:553700kB, rss:32552kB, swap:0kB
[5813539.505229] Out of memory in UB 18574: OOM killed process 26445 (httpd) score 0 vm:553700kB, rss:32568kB, swap:0kB
[5813539.896483] Out of memory in UB 18574: OOM killed process 26447 (httpd) score 0 vm:553700kB, rss:32600kB, swap:0kB
[5813540.338049] Out of memory in UB 18574: OOM killed process 26449 (httpd) score 0 vm:553700kB, rss:32580kB, swap:0kB
[5813540.547744] OOM killer in rage, 1 tasks killed
[5813540.547944] Out of memory in UB 18574: OOM killed process 26454 (httpd) score 0 vm:549788kB, rss:28524kB, swap:0kB
[5813578.232000] Out of memory in UB 18574: OOM killed process 27662 (mysqld) score 0 vm:1208080kB, rss:84780kB, swap:0kB
[5813580.382122] Out of memory in UB 18574: OOM killed process 27706 (httpd) score 0 vm:556264kB, rss:35020kB, swap:0kB
[5813582.749868] Out of memory in UB 18574: OOM killed process 27799 (mysqld) score 0 vm:1073504kB, rss:80760kB, swap:0kB
[5813584.095911] Out of memory in UB 18574: OOM killed process 27845 (mysqld) score 0 vm:1205452kB, rss:80132kB, swap:0kB
[5813585.376252] Out of memory in UB 18574: OOM killed process 27887 (mysqld) score 0 vm:739028kB, rss:71704kB, swap:0kB
[5813664.233447] Out of memory in UB 18574: OOM killed process 28770 (mysqld) score 0 vm:2427940kB, rss:275188kB, swap:0kB
[5813665.936821] Out of memory in UB 18574: OOM killed process 28856 (mysqld) score 0 vm:2230456kB, rss:272320kB, swap:0kB
[5813666.697742] Out of memory in UB 18574: OOM killed process 28926 (mysqld) score 0 vm:1899288kB, rss:253972kB, swap:0kB
[5815886.489488] Out of memory in UB 18574: OOM killed process 29791 (mysqld) score 0 vm:2493476kB, rss:276416kB, swap:0kB


Код: выделить все
]# free -m
              total        used        free      shared  buff/cache   available
Mem:            512          93         330           8          87         300
Swap:             0           0           0
radudu99
 
Сообщений: 3
Зарегистрирован: Вт апр 19, 2016 4:16 pm

Re: Падает MariaDB

Сообщение radudu99 » Вт апр 19, 2016 5:03 pm

да памяти нет. но а как оптимизировать то? есть идеи?
radudu99
 
Сообщений: 3
Зарегистрирован: Вт апр 19, 2016 4:16 pm

Re: Падает MariaDB

Сообщение ls » Чт апр 21, 2016 4:15 am

Занимает всю память судя по всему apache, настройте в нем ограничения
MaxClients 25
вполне хватит
* FirstVDS в twitter в facebook и в вконтакте *
ls
Support team
 
Сообщений: 6388
Зарегистрирован: Чт мар 01, 2007 10:36 am
Откуда: FirstVDS


Вернуться в Базы данных

Кто сейчас на форуме

Сейчас этот форум просматривают: нет зарегистрированных пользователей и гости: 4