Redmi Note 9 Shadow Black, 4GB RAM, 64GB Storage

• 48MP quad rear camera with ultra-wide, depth sensor, macro mode, portrait, night mode, AI scene recognition, HDR, pro mode | 13 front camera

Redmi 9 (Sky Blue, 4GB RAM, 64GB Storage)

Redmi 9 (Sky Blue, 4GB RAM, 64GB Storage) | Extra INR 300 Cashback as Amazon Pay Balance

InnoDB's default Row Format in MySQL 5.6 and 5.7

The default row format for InnoDB tables 

• in MySQL 5.6 is COMPACT 
• in MySQL 5.7 is DYNAMIC

Default InnoDB Row Format has been changed in MySQL 5.7. let me explain why, and provide you some more background information and good-to-know things.

What is row format?

The row format of a table determines behaviour of physically stored. This can affect the performane of queries and DML operations. As more rows fit into a single disk page:

• queries and index lookups can work faster.
• less cache memory is required in the buffer pool.
• less I/O is required to write out updated values.

Supported row formats

The InnoDB storage engine supports four row formats: REDUNDANT, COMPACT, DYNAMIC, and COMPRESSED.

Here's a quick overview:

Row Format	REDUNDANT	COMPACT	DYNAMIC	COMPRESSED
Compact Storage Characteristics	No	Yes	Yes	Yes
Enhanced Variable-Length Column Storage	No	No	Yes	Yes
Large Index Key Prefix Support	No	No	Yes	Yes
Compression Support	No	No	No	Yes
Supported Tablespace Types	system, file-per table, general*	system, file-per-table, general*	file-per-table, general*	file-per-table, general*
Required File Format	Antelope or Barracuda	Antelope or Barracuda	Barracuda	Barracuda

*only available in MySQL 5.7

Default value

The default row format for InnoDB table sis defined by innodb_default_row_formatvariable. The default value is different in MySQL 5.6 and 5.7. If you are now aware of this difference, and you use the default value in MySQL 5.6, you can encounter problems like the following:

Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

The different default value between MySQL 5.6 and 5.7

The default row format for InnoDB tables in MySQL 5.6 is COMPACT and in MySQL 5.7 is DYNAMIC.

Determining the Row Format of a Table

You can determine the row format of a table, by using SHOW TABLE STATUS:

mysql> SHOW TABLE STATUS IN test1\G
*************************** 1. row ***************************
           Name: t1
         Engine: InnoDB
        Version: 10
     Row_format: Dynamic
           Rows: 0
 Avg_row_length: 0
    Data_length: 16384
Max_data_length: 0
   Index_length: 16384
      Data_free: 0
 Auto_increment: 1
    Create_time: 2016-09-14 16:29:38
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options: 
        Comment:

Alternatively, you can query the INFORMATION_SCHEME.INNODB_TABLES table

mysql> SELECT NAME, ROW_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME='test1/t1';
+----------+------------+
| NAME     | ROW_FORMAT |
+----------+------------+
| test1/t1 | Dynamic    |
+----------+------------+

Define the row format of a table explicitly

You can explicitly define the row format of a table, by using the ROW_FORMAT table option in a CREATE TABLE or ALTER TABLE statement. For example:

CREATE TABLE t1 (c1 INT) ROW_FORMAT=DYNAMIC;ALTER TABLE t1 ROW_FORMAT=DYNAMIC;

Diffrence Between Marketing and Digital Marketing

Here, digital marketing related to internet and marketing represent to pamphlet or offline advertisement. 

Marketing : 

Marketing is a process. we have to make a plan from day one and do more work in respective of marketing for small business and large organisations as well.

Too many people have good business plan but due to lack of marketing, people can't expand those services and got failure in business while through digitalisation, people can easily broadcast and can reach to large number of audience.

Digital Marketing : 

Now a days all things are migrating online. Internet is making our life easy. We can grab too many benefits through Internet.

We can do Multiple activities through this Technology like : Online Shopping, Recharge, Bill Payment, Online Ticket, Bill Transaction Etc. 

Before accepting any offer or before purchasing any services user too much research and check the revenue on Internet which is possible due to digitalisation only. 

