ReSQL.ru
     
powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Мобильная версия    Контакт    Правила    FAQ    Помощь
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр
Форумы / MySQL [игнор отключен] [закрыт для гостей] / django останавливает Mysql
9 сообщений из 9, страница 1 из 1
django останавливает Mysql
    #39034750
serrrgggeee
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
serrrgggeee
Гость
Здравствуйте, у меня виртуальный хостинг, на нем два сайта один php другой python. Здесь работает связка nginx + mysql. И в данном случае mysql работает только с php, но работал и с сайтом django python, но потом когда начались проблемы я его перевел на sqlite. А проблемы вот в чем когда я запуская сервер на котором работает djangо и не важно это manage.py runserver это тестовый сервер или uwsgi то при их запуске останавливается mysql, хотя сайт уже не использует мускл. Я понимаю что проблема в коде django, но я так думаю можно узнать причину остановки из логов mysql, поэтому обращаюсь сюда. Поэтому вылаживаю настройки и логи, буду признателен за помощь.
Код: powershell
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.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
#
# 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            = 3307
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]
socket          = /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            = 3307
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1
#
# * Fine Tuning
#
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 20 #8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP
max_connections        = 100   #
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 10M #1
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
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#slow_query_log = 1
#slow_query_log_file = /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      = 36M #/16

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

[isamchk]
key_buffer              = 36M #/16

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#


innodb_buffer_pool_size=4G
innodb_buffer_pool_instances=2
innodb_read_io_threads=12
innodb_write_io_threads=12
innodb_io_capacity=300
innodb_log_file_size=128M
innodb_flush_method            = O_DIRECT
innodb_log_files_in_group      = 2
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table          = 1

!includedir /etc/mysql/conf.d/





Код: powershell
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.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
root@crackkc:/var/log/mysql# cat error.log
2015-08-24 01:35:09 13904 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 01:35:09 13904 [ERROR] Function 'innodb' already exists
2015-08-24 01:35:09 13904 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 01:35:09 13904 [ERROR] Function 'federated' already exists
2015-08-24 01:35:09 13904 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 01:35:09 13904 [ERROR] Function 'blackhole' already exists
2015-08-24 01:35:09 13904 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 01:35:09 13904 [ERROR] Function 'archive' already exists
2015-08-24 01:35:09 13904 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 01:35:09 13904 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 01:35:09 13904 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 01:35:09 13904 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 01:35:09 13904 [Note] InnoDB: Memory barrier is not used
2015-08-24 01:35:09 13904 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 01:35:09 13904 [Note] InnoDB: Using Linux native AIO
2015-08-24 01:35:09 13904 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 01:35:09 13904 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 01:35:09 13904 [Note] InnoDB: Completed initialization of buffer pool
2015-08-24 01:35:09 13904 [Note] InnoDB: Highest supported file format is Barracuda.
2015-08-24 01:35:09 13904 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-24 01:35:09 13904 [Note] InnoDB: Waiting for purge to start
2015-08-24 01:35:09 13904 [Note] InnoDB: 5.6.25 started; log sequence number 54580288
2015-08-24 01:35:09 13904 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2015-08-24 01:35:09 13904 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2015-08-24 01:35:09 13904 [Note] Server socket created on IP: '127.0.0.1'.
2015-08-24 01:35:09 13904 [Note] Event Scheduler: Loaded 0 events
2015-08-24 01:35:09 13904 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.25-1~dotdeb+7.1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
2015-08-24 01:35:15 14034 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 01:35:15 14034 [ERROR] Function 'innodb' already exists
2015-08-24 01:35:15 14034 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 01:35:15 14034 [ERROR] Function 'federated' already exists
2015-08-24 01:35:15 14034 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 01:35:15 14034 [ERROR] Function 'blackhole' already exists
2015-08-24 01:35:15 14034 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 01:35:15 14034 [ERROR] Function 'archive' already exists
2015-08-24 01:35:15 14034 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 01:35:15 14034 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 01:35:15 14034 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 01:35:15 14034 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 01:35:15 14034 [Note] InnoDB: Memory barrier is not used
2015-08-24 01:35:15 14034 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 01:35:15 14034 [Note] InnoDB: Using Linux native AIO
2015-08-24 01:35:15 14034 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 01:35:15 14034 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 01:35:15 14034 [Note] InnoDB: Completed initialization of buffer pool
2015-08-24 01:35:16 14067 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 01:35:16 14067 [ERROR] Function 'innodb' already exists
2015-08-24 01:35:16 14067 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 01:35:16 14067 [ERROR] Function 'federated' already exists
2015-08-24 01:35:16 14067 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 01:35:16 14067 [ERROR] Function 'blackhole' already exists
2015-08-24 01:35:16 14067 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 01:35:16 14067 [ERROR] Function 'archive' already exists
2015-08-24 01:35:16 14067 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 01:35:16 14067 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 01:35:16 14067 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 01:35:16 14067 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 01:35:16 14067 [Note] InnoDB: Memory barrier is not used
2015-08-24 01:35:16 14067 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 01:35:16 14067 [Note] InnoDB: Using Linux native AIO
2015-08-24 01:35:16 14067 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 01:35:16 14067 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 01:35:16 14067 [Note] InnoDB: Completed initialization of buffer pool
2015-08-24 02:20:53 14239 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 02:20:53 14239 [ERROR] Function 'innodb' already exists
2015-08-24 02:20:53 14239 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 02:20:53 14239 [ERROR] Function 'federated' already exists
2015-08-24 02:20:53 14239 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 02:20:53 14239 [ERROR] Function 'blackhole' already exists
2015-08-24 02:20:53 14239 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 02:20:53 14239 [ERROR] Function 'archive' already exists
2015-08-24 02:20:53 14239 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 02:20:53 14239 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 02:20:53 14239 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 02:20:53 14239 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 02:20:53 14239 [Note] InnoDB: Memory barrier is not used
2015-08-24 02:20:53 14239 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 02:20:53 14239 [Note] InnoDB: Using Linux native AIO
2015-08-24 02:20:53 14239 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 02:20:53 14239 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 02:20:54 14271 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 02:20:54 14271 [ERROR] Function 'innodb' already exists
2015-08-24 02:20:54 14271 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 02:20:54 14271 [ERROR] Function 'federated' already exists
2015-08-24 02:20:54 14271 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 02:20:54 14271 [ERROR] Function 'blackhole' already exists
2015-08-24 02:20:54 14271 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 02:20:54 14271 [ERROR] Function 'archive' already exists
2015-08-24 02:20:54 14271 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 02:20:54 14271 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 02:20:54 14271 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 02:20:54 14271 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 02:20:54 14271 [Note] InnoDB: Memory barrier is not used
2015-08-24 02:20:54 14271 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 02:20:54 14271 [Note] InnoDB: Using Linux native AIO
2015-08-24 02:20:54 14271 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 02:20:54 14271 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 02:20:55 14303 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 02:20:55 14303 [ERROR] Function 'innodb' already exists
2015-08-24 02:20:55 14303 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 02:20:55 14303 [ERROR] Function 'federated' already exists
2015-08-24 02:20:55 14303 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 02:20:55 14303 [ERROR] Function 'blackhole' already exists
2015-08-24 02:20:55 14303 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 02:20:55 14303 [ERROR] Function 'archive' already exists
2015-08-24 02:20:55 14303 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 02:20:55 14303 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 02:20:55 14303 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 02:20:55 14303 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 02:20:55 14303 [Note] InnoDB: Memory barrier is not used
2015-08-24 02:20:55 14303 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 02:20:55 14303 [Note] InnoDB: Using Linux native AIO
2015-08-24 02:20:55 14303 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 02:20:55 14303 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 02:21:04 14340 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 02:21:04 14340 [ERROR] Function 'innodb' already exists
2015-08-24 02:21:04 14340 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 02:21:04 14340 [ERROR] Function 'federated' already exists
2015-08-24 02:21:04 14340 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 02:21:04 14340 [ERROR] Function 'blackhole' already exists
2015-08-24 02:21:04 14340 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 02:21:04 14340 [ERROR] Function 'archive' already exists
2015-08-24 02:21:04 14340 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 02:21:04 14340 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 02:21:04 14340 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 02:21:04 14340 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 02:21:04 14340 [Note] InnoDB: Memory barrier is not used
2015-08-24 02:21:04 14340 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 02:21:04 14340 [Note] InnoDB: Using Linux native AIO
2015-08-24 02:21:04 14340 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 02:21:04 14340 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 02:21:04 14340 [Note] InnoDB: Completed initialization of buffer pool
2015-08-24 02:21:04 14340 [Note] InnoDB: Highest supported file format is Barracuda.
2015-08-24 02:21:04 14340 [Note] InnoDB: The log sequence numbers 54580288 and 54580288 in ibdata files do not match the log sequence number 54580298 in the ib_logfiles!
2015-08-24 02:21:04 14340 [Note] InnoDB: Database was not shutdown normally!
2015-08-24 02:21:04 14340 [Note] InnoDB: Starting crash recovery.
2015-08-24 02:21:04 14340 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-08-24 02:21:04 14340 [Note] InnoDB: Restoring possible half-written data pages 
2015-08-24 02:21:04 14340 [Note] InnoDB: from the doublewrite buffer...
2015-08-24 02:21:04 14340 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-24 02:21:04 14340 [Note] InnoDB: Waiting for purge to start
2015-08-24 02:21:04 14340 [Note] InnoDB: 5.6.25 started; log sequence number 54580298
2015-08-24 02:21:04 14340 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
2015-08-24 02:21:04 14340 [Note] Starting crash recovery...
2015-08-24 02:21:04 14340 [Note] Crash recovery finished.
2015-08-24 02:21:04 14340 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3307
2015-08-24 02:21:04 14340 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2015-08-24 02:21:04 14340 [Note] Server socket created on IP: '127.0.0.1'.
2015-08-24 02:21:04 14340 [Note] Event Scheduler: Loaded 0 events
2015-08-24 02:21:04 14340 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.25-1~dotdeb+7.1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3307  (Debian)
2015-08-24 02:22:20 14468 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 02:22:20 14468 [ERROR] Function 'innodb' already exists
2015-08-24 02:22:20 14468 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 02:22:20 14468 [ERROR] Function 'federated' already exists
2015-08-24 02:22:20 14468 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 02:22:20 14468 [ERROR] Function 'blackhole' already exists
2015-08-24 02:22:20 14468 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 02:22:20 14468 [ERROR] Function 'archive' already exists
2015-08-24 02:22:20 14468 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 02:22:20 14468 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 02:22:20 14468 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 02:22:20 14468 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 02:22:20 14468 [Note] InnoDB: Memory barrier is not used
2015-08-24 02:22:20 14468 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 02:22:20 14468 [Note] InnoDB: Using Linux native AIO
2015-08-24 02:22:20 14468 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 02:22:20 14468 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 02:22:20 14468 [Note] InnoDB: Completed initialization of buffer pool
2015-08-24 02:22:21 14505 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 02:22:21 14505 [ERROR] Function 'innodb' already exists
2015-08-24 02:22:21 14505 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 02:22:21 14505 [ERROR] Function 'federated' already exists
2015-08-24 02:22:21 14505 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 02:22:21 14505 [ERROR] Function 'blackhole' already exists
2015-08-24 02:22:21 14505 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 02:22:21 14505 [ERROR] Function 'archive' already exists
2015-08-24 02:22:21 14505 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 02:22:21 14505 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 02:22:21 14505 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 02:22:21 14505 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 02:22:21 14505 [Note] InnoDB: Memory barrier is not used
2015-08-24 02:22:21 14505 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 02:22:21 14505 [Note] InnoDB: Using Linux native AIO
2015-08-24 02:22:21 14505 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 02:22:21 14505 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 02:24:56 14546 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 02:24:56 14546 [ERROR] Function 'innodb' already exists
2015-08-24 02:24:56 14546 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 02:24:56 14546 [ERROR] Function 'federated' already exists
2015-08-24 02:24:56 14546 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 02:24:56 14546 [ERROR] Function 'blackhole' already exists
2015-08-24 02:24:56 14546 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 02:24:56 14546 [ERROR] Function 'archive' already exists
2015-08-24 02:24:56 14546 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 02:24:56 14546 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 02:24:56 14546 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 02:24:56 14546 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 02:24:56 14546 [Note] InnoDB: Memory barrier is not used
2015-08-24 02:24:56 14546 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 02:24:56 14546 [Note] InnoDB: Using Linux native AIO
2015-08-24 02:24:56 14546 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 02:24:56 14546 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 02:24:56 14546 [Note] InnoDB: Completed initialization of buffer pool
2015-08-24 02:24:56 14546 [Note] InnoDB: Highest supported file format is Barracuda.
2015-08-24 02:24:56 14546 [Note] InnoDB: The log sequence numbers 54580288 and 54580288 in ibdata files do not match the log sequence number 54580308 in the ib_logfiles!
2015-08-24 02:24:56 14546 [Note] InnoDB: Database was not shutdown normally!
2015-08-24 02:24:56 14546 [Note] InnoDB: Starting crash recovery.
2015-08-24 02:24:56 14546 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-08-24 02:24:56 14546 [Note] InnoDB: Restoring possible half-written data pages 
2015-08-24 02:24:56 14546 [Note] InnoDB: from the doublewrite buffer...
2015-08-24 02:24:56 14546 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-24 02:24:56 14546 [Note] InnoDB: Waiting for purge to start
2015-08-24 02:24:56 14546 [Note] InnoDB: 5.6.25 started; log sequence number 54580308
2015-08-24 02:24:56 14546 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
2015-08-24 02:24:56 14546 [Note] Starting crash recovery...
2015-08-24 02:24:56 14546 [Note] Crash recovery finished.
2015-08-24 02:24:56 14546 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3307
2015-08-24 02:24:56 14546 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2015-08-24 02:24:56 14546 [Note] Server socket created on IP: '127.0.0.1'.
2015-08-24 02:24:56 14546 [Note] Event Scheduler: Loaded 0 events
2015-08-24 02:24:56 14546 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.25-1~dotdeb+7.1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3307  (Debian)
2015-08-24 02:25:02 14677 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 02:25:02 14677 [ERROR] Function 'innodb' already exists
2015-08-24 02:25:02 14677 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 02:25:02 14677 [ERROR] Function 'federated' already exists
2015-08-24 02:25:02 14677 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 02:25:02 14677 [ERROR] Function 'blackhole' already exists
2015-08-24 02:25:02 14677 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 02:25:02 14677 [ERROR] Function 'archive' already exists
2015-08-24 02:25:02 14677 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 02:25:02 14677 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 02:25:02 14677 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 02:25:02 14677 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 02:25:02 14677 [Note] InnoDB: Memory barrier is not used
2015-08-24 02:25:02 14677 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 02:25:02 14677 [Note] InnoDB: Using Linux native AIO
2015-08-24 02:25:02 14677 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 02:25:02 14677 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 02:25:02 14677 [Note] InnoDB: Completed initialization of buffer pool
2015-08-24 02:25:02 14710 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 02:25:02 14710 [ERROR] Function 'innodb' already exists
2015-08-24 02:25:02 14710 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 02:25:02 14710 [ERROR] Function 'federated' already exists
2015-08-24 02:25:02 14710 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 02:25:02 14710 [ERROR] Function 'blackhole' already exists
2015-08-24 02:25:02 14710 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 02:25:02 14710 [ERROR] Function 'archive' already exists
2015-08-24 02:25:02 14710 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 02:25:02 14710 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 02:25:02 14710 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 02:25:02 14710 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 02:25:02 14710 [Note] InnoDB: Memory barrier is not used
2015-08-24 02:25:02 14710 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 02:25:02 14710 [Note] InnoDB: Using Linux native AIO
2015-08-24 02:25:02 14710 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 02:25:02 14710 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 02:25:02 14710 [Note] InnoDB: Completed initialization of buffer pool
2015-08-24 02:25:19 14767 [Note] Plugin 'FEDERATED' is disabled.
2015-08-24 02:25:19 14767 [ERROR] Function 'innodb' already exists
2015-08-24 02:25:19 14767 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-24 02:25:19 14767 [ERROR] Function 'federated' already exists
2015-08-24 02:25:19 14767 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-24 02:25:19 14767 [ERROR] Function 'blackhole' already exists
2015-08-24 02:25:19 14767 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-24 02:25:19 14767 [ERROR] Function 'archive' already exists
2015-08-24 02:25:19 14767 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-24 02:25:19 14767 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-24 02:25:19 14767 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-24 02:25:19 14767 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-24 02:25:19 14767 [Note] InnoDB: Memory barrier is not used
2015-08-24 02:25:19 14767 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-24 02:25:19 14767 [Note] InnoDB: Using Linux native AIO
2015-08-24 02:25:19 14767 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-24 02:25:19 14767 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-24 02:25:19 14767 [Note] InnoDB: Completed initialization of buffer pool
2015-08-24 02:25:19 14767 [Note] InnoDB: Highest supported file format is Barracuda.
2015-08-24 02:25:19 14767 [Note] InnoDB: The log sequence numbers 54580288 and 54580288 in ibdata files do not match the log sequence number 54580318 in the ib_logfiles!
2015-08-24 02:25:19 14767 [Note] InnoDB: Database was not shutdown normally!
2015-08-24 02:25:19 14767 [Note] InnoDB: Starting crash recovery.
2015-08-24 02:25:19 14767 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-08-24 02:25:19 14767 [Note] InnoDB: Restoring possible half-written data pages 
2015-08-24 02:25:19 14767 [Note] InnoDB: from the doublewrite buffer...
2015-08-24 02:25:20 14767 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-24 02:25:20 14767 [Note] InnoDB: Waiting for purge to start
2015-08-24 02:25:20 14767 [Note] InnoDB: 5.6.25 started; log sequence number 54580318
2015-08-24 02:25:20 14767 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
2015-08-24 02:25:20 14767 [Note] Starting crash recovery...
2015-08-24 02:25:20 14767 [Note] Crash recovery finished.
2015-08-24 02:25:20 14767 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3307
2015-08-24 02:25:20 14767 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2015-08-24 02:25:20 14767 [Note] Server socket created on IP: '127.0.0.1'.
2015-08-24 02:25:20 14767 [Note] Event Scheduler: Loaded 0 events
2015-08-24 02:25:20 14767 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.25-1~dotdeb+7.1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3307  (Debian)
root@crackkc:/var/log/mysql#



Код: powershell
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.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
root@crackkc:/var/log/mysql# cat mysql.log
/usr/sbin/mysqld, Version: 5.6.25-1~dotdeb+7.1-log ((Debian)). started with:
Tcp port: 3307  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
150824  3:33:27     1 Connect   debian-sys-maint@localhost on 
                    1 Quit
                    2 Connect   debian-sys-maint@localhost on mysql
                    2 Query     select @@version_comment limit 1
                    2 Query     SET SQL_LOG_BIN=0
                    2 Query     show variables like 'datadir'
                    2 Quit
                    3 Connect   debian-sys-maint@localhost on 
                    3 Query     select @@version_comment limit 1
                    3 Query     SELECT count(*) FROM mysql.user WHERE user='root' and password=''
                    3 Quit
                    4 Connect   debian-sys-maint@localhost on 
                    4 Query     select @@version_comment limit 1
                    4 Query     select concat('select count(*) into @discard from `',
                    TABLE_SCHEMA, '`.`', TABLE_NAME, '`') 
      from information_schema.TABLES where ENGINE='MyISAM'
                    4 Quit
                    5 Connect   debian-sys-maint@localhost on 
                    5 Query     select @@version_comment limit 1
                    5 Query     select count(*) into @discard from `information_schema`.`COLUMNS`
                    5 Quit
                    6 Connect   debian-sys-maint@localhost on 
                    6 Query     select @@version_comment limit 1
                    6 Query     select count(*) into @discard from `information_schema`.`EVENTS`
                    6 Quit
                    7 Connect   debian-sys-maint@localhost on 
                    7 Query     select @@version_comment limit 1
                    7 Query     select count(*) into @discard from `information_schema`.`OPTIMIZER_TRACE`
                    7 Quit
                    8 Connect   debian-sys-maint@localhost on 
                    8 Query     select @@version_comment limit 1
                    8 Query     select count(*) into @discard from `information_schema`.`PARAMETERS`
                    8 Quit
                    9 Connect   debian-sys-maint@localhost on 
                    9 Query     select @@version_comment limit 1
                    9 Query     select count(*) into @discard from `information_schema`.`PARTITIONS`
                    9 Quit
                   10 Connect   debian-sys-maint@localhost on 
                   10 Query     select @@version_comment limit 1
                   10 Query     select count(*) into @discard from `information_schema`.`PLUGINS`
                   10 Quit
                   11 Connect   debian-sys-maint@localhost on 
                   11 Query     select @@version_comment limit 1
                   11 Query     select count(*) into @discard from `information_schema`.`PROCESSLIST`
                   11 Quit
                   12 Connect   debian-sys-maint@localhost on 
                   12 Query     select @@version_comment limit 1
                   12 Query     select count(*) into @discard from `information_schema`.`ROUTINES`
                   12 Quit
                   13 Connect   debian-sys-maint@localhost on 
                   13 Query     select @@version_comment limit 1
                   13 Query     select count(*) into @discard from `information_schema`.`TRIGGERS`
                   13 Quit
                   14 Connect   debian-sys-maint@localhost on 
                   14 Query     select @@version_comment limit 1
                   14 Query     select count(*) into @discard from `information_schema`.`VIEWS`
                   14 Quit
                   15 Connect   debian-sys-maint@localhost on 
                   15 Query     select @@version_comment limit 1
                   15 Query     select count(*) into @discard from `mysql`.`columns_priv`
                   15 Quit
                   16 Connect   debian-sys-maint@localhost on 
                   16 Query     select @@version_comment limit 1
                   16 Query     select count(*) into @discard from `mysql`.`db`
                   16 Quit
                   17 Connect   debian-sys-maint@localhost on 
                   17 Query     select @@version_comment limit 1
                   17 Query     select count(*) into @discard from `mysql`.`event`
                   17 Quit
                   18 Connect   debian-sys-maint@localhost on 
                   18 Query     select @@version_comment limit 1
                   18 Query     select count(*) into @discard from `mysql`.`func`
                   18 Quit
                   19 Connect   debian-sys-maint@localhost on 
                   19 Query     select @@version_comment limit 1
                   19 Query     select count(*) into @discard from `mysql`.`help_category`
                   19 Quit
                   20 Connect   debian-sys-maint@localhost on 
                   20 Query     select @@version_comment limit 1
                   20 Query     select count(*) into @discard from `mysql`.`help_keyword`
                   20 Quit
                   21 Connect   debian-sys-maint@localhost on 
                   21 Query     select @@version_comment limit 1
                   21 Query     select count(*) into @discard from `mysql`.`help_relation`
                   21 Quit
                   22 Connect   debian-sys-maint@localhost on 
                   22 Query     select @@version_comment limit 1
                   22 Query     select count(*) into @discard from `mysql`.`help_topic`
                   22 Quit
                   23 Connect   debian-sys-maint@localhost on 
                   23 Query     select @@version_comment limit 1
                   23 Query     select count(*) into @discard from `mysql`.`ndb_binlog_index`
                   23 Quit
                   24 Connect   debian-sys-maint@localhost on 
                   24 Query     select @@version_comment limit 1
                   24 Query     select count(*) into @discard from `mysql`.`plugin`
                   24 Quit
                   25 Connect   debian-sys-maint@localhost on 
                   25 Query     select @@version_comment limit 1
                   25 Query     select count(*) into @discard from `mysql`.`proc`
                   25 Quit
                   26 Connect   debian-sys-maint@localhost on 
                   26 Query     select @@version_comment limit 1
                   26 Query     select count(*) into @discard from `mysql`.`procs_priv`
                   26 Quit
                   27 Connect   debian-sys-maint@localhost on 
                   27 Query     select @@version_comment limit 1
                   27 Query     select count(*) into @discard from `mysql`.`proxies_priv`
                   27 Quit
                   28 Connect   debian-sys-maint@localhost on 
                   28 Query     select @@version_comment limit 1
                   28 Query     select count(*) into @discard from `mysql`.`servers`
                   28 Quit
                   29 Connect   debian-sys-maint@localhost on 
                   29 Query     select @@version_comment limit 1
                   29 Query     select count(*) into @discard from `mysql`.`tables_priv`
                   29 Quit
                   30 Connect   debian-sys-maint@localhost on 
                   30 Query     select @@version_comment limit 1
                   30 Query     select count(*) into @discard from `mysql`.`time_zone`
                   30 Quit
                   31 Connect   debian-sys-maint@localhost on 
                   31 Query     select @@version_comment limit 1
                   31 Query     select count(*) into @discard from `mysql`.`time_zone_leap_second`
                   31 Quit
                   32 Connect   debian-sys-maint@localhost on 
                   32 Query     select @@version_comment limit 1
                   32 Query     select count(*) into @discard from `mysql`.`time_zone_name`
                   32 Quit
                   33 Connect   debian-sys-maint@localhost on 
                   33 Query     select @@version_comment limit 1
                   33 Query     select count(*) into @discard from `mysql`.`time_zone_transition`
                   33 Quit
                   34 Connect   debian-sys-maint@localhost on 
                   34 Query     select @@version_comment limit 1
                   34 Query     select count(*) into @discard from `mysql`.`time_zone_transition_type`
                   34 Quit
                   35 Connect   debian-sys-maint@localhost on 
                   35 Query     select @@version_comment limit 1
                   35 Query     select count(*) into @discard from `mysql`.`user`
                   35 Quit
                   36 Connect   debian-sys-maint@localhost on 
                   36 Query     select @@version_comment limit 1
                   36 Query     select count(*) into @discard from `niws`.`catalog`
                   36 Quit
                   37 Connect   debian-sys-maint@localhost on 
                   37 Query     select @@version_comment limit 1
                   37 Query     select count(*) into @discard from `niws`.`comments`
                   37 Quit
                   38 Connect   debian-sys-maint@localhost on 
                   38 Query     select @@version_comment limit 1
                   38 Query     select count(*) into @discard from `niws`.`content`
                   38 Quit
                   39 Connect   debian-sys-maint@localhost on 
                   39 Query     select @@version_comment limit 1
                   39 Query     select count(*) into @discard from `niws`.`forum`
                   39 Quit
                   40 Connect   debian-sys-maint@localhost on 
                   40 Query     select @@version_comment limit 1
                   40 Query     select count(*) into @discard from `niws`.`mail`
                   40 Quit
                   41 Connect   debian-sys-maint@localhost on 
                   41 Query     select @@version_comment limit 1
                   41 Query     select count(*) into @discard from `niws`.`menu`
                   41 Quit
                   42 Connect   debian-sys-maint@localhost on 
                   42 Query     select @@version_comment limit 1
                   42 Query     select count(*) into @discard from `niws`.`news`
                   42 Quit
                   43 Connect   debian-sys-maint@localhost on 
                   43 Query     select @@version_comment limit 1
                   43 Query     select count(*) into @discard from `niws`.`pages`
                   43 Quit
                   44 Connect   debian-sys-maint@localhost on 
                   44 Query     select @@version_comment limit 1
                   44 Query     select count(*) into @discard from `niws`.`user_admin`
                   44 Quit
                   45 Connect   debian-sys-maint@localhost on 
                   45 Query     select @@version_comment limit 1
                   45 Query     select count(*) into @discard from `phpmyadmin`.`pma_bookmark`
                   45 Quit
                   46 Connect   debian-sys-maint@localhost on 
                   46 Query     select @@version_comment limit 1
                   46 Query     select count(*) into @discard from `phpmyadmin`.`pma_column_info`
                   46 Quit
                   47 Connect   debian-sys-maint@localhost on 
                   47 Query     select @@version_comment limit 1
                   47 Query     select count(*) into @discard from `phpmyadmin`.`pma_designer_coords`
                   47 Quit
                   48 Connect   debian-sys-maint@localhost on 
                   48 Query     select @@version_comment limit 1
                   48 Query     select count(*) into @discard from `phpmyadmin`.`pma_history`
                   48 Quit
                   49 Connect   debian-sys-maint@localhost on 
                   49 Query     select @@version_comment limit 1
                   49 Query     select count(*) into @discard from `phpmyadmin`.`pma_pdf_pages`
                   49 Quit
                   50 Connect   debian-sys-maint@localhost on 
                   50 Query     select @@version_comment limit 1
                   50 Query     select count(*) into @discard from `phpmyadmin`.`pma_relation`
                   50 Quit
                   51 Connect   debian-sys-maint@localhost on 
                   51 Query     select @@version_comment limit 1
                   51 Query     select count(*) into @discard from `phpmyadmin`.`pma_table_coords`
                   51 Quit
                   52 Connect   debian-sys-maint@localhost on 
                   52 Query     select @@version_comment limit 1
                   52 Query     select count(*) into @discard from `phpmyadmin`.`pma_table_info`
                   52 Quit
                   53 Connect   debian-sys-maint@localhost on 
                   53 Query     select @@version_comment limit 1
                   53 Query     select count(*) into @discard from `phpmyadmin`.`pma_tracking`
                   53 Quit
                   54 Connect   debian-sys-maint@localhost on 
                   54 Query     select @@version_comment limit 1
                   54 Query     select count(*) into @discard from `phpmyadmin`.`pma_userconfig`
                   54 Quit
