http://revisium.com/ai/
Не уходит почта себе же.
== admin@*****.ru routing defer (-51): retry time not reached delivering 1XmW8q-0006xR-Lg (queue run pid 25329)
Висят письма в очереди.
2014-11-07 19:15:46 Start queue run: pid=26024 2014-11-07 19:15:46 1XmZ1D-0001Ox-Ng == admin@******.ru routing defer (-51): retry time not reached 2014-11-07 19:15:46 1XmfAO-0007wi-5K == admin@******.ru routing defer (-51): retry time not reached 2014-11-07 19:15:46 1XmUg9-00051h-N3 == info@******.ru routing defer (-51): retry time not reached 2014-11-07 19:15:46 1XmS6U-0002Ly-9c == admin@******.ru routing defer (-51): retry time not reached 2014-11-07 19:15:46 1XmYvO-0001Ij-NP == admin@******.ru routing defer (-51): retry time not reached 2014-11-07 19:15:46 1XmUQd-0004kj-M8 == admin@******.com routing defer (-51): retry time not reached 2014-11-07 19:15:46 1XmW8q-0006xR-Lg == admin@******.ru routing defer (-51): retry time not reached 2014-11-07 19:15:46 1XmiG7-0002bH-FM == admin@******.ru routing defer (-51): retry time not reached 2014-11-07 19:15:46 1XmVdh-0006Tp-O6 == admin@******.ru routing defer (-51): retry time not reached 2014-11-07 19:15:46 End queue run: pid=26024
Hostname domen.me
Debian 7 + ISPmanager4
Заранее спасибо за советы.
"докапываются" чуть ли не хлеще директа
таких мало осталось с пассивным охлаждением
Вроде был адекватный человек, парсер сделал за 35$, без авансов, правил в реальном времени, это говорит о том, что секёт в теме.
Две недели как начал пропадать, т.к. у него висит ещё один парсер, но тоже без аванса.
Оплачивал на карту сбербанка:
676196000488555294
Денис Андреевич
Может что случилось у прогера нашего.
InnoDB
innodb_flush_log_at_trx_commit - такого значения нет.
innodb_flush_log_at_trx_commit — имеет три допустимых значения: 0, 1, 2. При значении равном 0, лог сбрасывается на диск один раз в секунду, вне зависимости от происходящих транзакций. При значении равном 1, лог сбрасывается на диск при каждой транзакции. При значении равном 2, лог пишется при каждой транзакции, но не сбрасывается на диск никогда, оставляя это на совести ОС. По умолчанию используется 1, что является самой надежной настройкой, но не самой быстрой. В общем случае вы можете смело использовать 2, данные могут быть утеряны лишь в случае краха ОС и лишь за несколько секунд (зависит от настроек ОС). 0 — самый быстрый режим, но данные могут быть утеряны как при крахе ОС, так и при крахе самого сервера MySQL (впрочем данные лишь за 1-2 секунды).
[mysqld] federated datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 max_connections=64 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5 #log-queries-not-using-indexes slow-query-log=ON tmp_table_size=264M max_heap_table_size=264M innodb_buffer_pool_size=1000M key_buffer_size=260M join_buffer_size=10M thread_cache_size=3096 query_cache_size=250M query_cache_limit=26M innodb_buffer_pool_instances=2 tmpdir=/mysqltmp table_cache=2096 table_definition_cache=2096 #innodb_use_native_aio = 0 innodb_file_per_table [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
[OK] Currently running supported MySQL version 5.5.40-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV +FEDERATED +InnoDB +MRG_MYISAM [--] Data in MyISAM tables: 377M (Tables: 128) [--] Data in InnoDB tables: 648M (Tables: 160) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [--] Data in MEMORY tables: 372K (Tables: 3) [!!] Total fragmented tables: 35 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 4h 29m 24s (200K q [12.412 qps], 11K conn, TX: 4B, RX: 48M) [--] Reads / Writes: 62% / 38% [--] Total buffers: 1.7G global + 12.6M per thread (64 max threads) [OK] Maximum possible memory usage: 2.5G (63% of installed RAM) [OK] Slow queries: 0% (0/200K) [OK] Highest usage of available connections: 10% (7/64) [OK] Key buffer size / total MyISAM indexes: 260.0M/238.1M [OK] Key buffer hit rate: 97.3% (449K cached / 12K reads) [OK] Query cache efficiency: 66.9% (89K cached / 133K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 12K sorts) [!!] Joins performed without indexes: 5132 [!!] Temporary tables created on disk: 46% (5K on disk / 11K total) [OK] Thread cache hit rate: 99% (7 created / 11K connections) [OK] Table cache hit rate: 84% (208 open / 245 opened) [OK] Open file limit used: 3% (131/4K) [OK] Table locks acquired immediately: 99% (139K immediate / 139K locks) [OK] InnoDB buffer pool / data size: 1000.0M/648.8M [OK] InnoDB log waits: 0 -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Adjust your join queries to always utilize indexes Temporary table size is already large - reduce result set size Reduce your SELECT DISTINCT queries without LIMIT clauses Variables to adjust: join_buffer_size (> 10.0M, or always use indexes with joins)
Какие варианты есть ещё кроме бегета?
total used free shared buffers cached Mem: 4096 2409 1686 39 0 1373 -/+ buffers/cache: 1036 3060
Filesystem Size Used Avail Use% Mounted on /dev/simfs 50G 17G 34G 33% /
tmp_table_size=264M tmpdir=/mysqltmp
reboot system boot 2.6.32-042stab09 Mon Nov 3 12:36 - 17:26 (04:49) reboot system boot 2.6.32-042stab09 Fri Oct 31 18:12 - 17:26 (2+23:13) reboot system boot 2.6.32-042stab09 Wed Oct 15 22:32 - 17:26 (18+19:53)
141103 12:36:21 InnoDB: Initializing buffer pool, size = 1000.0M 141103 12:36:21 InnoDB: Completed initialization of buffer pool 141103 12:36:21 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! 141103 12:36:21 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... 141103 12:36:22 InnoDB: Waiting for the background threads to start 141103 12:36:23 InnoDB: 5.5.40 started; log sequence number 697483646 141103 12:36:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 141103 12:36:23 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 141103 12:36:23 [Note] Server socket created on IP: '0.0.0.0'. 141103 12:36:23 [Note] Event Scheduler: Loaded 0 events 141103 12:36:23 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.40-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi 141103 12:36:34 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './nastej_db/xf_session.MYI'; try to repair it 141103 12:36:34 [ERROR] Got an error from thread_id=2, /builddir/build/BUILD/mysql-5.5.40/storage/myisam/mi_write.c:226 141103 12:36:34 [ERROR] MySQL thread id 2, OS thread handle 0x7f0aaf152700, query id 51 localhost nastej_db update INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES ('95d589468317ce6dd4c6d118f596144d', 'a:5:{s:12:\"sessionStart\";i:1415007393;s:2:\"ip\";i:1123632478;s:9:\"userAgent\";s:72:\"Mozilla/5.0 (compatible; Google$ 141103 12:36:51 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './nastej_db/xf_session.MYI'; try to repair it 141103 12:36:51 [ERROR] Got an error from thread_id=4, /builddir/build/BUILD/mysql-5.5.40/storage/myisam/mi_write.c:226 141103 12:36:51 [ERROR] MySQL thread id 4, OS thread handle 0x7f0aaf152700, query id 119 localhost nastej_db update INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES ('ca7a01b458c2b9b0dec748de97e9ca29', 'a:5:{s:12:\"sessionStart\";i:1415007411;s:2:\"ip\";i:1123632478;s:9:\"userAgent\";s:72:\"Mozilla/5.0 (compatible; Google$ 141103 12:37:03 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './nastej_db/xf_session.MYI'; try to repair it 141103 12:37:03 [ERROR] Got an error from thread_id=5, /builddir/build/BUILD/mysql-5.5.40/storage/myisam/mi_write.c:226
