mysql will slow after a couple of hours and need restarted to workWindows: record I/O stats (eqivalent to iostat)MSMQ very slow to receive messagesMySQL Binary Log activated = high-end server damn slowIIS 7.5 extremely slow, intermittently no responseWindows 2008 R2 IIS 7.5 very poor performanceMySQL is too slow on Windows VPSIOPS write increased, Disk write latency decreased, Avg req size decreased - Page load speed decreasedMySQL Performance Bottleneck - I/O or CPU?MySQL performance problems after hardware upgrade and move to VMVery High CPU load Low to Medium RAM usage on VPS (mysql over 100% CPU)find bottleneck of a slow server centos
King or Queen-Which piece is which?
Implementation of the Jacobi Symbol in C
In the US, can a former president run again?
Why things float in space, though there is always gravity of our star is present
Umlaut character order when sorting
Is declining an undergraduate award which causes me discomfort appropriate?
What kind of chart is this?
I have found ports on my Samsung smart tv running a display service. What can I do with it?
How is linear momentum conserved in circular motion?
How do I find which software is doing an SSH connection?
Am I legally required to provide a (GPL licensed) source code even after a project is abandoned?
Is there a polite way to ask about one's ethnicity?
Densest sphere packing
"Prove that ∂A is closed given ∂A = Cl(A) − Int(A)"
Why are there no file insertion syscalls
What preparations would Hubble have needed to return in a Shuttle?
Summing cube roots in fractions
What is this plant I saw for sale at a Romanian farmer's market?
How are で and いう being used in this context?
In Street Fighter, what does the M stand for in M Bison?
Unrecognized IC Package Style
Definition of 'vrit'
How to compute the inverse of an operation in Q#?
Is the author of the Shu"t HaRidvaz the same one as the one known to be the rebbe of the Ariza"l?
mysql will slow after a couple of hours and need restarted to work
Windows: record I/O stats (eqivalent to iostat)MSMQ very slow to receive messagesMySQL Binary Log activated = high-end server damn slowIIS 7.5 extremely slow, intermittently no responseWindows 2008 R2 IIS 7.5 very poor performanceMySQL is too slow on Windows VPSIOPS write increased, Disk write latency decreased, Avg req size decreased - Page load speed decreasedMySQL Performance Bottleneck - I/O or CPU?MySQL performance problems after hardware upgrade and move to VMVery High CPU load Low to Medium RAM usage on VPS (mysql over 100% CPU)find bottleneck of a slow server centos
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
i have a windows 7 server just have mysql installed.
i will connect to it on a local network after a while of working server response slowly and cant answer requests correctly..
my clients have up to 3k-4k request per seconds
the server have two xeon cpu with 64 gig ram and some 10 k sas hard disk
but cpu usage is lower then 10% and ram usage is about 2 gigs
my mysql configuration is like this:
[client]
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_connection=5000
max_allowed_packet = 10M
table_open_cache = 512
sort_buffer_size = 20M
read_buffer_size = 20M
read_rnd_buffer_size = 80M
myisam_sort_buffer_size = 64M
thread_cache_size = 16
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
log-bin=mysql-bin
server-id = 1
innodb_flush_method = O_DIRECT
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
how can i get a better performance this ?
windows mysql performance
edited Jun 2 at 11:52
asktyagi
521110
asked Jun 2 at 11:27
peiman F.peiman F.
1016
migrated from superuser.com Jun 2 at 11:38
This question came from our site for computer enthusiasts and power users.
add a comment |
i have a windows 7 server just have mysql installed.
i will connect to it on a local network after a while of working server response slowly and cant answer requests correctly..
my clients have up to 3k-4k request per seconds
the server have two xeon cpu with 64 gig ram and some 10 k sas hard disk
but cpu usage is lower then 10% and ram usage is about 2 gigs
my mysql configuration is like this:
[client]
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_connection=5000
max_allowed_packet = 10M
table_open_cache = 512
sort_buffer_size = 20M
read_buffer_size = 20M
read_rnd_buffer_size = 80M
myisam_sort_buffer_size = 64M
thread_cache_size = 16
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
log-bin=mysql-bin
server-id = 1
innodb_flush_method = O_DIRECT
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
how can i get a better performance this ?
windows mysql performance
edited Jun 2 at 11:52
asktyagi
521110
asked Jun 2 at 11:27
peiman F.peiman F.
1016
migrated from superuser.com Jun 2 at 11:38
This question came from our site for computer enthusiasts and power users.
Can you give stats when server perform slow? need I/O, CPU, memory, network and slow query details with number of active connection at that time.
– asktyagi
Jun 2 at 11:54
windows work fine when mysql is slow and dont responding.how can i monitor i/o status?
– peiman F.
Jun 2 at 11:56
check this serverfault.com/questions/188589/…
– asktyagi
Jun 2 at 12:02
How many 10k spindles, in what type of array? Might get 100 IOPS each, not counting parity or mirrored writes.
– John Mahowald
Jun 2 at 15:57
add a comment |
i have a windows 7 server just have mysql installed.
i will connect to it on a local network after a while of working server response slowly and cant answer requests correctly..
my clients have up to 3k-4k request per seconds
the server have two xeon cpu with 64 gig ram and some 10 k sas hard disk
but cpu usage is lower then 10% and ram usage is about 2 gigs
my mysql configuration is like this:
[client]
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_connection=5000
max_allowed_packet = 10M
table_open_cache = 512
sort_buffer_size = 20M
read_buffer_size = 20M
read_rnd_buffer_size = 80M
myisam_sort_buffer_size = 64M
thread_cache_size = 16
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
log-bin=mysql-bin
server-id = 1
innodb_flush_method = O_DIRECT
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
how can i get a better performance this ?
windows mysql performance
edited Jun 2 at 11:52
asktyagi
521110
asked Jun 2 at 11:27
peiman F.peiman F.
1016
i have a windows 7 server just have mysql installed.
i will connect to it on a local network after a while of working server response slowly and cant answer requests correctly..
my clients have up to 3k-4k request per seconds
the server have two xeon cpu with 64 gig ram and some 10 k sas hard disk
but cpu usage is lower then 10% and ram usage is about 2 gigs
my mysql configuration is like this:
[client]
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_connection=5000
max_allowed_packet = 10M
table_open_cache = 512
sort_buffer_size = 20M
read_buffer_size = 20M
read_rnd_buffer_size = 80M
myisam_sort_buffer_size = 64M
thread_cache_size = 16
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
log-bin=mysql-bin
server-id = 1
innodb_flush_method = O_DIRECT
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
how can i get a better performance this ?
windows mysql performance
windows mysql performance
edited Jun 2 at 11:52
asktyagi
521110
asked Jun 2 at 11:27
peiman F.peiman F.
1016
edited Jun 2 at 11:52
asktyagi
521110
asked Jun 2 at 11:27
peiman F.peiman F.
1016
edited Jun 2 at 11:52
asktyagi
521110
edited Jun 2 at 11:52
asktyagi
521110
edited Jun 2 at 11:52
asktyagi
521110
521110
asked Jun 2 at 11:27
peiman F.peiman F.
1016
asked Jun 2 at 11:27
peiman F.peiman F.
1016
asked Jun 2 at 11:27
peiman F.peiman F.
1016
1016
migrated from superuser.com Jun 2 at 11:38
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Jun 2 at 11:38
This question came from our site for computer enthusiasts and power users.
Can you give stats when server perform slow? need I/O, CPU, memory, network and slow query details with number of active connection at that time.
– asktyagi
Jun 2 at 11:54
windows work fine when mysql is slow and dont responding.how can i monitor i/o status?
– peiman F.
Jun 2 at 11:56
check this serverfault.com/questions/188589/…
– asktyagi
Jun 2 at 12:02
How many 10k spindles, in what type of array? Might get 100 IOPS each, not counting parity or mirrored writes.
– John Mahowald
Jun 2 at 15:57
add a comment |
Can you give stats when server perform slow? need I/O, CPU, memory, network and slow query details with number of active connection at that time.
– asktyagi
Jun 2 at 11:54
windows work fine when mysql is slow and dont responding.how can i monitor i/o status?
– peiman F.
Jun 2 at 11:56
check this serverfault.com/questions/188589/…
– asktyagi
Jun 2 at 12:02
How many 10k spindles, in what type of array? Might get 100 IOPS each, not counting parity or mirrored writes.
– John Mahowald
Jun 2 at 15:57
Can you give stats when server perform slow? need I/O, CPU, memory, network and slow query details with number of active connection at that time.
– asktyagi
Jun 2 at 11:54
Can you give stats when server perform slow? need I/O, CPU, memory, network and slow query details with number of active connection at that time.
– asktyagi
Jun 2 at 11:54
windows work fine when mysql is slow and dont responding.how can i monitor i/o status?
– peiman F.
Jun 2 at 11:56
windows work fine when mysql is slow and dont responding.how can i monitor i/o status?
– peiman F.
Jun 2 at 11:56
check this serverfault.com/questions/188589/…
– asktyagi
Jun 2 at 12:02
check this serverfault.com/questions/188589/…
– asktyagi
Jun 2 at 12:02
How many 10k spindles, in what type of array? Might get 100 IOPS each, not counting parity or mirrored writes.
– John Mahowald
Jun 2 at 15:57
How many 10k spindles, in what type of array? Might get 100 IOPS each, not counting parity or mirrored writes.
– John Mahowald
Jun 2 at 15:57
add a comment |
1 Answer
1
active
oldest
votes
What Engine are you using for your tables? It should be InnoDB. In this case, you should configure
innodb_buffer_pool_size = 20G
(Or perhaps more; how much data do you have?)
Use the slowlog to find the slow queries, then let's see SHOW CREATE TABLE and EXPLAIN SELECT ....
answered Jun 2 at 17:51
Rick JamesRick James
2816
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fserverfault.com%2fquestions%2f969835%2fmysql-will-slow-after-a-couple-of-hours-and-need-restarted-to-work%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
What Engine are you using for your tables? It should be InnoDB. In this case, you should configure
innodb_buffer_pool_size = 20G
(Or perhaps more; how much data do you have?)
Use the slowlog to find the slow queries, then let's see SHOW CREATE TABLE and EXPLAIN SELECT ....
answered Jun 2 at 17:51
Rick JamesRick James
2816
add a comment |
What Engine are you using for your tables? It should be InnoDB. In this case, you should configure
innodb_buffer_pool_size = 20G
(Or perhaps more; how much data do you have?)
Use the slowlog to find the slow queries, then let's see SHOW CREATE TABLE and EXPLAIN SELECT ....
answered Jun 2 at 17:51
Rick JamesRick James
2816
add a comment |
What Engine are you using for your tables? It should be InnoDB. In this case, you should configure
innodb_buffer_pool_size = 20G
(Or perhaps more; how much data do you have?)
Use the slowlog to find the slow queries, then let's see SHOW CREATE TABLE and EXPLAIN SELECT ....
answered Jun 2 at 17:51
Rick JamesRick James
2816
What Engine are you using for your tables? It should be InnoDB. In this case, you should configure
innodb_buffer_pool_size = 20G
(Or perhaps more; how much data do you have?)
Use the slowlog to find the slow queries, then let's see SHOW CREATE TABLE and EXPLAIN SELECT ....
answered Jun 2 at 17:51
Rick JamesRick James
2816
answered Jun 2 at 17:51
Rick JamesRick James
2816
answered Jun 2 at 17:51
Rick JamesRick James
2816
answered Jun 2 at 17:51
Rick JamesRick James
2816
2816
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- 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%2fserverfault.com%2fquestions%2f969835%2fmysql-will-slow-after-a-couple-of-hours-and-need-restarted-to-work%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
Can you give stats when server perform slow? need I/O, CPU, memory, network and slow query details with number of active connection at that time.
– asktyagi
Jun 2 at 11:54
windows work fine when mysql is slow and dont responding.how can i monitor i/o status?
– peiman F.
Jun 2 at 11:56
check this serverfault.com/questions/188589/…
– asktyagi
Jun 2 at 12:02
How many 10k spindles, in what type of array? Might get 100 IOPS each, not counting parity or mirrored writes.
– John Mahowald
Jun 2 at 15:57