Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • Aug 23 07:05
    Sebastianooooooo opened #54
  • Aug 12 06:36

    louislivi on develop

    Remove travis php 7.0 version (compare)

  • Aug 12 03:51

    louislivi on develop

    Update travis swoole version to… (compare)

  • Aug 12 03:10

    louislivi on develop

    Update docs README.md format (compare)

  • Aug 12 02:58

    louislivi on develop

    Add SMProxy database alias (compare)

  • Aug 08 10:07

    louislivi on master

    Fix swoole table too short colu… (compare)

  • Aug 08 06:25

    louislivi on master

    Fix connect close delete thread… (compare)

  • Aug 08 02:43

    louislivi on master

    Update docs translations button… (compare)

  • Aug 06 01:40

    louislivi on master

    Update docs README.md (compare)

  • Aug 05 10:33

    louislivi on master

    Fix maxConns computed columns a… (compare)

  • Aug 05 03:18
    yymmhh closed #53
  • Aug 05 03:10
    yymmhh edited #53
  • Aug 05 03:10
    yymmhh opened #53
  • Jul 23 02:40

    louislivi on master

    Fix travis ci mysql password er… (compare)

  • Jul 23 02:28

    louislivi on master

    Fix travis ci mysql build error (compare)

  • Jul 23 02:21

    louislivi on master

    Fix travis ci mysql error (compare)

  • Jul 23 01:38

    louislivi on master

    Fix swoole table size (compare)

  • Jul 23 01:34

    louislivi on master

    Fix swoole table Unable to allo… (compare)

  • Jul 17 01:13
    louislivi commented #52
  • Jul 16 07:21
    571031767 opened #52
louislivi
@louislivi
可以在这里发言哦~
louislivi
@louislivi
Can speak here~
louislivi
@louislivi
  /$$$$$$  /$$      /$$ /$$$$$$$                                        
 /$$__  $$| $$$    /$$$| $$__  $$                                       
| $$  \__/| $$$$  /$$$$| $$  \ $$ /$$$$$$   /$$$$$$  /$$   /$$ /$$   /$$
|  $$$$$$ | $$ $$/$$ $$| $$$$$$$//$$__  $$ /$$__  $$|  $$ /$$/| $$  | $$
 \____  $$| $$  $$$| $$| $$____/| $$  \__/| $$  \ $$ \  $$$$/ | $$  | $$
 /$$  \ $$| $$\  $ | $$| $$     | $$      | $$  | $$  >$$  $$ | $$  | $$
|  $$$$$$/| $$ \/  | $$| $$     | $$      |  $$$$$$/ /$$/\  $$|  $$$$$$$
 \______/ |__/     |__/|__/     |__/       \______/ |__/  \__/ \____  $$
                                                               /$$  | $$
                                                              |  $$$$$$/
                                                               \______/

SMProxy

一个基于 MySQL 协议,Swoole 开发的MySQL数据库连接池。
  • 支持读写分离
  • 支持数据库连接池,能够有效解决 PHP 带来的数据库连接瓶颈
  • 支持 SQL92 标准
  • 采用协程调度
  • 支持多个数据库连接,多个数据库,多个用户,灵活搭配
  • 遵守 MySQL 原生协议,跨语言,跨平台的通用中间件代理
  • 支持 MySQL 事务
  • 支持 HandshakeV10 协议版本
  • 完美兼容 MySQL4.1 - 8.0
  • 兼容各大框架,无缝提升性能
galen-bin
@galen-bin
怎么安装呢
louislivi
@louislivi
解压,配好配置,执行SMProxy文件
lifengjacky
@lifengjacky
000
Foolgry
@foolgry
test
lijiping126
@lijiping126
demo
@galen-bin hi
xiaolong
@luanjinlong
The requested PHP extension ext-swoole ^2.1.3||^4.3 is missing from your system. Install or enable PHP's swoole extension. 这个报错不知道怎么处理
我已经安装了 swoole PHP 的扩展也正常
Arif Majid
@binaryelites
PHP Fatal error: Uncaught RuntimeException: Cannot find config dir. in /home/shahid/swoole/SMProxy/src/Helper/functions.php:106
louislivi
@louislivi
@binaryelites The config directory should be located in the SMProxy directory.
Arif Majid
@binaryelites
Do we have any oracle library for this?
louislivi
@louislivi
Not yet.
Arif Majid
@binaryelites
any plans for the oracle extension?
Arif Majid
@binaryelites
@louislivi SMPROXY@ Reach max connections! Cann't pending fetch!
should the maxConns be always be a multiple of num of cpus available?
around 5-10k queries are executed per second here
Mr.lu
@imisy
哎 这个不错哦
louislivi
@louislivi
@binaryelites No plan for the time being,you are right ,Reach max connections question to see
Arif Majid
@binaryelites
@louislivi recommended timeout is 2-5 seconds. should we increase it to 10 seconds? will it cause any issue? As i am facing this issue frequently now.
louislivi
@louislivi
@binaryelites 10 seconds is OK. I suggest you increase maxConns.
Aslam Shahid
@ashahid007
Hello. Few of my connections are never used even i see Reach max Connection Pending Fetch. Why this happens. How i can enable logs or Fix it.
Also, what is benefit of using multiple workers. CPU or Concurrency etc.
louislivi
@louislivi
Maybe your connection will not be released, it will also cause the problem.
Explanation of workers https://www.swoole.co.uk/docs/modules/swoole-server/configuration
xiaoguo
@xiaoguo0426
请问SMProxy与mysql自身的连接池两者有什么区别呢?或者SMProxy有哪些优势?
miaotaizi
@miaotaizi
这个扩展是不能跟 xdebug 一起运行吗