The table status of Mysql shows more than 20, 000 records, but count (*) shows 0

as shown in the figure below, there are obviously more than 20, 000 records in the table, but 0 is displayed using count (*). Is it locked? How to unlock it?

mysql> show table status like "md_org" \G
*************************** 1. row ***************************
           Name: MD_ORG
         Engine: InnoDB
        Version: 10
     Row_format: Dynamic
           Rows: 26553
 Avg_row_length: 337
    Data_length: 8962048
Max_data_length: 0
   Index_length: 5832704
      Data_free: 4194304
 Auto_increment: NULL
    Create_time: 2018-08-27 11:09:17
    Update_time: NULL
     Check_time: NULL
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options:
        Comment:
1 row in set (0.01 sec)

mysql> select count(*) from md_org;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.04 sec)

Database mysql

May.02,2021

Thank you for the invitation.
this select count (*) from md_org is just a query, has nothing to do with locks, and is not locked.

Rows:26553 is a rough statistic and is not guaranteed to be accurate. The exact number of rows is obtained using selct count (xxx).

if it is found to be 0, it means that the actual number of rows in the table is 0.

< hr >

I will restore your situation:
you open the transaction, and then insert data constantly, inserting more than 20,000 pieces of data. At this time, the rows in show table status will see the more than 20,000 pieces of data you inserted, but you accidentally close the x and drop the window, resulting in the transaction not committing. There is no such data in the actual table (mysql will not intelligently update the number of rows entries, it is just a rough statistic.) It's not necessary.

Previous: Can vue use middleware?

Next: Vue ergodic problem

What is the relationship between transactions at different levels of isolation?
for example, the isolation level of transaction An is repeatable read my understanding is that a read sql statement of transaction An is the same as the result repeated many times, regardless of whether or not other transactions have changed the data ...

Database mysql

Feb.26,2021
Mysql and java multi-table join service optimization?
thinking about doing homework. If there is such a check-in system Design according to the paradigm College schedule course schedule (College schedule one to many) teacher schedule Student schedule Teaching schedule (teacher schedule many to many...

Java-web Database-Development Database mysql java

Mar.28,2021
What is the relationship between the database connection pool and the number of concurrent threads on the database server?
https: blog.csdn.net w059805. it is said in this article that the size of the database connection pool on the client side of has been reduced from 2048 to 96. The number of concurrent threads on MySQL server has been maintained at 9600 . what I won...

Connection-pool database mysql

Apr.26,2021
If a network wants to set permissions, how can it be better than design?
for example, there is an option list at the top reports Statistics articles goods Manager Edit Statistics this is the name of each title each title can enter a different face for example, managers can enter the above four facets editing ca...

Database-Design Database mysql php7 php

Apr.28,2021
How to set permissions for managers? If there is a problem with the modification, WHERE.? under the revision method.
HTML <? while ($row = mysqli_fetch_array($permission_data)){?> <tr> <td class="manager"><?=$row[ name ];?>< td> <td class="manager"> <i...

Database-Design Database mysql php7 php

Apr.29,2021
Would like to ask and exchange the strategy of database table design, I hope you can give me some advice?
I am currently working on the design of a database table for a data management system, but I have encountered such a situation: for example, there are two types of data, one is grouping group, the other is member member; , and then each group has a lo...

Database-Design Database mysql

Jun.27,2021
How to build tables in many-to-many relationships?
problem description has a relationship to manage: has multiple app, multiple tags per app, tag, multiple user per tag. User may be under tag11 or tag12 of app1, or under tag21 or tag22 of app2. how to establish a relational table in this case? add...

Database-Design Database mysql java oracle

Jul.17,2021
Can the sqlite database obtain the modification record? Or the whole data MD5
there is a need to submit a db file for sqlite, but every time sqlite loads are turned off, the db file is modified even if no modification is made. As a result, it is impossible to use md5 for file deduplication directly, so is it a bit slow to use sql ...

Database mysql sqlite python

Aug.13,2021
Web site formal and test data and backend planning problems
suppose a web site has a backend, and the default is test.com admim (test.com is my own personal domain and must be encrypted to log in, so the test will have a test manager account, and there will be an official manager account), and you can add back-...

Database mysqli mysql php7 php

Aug.24,2021
How to regroup the queried data?
about the design of the fields of a table a during the design phase of the data table during the development of the project, including the creation time and status of the id,name,. first of all, according to my business needs, I need to group the data ...

Database mysql php

Sep.08,2021
What is the underlying storage of timestamp after Mysql5.6?
found an interesting problem with timestamp after the mysql5.6 version, as follows: mysql> desc test_idx; +--------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+-...

Database mysql

Oct.31,2021
The essential difference between relational and non-relational databases?
when should I use a relational database and when should I use a non-relational database? ...

Non-relational-database relational-database mysql

Nov.29,2021
Mysql queries are normal in the database, but errors are reported in java
select I. I. ID. I. Price. I. Amount. Name from orderitem i, goods g where order_id =? And i.goods_id = g.id java.sql.SQLException: Cannot create com.yanzi.model.OrderItem: com.yanzi.model.OrderItem Query: select I.id from orderitem i, goods g where or...

Database mysql

Feb.14,2022
Data table design, design polymorphic association
problem description this kind of business is involved in the development. My idea is as follows: polymorphic association is used. This structure is particularly troublesome, relying on code implementation, and requires better solutions. has a course ...

Php database mysql

Jul.14,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e8e2fa-11b3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e8e2fa-11b3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?