[00:02:50] sakal is now online
[00:06:23] Typhon is now online
[00:07:51] sakal is now online
[00:09:09] Сволота is now xa
[00:09:12] gigimon is now offline
[00:09:12] gigimon is now online
[00:11:35] Сволота is now online
[00:12:36] Typhon is now offline
[00:12:53] sakal is now online
[00:17:27] Сволота is now away
[00:17:55] sakal is now online
[00:22:58] sakal is now online
[00:25:39] gigimon is now online
[00:27:27] Сволота is now xa
[00:28:01] sakal is now online
[00:28:25] gigimon is now online
[00:29:21] levsha is now xa
[00:33:04] sakal is now online
[00:38:05] sakal is now online
[00:40:20] ink08 is now online
[00:40:39] Сволота is now online
[00:43:08] sakal is now online
[00:47:01] webninja is now dnd
[00:47:44] Joes is now Yep, I'm here.
[00:48:10] sakal is now online
[00:48:17] Singularity is now chat
[00:49:10] Singularity: бпитон?
[00:53:13] sakal is now online
[00:58:15] sakal is now online
[01:02:35] webninja is now dnd
[01:03:17] sakal is now online
[01:03:32] mironich is now away
[01:03:32] mironich is now online
[01:05:30] Сволота is now away
[01:08:19] sakal is now online
[01:13:22] sakal is now online
[01:13:47] xa4a is now away
[01:15:30] Сволота is now xa
[01:17:42] py_two is now offline
[01:18:25] sakal is now online
[01:23:27] sakal is now online
[01:28:30] sakal is now online
[01:33:33] sakal is now online
[01:38:35] sakal is now online
[01:38:37] gigimon is now offline
[01:38:43] gigimon is now online
[01:40:06] xa4a is now away
[01:43:37] sakal is now online
[01:48:41] sakal is now online
[01:53:44] sakal is now online
[01:54:48] fbvaal is now offline
[01:56:18] mishok13 is now online
[01:58:46] sakal is now online
[01:59:12] mironich is now offline
[01:59:38] Сволота is now online
[02:03:48] sakal is now online
[02:05:58] Сволота is now away
[02:08:51] sakal is now online
[02:14:05] sakal is now online
[02:15:58] Сволота is now xa
[02:18:55] sakal is now online
[02:21:23] webninja is now offline
[02:23:51] webninja is now dnd
[02:23:58] sakal is now online
[02:24:59] gigimon is now offline
[02:25:24] Сволота is now online
[02:29:00] sakal is now online
[02:29:05] levsha is now offline
[02:34:03] sakal is now online
[02:39:05] sakal is now online
[02:39:58] deisler is now offline
[02:44:07] sakal is now online
[02:49:09] sakal is now online
[02:49:31] mishok13 is now away
[02:54:04] mishok13 is now online
[02:54:11] sakal is now online
[02:59:13] sakal is now online
[03:04:16] sakal is now online
[03:05:10] Сволота is now away
[03:08:54] Сволота is now online
[03:09:18] sakal is now online
[03:10:16] mishok13 is now offline
[03:14:22] sakal is now online
[03:19:26] sakal is now online
[03:24:26] sakal is now online
[03:26:08] Сволота is now away
[03:29:28] sakal is now online
[03:31:08] Сволота is now online
[03:34:30] sakal is now online
[03:35:17] xa4a is now away
[03:35:23] xa4a is now away
[03:36:10] Сволота is now away
[03:38:48] Сволота is now online
[03:39:32] sakal is now online
[03:44:34] sakal is now online
[03:49:37] sakal is now online
[03:51:00] Singularity is now offline
[03:52:05] Ranwise is now offline
[03:54:39] sakal is now online
[03:59:41] sakal is now online
[04:00:30] alexey-grom is now online
[04:04:44] sakal is now online
[04:09:47] sakal is now online
[04:09:50] Сволота is now away
[04:14:50] sakal is now online
[04:19:50] Сволота is now xa
[04:19:52] sakal is now online
[04:23:16] xa4a is now away
[04:24:53] sakal is now online
[04:28:16] xa4a is now away
[04:29:55] sakal is now online
[04:34:58] sakal is now online
[04:39:48] Сволота is now online
[04:39:59] sakal is now online
[04:43:06] mrDoctorWho is now online
[04:45:01] sakal is now online
[04:50:03] sakal is now online
[04:55:04] sakal is now online
[04:59:14] mrDoctorWho is now offline
[05:00:06] sakal is now online
[05:05:08] sakal is now online
[05:10:10] sakal is now online
[05:15:12] sakal is now online
[05:17:44] Tony is now away
[05:20:15] sakal is now online
[05:25:16] sakal is now online
[05:26:30] alexey-grom is now away
[05:27:40] alexey-grom is now online
[05:29:41] xa4a is now away
[05:30:18] sakal is now online
[05:35:20] sakal is now online
[05:40:22] sakal is now online
[05:42:44] Tony is now xa
[05:45:24] sakal is now online
[05:49:09] alexey-grom is now offline
[05:50:25] sakal is now online
[05:55:28] sakal is now online
[06:00:29] sakal is now online
[06:05:31] sakal is now online
[06:10:33] sakal is now online
[06:15:35] sakal is now online
[06:20:37] sakal is now online
[06:25:39] sakal is now online
[06:29:02] Сволота is now away
[06:30:41] sakal is now online
[06:32:30] Сволота is now online
[06:35:42] sakal is now online
[06:39:15] alexey-grom is now online
[06:40:44] sakal is now online
[06:45:46] sakal is now online
[06:50:48] sakal is now online
[06:55:38] Сволота is now away
[06:55:49] sakal is now online
[07:00:51] sakal is now online
[07:04:50] Сволота is now online
[07:05:53] sakal is now online
[07:09:52] Сволота is now away
[07:10:54] sakal is now online
[07:15:56] sakal is now online
[07:18:47] webninja is now dnd
[07:19:52] Сволота is now xa
[07:20:58] sakal is now online
[07:22:32] pytwo is now offline
[07:22:35] pytwo is now online
[07:26:00] sakal is now online
[07:31:02] sakal is now online
[07:36:05] sakal is now online
[07:41:06] sakal is now online
[07:41:46] огыешсук is now online
[07:46:08] sakal is now online
[07:51:11] sakal is now online
[07:52:08] Сволота is now online
[07:56:13] sakal is now online
[07:58:48] огыешсук: webninja: а ты как на визу собираешься? Сам или через агентство какое?
[08:01:15] sakal is now online
[08:02:22] webninja is now dnd
[08:06:17] sakal is now online
[08:07:10] webninja is now dnd
[08:07:21] webninja: сам походу
[08:07:32] webninja: ну там вернее в пенанге отдать через агентство
[08:07:35] webninja: да и все чтобы не парится
[08:11:19] sakal is now online
[08:11:58] bliznezz is now away
[08:11:59] bliznezz is now online
[08:12:51] webninja is now dnd
[08:16:21] sakal is now online
[08:17:00] bliznezz is now away
[08:17:01] bliznezz is now away
[08:21:23] sakal is now online
[08:26:26] sakal is now online
[08:31:27] sakal is now online
[08:32:12] gf is now online
[08:36:06] огыешсук: А на чем?
[08:36:30] sakal is now online
[08:41:32] sakal is now online
[08:46:12] alexey-grom is now offline
[08:46:12] alexey-grom is now online
[08:46:34] sakal is now online
[08:46:57] webninja is now dnd
[08:47:08] webninja: что на чем? на автобусе с натона
[08:47:13] webninja: паром все дела
[08:47:19] webninja: как тру
[08:50:09] огыешсук: Тогда почему не через агентство, раз уж все одно на автобусе.
[08:51:36] sakal is now online
[08:53:17] webninja is now dnd
[08:56:38] sakal is now online
[09:01:39] sakal is now online
[09:06:41] sakal is now online
[09:11:43] sakal is now online
[09:16:45] sakal is now online
[09:21:47] sakal is now online
[09:26:50] sakal is now online
[09:31:53] sakal is now online
[09:36:54] sakal is now online
[09:41:56] sakal is now online
[09:42:11] alexey-grom is now away
[09:45:27] livevil is now away
[09:46:59] sakal is now online
[09:47:00] Сволота is now away
[09:52:01] sakal is now online
[09:52:40] Сволота is now online
[09:57:03] sakal is now online
[10:01:17] alexey-grom is now online
[10:02:06] sakal is now online
[10:02:06] webninja is now dnd
[10:07:07] sakal is now online
[10:08:26] webninja is now dnd
[10:12:09] sakal is now online
[10:17:12] sakal is now online
[10:22:16] sakal is now online
[10:27:20] sakal is now online
[10:32:20] sakal is now online
[10:32:35] fbvaal is now online
[10:35:45] bliznezz is now away
[10:35:46] bliznezz is now online
[10:37:20] sakal is now online
[10:42:24] sakal is now online
[10:44:33] xa4a is now away
[10:47:26] sakal is now online
[10:52:28] sakal is now online
[10:57:31] sakal is now online
[11:02:33] sakal is now online
[11:06:37] огыешсук is now away
[11:06:40] огыешсук is now online
[11:07:35] sakal is now online
[11:08:18] bliznezz is now away
[11:08:19] bliznezz is now away
[11:09:54] deisler is now away
[11:12:49] sakal is now online
[11:16:45] bliznezz is now away
[11:16:45] bliznezz is now online
[11:17:39] sakal is now online
[11:19:11] mishok13 is now online
[11:22:08] огыешсук is now away
[11:22:42] sakal is now online
[11:27:30] ink08 is now online
[11:27:43] sakal is now online
[11:28:14] Сволота is now away
[11:30:41] webninja is now dnd
[11:32:07] огыешсук is now xa
[11:32:46] sakal is now online
[11:33:00] gigimon is now online
[11:33:44] Сволота is now online
[11:36:36] огыешсук is now online
[11:36:56] webninja is now dnd
[11:37:48] sakal is now online
[11:37:50] webninja is now dnd
[11:39:57] xa4a is now away
[11:40:19] xa4a is now away
[11:42:44] огыешсук is now away
[11:42:51] sakal is now online
[11:42:52] webninja is now dnd
[11:43:04] webninja is now dnd
[11:45:06] огыешсук is now online
[11:47:53] sakal is now online
[11:49:02] mishok13 is now offline
[11:49:34] gigimon is now offline
[11:49:48] Сволота is now away
[11:52:55] sakal is now online
[11:55:02] Сволота is now online
[11:55:10] xa4a is now away
[11:55:26] xa4a is now away
[11:57:58] sakal is now online
[11:57:58] webninja is now dnd
[11:58:05] livevil is now online
[11:58:05] livevil is now online
[11:58:32] xa4a is now away
[11:59:10] slav0nic is now xa
[11:59:58] nott is now online
[12:00:02] Сволота is now away
[12:01:41] webninja is now dnd
[12:03:00] sakal is now online
[15:04:03] gf is now online
[15:04:03] Сволота is now online
[15:04:03] nott is now away
[15:04:03] gigimon is now away
[15:04:03] alexey-grom is now online
[15:04:03] mishok13 is now away
[15:04:03] blw0rm is now away
[15:04:03] sakal is now online
[15:04:03] Joes is now Yep, I'm here.
[15:04:03] pytwo is now online
[15:04:03] livevil is now online
[15:04:03] tvorzasp is now сколько RoR на PHP не портируй, все равно Codeigniter получается
[15:04:03] mrDoctorWho is now online
[15:04:03] deisler is now away
[15:04:03] bliznezz is now online
[15:04:03] Typhon is now online
[15:04:03] ink08 is now online
[15:04:03] fbvaal is now online
[15:04:03] Tony is now online
[15:04:03] Ranwise is now ** This message was blocked by the ICQ server **
[15:04:03] xa4a is now online
[15:04:03] nmk is now online
[15:04:03] slav0nic is now xa
[15:04:03] webninja is now dnd
[15:04:03] Singularity is now chat
[15:04:03] огыешсук is now online
[15:04:03] magic_pony is now online
[15:04:03] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[15:05:25] mrDoctorWho is now offline
[15:05:59] xa4a is now online
[15:06:50] sakal is now online
[15:08:59] ink08 is now away
[15:09:01] ink08 is now away
[15:09:19] bliznezz is now away
[15:09:20] bliznezz is now away
[15:09:46] gigimon is now away
[15:09:51] gigimon is now online
[15:10:36] webninja is now dnd
[15:10:58] xa4a is now online
[15:11:52] sakal is now online
[15:13:01] bliznezz is now away
[15:13:01] bliznezz is now online
[15:13:41] ink08 is now away
[15:13:42] ink08 is now online
[15:14:26] slav0nic: сайт поднял
[15:15:23] webninja is now dnd
[15:16:54] sakal is now online
[15:18:06] webninja is now dnd
[15:18:10] blw0rm is now xa
[15:19:44] ink08 is now away
[15:19:46] ink08 is now away
[15:19:49] Singularity is now chat
[15:20:26] ink08 is now away
[15:20:27] ink08 is now online
[15:21:57] sakal is now online
[15:23:45] webninja is now dnd
[15:23:50] Tony is now away
[15:24:01] Singularity: Молодец
[15:27:00] sakal is now online
[15:28:10] blw0rm is now online
[15:29:41] xa4a is now away
[15:30:55] bliznezz: ping
[15:30:57] slav0nic is now offline
[15:31:17] xa4a is now online
[15:31:23] slav0nic is now xa
[15:31:31] webninja is now dnd
[15:31:42] livevil is now online
[15:32:02] sakal is now online
[15:34:29] tvorzasp is now away
[15:34:29] tvorzasp is now away
[15:36:33] nott is now online
[15:36:55] nott is now away
[15:36:57] nott is now online
[15:37:05] sakal is now online
[15:37:21] mishok13 is now online
[15:38:11] ink08 is now away
[15:38:13] ink08 is now away
[15:38:22] xa4a: bliznezz: pong
[15:38:52] Singularity is now chat
[15:40:29] tvorzasp is now away
[15:40:30] tvorzasp is now сколько RoR на PHP не портируй, все равно Codeigniter получается
[15:40:43] Typhon is now away
[15:41:04] Singularity is now chat
[15:42:08] sakal is now online
[15:43:02] Typhon is now online
[15:43:45] Singularity: https://code.google.com/p/blockly/ афигенчик :-D
[15:45:11] ink08 is now away
[15:45:12] ink08 is now online
[15:45:21] alexey-grom is now offline
[15:46:35] Сволота is now away
[15:46:35] blw0rm is now offline
[15:46:43] blw0rm is now online
[15:47:10] sakal is now online
[15:48:50] Tony is now xa
[15:49:47] xa4a is now away
[15:51:25] Сволота is now online
[15:52:13] sakal is now online
[15:53:15] livevil is now online
[15:53:38] slav0nic: Singularity, у MIT есть проект программирование для детей
[15:53:41] slav0nic: там создание игр
[15:53:53] slav0nic: по-моему вот кот с радугой на этом был сделан
[15:54:03] Singularity: ?
[15:54:22] slav0nic: http://scratch.mit.edu/
[15:54:39] slav0nic: Nyan Cat ёпт
[15:54:46] slav0nic: по крайней мере дет был аналог)
[15:57:18] sakal is now online
[15:58:39] Сволота is now away
[15:59:47] xa4a is now away
[16:00:31] Сволота is now online
[16:01:08] Typhon is now away
[16:02:18] sakal is now online
[16:02:25] Typhon is now online
[16:05:36] Сволота is now away
[16:06:41] Singularity is now offline
[16:07:15] gigimon is now online
[16:07:20] sakal is now online
[16:09:06] bliznezz: http://lab.madscience.nl/oo.sh.txt
[16:10:35] Сволота is now online
[16:10:54] slav0nic is now offline
[16:12:24] sakal is now online
[16:12:24] Typhon is now away
[16:12:46] Ranwise is now offline
[16:12:58] Ranwise is now ** This message was blocked by the ICQ server **
[16:13:51] slav0nic is now xa
[16:14:41] Typhon is now online
[16:15:37] Сволота is now away
[16:16:27] Сволота is now online
[16:17:25] sakal is now online
[16:17:53] xa4a is now away
[16:18:04] xa4a is now online
[16:18:19] ink08 is now online
[16:18:21] ink08 is now away
[16:47:57] webninja is now dnd
[16:47:57] gigimon is now online
[16:47:57] mishok13 is now online
[16:47:57] Tony is now xa
[16:47:57] deisler is now away
[16:47:57] nmk is now online
[16:47:57] gf is now online
[16:47:57] xa4a is now online
[16:47:57] py_two is now xa
[16:47:57] levsha is now online
[16:47:57] bliznezz is now online
[16:47:57] tvorzasp is now сколько RoR на PHP не портируй, все равно Codeigniter получается
[16:47:57] slav0nic is now xa
[16:47:57] Сволота is now online
[16:47:57] Ranwise is now ** This message was blocked by the ICQ server **
[16:47:57] огыешсук is now online
[16:47:57] sakal is now online
[16:47:57] blw0rm is now online
[16:47:57] nott is now online
[16:47:57] fbvaal is now online
[16:47:57] ink08 is now away
[16:47:57] Joes is now Yep, I'm here.
[16:47:57] magic_pony is now online
[16:47:57] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[16:47:57] Typhon is now online
[16:47:57] livevil is now online
[16:49:44] Singularity is now chat
[16:50:42] Singularity: bliznezz: шта эта?
[16:51:01] levsha: это адов капец
[16:51:09] bliznezz: Singularity: типа реализация типа ооп на баше
[16:51:28] Singularity: Аааа
[16:52:37] sakal is now online
[16:57:39] sakal is now online
[17:00:17] Сволота is now away
[17:01:03] xa4a is now away
[17:01:22] ink08 is now away
[17:01:23] ink08 is now online
[17:01:44] xa4a is now online
[17:02:03] livevil is now online
[17:02:16] py_two is now offline
[17:02:21] xa4a is now online
[17:02:42] sakal is now online
[17:04:09] livevil is now online
[17:04:36] xa4a is now online
[17:05:09] blw0rm is now offline
[17:05:10] blw0rm is now online
[17:05:12] blw0rm is now online
[17:05:14] Typhon is now away
[17:05:17] Сволота is now online
[17:07:44] sakal is now online
[17:08:16] alexey-grom is now online
[17:10:19] Сволота is now away
[17:12:46] sakal is now online
[17:12:53] Сволота is now online
[17:14:18] Typhon is now offline
[17:17:16] Typhon is now away
[17:17:48] sakal is now online
[17:18:56] tvorzasp is now away
[17:18:56] tvorzasp is now away
[17:19:43] mishok13 is now away
[17:20:40] mishok13 is now online
[17:22:50] sakal is now online
[17:28:01] sakal is now online
[17:29:24] огыешсук is now away
[17:32:58] sakal is now online
[17:34:19] blw0rm is now away
[17:34:27] огыешсук is now online
[17:35:17] blw0rm is now online
[17:36:22] nott is now away
[17:36:31] Сволота is now away
[17:37:56] sakal is now online
[17:38:30] alexey-grom is now away
[17:39:29] Magister Yoda is now online
[17:40:28] alexey-grom is now online
[17:41:33] Сволота is now online
[17:42:10] nott is now online
[17:42:59] sakal is now online
[17:43:23] tvorzasp is now away
[17:43:23] tvorzasp is now сколько RoR на PHP не портируй, все равно Codeigniter получается
[17:46:35] Сволота is now away
[17:48:01] sakal is now online
[17:49:25] webninja is now dnd
[17:49:55] Сволота is now online
[17:53:04] sakal is now online
[17:53:05] webninja: как инсерты ускорить
[17:53:07] webninja: отключил индексы
[17:53:17] webninja: коммичу пачкой по 100
[17:53:20] webninja: медленно
[17:53:23] webninja: 20к за день
[17:53:32] webninja: 330к нужно сделать
[17:53:39] nmk: а база то какая?
[17:53:41] webninja: mysql
[17:53:43] nmk: 20к в день это как-то грустно
[17:53:50] nmk: а запись не по 100кб?
[17:54:05] webninja: запись объемная может быть да
[17:54:50] nmk: так а что с загрузкой диска во время вставки? в mysqlе же есть еще какие-то настройки коммитов, типа когда там на диск что скидывается
[17:55:24] webninja: http://dumpz.org/409553/
[17:55:26] webninja: вот
[17:55:36] webninja: может проверять не надо? ну там что есть уже в базе
[17:55:55] webninja: да там есть buffer_size поставил 512метров
[17:56:12] nmk: ну ты не только инсертишь, ты еще проверяешь. и инсертить хорошо пачкой сразу
[17:56:31] webninja: key_buffer
[17:56:47] nmk: хотя может sqla сразу делает bulk insert
[17:56:47] webninja: так я так и делаю в сессию сую 100 итемов, потом коммит
[17:56:57] nmk: а ты уверен что это одним инсертом уходит?
[17:57:08] webninja: щаз гляну
[17:57:37] огыешсук: во первых, надо myisam, во вторых таки да -- надо одним инсертом
[17:57:38] alexey-grom is now away
[17:58:05] nmk: myisam эта такая штука которая развалится если вырубят питание?
[17:58:06] sakal is now online
[17:58:19] webninja: да пусть хоть огнем горит )
[17:58:21] webninja: главное резче
[17:58:25] webninja: за сутки хотябы
[17:58:32] nmk: ну тогда myisam
[17:58:36] nmk: или прямо в память пиши
[17:58:37] nmk: :)
[17:58:40] nmk: потом копируй на диск
[17:59:21] nmk: принципе если у тебя там никаких параллельных вставок/проверок нету, то myisam (если я правильно помню, что это нетранзакционный движок) предпочтительней
[18:00:39] Сволота is now away
[18:01:13] Сволота is now online
[18:03:10] sakal is now online
[18:03:35] alexey-grom is now online
[18:03:52] webninja: щаз буду читать как myisam сделать
[18:04:05] xa4a is now online
[18:04:52] xa4a: а ты в несколько потоков пишешь?
[18:05:13] xa4a: ну и да, надо начинать с того, что смотреть в чём затык
[18:05:15] xa4a: vmstat
[18:05:22] xa4a: http://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb-diskio.html
[18:05:28] xa4a: webninja: ^
[18:05:55] Magister Yoda is now offline
[18:06:13] webninja: ша
[18:06:15] Сволота is now away
[18:06:17] webninja: в один поток
[18:06:21] Сволота is now online
[18:06:48] webninja: граб, там один поток выполнения. я короче сайт в кэш закинул в монгу, 17 гигабайт. теперь надо отрендерить в mysql
[18:07:22] Tony is now online
[18:07:45] Singularity is now offline
[18:08:11] sakal is now online
[18:11:48] xa4a is now online
[18:12:05] xa4a: webninja: где затык?
[18:12:53] slav0nic: webninja, а сколько rps выходит по статистике?
[18:12:56] webninja is now dnd
[18:13:14] sakal is now online
[18:13:39] webninja is now dnd
[18:13:39] webninja: походу 1-2 )))
[18:13:41] webninja: визуально
[18:13:53] xa4a: ты что-то делаешь не так
[18:14:54] slav0nic: та да)у меня помню 5к дет было при 70% инсерты точечные
[18:15:07] slav0nic: правда там аж 100мб было в базе)
[18:15:25] slav0nic: вообще в mysql есть статистика
[18:15:32] mishok13 is now away
[18:15:36] Typhon is now offline
[18:15:45] slav0nic: можешь попробовать скрипты аля mysqlperf чтоли
[18:15:58] slav0nic: правда не уверен что с одними инсертами он что-то увидит
[18:16:01] slav0nic: у тебя не впс хоть?
[18:16:04] Typhon is now away
[18:16:44] xa4a: 1-2 инсерта по 100 строк?
[18:17:06] xa4a: у тебя, скорее всего, проблема в self.session.query(Hotel).filter_by( link=data['link']).first()
[18:17:09] slav0nic: попробуй mysqltuner.pl/mysqltuner.pl из "без напряжного" авось)
[18:17:30] xa4a: у тебя каждый селект - это куча seek'ов по диску
[18:17:37] xa4a: а инсерты все идут последовательные
[18:17:55] xa4a: короче выбери сначала кучей весь селект, что тебе нужен, а потом делай все инсерты
[18:17:58] webninja: у тебя не впс хоть? ваще у меня внутри виртуалбокс щаз линь
[18:18:10] slav0nic: =\
[18:18:17] sakal is now online
[18:18:22] webninja: да я тоже думаю грохнуть строчку
[18:18:25] webninja: с серчами
[18:18:31] webninja: но блин а если что-то пойдет не так?
[18:18:34] webninja: то потом заново?
[18:18:45] xa4a: можешь параллельно делать)
[18:18:51] xa4a: в другую базу
[18:19:01] xa4a: но хуже вряд ли будет
[18:19:43] xa4a: webninja: http://docs.sqlalchemy.org/en/rel_0_5/session.html#merging
[18:20:21] xa4a: oh, wait
[18:20:39] xa4a: webninja: а у тебя на link индекс есть?
[18:21:18] nott is now away
[18:21:22] nott is now online
[18:21:39] Typhon is now away
[18:23:20] sakal is now online
[18:23:55] webninja is now dnd
[18:25:52] ink08 is now away
[18:25:52] ink08 is now away
[18:25:59] webninja is now dnd
[18:26:07] webninja: нет
[18:26:11] webninja: я отключил индексы для таблицы
[18:27:40] ink08 is now away
[18:27:40] ink08 is now online
[18:28:24] sakal is now online
[18:28:24] Typhon is now away
[18:28:24] Typhon is now online
[18:29:06] Singularity is now chat
[18:29:58] xa4a: теперь включи
[18:30:07] xa4a: вся проблема от этого
[18:30:14] xa4a: у тебя на каждую запись вся таблица просматривается
[18:30:17] xa4a: в поисках линка
[18:30:22] xa4a: сделай индекс на линк
[18:31:33] webninja: разницы нет
[18:31:46] webninja: сек ща
[18:31:48] webninja: кстати да
[18:33:24] sakal is now online
[18:33:38] gigimon: чуваки, кто юзает торнадо и mysql, расскажите, а как мне ловить мускульные исключения?
[18:33:51] mishok13 is now online
[18:34:16] gigimon: а то я как понимаю он асинхронный и эксепшен вылазит дальше по коду, не в try блое
[18:35:27] gigimon: оп, похоже я дурак и ночью не там написал строчку >_<
[18:35:29] xa4a: gigimon: что за асинхронный mysql?
[18:35:47] livevil is now online
[18:35:50] xa4a: webninja: посмотри, какие оно запросы генерирует
[18:35:52] gigimon: torndb - либа для торнадо по подключению
[18:35:58] xa4a: и покажи EXPLAIN на них
[18:36:00] gigimon: к мускулю у торнадо
[18:37:12] xa4a: gigimon: но там не видно никакой асинхронности?
[18:37:28] gigimon: не, ща покажу
[18:38:26] sakal is now online
[18:38:53] gigimon: xa4a: http://dumpz.org/409625/
[18:39:17] gigimon: BaseException стоит уже от безысходности, т.к.OperationalError или Exception тож не ловится
[18:39:19] ink08 is now away
[18:39:21] ink08 is now away
[18:40:50] ink08 is now away
[18:40:50] ink08 is now online
[18:41:35] Сволота is now away
[18:41:53] xa4a: gigimon: https://github.com/bdarnell/torndb/blob/master/torndb.py#L96
[18:42:30] Typhon is now away
[18:42:36] gigimon: ахуенное решение хочу заметить
[18:42:44] gigimon: нафига так делать?
[18:43:14] gigimon: получается, что я никак не могу узнать, подключился я или нет
[18:43:15] Сволота is now online
[18:43:27] gigimon: и чего я сразу в исходники не залез...
[18:43:29] sakal is now online
[18:43:33] xa4a: а тебе этого не надо знать
[18:43:39] xa4a: ну как..
[18:43:47] xa4a: оно при запросе снова попробует подключиться
[18:44:43] xa4a: ну и выпадет на запросе уже
[18:47:35] ink08 is now away
[18:47:36] ink08 is now away
[18:47:47] ink08 is now away
[18:47:47] ink08 is now online
[18:48:02] slav0nic is now offline
[18:48:15] Сволота is now away
[18:48:27] webninja is now dnd
[18:48:31] sakal is now online
[18:49:00] Typhon is now online
[18:50:32] deisler is now offline
[18:51:45] xa4a is now away
[18:52:45] Сволота is now online
[18:53:34] sakal is now online
[18:54:22] xa4a is now online
[18:58:38] sakal is now online
[18:58:39] ink08 is now away
[18:58:40] ink08 is now away
[19:04:35] tvorzasp is now сколько RoR на PHP не портируй, все равно Codeigniter получается
[19:04:35] nmk is now online
[19:04:35] gigimon is now online
[19:04:35] огыешсук is now online
[19:04:35] sakal is now online
[19:04:35] gf is now online
[19:04:35] levsha is now online
[19:04:35] ink08 is now online
[19:04:35] webninja is now dnd
[19:04:35] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[19:04:35] alexey-grom is now online
[19:04:35] magic_pony is now online
[19:04:35] blw0rm is now online
[19:04:35] Singularity is now chat
[19:04:35] fbvaal is now online
[19:04:35] Сволота is now online
[19:04:35] Ranwise is now ** This message was blocked by the ICQ server **
[19:04:35] Joes is now Yep, I'm here.
[19:04:35] livevil is now online
[19:04:35] Tony is now online
[19:04:35] mishok13 is now online
[19:04:35] Typhon is now away
[19:04:35] xa4a is now online
[19:04:35] nott is now online
[19:04:35] bliznezz is now online
[19:06:12] Typhon is now online
[19:07:22] dicos is now online
[19:08:41] sakal is now online
[19:08:53] ink08 is now away
[19:08:54] ink08 is now away
[19:09:11] nott is now away
[19:13:44] sakal is now online
[19:14:21] Typhon is now away
[19:15:12] Typhon is now online
[19:15:36] pytwo is now online
[19:17:01] gf is now offline
[19:17:50] gigimon: xa4a: в данной ситуации надо, т.к. я через форму задаю хост и надо чекать, работает или нет
[19:18:01] gigimon: видимо придется делать запрос какой-то и чекать его
[19:18:17] Singularity is now chat
[19:18:20] xa4a: угу..
[19:18:31] xa4a: webninja: индекс помог?
[19:18:46] sakal is now online
[19:19:21] огыешсук is now offline
[19:21:45] deisler is now away
[19:23:48] sakal is now online
[19:25:09] nott is now online
[19:28:51] sakal is now online
[19:33:02] ink08 is now away
[19:33:02] ink08 is now online
[19:33:53] sakal is now online
[19:34:41] gigimon is now offline
[19:38:56] sakal is now online
[19:43:58] sakal is now online
[19:45:08] dicos is now away
[19:45:10] dicos is now away
[19:45:41] ink08 is now away
[19:45:42] ink08 is now away
[19:47:16] nmk is now offline
[19:48:05] ink08 is now away
[19:48:05] ink08 is now online
[19:49:01] sakal is now online
[19:49:49] webninja is now dnd
[19:50:00] webninja: ща
[19:51:45] Сволота is now away
[19:54:04] sakal is now online
[19:55:20] bliznezz is now away
[19:55:21] bliznezz is now away
[19:59:08] sakal is now online
[19:59:16] pytwo is now offline
[19:59:29] Сволота is now online
[20:00:39] webninja: так а чо таблицу myisam делать?
[20:01:08] webninja: кстати с индексом пидорасит норм.
[20:01:25] webninja: в начале без индекса тоже быстро было потом все медленнее и медленнее
[20:01:38] webninja: так что если щаз ок будет то big thanx пацаны )
[20:04:09] sakal is now online
[20:06:39] xa4a: без индекса - делает фул-скан. будет всё медленнее и медленнее, чем больше данных
[20:07:16] webninja: да, это ясно.
[20:07:40] webninja: MyISAM — одна из основных (наряду с InnoDB <http://ru.wikipedia.org/wiki/InnoDB>) систем хранения данных в СУБД <http://ru.wikipedia.org/wiki/%D0%A1%D0%A3%D0%91%D0%94> MySQL <http://ru.wikipedia.org/wiki/MySQL>. Она основывается на коде ISAM <http://ru.wikipedia.org/wiki/ISAM> и обладает в сравнении с ним рядом полезных дополнений. Таблицы MyISAM прекрасно подходят для использования в WWW <http://ru.wikipedia.org/wiki/WWW> и других средах, где преобладают запросы на чтение. Таблицы типа MyISAM показывают хорошие результаты при выборках SELECT <http://ru.wikipedia.org/wiki/SELECT>. Во многом это связано с отсутствием поддержки транзакций <http://ru.wikipedia.org/wiki/%D0%A2%D1%80%D0%B0%D0%BD%D0%B7%D0%B0%D0%BA%D1%86%D0%B8%D1%8F_%28%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%82%D0%B8%D0%BA%D0%B0%29> и внешних ключей <http://ru.wikipedia.org/wiki/%D0%A1%D1%81%D1%8B%D0%BB%D0%BE%D1%87%D0%BD%D0%B0%D1%8F_%D1%86%D0%B5%D0%BB%D0%BE%D1%81%D1%82%D0%BD%D0%BE%D1%81%D1%82%D1%8C>. Однако при модификации и добавлении записей вся таблица кратковременно блокируется, это может привести к серьёзным задержкам при большой загрузке.
[20:07:46] webninja: так а в чем поинт?
[20:09:11] sakal is now online
[20:11:55] xa4a: единственное преимущество myisam перед innodb - в том, что myisam умеет понотекстный поиск
[20:12:04] xa4a: других причин использовать myisam нет
[20:12:16] webninja: муть какая
[20:12:18] webninja: не то что в монге
[20:12:22] webninja: щаз на курсы записался по монге
[20:12:48] xa4a: http://en.wikipedia.org/wiki/Aria_(storage_engine)
[20:12:57] xa4a: вот это должно заменить myisam
[20:13:15] Ranwise: я не сильно разбирась но почему монгу не оставить?
[20:13:36] xa4a: потому что она не подходит для хранения реляционных данных?
[20:14:14] sakal is now online
[20:15:35] webninja: скорее клиент не знает что такое монга
[20:15:39] Ranwise: есть где-нибудь примеры когда не нужно использовать или когда можно\нужно
[20:15:56] webninja: когда данные не ложаться в реляционную БД
[20:16:13] webninja: щаз во многих проектах несколько БД юзают.
[20:16:23] webninja: что-то в монге хранят, что-то в скуле.
[20:17:06] webninja: например если есть задача репорт сгенерировать по данным. если это достаточно долгая операция, то celery которая пишет во временную таблицу монги. как сделать скулем если репортов много разных? я хз.
[20:17:55] webninja: монга документом оперирует а не таблицей. документы в пределах коллекции могут быть абсолютно произвольного формата.
[20:19:17] sakal is now online
[20:19:24] xa4a: Ranwise: реляционные данные - когда их сложно представить в виде дерева, или деревьев независимых
[20:19:51] xa4a: например какой-то форум с юзерами, группами, постами, этц
[20:19:58] xa4a: или е-комерц
[20:20:06] webninja: угу чтобы дерево в скуле представить этож целая академическая задача.
[20:20:11] xa4a: ещё монга, говорят, теряет данные
[20:20:18] webninja: врут наверное
[20:20:21] nott is now away
[20:20:27] xa4a: когда крешится
[20:20:35] webninja: хм, может быть
[20:20:52] webninja: там написано что журналирование нужно врубать. оно по дефолту включено только на 64 битных системах
[20:20:59] xa4a: в скле тебе просто чаще всего не надо представлять данные в виде дерева
[20:21:07] xa4a: т.к. они такими не являются в реальном мире
[20:21:09] webninja: ну канешно ) категории
[20:21:13] webninja: вложенные
[20:21:20] webninja: на каждом сайте
[20:21:20] xa4a: и всё
[20:21:31] webninja: ну да.
[20:21:42] xa4a: а в документоориентированной бд - надо всё в одно дерево как-то упаковывать
[20:21:47] webninja: а кстати если граф связей хранить, есть какие-то БД специализированные?
[20:21:55] xa4a: какие-то есть
[20:22:08] xa4a: graph dbs
[20:22:43] webninja: о ништяк, уже 10к инсертнулось )))
[20:23:50] xa4a: медленновато как-то
[20:24:20] sakal is now online
[20:24:23] Ranwise: а как из mysql в mongo перегнать? есть проги какие нибудь?
[20:24:31] Typhon is now away
[20:25:12] Typhon is now online
[20:25:15] webninja: не
[20:25:34] webninja: вряд ли
[20:25:42] dicos is now away
[20:25:43] dicos is now online
[20:29:23] sakal is now online
[20:29:41] nott is now online
[20:33:35] xa4a is now online
[20:34:25] sakal is now online
[20:34:34] webninja is now dnd
[20:37:24] blw0rm is now offline
[20:38:16] Singularity is now offline
[20:39:28] sakal is now online
[20:41:02] tvorzasp is now away
[20:41:02] tvorzasp is now away
[20:42:53] tvorzasp is now away
[20:42:53] tvorzasp is now сколько RoR на PHP не портируй, все равно Codeigniter получается
[20:43:41] nott is now offline
[20:44:31] sakal is now online
[20:49:33] sakal is now online
[20:49:50] dicos is now offline
[20:54:35] sakal is now online
[20:59:38] sakal is now online
[21:04:41] sakal is now online
[21:07:32] webninja is now dnd
[21:09:09] xa4a is now away
[21:09:44] sakal is now online
[21:10:33] webninja is now dnd
[21:10:33] webninja is now offline
[21:11:25] webninja is now dnd
[21:12:53] webninja is now offline
[21:14:47] sakal is now online
[21:15:04] levsha is now offline
[21:18:00] gigimon is now online
[21:19:09] xa4a is now away
[21:19:35] tvorzasp is now away
[21:19:35] tvorzasp is now away
[21:19:49] sakal is now online
[21:22:51] livevil is now online
[21:23:04] ink08 is now away
[21:23:05] ink08 is now away
[21:24:04] ink08 is now away
[21:24:04] ink08 is now online
[21:24:52] sakal is now online
[21:25:45] xa4a is now away
[21:25:49] xa4a is now online
[21:26:42] Сволота is now away
[21:29:54] sakal is now online
[21:31:43] webninja is now dnd
[21:32:40] Сволота is now online
[21:33:16] webninja is now offline
[21:34:57] sakal is now online
[21:36:31] webninja is now dnd
[21:38:24] xa4a is now away
[21:38:50] xa4a is now online
[21:39:11] tvorzasp is now away
[21:39:11] tvorzasp is now сколько RoR на PHP не портируй, все равно Codeigniter получается
[21:40:00] sakal is now online
[21:40:59] ink08 is now away
[21:41:02] ink08 is now away
[21:41:38] ink08 is now away
[21:41:38] ink08 is now online
[21:42:03] xa4a is now online
[21:42:31] webninja is now dnd
[21:42:31] webninja is now offline
[21:43:48] Сволота is now away
[21:45:02] sakal is now online
[21:48:50] Сволота is now online
[21:50:05] sakal is now online
[21:51:12] ink08 is now away
[21:51:13] ink08 is now away
[21:51:14] mishok13 is now offline
[21:52:21] ink08 is now away
[21:52:21] ink08 is now online
[21:53:52] Сволота is now away
[21:55:07] sakal is now online
[21:56:26] Сволота is now online
[22:00:09] sakal is now online
[22:02:47] Ranwise: в федоре вроде MariaDB по дефолту будет, типа оракл не всю инфу про разработку майскл пишет
[22:03:17] MAVr is now — Уважаемые пассажиры! Убедительно просим вас не аплодировать экипажу до полной остановки самолета. Спасибо!
[22:05:12] sakal is now online
[22:07:26] levsha is now online
[22:07:34] mishok13 is now online
[22:10:13] Typhon is now away
[22:10:15] sakal is now online
[22:12:05] Typhon is now online
[22:12:48] Typhon is now offline
[22:14:45] Typhon is now online
[22:14:50] alexey-grom is now away
[22:15:17] sakal is now online
[22:15:42] alexey-grom is now online
[22:15:44] Typhon is now offline
[22:20:21] sakal is now online
[22:22:19] d1ffuz0r is now online
[22:25:23] sakal is now online
[22:25:31] xa4a is now away
[22:26:38] Сволота is now away
[22:30:25] sakal is now online
[22:31:43] gigimon is now online
[22:31:43] gigimon is now away
[22:35:28] sakal is now online
[22:35:32] xa4a is now away
[22:36:38] Сволота is now xa
[22:39:20] gigimon is now away
[22:39:22] gigimon is now online
[22:40:31] sakal is now online
[22:43:16] Сволота is now online
[22:44:23] webninja is now dnd
[22:45:33] sakal is now online
[22:46:24] alexey-grom is now away
[22:46:44] webninja is now offline
[22:49:14] mishok13 is now away
[22:49:21] xa4a is now away
[22:49:23] mishok13 is now online
[22:49:25] xa4a is now online
[22:50:35] sakal is now online
[22:55:40] sakal is now online
[22:56:48] Сволота is now away
[23:00:43] sakal is now online
[23:01:46] Сволота is now online
[23:03:02] ink08 is now offline
[23:05:43] sakal is now online
[23:06:24] alexey-grom is now xa
[23:06:48] Сволота is now away
[23:07:06] MAVr is now offline
[23:10:48] sakal is now online
[23:11:49] Сволота is now online
[23:12:49] ink08 is now away
[23:15:49] sakal is now online
[23:20:52] sakal is now online
[23:25:54] sakal is now online
[23:30:18] gigimon is now online
[23:30:56] sakal is now online
[23:31:30] gigimon is now online
[23:32:54] Сволота is now away
[23:35:59] sakal is now online
[23:37:01] mishok13 is now away
[23:37:23] tvorzasp is now offline
[23:37:58] Сволота is now online
[23:41:01] sakal is now online
[23:41:18] mishok13 is now online
[23:41:27] livevil is now online
[23:44:47] xa4a is now away
[23:44:49] xa4a is now online
[23:46:04] sakal is now online
[23:48:59] mishok13 is now away
[23:49:04] mishok13 is now online
[23:50:20] xa4a is now online
[23:51:06] sakal is now online
[23:52:14] xa4a is now away
[23:54:35] gigimon is now online
[23:56:27] Ranwise is now offline
[23:56:34] xa4a is now online
[23:58:02] sakal is now online
[23:58:05] Сволота is now away
[23:59:29] sakal is now online
[23:59:41] webninja is now dnd