4 messages in com.mysql.lists.perlRe: Table Sizes| From | Sent On | Attachments |
|---|---|---|
| Bill Platt | 16 Feb 2006 14:47 | |
| Logan, David (SST - Adelaide) | 16 Feb 2006 15:10 | |
| Jan Kratochvil | 16 Feb 2006 15:28 | |
| Greg Meckes | 16 Feb 2006 18:27 |
| Subject: | Re: Table Sizes |
|---|---|
| From: | Jan Kratochvil (la...@jankratochvil.net) |
| Date: | 02/16/2006 03:28:25 PM |
| List: | com.mysql.lists.perl |
Hi,
On Thu, 16 Feb 2006 23:47:29 +0100, Bill Platt wrote: ...
I have a mysql database I am working with that has 32 million records in it. ... Maybe I should break it down alphabetically or something.
This goes against the meaning of using SQL server - it optimizes this itself.
...
The reason for my concern about this is when I access the database through phpMyadmin,
I do not use phpMyadmin myself, I find mysql(1) client more comfortable. Still: Do you really have the SQL indexes properly setup even for the accesses by phpMyadmin? The time is consumed by MySQL or phpMyAdmin (httpd/PHP)? You can also access query limited by parts FIELD like 'f%' without modifying the tables structure, can't you? Sure the proper index should be setup and this approach would be definitely just a phpMyadmin workaround.
Sorry for not knowing the phpMyadmin problems myself, I find you should even be able to use mysql-query-browser and mysql-administrator as GUI interfaces.
Regards, Lace