To broadcast your service digital marketing is a easy way to get more audience globally.

We can connect user through Internet to Provide them our services.We can more focus on targeted Audience for our business which was difficult offline.

Initially digital  marketing started by giving advertisement on cable TV which was too expensive and dependent on cable operator while now days we have open world and large number of resources like social networking, blog writing, website or you can say we have world web wide So that we can expand our business globally.

We have too many information sources in this world from where we can get required details anytime anywhere this is only possible due to digitalisation. 

The Top Most Romantic songs in Hindi Film Industry

Are you looking for Best Romantic Songs in Bollywood Industry?

Most Romantic Hindi Songs List

Let us have a look at some of the best romantic songs of all time. These songs are big hits of those eras of Bollywood.

1. Song : Barish

Lyrics of Barish

Chehre mein tere
Khud ko main dhundun
Aankhon ke darmiyan
Tu ab hai iss tarah
Khwabon ko bhi jagah na mile

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ 

2.  Song : Agar Tum Saath Ho

Lyrics of Agar Tum Saath Ho

Pal Bhar Thahar Jaao,
Dil Ye Sambhal Jaaye,
Kaise Tumhe Roka Ka,
runMeri Taraf Aata Har,
Gham Phisal Jaaye,

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

3. Song : Muskurane Ki Wajah Tum Ho

Lyrics of Muskurane Ki Wajah Tum Ho

Gungunane ki wajah tum ho
Jiya jaaye na, jaaye na, 
jaaye na..
O re piya re..
Jiya jaaye na, jaaye na, jaaye na..
O re piya re..

Muskurane ki wajah tum ho

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

4. Song : Hua Hai Aj Pehli Bar

Lyrics of Hua Hai Aj Pehli Bar

Hua hai aaj pehli baar
Jo aise muskuraya hoon
Tumhe dekha toh jaana ye
Ke kyun duniya mein aaya hoon


__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

5. Song : Pee Loon, Once Upon A Time In Mumbai

Lyrics of Pee Loon

Pee Loon Tere Neelay Neelay Nainon Se Shabnam
Pee Loon Tere Geelay Geelay Hoto Ki SargamPee Loon Hai Peenay Ka MausamTere Sang Ishq Taari HaiTere Sang Ik Khumari Hai

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

6. Song : Jeene Laga Hoon Pehle Se Zyada

Lyrics of  Jeene Laga Hoon Pehle Se Zyada

Jeene laga hoon pehle se zyada

Pehle se zyada tum pe marne laga hoon

Main, mera dil aur tum ho yahaan

Phir kyun ho palkein jhukaaye wahaan
Tum sa haseen pehle dekha nahin
Tum is se pehle the jaane kahaan..

__ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __

7. Song : Hum Tere Bin Ab Reh Nahi Sakte

Lyrics of Hum Tere Bin Ab Reh Nahi Sakte

Hum tere bin ab reh nahi sakte
Tere bina kya wajood mera Tujhse juda gar ho jaayenge
Toh khud se hi ho jaayenge judaa

Top 5 mobiles under Rs. 20000 in India

 Xiaomi's Poco F1

Expert comment:   Xiaomi's Poco F1, also called Pocophone F1, is the best value-for-money smartphone available in the market. The handset comes with flagship-grade Snapdragon 845 processor at an extremely affordable price point. Xiaomi's new sub-brand's first smartphone does not only offer great performance but also packs some capable cameras and a massive 4,000mAh battery. If you like gaming on your handset and have certain budget constraints, this might be the best smartphone available for you.

Honor Play

Expert comment:   The newly launched Honor Play is among the very few handsets in the market that can be claimed to offer true value for your money. The handset brings along the flagship-grade HiSilicon Kirin 970 processor that can easily tackle demanding games and apps. There is respectable battery capacity as well as impressive memory on board to ensure there are no hiccups in terms of performance requirements. You also get dual rear cameras at the back that are powered by the company's AI Master feature to help you click better pictures in different conditions.

Xiaomi Redmi Note 7 Pro

