Project

General

Profile

Actions
Copy link

Feature #17957

closed

Improve database performance for external database host

Added by Dmitry Dulepov almost 17 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Dmitry Dulepov
Category:
-
Target version:
-
Start date:
2007-12-29
Due date:
% Done:

0%

Estimated time:
PHP Version:
5.0
Tags:
Complexity:
Sprint Focus:

Description

According to [1] MySQL performance may be greatly improved by using compression if MySQL is on the external host and connection link speed is less than 1Gbps. Attached patch adds an option to TYPO3 to enable compression and modifies database layer to use it for external database hosts.

[1] http://www.mysqlperformanceblog.com/2007/12/20/large-result-sets-vs-compression-protocol/

(issue imported from #M7059)

Files

Download all files
mysql_ext_db_perf.patch (4.45 KB) mysql_ext_db_perf.patch Administrator Admin, 2007-12-29 11:57
7059.diff (4.39 KB) 7059.diff Administrator Admin, 2008-10-03 11:06

Related issues 2 (0 open — 2 closed)

Related to TYPO3 Core - Bug #23066: mysql_pconnect() has too many parametersRejectedSteffen Gebert2010-07-01

Actions
Related to TYPO3 Core - Bug #23346: dbClientCompress crashes with pconnectClosedOliver Hader2010-08-04

Actions
Actions
Copy link

Also available in: Atom PDF