Author: bussiness // Category:
- Explain MySQL architecture. - The front layer takes care of network connections and security authentications, the middle layer does the SQL query parsing, and then the query is handled off to the storage engine. A storage engine could be either a default one supplied with MySQL (MyISAM) or a commercial one supplied by a third-party vendor (ScaleDB, InnoDB, etc.)
- Explain MySQL locks. - Table-level locks allow the user to lock the entire table, page-level locks allow locking of certain portions of the tables (those portions are referred to as tables), row-level locks are the most granular and allow locking of specific rows.
- Explain multi-version concurrency control in MySQL. - Each row has two additional columns associated with it - creation time and deletion time, but instead of storing timestamps, MySQL stores version numbers.
- What are MySQL transactions? - A set of instructions/queries that should be executed or rolled back as a single atomic unit.
- What’s ACID? - Automicity - transactions are atomic and should be treated as one in case of rollback. Consistency - the database should be in consistent state between multiple states in transaction. Isolation - no other queries can access the data modified by a running transaction. Durability - system crashes should not lose the data.
- Which storage engines support transactions in MySQL? - Berkeley DB and InnoDB.
- How do you convert to a different table type? - ALTER TABLE customers TYPE = InnoDB
- How do you index just the first four bytes of the column? - ALTER TABLE customers ADD INDEX (business_name(4))
- What’s the difference between PRIMARY KEY and UNIQUE in MyISAM? - PRIMARY KEY cannot be null, so essentially PRIMARY KEY is equivalent to UNIQUE NOT NULL.
- How do you prevent MySQL from caching a query? - SELECT SQL_NO_CACHE …
- What’s the difference between query_cache_type 1 and 2? - The second one is on-demand and can be retrieved via SELECT SQL_CACHE … If you’re worried about the SQL portability to other servers, you can use SELECT /* SQL_CACHE */ id FROM … - MySQL will interpret the code inside comments, while other servers will ignore it.
Author: bussiness // Category:
Affiliate Future is one of the UK's largest affiliate network, delivering thousands of sales and around seven hundred merchants ranging from small stores to big MNC companies.
Affiliate Future is offering you new opportunities to earn money by your site. There is an affiliate-recruiter program. You too can sign up and make money by putting advertisements of your choice on your website.
Affiliate Future has more than 5 categories by which you can find each and every products of your choice.
If you are responsible for a website and want to increase its earning potential, join AffiliateFuture's network to earn more revenue from your visitors. It works by allowing Merchants to advertise on your site, and AffiliateFuture pays you monthly when these adverts generate visits, leads or sales.
Joining is free and simple process, register with your site add merchants and start earning.
You can JOIN Afilisate Future with this Link.
