tatacom 于 2009-02-07 16:00(14 年以前) 发表:
80W主题的论坛, 用户访问翻页占CPU很厉害, 请问有没有什么好的解决办法?

慢查询日志里很多这样的

# Query_time: 6 Lock_time: 0 Rows_sent: 38 Rows_examined: 33892
SELECT t.* FROM cdb_threads t
WHERE t.fid='58' AND t.displayorder IN (0, 1)
ORDER BY t.displayorder DESC, t.dateline DESC
LIMIT 101, 38;

# Query_time: 6 Lock_time: 0 Rows_sent: 38 Rows_examined: 51837
SELECT t.* FROM cdb_threads t
WHERE t.fid='25' AND t.displayorder IN (0, 1)
ORDER BY t.displayorder DESC, t.dateline DESC
LIMIT 25637, 38;

第 4355 楼评论 PHP SQL 注入攻击的技术实现以及预防办法:

小强于 2009-02-09 10:18(14 年以前) 发表:
LZ强啊
以后多多发表点，好让我们学习学习
受教了

第 4356 楼评论再见，北京（之二）：北京暂住证:

idsmirror 于 2009-02-09 18:31(14 年以前) 发表:
顶

第 4357 楼评论 Linux 下 OpenVPN 安装和 Windows OpenVPN GUI 安装笔记:

zengw 于 2009-02-10 11:39(14 年以前) 发表:
没做/etc/init.d/named start 这一步，完成后我用Windows vpn客户端拨号到vmware上去成功了并能上网，但是公司另一台PC拨号拨上去后却不能上网，其获得的IP和DNS均正常！请问是不是跟没做/etc/init.d/named start 这一步有关，但是跟vmware同一台PC上的Windows却可以上网！

第 4358 楼评论再见，北京（之二）：北京暂住证:

黑社会于 2009-02-10 16:00(14 年以前) 发表:
今天我去更换驾证，他妈的说要暂住证，荒谬至极，简直要操他先人，生活在这个国度，这么多年改革，居然还有这回事，黑社会！

第 4359 楼评论你认识这些三叠字和四叠字吗? 犇猋骉蟲麤毳淼掱焱垚鑫卉芔鱻飍姦掱贔:

王志淼于 2009-02-10 20:06(14 年以前) 发表:
有没有五叠字请教一下谢谢了

XiaoHui 回复于 2009-02-17 00:14:

有的。许多人认为四叠字就是极限，其实不然。

五叠字

五个口：外边为大口，里边有四个小口呈“燚字型”排列，应该算是一个五叠字。

五个口： “器”字型结构，中间的“犬”是一个“口”字，这应该是另一种五叠字。

六叠字

六个木：左右结构，左右两边分别是两个“森”字，而“森”本身就是一个“品”字型三叠字，因此整字是一个六叠字

六个子：上下结构，而上下部分又呈是“左中右”结构，这六部分，每一部分分别都是“子”，应该算是个另类六叠字

八叠字

八个木：四个“林”字呈燚字型排列。

四个“竹”字呈“燚字型”排列

当前页: 218 / 375
所有页面: [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]