150824  3:33:29    55 Connect   root@localhost on 
                   55 Init DB   niws
                   55 Query     SET NAMES utf8
                   55 Query     SELECT *
FROM (`menu`)
WHERE `id` =  '88'
                   55 Query     SELECT *
FROM (`menu`)
WHERE `id_mom` =  '22'
ORDER BY `order` ASC
                   55 Query     SELECT *
FROM (`menu`)
WHERE `id` =  '88'
                   55 Query     SELECT *
FROM (`menu`)
ORDER BY `order` ASC
                   55 Query     SELECT *
FROM (`catalog`)
WHERE `cat` =  '88'
ORDER BY `id` DESC
                   55 Query     SELECT *
FROM (`menu`)
WHERE `url` =  '1'
ORDER BY `order` ASC
                   56 Connect   root@localhost on 
                   56 Init DB   niws
                   56 Query     SET NAMES utf8
                   56 Query     SELECT *
FROM (`pages`)
WHERE `name` =  'main'
                   56 Query     SELECT *
FROM (`menu`)
ORDER BY `order` ASC
                   56 Query     SELECT *
FROM (`menu`)
WHERE `id_mom` =  '22'
ORDER BY `order` ASC
                   56 Query     SELECT *
FROM (`content`)
WHERE `cat` =  'main'
                   56 Query     SELECT *
