Which data structure to use?

DDD888 · 发表于 10-2-2016 08:40:15

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

您需要登录才可以下载或查看，没有帐号？FreeOZ用户注册

x

本帖最后由 DDD888 于 10-2-2016 09:42 编辑

Sometimes the webserver I develop faced crashing due to some sql running a long long time i.e. running 30 minutes. Not very often. Once in two years. I don't want to turn on mysql long query log function. I want to develop code to log such sql if running without return from mysql.

I am thinking that I log the sql before sending to the sql server with a datetime stamp. If the sql query finished running on sql server and return to my code, I will deleted the sql record in my bookkeeping. I might face multiple same sql statement submit to the server, I think that I don't care the order to delete the sql as long as they runs very quickly, not the trouble making sql.

What data structure should I use? I think that array might not fit the bill, as I need to do bookkeeping about finding the empty cell to fill in and remove the sql in the cell.

What do you think? Thanks in advance

mason00 · 发表于 10-2-2016 09:27:51

你的应用和数据库之间的连接是没time out的吗？log应该是数据库做的。应用可以Log所有超时的sql。

DDD888 · 发表于 10-2-2016 09:58:53

mason00 发表于 10-2-2016 10:27
你的应用和数据库之间的连接是没time out的吗？log应该是数据库做的。应用可以Log所有超时的sql。

Thanks

I am asking my boss if he want that solution.

DDD888 · 发表于 10-2-2016 10:02:22

本帖最后由 DDD888 于 10-2-2016 11:39 编辑

DDD888 发表于 10-2-2016 10:58
Thanks

I am asking my boss if he want that solution.

My boss said no. He said that timeout might affect mysql database replication. I asked him to clarify it. And he said only as temporary solution using timeout. I still need to solve my original question.

mason00 · 发表于 10-2-2016 11:59:55

DDD888 发表于 10-2-2016 10:02
My boss said no. He said that timeout might affect mysql database replication. I asked him to cl ...

没有time out，你还是可以让sql数据库自己记录Long query。你可以分析数据库log。

mason00 · 发表于 10-2-2016 12:00:54

DDD888 发表于 10-2-2016 10:02
My boss said no. He said that timeout might affect mysql database replication. I asked him to cl ...

应用和数据库之间的连接time out，不是数据库全局的所有链接time out。

DDD888 · 发表于 10-2-2016 12:23:56

mason00 发表于 10-2-2016 12:59
没有time out，你还是可以让sql数据库自己记录Long query。你可以分析数据库log。

My boss turned off mysql database log. The server is very busy and the server generates lots of database log. It is outside of my control. My boss is the database admin.

DDD888 · 发表于 10-2-2016 12:24:26

mason00 发表于 10-2-2016 13:00
应用和数据库之间的连接time out，不是数据库全局的所有链接time out。

That is what I told him. He agrees.

		自动登录	找回密码
密码			FreeOZ用户注册

FreeOZ

[学习深造] Which data structure to use?

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。