Продюсер

Рейтинг

Регистрация

09.11.2010

Проблема с MySQL

26 января 2013, 07:42

MarcusTven:
Кто-то перегрузил вам mysql сервер

У хостера были проблемы..я в курсе этого.....

Сегодня скрипт мне уже говорит:

query_cache_size (> 72M)

Проблемы с Clamav

26 января 2013, 06:38

Если он бесполезен - выключу.

Просто вот например на днях, сделал бекап, скачал на комп, распаковал...

Мой Nod32 начал ругаться на какие-то непонятные скрипты в каталогах с моими сайтами (scripts.php, 1.php и т д ) Как эти файлы попадают на сервер и что они делают не знаю.

Раньше я вообще обнаруживал у себя кучу рекламных страниц, кто-то через какие-то дырки лил это все на мои сайты и продвигал таким образом свои( ченое сео)

Короче после таких страстей задумываешься о хорошей защите.

Проблемы с Clamav

25 января 2013, 19:10

Вот что в логах:

Fri Jan 25 10:22:07 2013 -> SelfCheck: Database status OK.
Fri Jan 25 10:32:08 2013 -> SelfCheck: Database status OK.
Fri Jan 25 10:47:20 2013 -> SelfCheck: Database status OK.
Fri Jan 25 19:59:04 2013 -> +++ Started at Fri Jan 25 19:59:04 2013
Fri Jan 25 19:59:04 2013 -> clamd daemon 0.97.6 (OS: linux-gnu, ARCH: x86_64, CPU: x86_64)
Fri Jan 25 19:59:04 2013 -> Running as user clamav (UID 496, GID 497)
Fri Jan 25 19:59:04 2013 -> Log file size limited to -1 bytes.
Fri Jan 25 19:59:04 2013 -> Reading databases from /var/clamav
Fri Jan 25 19:59:04 2013 -> Not loading PUA signatures.
Fri Jan 25 19:59:04 2013 -> Bytecode: Security mode set to "TrustSigned".
Fri Jan 25 19:59:08 2013 -> Loaded 1670480 signatures.
Fri Jan 25 19:59:08 2013 -> TCP: Bound to address 127.0.0.1 on port 3310
Fri Jan 25 19:59:08 2013 -> TCP: Setting connection queue length to 30
Fri Jan 25 19:59:08 2013 -> LOCAL: Removing stale socket file /var/run/clamav/clamd.sock
Fri Jan 25 19:59:08 2013 -> LOCAL: Unix socket file /var/run/clamav/clamd.sock
Fri Jan 25 19:59:08 2013 -> LOCAL: Setting connection queue length to 30
Fri Jan 25 19:59:08 2013 -> Limits: Global size limit set to 104857600 bytes.
Fri Jan 25 19:59:08 2013 -> Limits: File size limit set to 26214400 bytes.
Fri Jan 25 19:59:08 2013 -> Limits: Recursion level limit set to 16.
Fri Jan 25 19:59:08 2013 -> Limits: Files limit set to 10000.
Fri Jan 25 19:59:08 2013 -> Archive support enabled.
Fri Jan 25 19:59:08 2013 -> Algorithmic detection enabled.
Fri Jan 25 19:59:08 2013 -> Portable Executable support enabled.
Fri Jan 25 19:59:08 2013 -> ELF support enabled.
Fri Jan 25 19:59:08 2013 -> Detection of broken executables enabled.
Fri Jan 25 19:59:08 2013 -> Mail files support enabled.
Fri Jan 25 19:59:08 2013 -> OLE2 support enabled.
Fri Jan 25 19:59:08 2013 -> PDF support enabled.
Fri Jan 25 19:59:08 2013 -> HTML support enabled.
Fri Jan 25 19:59:08 2013 -> Self checking every 600 seconds.
Fri Jan 25 20:09:59 2013 -> No stats for Database check - forcing reload
Fri Jan 25 20:09:59 2013 -> Reading databases from /var/clamav
Fri Jan 25 20:10:04 2013 -> Database correctly reloaded (1670480 signatures)
Fri Jan 25 20:20:04 2013 -> SelfCheck: Database status OK.
Fri Jan 25 20:30:04 2013 -> SelfCheck: Database status OK.
Fri Jan 25 20:40:04 2013 -> SelfCheck: Database status OK.
Fri Jan 25 20:50:04 2013 -> SelfCheck: Database status OK.
Fri Jan 25 21:00:30 2013 -> SelfCheck: Database status OK.
Fri Jan 25 21:10:30 2013 -> SelfCheck: Database status OK.
Fri Jan 25 21:20:30 2013 -> SelfCheck: Database status OK.
Fri Jan 25 21:30:30 2013 -> SelfCheck: Database status OK.
Fri Jan 25 21:40:30 2013 -> SelfCheck: Database status OK.
Fri Jan 25 21:50:30 2013 -> SelfCheck: Database status OK.
Fri Jan 25 22:00:31 2013 -> SelfCheck: Database status OK.
Fri Jan 25 22:10:31 2013 -> SelfCheck: Database status OK.
Fri Jan 25 22:20:31 2013 -> SelfCheck: Database status OK.
Fri Jan 25 22:30:31 2013 -> SelfCheck: Database status OK.
Fri Jan 25 22:40:31 2013 -> SelfCheck: Database status OK.
Fri Jan 25 22:50:32 2013 -> SelfCheck: Database status OK.
Fri Jan 25 23:00:32 2013 -> SelfCheck: Database status OK.

