[JIRA] Created: (MYO-113) Allow fast r/w splitting for applications which don't have select for updates

Discussion:

Gilles Rayrat (JIRA)

2009-12-22 14:46:47 UTC

Allow fast r/w splitting for applications which don't have select for updates
-----------------------------------------------------------------------------

Key: MYO-113
URL: https://forge.continuent.org/jira/browse/MYO-113
Project: Tungsten Connector
Type: Improvement

Components: PostgreSQL protocol, MySQL protocol
Reporter: Gilles Rayrat
Assigned to: Gilles Rayrat

Current read/write splitting code parses the whole query to determine if a "for update" follows select statements, which can be very resource consuming for long queries.

We should have a way to tell the connector that there are no "select for update" statements. It could be also good to have a test mode that would report clearly when such statements are found (for users who don't know if they have SFU statements)

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira

Gilles Rayrat (JIRA)

2009-12-22 16:46:46 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-113?page=all ]

Gilles Rayrat closed MYO-113:
-----------------------------

Fix Version: 0.6.9
Resolution: Fixed

Commited in SVN

Post by Gilles Rayrat (JIRA)
Allow fast r/w splitting for applications which don't have select for updates
-----------------------------------------------------------------------------
Key: MYO-113
URL: https://forge.continuent.org/jira/browse/MYO-113
Project: Tungsten Connector
Type: Improvement
Components: PostgreSQL protocol, MySQL protocol
Reporter: Gilles Rayrat
Assignee: Gilles Rayrat
Fix For: 0.6.9
Current read/write splitting code parses the whole query to determine if a "for update" follows select statements, which can be very resource consuming for long queries.
We should have a way to tell the connector that there are no "select for update" statements. It could be also good to have a test mode that would report clearly when such statements are found (for users who don't know if they have SFU statements)

Gilles Rayrat (JIRA)

2010-02-08 19:47:47 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-113?page=all ]

Gilles Rayrat closed MYO-113:
-----------------------------

Resolution: Fixed

Post by Gilles Rayrat (JIRA)
Allow fast r/w splitting for applications which don't have select for updates
-----------------------------------------------------------------------------
Key: MYO-113
URL: https://forge.continuent.org/jira/browse/MYO-113
Project: Tungsten Connector
Type: Improvement
Components: MySQL protocol, PostgreSQL protocol
Reporter: Gilles Rayrat
Assignee: Gilles Rayrat
Fix For: 0.6.8
Current read/write splitting code parses the whole query to determine if a "for update" follows select statements, which can be very resource consuming for long queries.
We should have a way to tell the connector that there are no "select for update" statements. It could be also good to have a test mode that would report clearly when such statements are found (for users who don't know if they have SFU statements)

Gilles Rayrat (JIRA)

2010-02-08 19:47:46 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-113?page=all ]

Gilles Rayrat reopened MYO-113:
-------------------------------

Re-opening to edit fix version

Post by Gilles Rayrat (JIRA)
Allow fast r/w splitting for applications which don't have select for updates
-----------------------------------------------------------------------------
Key: MYO-113
URL: https://forge.continuent.org/jira/browse/MYO-113
Project: Tungsten Connector
Type: Improvement
Components: MySQL protocol, PostgreSQL protocol
Reporter: Gilles Rayrat
Assignee: Gilles Rayrat
Fix For: 0.6.8
Current read/write splitting code parses the whole query to determine if a "for update" follows select statements, which can be very resource consuming for long queries.
We should have a way to tell the connector that there are no "select for update" statements. It could be also good to have a test mode that would report clearly when such statements are found (for users who don't know if they have SFU statements)