My directions were assuming that you are using the "mysql commandline". Here is an example:
mysql> SHOW TABLE STATUS LIKE 'ts' \G
*************************** 1. row ***************************
Name: ts
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 29
Avg_row_length: 564
Data_length: 16384
Max_data_length: 0
Index_length: 16384
Data_free: 0
Auto_increment: NULL
Create_time: 2009-03-19 19:00:09
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.30 sec)
It is not obvious why your attempt at SHOW TABLE STATUS failed.
> innodb_buffer_pool_size 8388608
That is really low for InnoDB. However, you have a tiny machine (only 1GB). Still, it might be good to raise that to 100M.
Some tips on shrinking the size of the table, which will improve performance:
You seem to know about SMALLINT (2 bytes) /MEDIUMINT (3 bytes), yet did not apply it here?
> `driverID` int(5) NOT NULL,
INT always takes 4 bytes; the "(5)" is irrelevant.
Latitude/Longitude --
DOUBLE (8 bytes) -- precise enough to distinguish one side of a hair from the other
FLOAT (4 bytes) -- precise to 6 feet / 2 meters
More details:
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
I see 3 other tables. Please provide the SHOW CREATE TABLE for them. And try again to get the SHOW TABLE STATUS for all for tables. If you are running from one of the UIs, try providing the command inside the 'enter SQL' window.