А вообще смысл есть в этом антивирусе?

Проблема с MySQL

25 января 2013, 15:56

несколько дней спустя:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.28
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 365M (Tables: 1073)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 1009K (Tables: 8)
[!!] Total fragmented tables: 48

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 8h 59m 9s (294K q [9.110 qps], 22K conn, TX: 7B, RX: 69M)
[--] Reads / Writes: 78% / 22%
[--] Total buffers: 120.0M global + 2.5M per thread (30 max threads)
[OK] Maximum possible memory usage: 195.0M (38% of installed RAM)
[OK] Slow queries: 0% (0/294K)
[OK] Highest usage of available connections: 13% (4/30)
[OK] Key buffer size / total MyISAM indexes: 32.0M/134.3M
[OK] Key buffer hit rate: 99.8% (6M cached / 13K reads)
[OK] Query cache efficiency: 53.6% (107K cached / 199K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 31K sorts)
[!!] Temporary tables created on disk: 31% (1K on disk / 3K total)
[OK] Thread cache hit rate: 99% (4 created / 22K connections)
[OK] Table cache hit rate: 66% (573 open / 868 opened)
[OK] Open file limit used: 25% (1K/4K)
[OK] Table locks acquired immediately: 99% (218K immediate / 218K locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
tmp_table_size (> 16M)
max_heap_table_size (> 16M)

[root@92 ~]#

Палю тему: как поднять до ТИЦ 100 за 5-10 y.e.

24 января 2013, 12:06

Тоже отписал на почту ТС.

Может что нового узнаю)

Проблема с MySQL

23 января 2013, 15:36

Еще спустя сутки:

[root@92 ~]# ./mysqltuner.pl

>> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.28
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 364M (Tables: 1063)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 1009K (Tables: 8)
[!!] Total fragmented tables: 33

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 20h 35m 5s (674K q [9.103 qps], 53K conn, TX: 18B, RX: 164M)
[--] Reads / Writes: 75% / 25%
[--] Total buffers: 120.0M global + 2.5M per thread (30 max threads)
[OK] Maximum possible memory usage: 195.0M (38% of installed RAM)
[OK] Slow queries: 0% (0/674K)
[OK] Highest usage of available connections: 46% (14/30)
[OK] Key buffer size / total MyISAM indexes: 32.0M/133.0M
[OK] Key buffer hit rate: 99.7% (8M cached / 22K reads)
[OK] Query cache efficiency: 57.2% (257K cached / 450K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (2 temp sorts / 67K sorts)
[OK] Temporary tables created on disk: 25% (1K on disk / 6K total)
[OK] Thread cache hit rate: 99% (33 created / 53K connections)
[OK] Table cache hit rate: 51% (586 open / 1K opened)
[OK] Open file limit used: 25% (1K/4K)
[OK] Table locks acquired immediately: 99% (475K immediate / 475K locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries

Проблема с MySQL

22 января 2013, 19:08

Спасибо за подробную помощь, сделал.

Проблема с MySQL

22 января 2013, 15:18

Вечер, вот так:

[root@92 ~]# ./mysqltuner.pl

>> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.28
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 363M (Tables: 1063)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 1M (Tables: 8)
[!!] Total fragmented tables: 32

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 22h 31m 46s (565K q [6.971 qps], 45K conn, TX: 15B, RX: 134M)
[--] Reads / Writes: 75% / 25%
[--] Total buffers: 96.0M global + 2.5M per thread (40 max threads)
[OK] Maximum possible memory usage: 196.0M (38% of installed RAM)
[OK] Slow queries: 0% (1/565K)
[OK] Highest usage of available connections: 22% (9/40)
[OK] Key buffer size / total MyISAM indexes: 32.0M/132.0M
[OK] Key buffer hit rate: 99.7% (6M cached / 17K reads)
[OK] Query cache efficiency: 55.5% (203K cached / 366K selects)
[!!] Query cache prunes per day: 17436
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 47K sorts)
[OK] Temporary tables created on disk: 15% (764 on disk / 4K total)
[OK] Thread cache hit rate: 99% (9 created / 45K connections)
[OK] Table cache hit rate: 64% (1K open / 1K opened)
[OK] Open file limit used: 53% (2K/4K)
[OK] Table locks acquired immediately: 99% (381K immediate / 381K locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Variables to adjust:
query_cache_size (> 48M)

[root@92 ~]#

Проблема с MySQL

22 января 2013, 03:10

Вот утренние анализы:

[root@92 ~]# ./mysqltuner.pl

>> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.28
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 362M (Tables: 1063)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 1M (Tables: 8)
[!!] Total fragmented tables: 29

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 10h 22m 20s (204K q [5.466 qps], 17K conn, TX: 5B, RX: 45M)
[--] Reads / Writes: 75% / 25%
[--] Total buffers: 96.0M global + 2.5M per thread (40 max threads)
[OK] Maximum possible memory usage: 196.0M (38% of installed RAM)
[OK] Slow queries: 0% (0/204K)
[OK] Highest usage of available connections: 22% (9/40)
[OK] Key buffer size / total MyISAM indexes: 32.0M/131.7M
[OK] Key buffer hit rate: 99.5% (2M cached / 12K reads)
[OK] Query cache efficiency: 54.9% (71K cached / 130K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 15K sorts)
[OK] Temporary tables created on disk: 12% (156 on disk / 1K total)
[OK] Thread cache hit rate: 99% (9 created / 17K connections)
[OK] Table cache hit rate: 82% (1K open / 1K opened)
[OK] Open file limit used: 52% (2K/4K)
[OK] Table locks acquired immediately: 99% (127K immediate / 127K locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries

[root@92 ~]#

Проблема с MySQL

21 января 2013, 16:36

Эти строчки добавить в my.сnf ?

Сделал...через час вывод покажу.

---------- Добавлено 21.01.2013 в 21:51 ----------

Спустя час:

[root@92 ~]# ./mysqltuner.pl

>> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.28
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 362M (Tables: 1063)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 1M (Tables: 8)
[!!] Total fragmented tables: 10

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 1h 4m 31s (20K q [5.200 qps], 1K conn, TX: 542M, RX: 4M)
[--] Reads / Writes: 76% / 24%
[--] Total buffers: 96.0M global + 2.5M per thread (40 max threads)
[OK] Maximum possible memory usage: 196.0M (38% of installed RAM)
[OK] Slow queries: 0% (0/20K)
[OK] Highest usage of available connections: 10% (4/40)
[OK] Key buffer size / total MyISAM indexes: 32.0M/131.5M
[OK] Key buffer hit rate: 97.7% (259K cached / 6K reads)
[OK] Query cache efficiency: 53.1% (6K cached / 13K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1K sorts)
[OK] Temporary tables created on disk: 18% (33 on disk / 181 total)
[OK] Thread cache hit rate: 99% (4 created / 1K connections)
[OK] Table cache hit rate: 93% (544 open / 583 opened)
[OK] Open file limit used: 24% (1K/4K)
[OK] Table locks acquired immediately: 99% (12K immediate / 12K locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries

1 2 3 4 5 6 7 8 9

Всего: 86

В 2023 году Google заблокировал более 170 млн фальшивых отзывов на Картах

Как удалить плохие SEO-ссылки и очистить ссылочную массу сайта

Продюсер