Continuent Developer Community
Welcome, Guest
Please Login or Register.    Lost Password?
Large single transaction updates (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 1
TOPIC: Large single transaction updates
#697
Chris Picton (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Large single transaction updates 3 Months, 2 Weeks ago Karma: 0  
Hi

We have some tables with a few million rows. Every now and again, an update is done to the tables which results in a few thousand rows updating or being inserted.

Since I am using ROW replication, the Tungsten master fails on these with either a packet too large exception or a heap error.

I have tried 72M max_allowed_packet, and 1024M java heap size, with the same results.

I am loathe to continually push these variables higher and higher, but am hoping that tungsten has a way of breaking this up into smaller chunks that can be managed more effectively.

Are there any settings i can look at to help with this?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
      Topics Author Date
    thread link
Large single transaction updates
Chris Picton 2010/05/24 09:54
    thread link
thread linkthread link Re:Large single transaction updates
Robert Hodges 2010/05/24 13:39
    thread link
thread linkthread linkthread link Re:Large single transaction updates
Chris Picton 2010/05/24 14:18
    thread link
thread linkthread linkthread linkthread link Re:Large single transaction updates
Robert Hodges 2010/05/24 14:43
    thread link
thread linkthread linkthread linkthread linkthread link Re:Large single transaction updates
Chris Picton 2010/05/24 16:11
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:Large single transaction updates
Robert Hodges 2010/05/24 17:28
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop