MySQL Forums
Forum List  »  Performance

1 row Update query long for short duration
Posted by: karl lauritzen
Date: June 11, 2013 10:14AM

The query below will run less than 1 second all day except for 2 hours at end of day 4pm to 5pm. Then it takes 2-5 seconds.

I run with mysql workbench and all is well. I did profile on it and result is below. I run slow query log then all i get is these queries. They are run in spinoff thread from our app not in the thread atached to a user session.

We have 5 different servers all with saame aplications. This is only server with this behavior. All are 16 core 96GB RAM. Windows. MySql 5.5.27

I have trx commit to 0. I use 8 pools buffer pool size 42GB and thread concurrency to 0

What else whould i look at beside run show profile when it happens later today?


CALL `b0040`.`spMasterTableUpdate`(1096, 2, _binary 'Mr. Rooter Z-Ware License Agreement

IMPORTANT

In this Agreement, Mr. Rooter Z-Ware will be referred to as the \"Product.\"

This software is licensed not sold. Installing this software indicates that the Licensee, has read and understands this license agreement, and accept its terms and conditions. If the Licensee does not agree with this license, the Licensee may not use or install this software or violate any of the terms of this license. Promptly return the software to Mr. Rooter Corporation (\"Mr. Rooter\").

TERMS

The Licensee may use each licensed copy in the Product on a single computer and make one archival copy of the materials received from Mr. Rooter whole or in part, for backup purposes.

Except as otherwise expressly permitted in this Agreement, the Licensee may not modify or create any derivative works of the Product or documentation; decompile, disassemble, reverse engineer, or otherwise attempt to derive the source code for the Product redistribute, sublicense, or otherwise transfer rights to the Product; or remove or alter any trademark, logo, copyright or other proprietary notices in the Product.

Mr. Rooter reserves the right to disable the Product in part or in whole upon termination of this Agreement. Mr. Rooter reserves the right to terminate this Agreement if the Licensee breaches any of its terms and conditions, Licensee ceases to be a franchisee or is in breach of his franchise agreement. Upon termination, the Licensee agrees to destroy the Product together with all archival copies.

No interest, license, conveyance or any right respecting the Product other than that expressly set out in the Agreement, is granted to Licensee under this Agreement, by implication or otherwise. The Product is not the property of Licensee, and Licensee may not sublicense, lease, loan, rent or give the Product or any modification to the Product to any party. The Product is protected under that section of the franchise agreement addressing Proprietary Information; the Product is accorded the same protection as the manuals, system, other Confidential Information and Trade Secrets (as those terms are defined in your franchise agreement). The Product is part of the Confidential Information available to franchisees and subject to confidentiality requirements. Licensee will permit access to the Product only to Licensee s authorized employees and representatives.

Licensee shall provide protection against computer viruses.

FEES

The Licensee shall pay all sales or excise taxes that are assessed against the Product by state, local, or national governments.


LIMITED WARRANTY

Although Mr. Rooter has verified, to the best of its ability, that the Product is reliable, Mr. Rooter does not warrant that the functions contained in the Product will meet the Licensee\'s requirements or that the Product will operate uninterrupted and error-free.

EXCEPT AS DESCRIBED IN THE LIMITED WARRANTY ABOVE, THE PRODUCT IS PROVIDED ON AN \"AS IS\" BASIS, WITHOUT WARRANTY OF ANY KIND, INCLUDING WITHOUT LIMITATION THE WARRANTIES THAT IT IS FREE OF DEFECTS, MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE OR NON-INFRINGING AND ALL SUCH WARRANTIES ARE EXPRESSLY AND SPECIFICALLY DISCLAIMED. SOME STATES DO NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES, SO THE ABOVE EXCLUSION MAY NOT APPLY. THIS WARRANTY GIVES THE LICENSEE SPECIFIC LEGAL RIGHTS AND THE LICENSEE MAY ALSO HAVE OTHER RIGHTS WHICH VARY FROM STATE TO STATE.

THE SECURITY MECHANISMS IMPLEMENTED BY THE PRODUCT HAVE INHERENT LIMITATIONS, AND LICENSEE MUST DETERMINE THAT THE PRODUCT SUFFICIENTLY MEETS ITS REQUIREMENTS. THE LICENSEE MUST SECURE ALL MEDIA DISTRIBUTED TO THEM BY MR. ROOTER AS WELL AS THE COMPUTER EQUIPMENT ON WHICH THIS PRODUCT IS INSTALLED AND DESTROY OR RETURN ALL SUCH MEDIA UPON TERMINATION OF THIS AGREEMENT. THIS DISCLAIMER OF WARRANTY CONSTITUTES AN ESSENTIAL PART OF THIS AGREEMENT. NO USE OF THE PRODUCT IS AUTHORIZED HEREUNDER EXCEPT UNDER THIS DISCLAIMER.


LIMITATION OF LIABILITY

IN NO EVENT WILL MR. ROOTER ITS SUPPLIERS OR RESELLERS OR ANY CONTRIBUTORS TO THE SOURCE CODE BE LIABLE FOR ANY INDIRECT, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OF OR INABILITY TO USE THE PRODUCT, INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF GOODWILL, WORK STOPPAGE, COMPUTER FAILURE OR MALFUNCTION, OR ANY AND ALL OTHER COMMERCIAL DAMAGES OR LOSSES, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. IN ANY CASE, MR. ROOTER\'S ENTIRE LIABILITY UNDER ANY PROVISION OF THIS AGREEMENT SHALL NOT EXCEED IN THE AGGREGATE THE SUM OF THE FEES LICENSEE PAID FOR THIS LICENSE AND FEES INCURRED FOR THE MAINTANANCE OF THE PRODUCT EXCEPT TO THE EXTENT APPLICABLE LAW PROHIBITS THE LIMITATION OF DAMAGES. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO THIS EXCLUSION AND LIMITATION MAY NOT BE APPLICABLE.

EXPORT CONTROL

The Product includes strong encryption. Licensee agrees to comply with all export laws and restrictions and regulations of the United States or foreign agencies or authorities, and not to export or re-export the Product or any direct product thereof in violation of any such restrictions, laws or regulations, or without all necessary approvals. As applicable, each party shall obtain and bear all expenses relating to any necessary licenses and/or exemptions with respect to its own export of the Product from the U.S. Neither the Product nor the underlying information or technology may be downloaded or otherwise exported or re-exported into Cuba, Iran, Iraq, Libya, North Korea, Sudan, Syria or any other country subject to U.S. trade sanctions covering the Product, to individuals or entities controlled by such countries, or to nationals or residents of such countries other than nationals who are lawfully admitted permanent residents of countries not subject to such sanctions; or to anyone on the U.S. Treasury Department\'s list of Specially Designated Nationals and Blocked Persons or the U.S. Commerce Department\'s Table of Denial Orders. By installing or using the Product, the Licensee agrees to the foregoing and represents and warrants that it complies with these conditions.

MISCELLANEOUS

This Agreement constitutes the entire agreement between the parties, and supersedes all prior agreements, whether written or oral. The terms of this Agreement may be modified by Mr. Rooter upon written notice to Licensee.


1) MasterPassword - Allows you access to any area. To use enter the MasterPassword above and then you can enter the same Password in any field that requests one.

2) SetupPassword - Allows you access to Prospect Setup. We recommend using this setting in a multi-user environment. To use, enter the SetupPassword above and then as you enter the Prospect Setup area you will be prompted to enter that password.

