When developing your own internet application its necessary that pages load quickly. The most important factors that confirm page response times is that the time taken to SQL queries, however does one recognize that SQL queries at fault?
The answer is MySQL's slow question log. By facultative this feature, a log file is formed which will tell you on every time a query takes too long to execute. you'll be able to then use this data to either optimize your info or rewrite the SQL.
For this guide i'll assume you have already installed MySQL or MariaDB. These article is supporting Ubuntu 16.04 however the identical approach works on different UNIX operating system.
Step 1: modify the Slow question log
First, confirm your MySQL configuration file "my.cnf" is located - on Ubuntu 16.04 it's /etc/mysql/my.cnf whereas on different distributions it's typically /etc/my.cnf
Edit the MySQL configuration file and add the subsequent lines at the end:
slow_query_log
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 1
Save your changes and restart MySQL
service mysql restart
Step 2: examining the slow question log
Start looking the slow log:
tail -f /var/log/mysql/slow.log
At startup, you may see output like this:
/usr/sbin/mysqld, Version: 5.7.12-0ubuntu1-log ((Ubuntu)). started with:
Tcp port: 3306 OS socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
Now, mistreatment your browser begin interacting together with your internet application and note the queries that are shown. shortly you will notice one or 2 queries that are systematically shown.
Acually, I recently saw your post, This is very nice and I feel good to see your post. I am always following your blog, Continue posting...
ReplyDeleteOracle DBA Training in Chennai
Oracle DBA Course in Chennai
Spark Training in Chennai
Oracle Training in Chennai
Social Media Marketing Courses in Chennai
Pega Training in Chennai
Linux Training in Chennai
Primavera Training in Chennai
Tableau Training in Chennai
Oracle DBA Training Fess in Chennai
IEEE Projects on Cloud Computing
DeleteFinal Year Projects for CSE
JavaScript Training in Chennai
JavaScript Training in Chennai
All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.
ReplyDeleteSoftware Testing Training in Chennai
Software Testing Course in Chennai
AWS Training in Chennai
Blue Prism Training in Chennai
CCNA Course in Chennai
Cloud Computing Training in Chennai
Data Science Course in Chennai
Software Testing Training in Velachery
I do have a habit of reading a lot of blogs and I am really happy that I have read this too. Thanks for sharing.
ReplyDeleteIELTS Coaching in Anna Nagar
IELTS Coaching in Chennai Anna Nagar
IELTS Coaching in Adyar
IELTS Coaching in Porur
IELTS Coaching in Mumbai
Best English Speaking Classes in Mumbai
Spoken English Classes in Chennai
IELTS Coaching Centre in Chennai
This is an interesting blog that you have posted,Good job.
ReplyDeleteHtml5 Training in Chennai
html course in chennai
html course fees in chennai
Html5 Training
Html5 Training in Velachery
DOT NET Training in Chennai
QTP Training in Chennai
LoadRunner Training in Chennai
It's remarkable. The way you describe the information is awesome. This will really help me out. Thanks for sharing.
ReplyDeleteR Training in Chennai
R Programming Training in Chennai
Blue Prism Training in Chennai
AWS Training in Chennai
VMware Training in Chennai
Cloud Computing Training in Chennai
Data Science Course in Chennai
R Training in Anna Nagar
R Training in T Nagar
This is an awesome post.Really very informative and creative contents.
ReplyDeleteWordpress Development company in Chennai
Excellent post, thanks for this. I gathered lots of information from this and I am happy about it. Do share more updates.
ReplyDeleteMicrosoft Dynamics crm Training in Chennai
Microsoft Dynamics Training
Microsoft crm Training
Hacking course in Chennai
PHP Training in Chennai
gst Training in Chennai
Microsoft Dynamics crm Training in Anna Nagar
Microsoft Dynamics crm Training in Vadapalani
Microsoft Dynamics crm Training in Thiruvanmiyur
A IEEE project is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities.
ReplyDeleteSpring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai
Pretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
ReplyDeleteDigital Marketing Course in Chennai
Digital Marketing Courses in Bangalore
digital marketing training in marathahalli
Digital Marketing Course in Coimbatore
Digital Marketing Course in Madurai
digital marketing training in btm