-
Notifications
You must be signed in to change notification settings - Fork 38
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
mysql的连接池获取 #3
Comments
看看定义,和代码 |
嗯嗯 刚才git上不能提交图片。我给你邮件截图。
[cid:_Foxmail.1@62becd44-426d-376d-bfc5-6bf8966612e3]
构造里边初始化了pool对象。然后在getconn的时候获取一个连接。
刚才我本地调试还发现了一个问题。基于这个conn如果不开启事务的话,就没问题。但是在开启事务的时候 就会提示未将对象引用到实例 也就是conn对象有问题。
…________________________________
[email protected]
发件人: 2881099<mailto:[email protected]>
发送时间: 2019-06-26 13:54
收件人: 2881099/SafeObjectPool<mailto:[email protected]>
抄送: junlei-lv<mailto:[email protected]>; Author<mailto:[email protected]>
主题: Re: [2881099/SafeObjectPool] mysql的连接池获取 (#3)
看看定义,和代码
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#3?email_source=notifications&email_token=AJ7SYWPO4XEFCGO5PACJZKLP4MACLA5CNFSM4H3OVW32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYSNHNA#issuecomment-505729972>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AJ7SYWLYHWMFQPTOD7U2PXDP4MACLANCNFSM4H3OVW3Q>.
|
用qq等工具截图,在github回复框可以直接粘贴的 |
嗯嗯
…________________________________
[email protected]
发件人: 2881099<mailto:[email protected]>
发送时间: 2019-06-26 14:00
收件人: 2881099/SafeObjectPool<mailto:[email protected]>
抄送: junlei-lv<mailto:[email protected]>; Author<mailto:[email protected]>
主题: Re: [2881099/SafeObjectPool] mysql的连接池获取 (#3)
https://github.com/2881099/FreeSql/blob/master/Providers/FreeSql.Provider.MySql/MySqlAdo/MySqlConnectionPool.cs
看看这个
―
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#3?email_source=notifications&email_token=AJ7SYWN6NYWAX27RSHTUTODP4MAZJA5CNFSM4H3OVW32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYSNR6I#issuecomment-505731321>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AJ7SYWKDUR5U5V5NSPNHC3LP4MAZJANCNFSM4H3OVW3Q>.
|
已经引用了freesql.mysql的组件。
但是
var pool = new MySql.Data.MySqlClient.MySqlConnectionPool("名称", connectionString, 可用时触发的委托, 不可用时触发的委托);
var conn = pool.Get();
try {
// 使用 ...
pool.Return(conn); //正常归还
} catch (Exception ex) {
pool.Return(conn, ex); //发生错误时归还
}
这个实例中的 MySqlConnectionPool 还是引用出来。
…________________________________
[email protected]
发件人: 2881099<mailto:[email protected]>
发送时间: 2019-06-26 14:00
收件人: 2881099/SafeObjectPool<mailto:[email protected]>
抄送: junlei-lv<mailto:[email protected]>; Author<mailto:[email protected]>
主题: Re: [2881099/SafeObjectPool] mysql的连接池获取 (#3)
https://github.com/2881099/FreeSql/blob/master/Providers/FreeSql.Provider.MySql/MySqlAdo/MySqlConnectionPool.cs
看看这个
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#3?email_source=notifications&email_token=AJ7SYWN6NYWAX27RSHTUTODP4MAZJA5CNFSM4H3OVW32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYSNR6I#issuecomment-505731321>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AJ7SYWKDUR5U5V5NSPNHC3LP4MAZJANCNFSM4H3OVW3Q>.
|
还是引用出来是什么意思? |
另外一个问题就是。使用pool开启的conn对象如果在不开启事务的情况下是可以正常使用的。但是一旦使用事务。在开启事务的时候就会检查到conn为null
…________________________________
[email protected]
发件人: 2881099<mailto:[email protected]>
发送时间: 2019-06-26 14:00
收件人: 2881099/SafeObjectPool<mailto:[email protected]>
抄送: junlei-lv<mailto:[email protected]>; Author<mailto:[email protected]>
主题: Re: [2881099/SafeObjectPool] mysql的连接池获取 (#3)
https://github.com/2881099/FreeSql/blob/master/Providers/FreeSql.Provider.MySql/MySqlAdo/MySqlConnectionPool.cs
看看这个
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#3?email_source=notifications&email_token=AJ7SYWN6NYWAX27RSHTUTODP4MAZJA5CNFSM4H3OVW32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYSNR6I#issuecomment-505731321>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AJ7SYWKDUR5U5V5NSPNHC3LP4MAZJANCNFSM4H3OVW3Q>.
|
找不到MysqlConnectionPool这个类
…________________________________
[email protected]
发件人: 2881099<mailto:[email protected]>
发送时间: 2019-06-26 14:52
收件人: 2881099/SafeObjectPool<mailto:[email protected]>
抄送: junlei-lv<mailto:[email protected]>; Author<mailto:[email protected]>
主题: Re: [2881099/SafeObjectPool] mysql的连接池获取 (#3)
还是引用出来是什么意思?
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#3?email_source=notifications&email_token=AJ7SYWPZ57FN6WVHFBEJVRDP4MG2ZA5CNFSM4H3OVW32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYSQ56Y#issuecomment-505745147>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AJ7SYWLI565I3KO36QX7XF3P4MG2ZANCNFSM4H3OVW3Q>.
|
那是一个内部类,可以把代码 copy 出来使用 |
弱弱的问下,你封装mysql用来作什么 |
mysql有个类型是不支持事务的 难道是用了mysam? |
长连接维持也需要开销,这个我也懵了, |
@senioi 内部服务用长连接好,效率高,且数量有限。 其实ado.net基本都实现了pooling,SafeObjectPool除了池化作用,还有断熔和恢复功能。 当数据库连接不上的时候,程序基本会一直请求数据库,15秒连超时才响应。断熔后即刻响应,不影响程序的其他功能。恢复功能,可以等到数据库可用时自动切换回来。 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
为什么每次获取出来的conn打开事务的时候回出现 conn是null的情况。
The text was updated successfully, but these errors were encountered: