cached L2O 

🚫
Exiled
Joined
Nov 18, 2004
Messages
377
Reaction score
0
heh i guess i better upgrade soon. Not enough hardware for the amount of users and size of DB's I guess.

01/31/2005 11:00:13.937, sql execution time [27594]ms, sql[EXEC lin_GetUserLogTime 2863, 1, 26]
01/31/2005 11:00:16.031, sql execution time [21484]ms, sql[EXEC lin_GetUserLogTime 8597, 1, 5]
01/31/2005 11:00:16.046, sql execution time [21266]ms, sql[EXEC lin_GetUserLogTime 3081, 1, 19]
01/31/2005 11:00:16.078, sql execution time [19906]ms, sql[EXEC lin_GetUserLogTime 8354, 1, 14]
01/31/2005 11:00:16.109, sql execution time [12016]ms, sql[EXEC lin_GetUserLogTime 8486, 1, 4]
01/31/2005 11:00:34.156, can not find location bbs
01/31/2005 11:01:23.687, sql execution time [24563]ms, sql[EXEC lin_GetUserLogTime 4748, 1, 30]
01/31/2005 11:01:56.203, [WareHouse.cpp][3933]Useitem::Cannot find item, [468208][2][1][7900][329154][1216364262]
01/31/2005 11:01:56.359, [WareHouse.cpp][3933]Useitem::Cannot find item, [468208][2][1][7900][329154][1216364262]
01/31/2005 11:01:56.406, [WareHouse.cpp][3933]Useitem::Cannot find item, [468208][2][1][7900][329154][1216364262]
01/31/2005 11:01:56.500, [WareHouse.cpp][3933]Useitem::Cannot find item, [468208][2][1][7900][329154][1216364262]
01/31/2005 11:02:18.890, sql execution time [22125]ms, sql[EXEC lin_GetUserLogTime 3979, 1, 7]
01/31/2005 11:02:18.890, sql execution time [15656]ms, sql[EXEC lin_GetUserLogTime 7471, 1, 14]
01/31/2005 11:02:18.937, sql execution time [13844]ms, sql[EXEC lin_GetUserLogTime 8571, 1, 6]
01/31/2005 11:02:56.140, [WareHouse.cpp][3933]Useitem::Cannot find item, [467683][2][1][3134][324188][1213242719]
01/31/2005 11:03:09.406, [WareHouse.cpp][3933]Useitem::Cannot find item, [460667][2][1][6299][260259][1216378787]
01/31/2005 11:03:27.968, sql execution time [26109]ms, sql[EXEC lin_GetUserLogTime 8599, 1, 5]
01/31/2005 11:03:28.718, sql execution time [25000]ms, sql[EXEC lin_GetUserLogTime 8559, 1, 8]
01/31/2005 11:03:32.375, sql execution time [12562]ms, sql[EXEC lin_GetUserLogTime 6332, 1, 17]
01/31/2005 11:04:21.671, sql execution time [23531]ms, sql[EXEC lin_GetUserLogTime 7279, 1, 19]
01/31/2005 11:04:21.750, sql execution time [22078]ms, sql[EXEC lin_GetUserLogTime 7298, 1, 13]
01/31/2005 11:05:31.671, Invalid WriteLogout BadGirl(4891), kill(4462), (0)
01/31/2005 11:06:09.375, sql execution time [22515]ms, sql[EXEC lin_GetUserLogTime 7023, 1, 17]
01/31/2005 11:06:09.390, sql execution time [15610]ms, sql[EXEC lin_GetUserLogTime 7340, 1, 11]
01/31/2005 11:07:15.593, sql execution time [11734]ms, sql[EXEC lin_GetUserLogTime 8102, 1, 8]
01/31/2005 11:07:15.640, sql execution time [10610]ms, sql[EXEC lin_GetUserLogTime 8607, 1, 4]
01/31/2005 11:07:16.375, sql execution time [26875]ms, sql[EXEC lin_DeleteItem 432415]
01/31/2005 11:07:16.375, sql execution time [15109]ms, sql[EXEC lin_DeleteItem 466454]
01/31/2005 11:08:06.765, sql execution time [9078]ms, sql[EXEC lin_CreateChar N'AsokSemai',N'torwald',6299,0,0,1,1,25,1,48656,40144,-3440,50.000000,80.000000,0,0,1,0,0,0,0,5,1,1]
01/31/2005 11:08:09.875, [WareHouse.cpp][3933]Useitem::Cannot find item, [464949][2][1][8243][300592][1216359474]
01/31/2005 11:08:10.421, [WareHouse.cpp][3933]Useitem::Cannot find item, [464949][2][1][8243][300592][1216359474]
01/31/2005 11:08:20.359, sql execution time [13594]ms, sql[EXEC lin_GetUserDataByCharId 8611]
01/31/2005 11:08:28.500, sql execution time [16484]ms, sql[EXEC lin_GetUserLogTime 8507, 1, 11]
01/31/2005 11:08:28.546, sql execution time [18391]ms, sql[EXEC lin_GetUserLogTime 5850, 2, 53]
01/31/2005 11:08:56.750, Invalid WriteLogout Linla(398), Lambchops(9), (0)
01/31/2005 11:09:21.625, Invalid WriteLogout buster(2958), buster76(2919), (0)
01/31/2005 11:09:28.843, sql execution time [10781]ms, sql[EXEC lin_GetUserLogTime 8607, 1, 5]
01/31/2005 11:09:35.343, sql execution time [13406]ms, sql[EXEC lin_GetUserLogTime 7274, 1, 23]
01/31/2005 11:09:57.015, can not find location bbs
01/31/2005 11:09:57.015, can not find location bbs
01/31/2005 11:10:09.500, Error sql: EXEC lin2comm.dbo.lin_GetFavorite 8606, 1 (0)
01/31/2005 11:10:09.500, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:09.500, Error occurred in RequestBBSGetFavorite
01/31/2005 11:10:13.156, Error sql: EXEC lin2comm.dbo.lin_GetBoardList 0, 1, 1, 0 (0)
01/31/2005 11:10:13.156, Error sql: EXEC lin2comm.dbo.lin_GetBoardList 0, 1, 1, 0 (0)
01/31/2005 11:10:13.156, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:13.156, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:13.156, Error occurred in RequestBBSGetBoardList
01/31/2005 11:10:13.156, Error occurred in RequestBBSGetBoardList
01/31/2005 11:10:13.187, Error sql: EXEC lin2comm.dbo.lin_GetBoardList 0, 1, 1, 0 (0)
01/31/2005 11:10:13.187, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:13.187, Error occurred in RequestBBSGetBoardList
01/31/2005 11:10:13.953, Error sql: EXEC lin2comm.dbo.lin_GetFavorite 8606, 1 (0)
01/31/2005 11:10:13.953, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:13.953, Error occurred in RequestBBSGetFavorite
01/31/2005 11:10:14.406, can not find location bbs
01/31/2005 11:10:18.328, Error sql: EXEC lin2comm.dbo.lin_GetFavorite 8606, 1 (0)
01/31/2005 11:10:18.328, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:18.328, Error occurred in RequestBBSGetFavorite
01/31/2005 11:10:18.500, Error sql: EXEC lin2comm.dbo.lin_GetBoardList 0, 1, 8, 0 (0)
01/31/2005 11:10:18.500, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:18.500, Error occurred in RequestBBSGetBoardList
01/31/2005 11:10:18.578, can not find location bbs
01/31/2005 11:10:18.687, can not find location bbs
01/31/2005 11:10:18.687, can not find location bbs
01/31/2005 11:10:18.750, Error sql: EXEC lin2comm.dbo.lin_GetFavorite 8606, 1 (0)
01/31/2005 11:10:18.750, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:18.750, Error occurred in RequestBBSGetFavorite
01/31/2005 11:10:18.750, Error sql: EXEC lin2comm.dbo.lin_GetBoardList 0, 1, 1, 0 (0)
01/31/2005 11:10:18.750, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:18.750, Error occurred in RequestBBSGetBoardList
01/31/2005 11:10:20.640, Error sql: EXEC lin2comm.dbo.lin_GetFavorite 6384, 1 (0)
01/31/2005 11:10:20.640, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:20.640, Error occurred in RequestBBSGetFavorite
01/31/2005 11:10:21.843, Error sql: EXEC lin2comm.dbo.lin_GetFavorite 6384, 1 (0)
01/31/2005 11:10:21.843, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:21.843, Error occurred in RequestBBSGetFavorite
01/31/2005 11:10:22.453, Error sql: EXEC lin2comm.dbo.lin_GetFavorite 8606, 1 (0)
01/31/2005 11:10:22.453, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:22.453, Error occurred in RequestBBSGetFavorite
01/31/2005 11:10:23.578, Error sql: EXEC lin2comm.dbo.lin_GetFavorite 8606, 1 (0)
01/31/2005 11:10:23.578, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:23.578, Error occurred in RequestBBSGetFavorite
01/31/2005 11:10:23.687, Error sql: EXEC lin2comm.dbo.lin_GetFavorite 8606, 1 (0)
01/31/2005 11:10:23.687, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:23.687, Error occurred in RequestBBSGetFavorite
01/31/2005 11:10:24.453, Error sql: EXEC lin2comm.dbo.lin_GetFavorite 8606, 1 (0)
01/31/2005 11:10:24.453, Error HYT00:[Microsoft][ODBC SQL Server Driver]Timeout expired
01/31/2005 11:10:24.453, Error occurred in RequestBBSGetFavorite
01/31/2005 11:12:28.906, sql execution time [14016]ms, sql[EXEC lin_GetUserLogTime 7632, 1, 17]
 
15-20 seconds for those sql tasks is WAYY to much. Either your DB is all messed up or yeah u need new hardware.

Btw use code tags next time and no need to double post.
 
Upvote 0
lol my db's are fine. This only happens after 20-35 hours of 500+ users logged on. I guess current hardware cant handle that.
 
Upvote 0
Back