[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MySQL priority

Posted on 2009-05-19
2
Medium Priority
?
795 Views
Last Modified: 2012-05-07
Dear Experts,

Is it possible to prioritize MySQL jobs in order or importance, so if 2 people, 1 person does a select and the other does an insert, the select gets priority.  If someone has already started an insert, then later someone starts a select, can the select take priority by reducing the CPU usage of the insert?  Also, the same with full text indexing, when a table is being index, is it possible to reduce its priority to allow select to take over?
0
Comment
Question by:narmi2
2 Comments
 
LVL 4

Accepted Solution

by:
manavsi earned 1200 total points
ID: 24423650
0
 
LVL 26

Assisted Solution

by:Umesh
Umesh earned 800 total points
ID: 24431954
In order to happen this (SELECT gets higher priority then READ) You need to convert all your INSERT statements to INSERT DELAYED statements... but make sure you table don't have much holes(DELETES).. and make sure concurrent_insert is set to 1
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
What we learned in Webroot's webinar on multi-vector protection.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question