Expert comment:   Xiaomi faced some stiff competition in this price range last year but the brand's new Redmi Note 7 Pro is already looking like the best mid-range smartphone launched this year. The handset comes with an extremely capable Snapdragon 675 SoC a whopping 48MP rear camera for capturing details. The phone comes with a glass sandwich design and has Gorilla Glass 5 protection on both sides. If you are looking for an all-rounder phone under Rs 15,000, Redmi Note 7 Pro is probably your best bet.

Samsung Galaxy A 50

Expert comment:   Samsung's new mid-range crusader comes with a premium design and sleek body that holds a gorgeous full-HD+ Super AMOLED panel. Apart from an in-display fingerprint sensor, the inclusion of One UI makes this phone attractive buy. There is a triple camera setup at the back of the phone that consists of a primary sensor, depth sensor, and an ultra-wide sensor, which ensures that the handset remains a capable shooter in all kinds of situations. With all these capabilities, Galaxy A50 is one of the best options available at this price.

Samsung Galaxy A 30

Expert comment:   Samsung's Galaxy A30 smartphone comes with a glossy polycarbonate back that gives a premium look to the handset. Taking cues from Galaxy A50, the Galaxy A30 also features a 6.4-inch FHD+ Super AMOLED display with a tiny notch to offer a fullscreen immersive experience. The Galaxy A30 also comes with a 4,000mAh battery to provide ample battery backup and supports fast charging too. Overall, the phone offers good value for money in this range.

80% Indians have more than 1 device simultaneously: Study

Three in four adult consumers in India constantly use more than one device simultaneously and spend almost 90 per cent of their workday interacting with devices, said an Adobe study on Friday.

Smartphones have also emerged as the most preferred medium for all shopping activities with 89 per cent of consumers currently being able to do all the retail activities they want on mobile, showed the findings based on a survey of 1,000 adult consumers in India. 

The study revealed that more than half of adults surveyed regularly use voice commands. 

"The rapid proliferation of advanced technologies and their increased usage on mobile devices, points to potential new areas for marketers to engage with consumers," said Sunder Madakshira, Head, Marketing, Adobe India.

"Considering the fast consumer adoption of voice tech, we expect to start seeing more brands experimenting with immersive ways of customer engagement over the next few years," Sunder added.

Squid Proxy Server

Squid Proxy Server

It's used to provide the internet connectivity to network connected system ny using single internet connection.

·         Package Required:- squid

·         Daemon name :--squid

·         Port Number:-- 3128

·         Path of config file:- /etc/squid/squid.conf

Key Point:--

1.    Install squid proxy

2.    on and start service by:- #service squid start

3.    Give two IPs one for internet and another for LAN

5 steps to secure your Linux server

5 steps to secure your Linux server

How would you ensure security of your production Linux Server? Should you can be happy with default configuration there in place or there’s are things which we must implement for enhancing security aspects? Of course, Yes. Here I’m writing 5 steps which I usually take to tighten security in Server. This doesn’t means these are Best thing you can do or You don’t need to do anything else. There are many ways and remember securing your Server is a never ending process, So keep an eye open and check your Server regularly.

Step 1. Disable direct root access. 
Login should be allowed using simple/wheel user and then from there you can switch to root or use sudo to execute commands under root privileges. Let’s disable direct root login:

How to change Date, Time and Time Zone in Linux

In Redhat based distro, here’s a quick solution to change your time zone to PST/PDT:

$ mv /etc/localtime /etc/localtime.Old && ln -s /usr/share/zoneinfo/PST8PDT /etc/localtime

Other commands:

How To Break Root Password in Linux(Centos/RHEL 5)

How To Break Root Password

Case I:--

If Bootloader don't have password or we know bootloader password

Key Points:--

1.    Select Redhat linux title and press E to edit

2.    Press E to edit kernel line

3.    then type 1 after giving single space

4.    Below Editing

5.    kernel /vmlinuz-2.6.32-71.el6.x86_64 ro ....................crashkernel=auto rhgb quiet

6.    After Editing

7.    kernel /vmlinuz-2.6.32-71.el6.x86_64 ro......................crashkernel=auto rhgb quiet 1

8.    Then Enter and boot by B