Re: Problem with very large tables in phpMyadmin
This is a discussion on Re: Problem with very large tables in phpMyadmin within the MySQL Database forums, part of the Database Forums category; On 20 Feb, 09:56, "A. Dischner" <anton.disch...@med.uni-muenchen.de> wrote: > Hi, &...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-20-2007
|
|||
|
|||
Re: Problem with very large tables in phpMyadmin
On 20 Feb, 09:56, "A. Dischner" <anton.disch...@med.uni-muenchen.de>
wrote: > Hi, > > we have tables with >100 mio rows. > > If we use phpMyadmin to display the darabase > there is a far too long running query to count the rows of the table. > > Is there a easy way to accomplish this? > > How do i look whats the size of my MaxExactCount? > > Thanks, > > Toni > > -- > Posen fuer Anfaenger:http://www.w-klch.med.uni-muenchen.de/dischner If you are using MyISAM you could use the table_rows value from the information schema table http://dev.mysql.com/doc/refman/5.0/...les-table.html 
|
Linear Mode
