Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How do I truncate all tables in mysql?
how we will Show selected records sorted in an ascending (asc) or descending (desc).
What is row?
How do you say mysql?
How do I run mysql?
How many sql dml commands are supported by 'mysql'?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
How do I completely remove mysql from windows?
What is the datatype of image?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What are enums used for in mysql?
How we can create index in mysql?
How to display top 50 rows?
What does do in mysql?
Is mysql a distributed database?
