cutecat Posted September 4, 2013 Share Posted September 4, 2013 is it possible? I think the bottleneck of my site is the SQL. Link to comment Share on other sites More sharing options...
cutecat Posted September 4, 2013 Author Share Posted September 4, 2013 (edited) my current setting have query cache - YES query cache limit - 64 MiB query cache min res unit - 4,096 query cache size - 256 MiB query cache type - ON query cache wlock invalidate - OFF Edited September 4, 2013 by cutecat (see edit history) Link to comment Share on other sites More sharing options...
tuk66 Posted September 5, 2013 Share Posted September 5, 2013 Database tuning is much more than just about increasing of cache. Is your server overloaded? Link to comment Share on other sites More sharing options...
cutecat Posted September 5, 2013 Author Share Posted September 5, 2013 not sure if the server is overloaded. here is the profiling Link to comment Share on other sites More sharing options...
Alex Simonchik BelVG Posted September 5, 2013 Share Posted September 5, 2013 Hi cutecat, how you got this awesome trase? I mean your screen Regards Link to comment Share on other sites More sharing options...
vekia Posted September 5, 2013 Share Posted September 5, 2013 It's not as easy as it seems. Here is a part of discussion from stackoverflow with little explanation: EXPLAIN is your friend. Other than that, you must rely on a mixture of ad-hoc tools, testing, and the OS tools to see exactly what's going on. A lot of things can be seen effectively either from the OS tools (good for determing whether a situation is CPU or IO bound) or the various variables which can be seen in MySQL itself (show global variables, show engine innodb status etc). I feel that it's really important to have a PERFORMANCE TEST ENVIRONMENT. Get a production-sized database with production-like load (using load simulation) running on production-grade hardware in your lab (expensive but essential). Once you've done that you can tweak any parameters you want in complete safety, knowing that even if it melts the whole server you can just rebuild it without affecting anything. Don't do specific things that people suggest unless you've tested them in your performance test environment and found them to be provably beneficial. Essentially, performance tuning usually looks at three areas, in this order: Structure of your database itself (table structure, indexes etc) Queries Tuning the server parameters The first two are often overlooked in favour of the last one, which can help but only after the first two are done. Don't underestimate the importance of reducing the amount of work the server needs to do - using smaller fields, fewer rows, fewer columns etc, is always better. source: http://stackoverflow.com/questions/362223/best-mysql-performance-tuning-tool 1 Link to comment Share on other sites More sharing options...
cutecat Posted September 5, 2013 Author Share Posted September 5, 2013 How do we tweak the database? It's not as easy as it seems. Here is a part of discussion from stackoverflow with little explanation: source: http://stackoverflow.com/questions/362223/best-mysql-performance-tuning-tool Link to comment Share on other sites More sharing options...
cutecat Posted September 5, 2013 Author Share Posted September 5, 2013 you have to enable the profiling to see the details. here is the guide http://www.inmotionhosting.com/support/edu/prestashop-15/348-enabling-debug-profiler Hi cutecat, how you got this awesome trase? I mean your screen Regards 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts