PHP/MySQL: Can 12 CPU cores make app faster than 6 CPU cores although CPU usage always below 40%? -



PHP/MySQL: Can 12 CPU cores make app faster than 6 CPU cores although CPU usage always below 40%? -

our problem mysql delaying our app after reduced cpu cores, although cpu usage , has been below 40%. question is: cpu reduction triggered mysql slow now? or should looking somewhere else?

more details: team running mobile app couple of one thousand users beingness online @ same time. fire 100 requests/second backend. using php/mysql , had 12 cpu cores , 8 gb ram. tool phpmyadmin showed cpu usage 15-25% , ram usage @ 1 gb.

then reduced cpu cores 6. cpu usage went 40% max. however, faced higher load (but not higher load had while running 12 cores) mysql not able process queries , queries lining delaying our whole app. did not happen when had 12 cores.

i grateful hints or tips. conducting full-review of server(variable) configuration. using innodb-tables.

thanks lot, fman

it sounds me mysql reaching it's i/o limits. did stress test on our db server , that's critical understanding db choke points when add together or alter records, have disk write (select can cached). when reading our website handled quite load, when simulated checkout (multiple records created) bogged downwards quickly.

back then, didn't have options. ssds expensive provision vs magnetic (and our choke number way beyond we've ever hit). best raid 10. but, clouds, can (and cheaply) have powerful db server handle i/o loads much improve (especially ssd prices dropping rapidly). you'll note amazon sells middle instances on provisioned iops feature

for production application requires fast , consistent i/o performance, recommend provisioned iops (input/output operations per second) storage. provisioned iops storage storage type delivers fast, predictable, , consistent throughput performance. when create db instance, specify iops rate , storage space allocation. amazon rds provisions iops rate , storage lifetime of db instance or until alter it. provisioned iops storage optimized i/o intensive, online transaction processing (oltp) workloads have consistent performance requirements.

it sounds much have simple setup (and maybe host db on same server). aws isn't game in town might want consider moving sort of cloud, or @ to the lowest degree step can handle higher i/o demands you're putting on server. forget number of cores. if hdd choking running 72 cores , not have difference whatsoever.

one other tip: check out mysql tuner. when run it, checks database stats (the longer it's been running, better) , can recommend lots of helpful tweaks can improve performance.

php mysql database performance innodb

Comments

Post a Comment

Popular posts from this blog

assembly - What is the addressing mode for ld, add, and rjmp instructions? -

assembly - What is the addressing mode for ld, add, and rjmp instructions? - hey guys know ldi (load immediate) addressing mode set immediate , st instruction addressing mode set index. however, have no thought others curious are! thanks :) the addressing modes explained in instruction set, in first few pages. in table of instructions see operands instruction determine addressing mode. mode indicated arguments assembly instruction. for example, ld had several different ways of operating, depending on arguments. 1 of them ld rd,x d number of register, such ld r3,x . ld r3,-z else (although both indirect addressing). rjmp k relative addressing, jumping pc + k + 1. add rr,rd direct register addressing. result contained in rd. assembly avr instructions
Read more

vowpalwabbit - Interpreting Vowpal Wabbit results: Why are some lines appended by "h"? -

vowpalwabbit - Interpreting Vowpal Wabbit results: Why are some lines appended by "h"? - below part of log training vw model. why of these lines followed h? you'll notice that's true of "average loss" line in summary @ end. i'm not sure means, or if should care. ... average since illustration illustration current current current loss lastly counter weight label predict features 1.000000 1.000000 1 1.0 -1.0000 0.0000 15 0.500000 0.000000 2 2.0 1.0000 1.0000 15 1.250000 2.000000 4 4.0 -1.0000 1.0000 9 1.167489 1.084979 8 8.0 -1.0000 1.0000 29 1.291439 1.415389 16 16.0 1.0000 1.0000 45 1.096302 0.901166 32 32.0 -1.0000 -1.0000 21 1.299807 1.503312 64 64.0 -1.0000 1.0000 ...
Read more

Is there a way to convert an HTML page styled with Bootstrap CSS into email-compatible html? -

Is there a way to convert an HTML page styled with Bootstrap CSS into email-compatible html? - is there way convert html page styled bootstrap css html email compatible form? see there exclusively different css frameworks, ink, creating email compatible html, there flow creating email doesn't require utilize of different css framework? there html -> pdf -> email html flow? or other flow? no, couple of reasons... first, there no reliable css or html email. clients on place in terms of css back upwards & how render html, structural/semantic problem. isn't converting classes much altering html structure. as explained in this css tricks post, typical solution ol-skool techniques table-based layouts, requiring exclusively restructure existing html. have add together client-specific hacks. second, , more importantly, shouldn't send everything on existing page email. if it's newsletter subscribers, people won't read it. instead, create ...
Read more