FROM (`catalog`)
WHERE `tip_text` =  'history'
ORDER BY `id` DESC
LIMIT 2
                   56 Query     SELECT *
FROM (`catalog`)
WHERE `tip_text` =  'open'
ORDER BY `id` DESC
LIMIT 2
                   56 Query     SELECT *
FROM (`catalog`)
WHERE `tip_text` =  'ludi'
ORDER BY `id` DESC
LIMIT 2
/usr/sbin/mysqld, Version: 5.6.25-1~dotdeb+7.1-log ((Debian)). started with:
Tcp port: 3307  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
150824  3:33:59     1 Connect   debian-sys-maint@localhost on 
                    1 Quit
                    2 Connect   debian-sys-maint@localhost on mysql
                    2 Query     select @@version_comment limit 1
                    2 Query     SET SQL_LOG_BIN=0
                    2 Query     show variables like 'datadir'
                    2 Quit
                    3 Connect   debian-sys-maint@localhost on 
                    3 Query     select @@version_comment limit 1
                    3 Query     SELECT count(*) FROM mysql.user WHERE user='root' and password=''
                    3 Quit
                    4 Connect   debian-sys-maint@localhost on 
                    4 Query     select @@version_comment limit 1
                    4 Query     select concat('select count(*) into @discard from `',
                    TABLE_SCHEMA, '`.`', TABLE_NAME, '`') 
      from information_schema.TABLES where ENGINE='MyISAM'
                    4 Quit
                    5 Connect   debian-sys-maint@localhost on 
                    5 Query     select @@version_comment limit 1
                    5 Query     select count(*) into @discard from `information_schema`.`COLUMNS`
                    5 Quit
                    6 Connect   debian-sys-maint@localhost on 
                    6 Query     select @@version_comment limit 1
                    6 Query     select count(*) into @discard from `information_schema`.`EVENTS`
                    6 Quit
                    7 Connect   debian-sys-maint@localhost on 
                    7 Query     select @@version_comment limit 1
                    7 Query     select count(*) into @discard from `information_schema`.`OPTIMIZER_TRACE`
                    7 Quit
                    8 Connect   debian-sys-maint@localhost on 
                    8 Query     select @@version_comment limit 1
                    8 Query     select count(*) into @discard from `information_schema`.`PARAMETERS`
                    8 Quit
                    9 Connect   debian-sys-maint@localhost on 
                    9 Query     select @@version_comment limit 1
                    9 Query     select count(*) into @discard from `information_schema`.`PARTITIONS`
                    9 Quit
                   10 Connect   debian-sys-maint@localhost on 
                   10 Query     select @@version_comment limit 1
                   10 Query     select count(*) into @discard from `information_schema`.`PLUGINS`
                   10 Quit
                   11 Connect   debian-sys-maint@localhost on 
                   11 Query     select @@version_comment limit 1
                   11 Query     select count(*) into @discard from `information_schema`.`PROCESSLIST`
                   11 Quit
                   12 Connect   debian-sys-maint@localhost on 
                   12 Query     select @@version_comment limit 1
                   12 Query     select count(*) into @discard from `information_schema`.`ROUTINES`
                   12 Quit
                   13 Connect   debian-sys-maint@localhost on 
                   13 Query     select @@version_comment limit 1
                   13 Query     select count(*) into @discard from `information_schema`.`TRIGGERS`
                   13 Quit
                   14 Connect   debian-sys-maint@localhost on 
                   14 Query     select @@version_comment limit 1
                   14 Query     select count(*) into @discard from `information_schema`.`VIEWS`
                   14 Quit
                   15 Connect   debian-sys-maint@localhost on 
                   15 Query     select @@version_comment limit 1
                   15 Query     select count(*) into @discard from `mysql`.`columns_priv`
                   15 Quit
                   16 Connect   debian-sys-maint@localhost on 
                   16 Query     select @@version_comment limit 1
                   16 Query     select count(*) into @discard from `mysql`.`db`
                   16 Quit
                   17 Connect   debian-sys-maint@localhost on 
                   17 Query     select @@version_comment limit 1
                   17 Query     select count(*) into @discard from `mysql`.`event`
                   17 Quit
                   18 Connect   debian-sys-maint@localhost on 
                   18 Query     select @@version_comment limit 1
                   18 Query     select count(*) into @discard from `mysql`.`func`
                   18 Quit
                   19 Connect   debian-sys-maint@localhost on 
                   19 Query     select @@version_comment limit 1
                   19 Query     select count(*) into @discard from `mysql`.`help_category`
                   19 Quit
                   20 Connect   debian-sys-maint@localhost on 
                   20 Query     select @@version_comment limit 1
                   20 Query     select count(*) into @discard from `mysql`.`help_keyword`
                   20 Quit
                   21 Connect   debian-sys-maint@localhost on 
                   21 Query     select @@version_comment limit 1
                   21 Query     select count(*) into @discard from `mysql`.`help_relation`
                   21 Quit
                   22 Connect   debian-sys-maint@localhost on 
                   22 Query     select @@version_comment limit 1
                   22 Query     select count(*) into @discard from `mysql`.`help_topic`
                   22 Quit
                   23 Connect   debian-sys-maint@localhost on 
                   23 Query     select @@version_comment limit 1
                   23 Query     select count(*) into @discard from `mysql`.`ndb_binlog_index`
                   23 Quit
