Answer / amith

Much more conservative approach to disk space management -
each MyISAM table is stored in a separate file, which could
be compressed then with myisamchk if needed. With InnoDB
the tables are stored in tablespace, and not much further
optimization is possible. All data except for TEXT and BLOB
can occupy 8,000 bytes at most. No full text indexing is
available for InnoDB. TRhe COUNT(*)s execute slower than in
MyISAM due to tablespace complexity.

What is mysql protocol?

0 Answers  

---

How to use triggers to track changes in mysql?

0 Answers  

---

Why myisam is faster than innodb?

0 Answers  

---

What are the features of Stored Procedures in MYSQL?

1 Answers  

---

What is longblob?

0 Answers  

---

---

Can you rename a database in mysql?

0 Answers  

---

Define REGEXP?

0 Answers  

---

what is cte? : Mysql dba

0 Answers  

---

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,

---

How can we store binary data in mysql?

2 Answers   HP,

---

What are the functions in mysql?

0 Answers  

---

What is the password of mysql?

0 Answers  

---