PennMUSH Community

Ticket #7619 (new incoming)

Opened 4 months ago

Last modified 4 months ago

MySQL persistent connections -- lag tradeoff?

Reported by: EricT Assigned to:
Priority: minor Milestone:
Keywords: mysql persistent connection lag Cc:
Visibility: Public

Description

Hi,

Build: Pennmush 1.8.3p5 with MySQL 4.1.22 under cygwin.

Running a website, I prefer applications (eg php) that do not open persistent MySQL connections but open and close when actually needed. Pennmush opens persistent connections, even if just a single @sql command is issued.

Maybe a tradeoff as this will reduce lag?

With good wishes, Eric T.

Change History

(in reply to: ↑ description ) 06/13/08 03:25:47 changed by EricT

Replying to EricT:

Hi, Build: Pennmush 1.8.3p5 with MySQL 4.1.22 under cygwin. Running a website, I prefer applications (eg php) that do not open persistent MySQL connections but open and close when actually needed. Pennmush opens persistent connections, even if just a single @sql command is issued. Maybe a tradeoff as this will reduce lag?

Scrub that: if pennmush only opens one persistent connection with MySQL and not one per player, it's not at all an issue.

With good wishes, eric.