How to report durations of 100+ queries in MySQL?Alternatives to MySQL WorkbenchMySQL Records Turnover: How...
What is the purpose of easy combat scenarios that don't need resource expenditure?
Can a person refuse a presidential pardon?
What is 6÷2×(1+2) =?
Consequences of lack of rigour
Digits in an algebraic irrational number
Find some digits of factorial 17
How to avoid being sexist when trying to employ someone to function in a very sexist environment?
Explain the objections to these measures against human trafficking
Can I write a book of my D&D game?
Is my visa status for all destinations in a flight with connections checked in the beginning or before each flight?
awk + sum all numbers
Caruana vs Carlsen game 10 (WCC) why not 18...Nxb6?
If I delete my router's history can my ISP still provide it to my parents?
Why exactly do action photographers need high fps burst cameras?
How to prevent users from executing commands through browser URL
How can my powered armor quickly replace its ceramic plates?
Who is this Ant Woman character in this image alongside the Wasp?
Publishing research using outdated methods
Roman Numerals equation 1
In Linux what happens if 1000 files in a directory are moved to another location while another 300 files were added to the source directory?
How to limit sight distance to 1 KM
Finding a mistake using Mayer-Vietoris
Why publish a research paper when a blog post or a lecture slide can have more citation count than a journal paper?
Why did other German political parties disband so fast when Hitler was appointed chancellor?
How to report durations of 100+ queries in MySQL?
Alternatives to MySQL WorkbenchMySQL Records Turnover: How to do it?MySQL Stress testing issues?can this mysql query be optimized further?Killing a process without login to MySQLMySQL performance issue - intermittently slow queriesMySql LIMIT + JOIN is stopping data from being returned?MySQL intermittent slow queriesDELETE Rows with or without LIMITMySQL in AWS RDS 100% CPU on some queries
I have list of 142 SQL queries in an .sql file.
At the beginning of this file I put SET profiling = 1;.
At the end SHOW PROFILES;.
I execute it with:
mysql -u root live_copy < C:/projects/mysqloptimization/mysql_queries.log > output.txt
But in the output.text file, at the end, it only lists the duration of 15 queries.
How can I get it to show me the duration of all 142 queries?
Is there a free tool I could use that has a better interface to do this? I use HeidiSQL but it has a limit of giving the output of only 100 queries.
mysql
asked Jan 21 '15 at 11:29
Edward TanguayEdward Tanguay
143116
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from serverfault.com Jan 21 '15 at 11:30
This question came from our site for system and network administrators.
add a comment |
I have list of 142 SQL queries in an .sql file.
At the beginning of this file I put SET profiling = 1;.
At the end SHOW PROFILES;.
I execute it with:
mysql -u root live_copy < C:/projects/mysqloptimization/mysql_queries.log > output.txt
But in the output.text file, at the end, it only lists the duration of 15 queries.
How can I get it to show me the duration of all 142 queries?
Is there a free tool I could use that has a better interface to do this? I use HeidiSQL but it has a limit of giving the output of only 100 queries.
mysql
asked Jan 21 '15 at 11:29
Edward TanguayEdward Tanguay
143116
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from serverfault.com Jan 21 '15 at 11:30
This question came from our site for system and network administrators.
add a comment |
I have list of 142 SQL queries in an .sql file.
At the beginning of this file I put SET profiling = 1;.
At the end SHOW PROFILES;.
I execute it with:
mysql -u root live_copy < C:/projects/mysqloptimization/mysql_queries.log > output.txt
But in the output.text file, at the end, it only lists the duration of 15 queries.
How can I get it to show me the duration of all 142 queries?
Is there a free tool I could use that has a better interface to do this? I use HeidiSQL but it has a limit of giving the output of only 100 queries.
mysql
asked Jan 21 '15 at 11:29
Edward TanguayEdward Tanguay
143116
I have list of 142 SQL queries in an .sql file.
At the beginning of this file I put SET profiling = 1;.
At the end SHOW PROFILES;.
I execute it with:
mysql -u root live_copy < C:/projects/mysqloptimization/mysql_queries.log > output.txt
But in the output.text file, at the end, it only lists the duration of 15 queries.
How can I get it to show me the duration of all 142 queries?
Is there a free tool I could use that has a better interface to do this? I use HeidiSQL but it has a limit of giving the output of only 100 queries.
mysql
mysql
asked Jan 21 '15 at 11:29
Edward TanguayEdward Tanguay
143116
asked Jan 21 '15 at 11:29
Edward TanguayEdward Tanguay
143116
asked Jan 21 '15 at 11:29
Edward TanguayEdward Tanguay
143116
asked Jan 21 '15 at 11:29
Edward TanguayEdward Tanguay
143116
asked Jan 21 '15 at 11:29
Edward TanguayEdward Tanguay
143116
143116
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
migrated from serverfault.com Jan 21 '15 at 11:30
This question came from our site for system and network administrators.
migrated from serverfault.com Jan 21 '15 at 11:30
This question came from our site for system and network administrators.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Go to the Heidi's tab Host, subtab Variables, scroll down to the line profiling_history_size 15 and change its value to 150.
The other way is to launch query like that:
SET @@session.profiling_history_size = 150;
answered Jan 21 '15 at 11:45
KondybasKondybas
2,656912
When I try to change it to 150, it resets it to 100. I tried this for "session" and "global". I can set it to lower than 100 and it will change, but if I enter anything above 100 it changes it to 100. Are you able to set it to anything above 100?
– Edward Tanguay
Jan 21 '15 at 11:56
dev.mysql.com/doc/refman/5.5/en/…
– Kondybas
Jan 21 '15 at 12:10
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f89794%2fhow-to-report-durations-of-100-queries-in-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Go to the Heidi's tab Host, subtab Variables, scroll down to the line profiling_history_size 15 and change its value to 150.
The other way is to launch query like that:
SET @@session.profiling_history_size = 150;
answered Jan 21 '15 at 11:45
KondybasKondybas
2,656912
When I try to change it to 150, it resets it to 100. I tried this for "session" and "global". I can set it to lower than 100 and it will change, but if I enter anything above 100 it changes it to 100. Are you able to set it to anything above 100?
– Edward Tanguay
Jan 21 '15 at 11:56
dev.mysql.com/doc/refman/5.5/en/…
– Kondybas
Jan 21 '15 at 12:10
add a comment |
Go to the Heidi's tab Host, subtab Variables, scroll down to the line profiling_history_size 15 and change its value to 150.
The other way is to launch query like that:
SET @@session.profiling_history_size = 150;
answered Jan 21 '15 at 11:45
KondybasKondybas
2,656912
When I try to change it to 150, it resets it to 100. I tried this for "session" and "global". I can set it to lower than 100 and it will change, but if I enter anything above 100 it changes it to 100. Are you able to set it to anything above 100?
– Edward Tanguay
Jan 21 '15 at 11:56
dev.mysql.com/doc/refman/5.5/en/…
– Kondybas
Jan 21 '15 at 12:10
add a comment |
Go to the Heidi's tab Host, subtab Variables, scroll down to the line profiling_history_size 15 and change its value to 150.
The other way is to launch query like that:
SET @@session.profiling_history_size = 150;
answered Jan 21 '15 at 11:45
KondybasKondybas
2,656912
Go to the Heidi's tab Host, subtab Variables, scroll down to the line profiling_history_size 15 and change its value to 150.
The other way is to launch query like that:
SET @@session.profiling_history_size = 150;
answered Jan 21 '15 at 11:45
KondybasKondybas
2,656912
answered Jan 21 '15 at 11:45
KondybasKondybas
2,656912
answered Jan 21 '15 at 11:45
KondybasKondybas
2,656912
answered Jan 21 '15 at 11:45
KondybasKondybas
2,656912
2,656912
When I try to change it to 150, it resets it to 100. I tried this for "session" and "global". I can set it to lower than 100 and it will change, but if I enter anything above 100 it changes it to 100. Are you able to set it to anything above 100?
– Edward Tanguay
Jan 21 '15 at 11:56
dev.mysql.com/doc/refman/5.5/en/…
– Kondybas
Jan 21 '15 at 12:10
add a comment |
When I try to change it to 150, it resets it to 100. I tried this for "session" and "global". I can set it to lower than 100 and it will change, but if I enter anything above 100 it changes it to 100. Are you able to set it to anything above 100?
– Edward Tanguay
Jan 21 '15 at 11:56
dev.mysql.com/doc/refman/5.5/en/…
– Kondybas
Jan 21 '15 at 12:10
When I try to change it to 150, it resets it to 100. I tried this for "session" and "global". I can set it to lower than 100 and it will change, but if I enter anything above 100 it changes it to 100. Are you able to set it to anything above 100?
– Edward Tanguay
Jan 21 '15 at 11:56
When I try to change it to 150, it resets it to 100. I tried this for "session" and "global". I can set it to lower than 100 and it will change, but if I enter anything above 100 it changes it to 100. Are you able to set it to anything above 100?
– Edward Tanguay
Jan 21 '15 at 11:56
dev.mysql.com/doc/refman/5.5/en/…
– Kondybas
Jan 21 '15 at 12:10
dev.mysql.com/doc/refman/5.5/en/…
– Kondybas
Jan 21 '15 at 12:10
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f89794%2fhow-to-report-durations-of-100-queries-in-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