150824  3:34:00    24 Connect   debian-sys-maint@localhost on 
                   24 Query     select @@version_comment limit 1
                   24 Query     select count(*) into @discard from `mysql`.`plugin`
                   24 Quit
                   25 Connect   debian-sys-maint@localhost on 
                   25 Query     select @@version_comment limit 1
                   25 Query     select count(*) into @discard from `mysql`.`proc`
                   25 Quit
                   26 Connect   debian-sys-maint@localhost on 
                   26 Query     select @@version_comment limit 1
                   26 Query     select count(*) into @discard from `mysql`.`procs_priv`
                   26 Quit
                   27 Connect   debian-sys-maint@localhost on 
                   27 Query     select @@version_comment limit 1
                   27 Query     select count(*) into @discard from `mysql`.`proxies_priv`
                   27 Quit
                   28 Connect   debian-sys-maint@localhost on 
                   28 Query     select @@version_comment limit 1
                   28 Query     select count(*) into @discard from `mysql`.`servers`
                   28 Quit
                   29 Connect   debian-sys-maint@localhost on 
                   29 Query     select @@version_comment limit 1
                   29 Query     select count(*) into @discard from `mysql`.`tables_priv`
                   29 Quit
                   30 Connect   debian-sys-maint@localhost on 
                   30 Query     select @@version_comment limit 1
                   30 Query     select count(*) into @discard from `mysql`.`time_zone`
                   30 Quit
                   31 Connect   debian-sys-maint@localhost on 
                   31 Query     select @@version_comment limit 1
                   31 Query     select count(*) into @discard from `mysql`.`time_zone_leap_second`
                   31 Quit
                   32 Connect   debian-sys-maint@localhost on 
                   32 Query     select @@version_comment limit 1
                   32 Query     select count(*) into @discard from `mysql`.`time_zone_name`
                   32 Quit
                   33 Connect   debian-sys-maint@localhost on 
                   33 Query     select @@version_comment limit 1
                   33 Query     select count(*) into @discard from `mysql`.`time_zone_transition`
                   33 Quit
                   34 Connect   debian-sys-maint@localhost on 
                   34 Query     select @@version_comment limit 1
                   34 Query     select count(*) into @discard from `mysql`.`time_zone_transition_type`
                   34 Quit
                   35 Connect   debian-sys-maint@localhost on 
                   35 Query     select @@version_comment limit 1
                   35 Query     select count(*) into @discard from `mysql`.`user`
                   35 Quit
                   36 Connect   debian-sys-maint@localhost on 
                   36 Query     select @@version_comment limit 1
                   36 Query     select count(*) into @discard from `niws`.`catalog`
                   36 Quit
                   37 Connect   debian-sys-maint@localhost on 
                   37 Query     select @@version_comment limit 1
                   37 Query     select count(*) into @discard from `niws`.`comments`
                   37 Quit
                   38 Connect   debian-sys-maint@localhost on 
                   38 Query     select @@version_comment limit 1
                   38 Query     select count(*) into @discard from `niws`.`content`
                   38 Quit
                   39 Connect   debian-sys-maint@localhost on 
                   39 Query     select @@version_comment limit 1
                   39 Query     select count(*) into @discard from `niws`.`forum`
                   39 Quit
                   40 Connect   debian-sys-maint@localhost on 
                   40 Query     select @@version_comment limit 1
                   40 Query     select count(*) into @discard from `niws`.`mail`
                   40 Quit
                   41 Connect   debian-sys-maint@localhost on 
                   41 Query     select @@version_comment limit 1
                   41 Query     select count(*) into @discard from `niws`.`menu`
                   41 Quit
                   42 Connect   debian-sys-maint@localhost on 
                   42 Query     select @@version_comment limit 1
                   42 Query     select count(*) into @discard from `niws`.`news`
                   42 Quit
                   43 Connect   debian-sys-maint@localhost on 
                   43 Query     select @@version_comment limit 1
                   43 Query     select count(*) into @discard from `niws`.`pages`
                   43 Quit
                   44 Connect   debian-sys-maint@localhost on 
                   44 Query     select @@version_comment limit 1
                   44 Query     select count(*) into @discard from `niws`.`user_admin`
                   44 Quit
                   45 Connect   debian-sys-maint@localhost on 
                   45 Query     select @@version_comment limit 1
                   45 Query     select count(*) into @discard from `phpmyadmin`.`pma_bookmark`
                   45 Quit
                   46 Connect   debian-sys-maint@localhost on 
                   46 Query     select @@version_comment limit 1
                   46 Query     select count(*) into @discard from `phpmyadmin`.`pma_column_info`
                   46 Quit
                   47 Connect   debian-sys-maint@localhost on 
                   47 Query     select @@version_comment limit 1
                   47 Query     select count(*) into @discard from `phpmyadmin`.`pma_designer_coords`
                   47 Quit
                   48 Connect   debian-sys-maint@localhost on 
                   48 Query     select @@version_comment limit 1
                   48 Query     select count(*) into @discard from `phpmyadmin`.`pma_history`
                   48 Quit
                   49 Connect   debian-sys-maint@localhost on 
                   49 Query     select @@version_comment limit 1
                   49 Query     select count(*) into @discard from `phpmyadmin`.`pma_pdf_pages`
                   49 Quit
                   50 Connect   debian-sys-maint@localhost on 
                   50 Query     select @@version_comment limit 1
                   50 Query     select count(*) into @discard from `phpmyadmin`.`pma_relation`
                   50 Quit
                   51 Connect   debian-sys-maint@localhost on 
                   51 Query     select @@version_comment limit 1
                   51 Query     select count(*) into @discard from `phpmyadmin`.`pma_table_coords`
                   51 Quit
                   52 Connect   debian-sys-maint@localhost on 
                   52 Query     select @@version_comment limit 1
                   52 Query     select count(*) into @discard from `phpmyadmin`.`pma_table_info`
                   52 Quit
                   53 Connect   debian-sys-maint@localhost on 
                   53 Query     select @@version_comment limit 1
                   53 Query     select count(*) into @discard from `phpmyadmin`.`pma_tracking`
                   53 Quit
                   54 Connect   debian-sys-maint@localhost on 
                   54 Query     select @@version_comment limit 1
                   54 Query     select count(*) into @discard from `phpmyadmin`.`pma_userconfig`
                   54 Quit
150824  3:34:02    55 Connect   root@localhost on 
                   55 Init DB   niws
                   55 Query     SET NAMES utf8
                   55 Query     SELECT *
FROM (`menu`)
WHERE `id` =  '85'
                   55 Query     SELECT *
FROM (`menu`)
WHERE `id_mom` =  '22'
ORDER BY `order` ASC
                   55 Query     SELECT *
FROM (`menu`)
WHERE `id` =  '85'
                   55 Query     SELECT *
FROM (`menu`)
ORDER BY `order` ASC
                   55 Query     SELECT *
FROM (`catalog`)
WHERE `cat` =  '85'
ORDER BY `id` DESC
                   55 Query     SELECT *
FROM (`menu`)
WHERE `url` =  '1'
ORDER BY `order` ASC
                   56 Connect   root@localhost on 
                   56 Init DB   niws
                   56 Query     SET NAMES utf8
                   56 Query     SELECT *
FROM (`pages`)
WHERE `name` =  'main'
                   56 Query     SELECT *
FROM (`menu`)
ORDER BY `order` ASC
                   56 Query     SELECT *
FROM (`menu`)
WHERE `id_mom` =  '22'
ORDER BY `order` ASC
                   56 Query     SELECT *
FROM (`content`)
WHERE `cat` =  'main'
                   56 Query     SELECT *
FROM (`catalog`)
WHERE `tip_text` =  'history'
ORDER BY `id` DESC
LIMIT 2
                   56 Query     SELECT *
FROM (`catalog`)
WHERE `tip_text` =  'open'
ORDER BY `id` DESC
LIMIT 2
                   56 Query     SELECT *
FROM (`catalog`)
WHERE `tip_text` =  'ludi'
ORDER BY `id` DESC
LIMIT 2
root@crackkc:/var/log/mysql#
...
Рейтинг: 0 / 0
24.08.2015, 10:34:43
| Ответить | Цитировать | Написать  
django останавливает Mysql
    #39036088
VGrey
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
VGrey
Гость
serrrgggeee , Вы бы лучше показали часть лога ошибок mysql в в момент запуска djangо.
...
Рейтинг: 0 / 0
26.08.2015, 09:02:46
| Ответить | Цитировать | Написать  
django останавливает Mysql
    #39036198
