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
- SQL Scheduler and Reporting Tool
- 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
- Sitemap
12 users online | 12 Guests and 0 Registered
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (470289 views)
- Error no. 2003: Can't connect... (385874 views)
- SQLyog Version History (238645 views)
- Error no. 1045: "Connection denied..." (199136 views)
- Error No. 2005: Unknown MySQL server host... (181441 views)
- Error no. 1251: "Client does not support authentication..." (170033 views)
- Can I use SQLyog with the WINE Windows emulator ... (161783 views)
- What is HTTP-tunneling? (136212 views)
- What Is SSH and SSH-tunneling? (107834 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (105821 views)
Latest FAQs 
- SQLyog Version History (2014-06-08 10:22)
- I get error 1130 "Host is not allowed to ... (2014-01-30 12:21)
- About CHUNKs and BULKs (2014-01-09 11:53)
- SQLyog is a client for the MySQL server - ... (2013-08-04 04:48)
- Problems creating a functional DSN on 64 bit Windows. ... (2013-07-22 08:34)
Sticky FAQs
ID #1159
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
Tags: -
Related entries:
- SQLyog Version History
- How Do I Remove Duplicates From My Databases?
- Introduction to the 'SQLyog Job Agent' (SJA)
- I only changed one row of data, but SQLyog wants to update more rows in the database. Why?
- Nothing happens when clicking the + sign left to a database
You can comment this FAQ