Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program

- Connection issues

- Using the GUI
- Managing your MySQL Database Systems

- Database Schema Synchronization
- MySQL DATA synchronization
- Notification Services
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)

- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
7 Users online :: 7 Guests and 0 Registered
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115201 views)
- Error no. 2003: Can't connect... (51979 views)
- Error no. 1251: "Client does not support authentication..." (48041 views)
- Error no. 1045: "Connection denied..." (41265 views)
- SQLyog Version History (39857 views)
- What is HTTP-tunneling? (29222 views)
- Error No. 2005: Unknown MySQL server host... (28259 views)
- What Is SSH and SSH-tunneling? (25442 views)
- Why are Stored Procedures not created when I import ... (23378 views)
- Do I need PHP to use SQLyog with MySQL? ... (21478 views)
Latest FAQs 
- SQLyog Version History (2010-03-09 03:20)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
- Failed dependency for libstdc++.so.5 error (2009-08-13 11:22)
- Wrong results are returned for FOUND_ROWS(). (2009-08-12 06:31)
MySQL bugs that affect SQLyog
ID #1159
In INFO tab for a database the 'Rows' count for InnoDB tables does not show the exact value.
In INFO tab for a database the 'Rows' count for InnoDB tables does not show the exact value.
This is an InnoDB issue with the SHOW TABLE STATUS statement. With InnoDB tables the 'Rows' count is an estimate only. So it is not really a bug - it is expected behaviour wiht InnoDB tables.
To get exact values you can execute "select count(*) from ´table´" to get the correct row count (and the Avg_row_length which will be Data_length (from SHOW TABLE STATUS)/Rows). But exact rows count on InnoDB can be very slow so we display the (not always exact) output for 'Rows' count from SHOW TABLE STATUS.
More information: http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html
This is an InnoDB issue with the SHOW TABLE STATUS statement. With InnoDB tables the 'Rows' count is an estimate only. So it is not really a bug - it is expected behaviour wiht InnoDB tables.
To get exact values you can execute "select count(*) from ´table´" to get the correct row count (and the Avg_row_length which will be Data_length (from SHOW TABLE STATUS)/Rows). But exact rows count on InnoDB can be very slow so we display the (not always exact) output for 'Rows' count from SHOW TABLE STATUS.
More information: http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- Welcome to the Webyog FAQ
- SQLyog Version History
- What kind of ODBC databases are supported by SQLyog Import External Data Tool?
- What is and what is not imported by the SQLyog Import External Data Tool?
Last update: 2008-10-15 07:52
Author: mikel
Revision: 1.0
You can comment this FAQ