3) UsePasswords is available to assign specific passwords to your employees. To use, select the UsePasswords option above and then close this window. Then select Employees. Add each Employee Name as they will enter it on the system and their individual Password. When starting the system, employees will be prompted to select their name and enter a password.',

IMPORTANT

In this Agreement, Mr. Rooter Z-Ware will be referred to as the \"Product.\"

This software is licensed not sold. Installing this software indicates that the Licensee, has read and understands this license agreement, and accept its terms and conditions. If the Licensee does not agree with this license, the Licensee may not use or install this software or violate any of the terms of this license. Promptly return the software to Mr. Rooter Corporation (\"Mr. Rooter\").

TERMS

The Licensee may use each licensed copy in the Product on a single computer and make one archival copy of the materials received from Mr. Rooter whole or in part, for backup purposes.

Except as otherwise expressly permitted in this Agreement, the Licensee may not modify or create any derivative works of the Product or documentation; decompile, disassemble, reverse engineer, or otherwise attempt to derive the source code for the Product redistribute, sublicense, or otherwise transfer rights to the Product; or remove or alter any trademark, logo, copyright or other proprietary notices in the Product.

Mr. Rooter reserves the right to disable the Product in part or in whole upon termination of this Agreement. Mr. Rooter reserves the right to terminate this Agreement if the Licensee breaches any of its terms and conditions, Licensee ceases to be a franchisee or is in breach of his franchise agreement. Upon termination, the Licensee agrees to destroy the Product together with all archival copies.

No interest, license, conveyance or any right respecting the Product other than that expressly set out in the Agreement, is granted to Licensee under this Agreement, by implication or otherwise. The Product is not the property of Licensee, and Licensee may not sublicense, lease, loan, rent or give the Product or any modification to the Product to any party. The Product is protected under that section of the franchise agreement addressing Proprietary Information; the Product is accorded the same protection as the manuals, system, other Confidential Information and Trade Secrets (as those terms are defined in your franchise agreement). The Product is part of the Confidential Information available to franchisees and subject to confidentiality requirements. Licensee will permit access to the Product only to Licensee s authorized employees and representatives.

Licensee shall provide protection against computer viruses.

FEES

The Licensee shall pay all sales or excise taxes that are assessed against the Product by state, local, or national governments.


LIMITED WARRANTY

Although Mr. Rooter has verified, to the best of its ability, that the Product is reliable, Mr. Rooter does not warrant that the functions contained in the Product will meet the Licensee\'s requirements or that the Product will operate uninterrupted and error-free.

EXCEPT AS DESCRIBED IN THE LIMITED WARRANTY ABOVE, THE PRODUCT IS PROVIDED ON AN \"AS IS\" BASIS, WITHOUT WARRANTY OF ANY KIND, INCLUDING WITHOUT LIMITATION THE WARRANTIES THAT IT IS FREE OF DEFECTS, MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE OR NON-INFRINGING AND ALL SUCH WARRANTIES ARE EXPRESSLY AND SPECIFICALLY DISCLAIMED. SOME STATES DO NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES, SO THE ABOVE EXCLUSION MAY NOT APPLY. THIS WARRANTY GIVES THE LICENSEE SPECIFIC LEGAL RIGHTS AND THE LICENSEE MAY ALSO HAVE OTHER RIGHTS WHICH VARY FROM STATE TO STATE.

THE SECURITY MECHANISMS IMPLEMENTED BY THE PRODUCT HAVE INHERENT LIMITATIONS, AND LICENSEE MUST DETERMINE THAT THE PRODUCT SUFFICIENTLY MEETS ITS REQUIREMENTS. THE LICENSEE MUST SECURE ALL MEDIA DISTRIBUTED TO THEM BY MR. ROOTER AS WELL AS THE COMPUTER EQUIPMENT ON WHICH THIS PRODUCT IS INSTALLED AND DESTROY OR RETURN ALL SUCH MEDIA UPON TERMINATION OF THIS AGREEMENT. THIS DISCLAIMER OF WARRANTY CONSTITUTES AN ESSENTIAL PART OF THIS AGREEMENT. NO USE OF THE PRODUCT IS AUTHORIZED HEREUNDER EXCEPT UNDER THIS DISCLAIMER.


LIMITATION OF LIABILITY

IN NO EVENT WILL MR. ROOTER ITS SUPPLIERS OR RESELLERS OR ANY CONTRIBUTORS TO THE SOURCE CODE BE LIABLE FOR ANY INDIRECT, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OF OR INABILITY TO USE THE PRODUCT, INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF GOODWILL, WORK STOPPAGE, COMPUTER FAILURE OR MALFUNCTION, OR ANY AND ALL OTHER COMMERCIAL DAMAGES OR LOSSES, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. IN ANY CASE, MR. ROOTER\'S ENTIRE LIABILITY UNDER ANY PROVISION OF THIS AGREEMENT SHALL NOT EXCEED IN THE AGGREGATE THE SUM OF THE FEES LICENSEE PAID FOR THIS LICENSE AND FEES INCURRED FOR THE MAINTANANCE OF THE PRODUCT EXCEPT TO THE EXTENT APPLICABLE LAW PROHIBITS THE LIMITATION OF DAMAGES. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO THIS EXCLUSION AND LIMITATION MAY NOT BE APPLICABLE.

EXPORT CONTROL

The Product includes strong encryption. Licensee agrees to comply with all export laws and restrictions and regulations of the United States or foreign agencies or authorities, and not to export or re-export the Product or any direct product thereof in violation of any such restrictions, laws or regulations, or without all necessary approvals. As applicable, each party shall obtain and bear all expenses relating to any necessary licenses and/or exemptions with respect to its own export of the Product from the U.S. Neither the Product nor the underlying information or technology may be downloaded or otherwise exported or re-exported into Cuba, Iran, Iraq, Libya, North Korea, Sudan, Syria or any other country subject to U.S. trade sanctions covering the Product, to individuals or entities controlled by such countries, or to nationals or residents of such countries other than nationals who are lawfully admitted permanent residents of countries not subject to such sanctions; or to anyone on the U.S. Treasury Department\'s list of Specially Designated Nationals and Blocked Persons or the U.S. Commerce Department\'s Table of Denial Orders. By installing or using the Product, the Licensee agrees to the foregoing and represents and warrants that it complies with these conditions.

MISCELLANEOUS

This Agreement constitutes the entire agreement between the parties, and supersedes all prior agreements, whether written or oral. The terms of this Agreement may be modified by Mr. Rooter upon written notice to Licensee.

1) MasterPassword - Allows you access to any area. To use enter the MasterPassword above and then you can enter the same Password in any field that requests one.

2) SetupPassword - Allows you access to Prospect Setup. We recommend using this setting in a multi-user environment. To use, enter the SetupPassword above and then as you enter the Prospect Setup area you will be prompted to enter that password.,NULL,NULL);



'continuing inside routine', '0.195179'
'checking permissions', '0.000082'
'Opening tables', '0.000026'
'System lock', '0.000018'
'init', '0.000785'
'Updating', '0.000129'
'end', '0.000022'
'query end', '0.000020'
'closing tables', '0.000687'



Edited 1 time(s). Last edit at 06/11/2013 10:23AM by karl lauritzen.

Options: ReplyQuote


Subject
Views
Written By
Posted
1 row Update query long for short duration
2013
June 11, 2013 10:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.