Skip to main content

Mysql Interview Questions


  • Current mysql version : 8 ( last was 5.7 ,  5.7 to directly 8 )
  • SHOW FULL PROCESSLIST is used to see all the query executing when refresh the site.
  • 1 second == 1000 mili second, 0-500 ms responce time of any query is ok
How to Read the MySQL Slow Query Log : The MySQL slow query log is where the MySQL database server registers all queries that exceed a given threshold of execution time. This can often be a good starting place to see which queries are slowest and how often they are slow.
MySQL on your server is configured to log all queries taking longer than 0.1 seconds.

/var/log/mysql/mysql-slow.log
Use EXPLAIN or EXPLAIN EXTENDED to explain the query how it is executed.
MySQL describe or ANALYZE command shows the structure of the table.

Best practice in respect of performance :
1 - always use index,
2 - index types , primary index and combined field index like fname & lname in one index not two index,
3 - one index scan is faster than two,
4 - data type matters like in a query we use .... where numeric_value = "66", in this case the CPU takes too much time to execute, because first it will check as a string then check as a number,
so use proper data types.
5 - try to avoid the not indication in query  like IS NOT, IS NOT NULL,NOT IN ,NOT LIKE
6 - use inner join instead of left join
7 - UNION ALL is better than UNION
8 - use latest version of db 

Comments

Post a Comment

Popular posts from this blog

Get The field values of node in Drupal 8

use Drupal \ node \ NodeInterface ; /** * Implements hook_ENTITY_TYPE_insert() for node entities. * * This tests saving a node on node insert. * * @see \Drupal\node\Tests\NodeSaveTest::testNodeSaveOnInsert() */ function node_test_node_insert ( NodeInterface $node ) { // Set the node title to the node ID and save. if ( $node - > getTitle ( ) == 'new' ) { $node - > setTitle ( 'Node ' . $node - > id ( ) ) ; $node - > setNewRevision ( FALSE ) ; $node - > save ( ) ; } } Now There is so many functions are there to get the values, For All the functions available visit the API code, https://api.drupal.org/api/drupal/core%21modules%21node%21src%21NodeInterface.php/interface/NodeInterface/8.2.x Some of as below, Node edit form, Drupal 8 Automatically Load the whole object no need to load the entity like below, if ($event->getFormId() == 'node_alexa_audio_clips_edit_form') { $node = \Drupal::ro...
Post a Comment
Read more

Drupal Setup with docker

Option 1:  docker pull mysql docker pull phpmyadmin docker pull drupal docker run -d --name MysqlClient -e MYSQL_ROOT_PASSWORD=drupal mysql Download the phpmyadmin image and Setup Container: docker run --name phpmyadmin -d --link MysqlClient:db -p 8083:80 phpmyadmin Download the Drupal image and Setup Container: docker run -d --name dweb2 --link MysqlClient -p 8082:80 -e MYSQL_USER:root -e MYSQL_PASSWORD:drupal drupal   We are using docker4 drupal and following below URL https://wodby.com/docs/1.0/stacks/drupal/local/ From Mount my codebase Download and unpack docker4drupal.tar.gz with hidden files in a new directory, also get the drupal code with in web directory composer create - project drupal / recommended - project my_site_name_dir It means with in new directory we have docker files and drupal files also has web folder for drupal. now run docker-compose up -d Now PROJECT_BASE_URL is mentioned in .env file open this url in the web with port, it will open the drupal page, ...
Post a Comment
Read more