t0m3kk: Някой случайно да му се намира няк'ъф абсолютно ненужен sql, който да е около 200 mb? Може и 100 да е, но да не е под 100 :)

Вход

Начало Потребители Групи

Следващ пост Профил на t0m3kk Предишен пост

t0m3kk

Някой случайно да му се намира няк'ъф абсолютно ненужен sql, който да е около 200 mb? Може и 100 да е, но да не е под 100

Jun 25 2012, 17:06

Коментари

aviatrix

па генерирай си

Jun 25 2012, 17:10

t0m3kk

па как?

Jun 25 2012, 17:11

dilana

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /var/www/html/system/classes/class_postcomment.php on line 102
http://www.generatedata.com/#generator така?

Jun 25 2012, 18:15

t0m3kk

Аз вече пробвах с 170MB SQL и скрипта си свърши перфектно работата... Извлече си, после си ги върна...

Jun 25 2012, 18:16

eXtreme

слагаш ini_set('max_execution_time', 320) и изпълнява sql insert заявка в while(1==1) цикъл

Jun 25 2012, 18:17

t0m3kk

хах, не се бях замислил за това

Jun 25 2012, 18:22

Facebook

DB Queries: 9 (0.0038s) | CACHE Queries: 20 (0.0017s) | Script Execution Time: 0.008 | Memory usage: 0.92MB | Server Load Average: 0.14, 0.1, 0.09

0.00038	SELECT * FROM posts_comments WHERE post_id="1428842" ORDER BY id ASC
0.00041	SELECT * FROM posts WHERE id<"1428930" AND user_id="6742" ORDER BY id DESC LIMIT 1
0.00029	SELECT id, type, data FROM posts_attachments WHERE post_id="1428932" LIMIT 1
0.00031	SELECT * FROM posts WHERE id>"1428930" AND user_id="6742" ORDER BY id ASC LIMIT 1
0.00024	SELECT id FROM groups WHERE is_public=0
0.00039	SELECT * FROM posts_comments WHERE post_id="1428930" ORDER BY id ASC
0.00024	SELECT * FROM posts WHERE id="1428930" LIMIT 1
0.00026	SELECT * FROM settings
0.00131	CONNECT 49.12.223.183:9906

0.00008	GET	f5dad\|1000\|n:1,userid:15903	object
0.00015	GET	f5dad\|1000\|n:1,userid:9542	object
0.00011	GET	f5dad\|1000\|n:1,groupid:53	object
0.00005	GET	f5dad\|1000\|n:1,group_invited_members:365	array
0.00006	GET	f5dad\|1000\|n:1,groupid:365	object
0.00007	GET	f5dad\|1000\|n:1,group_invited_members:358	array
0.00007	GET	f5dad\|1000\|n:1,groupid:358	object
0.00008	GET	f5dad\|1000\|n:1,group_invited_members:343	array
0.00010	GET	f5dad\|1000\|n:1,groupid:343	object
0.00006	GET	f5dad\|1000\|n:1,group_invited_members:240	array
0.00007	GET	f5dad\|1000\|n:1,groupid:240	object
0.00005	GET	f5dad\|1000\|n:1,group_invited_members:221	array
0.00005	GET	f5dad\|1000\|n:1,groupid:221	object
0.00005	GET	f5dad\|1000\|n:1,group_invited_members:132	array
0.00008	GET	f5dad\|1000\|n:1,groupid:132	object
0.00008	GET	f5dad\|1000\|n:1,userid:218	object
0.00008	GET	f5dad\|1000\|n:1,userid:8313	object
0.00011	GET	f5dad\|1000\|n:1,userid:2628	object
0.00028	GET	f5dad\|1000\|n:1,userid:6742	object
0.00001	CONNECT	172.20.0.6:11211	TRUE