Bug #40523 | Got error 22 from storage engine in windows but in linux get the error:errno: 2 | ||
---|---|---|---|
Submitted: | 5 Nov 2008 10:31 | Modified: | 21 Dec 2008 9:39 |
Reporter: | sfh sfh | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | mysql server/client 5.1.28 | OS: | Linux (and windows) |
Assigned to: | CPU Architecture: | Any | |
Tags: | partition error |
[5 Nov 2008 10:31]
sfh sfh
[6 Nov 2008 5:17]
Valeriy Kravchuk
Thank you for a problem report. Please, send the results of: show global variables like 'open_%'; from both environments.
[6 Nov 2008 6:40]
sfh sfh
i do the action: windows : open_files_limit 2048; linux : open_files_limit 1024; but i have been set the number to 6144.in my.ini file and then restart mysql. windows: # Size of the buffer used for doing full table scans of MyISAM tables. # Allocated per thread, if a full scan is needed. read_buffer_size=64K read_rnd_buffer_size=256K # This buffer is allocated when MySQL needs to rebuild the index in # REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE # into an empty table. It is allocated per thread so be careful with # large settings. sort_buffer_size=256K open_files_limit=6144 for linux /etc/my.ini: #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump
[6 Nov 2008 12:50]
sfh sfh
now i hava 3 tables table1:8389797 table2:765393 table3:7796602 when i do the query:select count(*) from table1 where ... it will 16 sconds but our aim is less than 2 seconds when the counts is 40000000.table2,table3 is 100000000 mysql can do that? show processlist,this is something wrong? mysql> show full processlist; +----+---------------+-----------------+--------------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+---------------+-----------------+--------------+---------+------+-------+-----------------------+ | 5 | stoneviewuser | localhost | stone_syslog | Sleep | 509 | | NULL | | 6 | stoneviewuser | localhost | stone_syslog | Sleep | 409 | | NULL | | 7 | stoneviewuser | localhost | stone_syslog | Query | 0 | NULL | show full processlist | | 8 | stoneviewuser | localhost | stone_syslog | Sleep | 149 | | NULL | | 9 | stoneviewuser | localhost | stone_syslog | Sleep | 270 | | NULL | | 10 | stoneviewuser | localhost | stone_syslog | Sleep | 264 | | NULL | | 11 | stoneviewuser | localhost:45810 | stoneview_db | Sleep | 64 | | NULL | | 12 | stoneviewuser | localhost | stone_syslog | Sleep | 231 | | NULL | | 13 | stoneviewuser | localhost | stone_syslog | Sleep | 137 | | NULL | +----+---------------+-----------------+--------------+---------+------+-------+-----------------------+
[10 Nov 2008 2:33]
sfh sfh
hava somebody help me ?
[21 Nov 2008 9:39]
Sveta Smirnova
Thank you for the feedback. do you have same error after increasing open_files_limit to 6144? Do you have same error if issue FLUSH TABLES; then DESC?
[22 Dec 2008 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".