serrrgggeee
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
serrrgggeee
Гость
Код: powershell
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.
root@crackkc:/var/log/mysql# cat error.log
2015-08-26 04:02:10 8137 [Note] Plugin 'FEDERATED' is disabled.
2015-08-26 04:02:10 8137 [ERROR] Function 'innodb' already exists
2015-08-26 04:02:10 8137 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-26 04:02:10 8137 [ERROR] Function 'federated' already exists
2015-08-26 04:02:10 8137 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-26 04:02:10 8137 [ERROR] Function 'blackhole' already exists
2015-08-26 04:02:10 8137 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-26 04:02:10 8137 [ERROR] Function 'archive' already exists
2015-08-26 04:02:10 8137 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-26 04:02:10 8137 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-26 04:02:10 8137 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-26 04:02:10 8137 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-26 04:02:10 8137 [Note] InnoDB: Memory barrier is not used
2015-08-26 04:02:10 8137 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-26 04:02:10 8137 [Note] InnoDB: Using Linux native AIO
2015-08-26 04:02:10 8137 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-26 04:02:10 8137 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-26 04:02:10 8137 [Note] InnoDB: Completed initialization of buffer pool
2015-08-26 04:02:10 8137 [Note] InnoDB: Highest supported file format is Barracuda.
2015-08-26 04:02:10 8137 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-26 04:02:10 8137 [Note] InnoDB: Waiting for purge to start
2015-08-26 04:02:10 8137 [Note] InnoDB: 5.6.25 started; log sequence number 70673431
2015-08-26 04:02:10 8137 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2015-08-26 04:02:10 8137 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2015-08-26 04:02:10 8137 [Note] Server socket created on IP: '127.0.0.1'.
2015-08-26 04:02:10 8137 [Note] Event Scheduler: Loaded 0 events
2015-08-26 04:02:10 8137 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.25-1~dotdeb+7.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
2015-08-26 04:09:45 8271 [Note] Plugin 'FEDERATED' is disabled.
2015-08-26 04:09:45 8271 [ERROR] Function 'innodb' already exists
2015-08-26 04:09:45 8271 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-08-26 04:09:45 8271 [ERROR] Function 'federated' already exists
2015-08-26 04:09:45 8271 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-08-26 04:09:45 8271 [ERROR] Function 'blackhole' already exists
2015-08-26 04:09:45 8271 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-08-26 04:09:45 8271 [ERROR] Function 'archive' already exists
2015-08-26 04:09:45 8271 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2015-08-26 04:09:45 8271 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-26 04:09:45 8271 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-26 04:09:45 8271 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-26 04:09:45 8271 [Note] InnoDB: Memory barrier is not used
2015-08-26 04:09:45 8271 [Note] InnoDB: Compressed tables use zlib 1.2.7
2015-08-26 04:09:45 8271 [Note] InnoDB: Using Linux native AIO
2015-08-26 04:09:45 8271 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-26 04:09:45 8271 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-08-26 04:09:45 8271 [Note] InnoDB: Completed initialization of buffer pool
root@crackkc:/var/log/mysql#
...
Рейтинг: 0 / 0
26.08.2015, 11:11:25
| Ответить | Цитировать | Написать  
django останавливает Mysql
    #39036256
ALex_hha
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ALex_hha
Участник
У вас по ходу какой то ад и израиль. Покажите свой /etc/my.cnf
...
Рейтинг: 0 / 0
26.08.2015, 12:22:33
| Ответить | Цитировать | Написать  
django останавливает Mysql
    #39036274
serrrgggeee
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
serrrgggeee
Гость
ALex_hha,
Код: powershell
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.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
root@crackkc:/var/log/mysql# sudo 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]
socket          = /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
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1
#
# * Fine Tuning
#
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = 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
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#slow_query_log = 1
#slow_query_log_file = /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         = 300M #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

innodb_buffer_pool_size = 1M

#StartServers 1
#MinSpareServers 1
#MaxSpareServers 5
#MaxClients 5

MaxRequestsPerChild 300

[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/
root@crackkc:/var/log/mysql#
...
Рейтинг: 0 / 0
26.08.2015, 12:35:35
| Ответить | Цитировать | Написать  
django останавливает Mysql
    #39036998
netwind
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
netwind
Участник
авторinnodb_buffer_pool_size = 1M
Полагаю, это критически мало и может даже вызывать остановку процесса на ровном месте.
...
Рейтинг: 0 / 0
26.08.2015, 23:21:09
| Ответить | Цитировать | Написать  
django останавливает Mysql
    #39037055
miksoft
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
miksoft
Участник
serrrgggeee
Код: powershell
1.
2015-08-26 04:09:45 8271 [Note] InnoDB: Initializing buffer pool, size = 128.0M

Судя по этой строке, реально применяется какой-то другой конфиг, нежели два показанных.
Либо применяется второй конфиг, а параметр innodb_buffer_pool_size = 1M отбрасывается, т.к. он ниже минимального порога, и используется значение по-умолчанию.
...
Рейтинг: 0 / 0
26.08.2015, 23:55:37
| Ответить | Цитировать | Написать  
django останавливает Mysql
    #39037179
serrrgggeee
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
serrrgggeee
Гость
miksoft,
я уже прибавил этот параметр, а где еще могут быть настройки?
...
Рейтинг: 0 / 0
27.08.2015, 08:54:11
| Ответить | Цитировать | Написать  
django останавливает Mysql
    #39037393
ALex_hha
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
ALex_hha
Участник
!includedir /etc/mysql/conf.d/

вот тут
...
Рейтинг: 0 / 0
27.08.2015, 12:54:50
| Ответить | Цитировать | Написать  
9 сообщений из 9, страница 1 из 1
Форумы / MySQL [игнор отключен] [закрыт для гостей] / django останавливает Mysql
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение   Полит. конфиден.  
NoSQL.ru       Кролег: Проекты, Новости, Чат       РЕД ФОРУМ       Фотоальбом: Участники, Встречи
Закрыть
start [/forum/topic.php?fid=47&fpage=126&tid=1832774]:
 0ms
get settings:
 6ms
get forum list:
 9ms
check forum access:
 2ms
check topic access:
 2ms
track hit:
 30ms
get topic data:
 8ms
get forum data:
 2ms
get page messages:
 61ms
get tp. blocked users:
 1ms
others: 215ms
total:  336ms
созд. / загр.: 336ms
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]