11-26-2009, 09:54 AM
|
|||
|
|||
Got error 12 from storage engine
mysql> show variables;
ERROR 1030 (HY000): Got error 12 from storage engine mysql> show databases; ERROR 1030 (HY000): Got error 12 from storage engine mysql> show status; ERROR 1030 (HY000): Got error 12 from storage engine mysql> select * from mysql.user limit 1; +-----------+------+------------------------------------------- +-------------+-------------+-------------+-------------+------------- +-----------+-------------+---------------+--------------+----------- +------------+-----------------+------------+------------ +--------------+------------+-----------------------+------------------ +--------------+-----------------+------------------+------------------ +----------------+---------------------+-------------------- +------------------+----------+------------+------------- +--------------+---------------+-------------+----------------- +----------------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | +-----------+------+------------------------------------------- +-------------+-------------+-------------+-------------+------------- +-----------+-------------+---------------+--------------+----------- +------------+-----------------+------------+------------ +--------------+------------+-----------------------+------------------ +--------------+-----------------+------------------+------------------ +----------------+---------------------+-------------------- +------------------+----------+------------+------------- +--------------+---------------+-------------+----------------- +----------------------+ | localhost | root | *A0C89EBA55DB53A0AD977FE2CBFC9D3D74D2A449 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | +-----------+------+------------------------------------------- +-------------+-------------+-------------+-------------+------------- +-----------+-------------+---------------+--------------+----------- +------------+-----------------+------------+------------ +--------------+------------+-----------------------+------------------ +--------------+-----------------+------------------+------------------ +----------------+---------------------+-------------------- +------------------+----------+------------+------------- +--------------+---------------+-------------+----------------- +----------------------+ 1 row in set (0.02 sec) i have tried set several variables like:sort_buffer_size,read_buffer_size,join_buffer _size,key_buffer_size at least 64M,but i still got error above,what's the problem? anyone who gives suggestions will be appreciated! 
|
|
Today
|
||||
|
||||
Sponsored Links
|
|
11-26-2009, 10:56 AM
|
|||
|
|||
|
Re: Got error 12 from storage engine
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1 ljian wrote: > mysql> show variables; > (snip) > i have tried set several variables > like:sort_buffer_size,read_buffer_size,join_buffer _size,key_buffer_size > at least 64M,but i still got error above,what's the problem? anyone > who gives suggestions will be appreciated! Hello, as far as I know it could be something like this: http://forums.mysql.com/read.php?21,...1667#msg-71667 regards, johannes keßler -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.13 (GNU/Linux) iEYEARECAAYFAksOXt4ACgkQE++2Zdc7EtezWwCglatVV+kB/dL3k1zWNhPLBghR +8QAoIDvwbkwU4Ux2B1zmJPkDcofnyVI =kF03 -----END PGP SIGNATURE-----
|
|
11-26-2009, 01:23 PM
|
|||
|
|||
|
Re: Got error 12 from storage engine
ljian wrote:
> mysql> show variables; > ERROR 1030 (HY000): Got error 12 from storage engine > mysql> show databases; > ERROR 1030 (HY000): Got error 12 from storage engine > mysql> show status; > ERROR 1030 (HY000): Got error 12 from storage engine > mysql> select * from mysql.user limit 1; > +-----------+------+------------------------------------------- > +-------------+-------------+-------------+-------------+------------- > +-----------+-------------+---------------+--------------+----------- > +------------+-----------------+------------+------------ > +--------------+------------+-----------------------+------------------ > +--------------+-----------------+------------------+------------------ > +----------------+---------------------+-------------------- > +------------------+----------+------------+------------- > +--------------+---------------+-------------+----------------- > +----------------------+ > | Host | User | Password | > Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | > Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | > Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv > | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv > | Repl_slave_priv | Repl_client_priv | Create_view_priv | > Show_view_priv | Create_routine_priv | Alter_routine_priv | > Create_user_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject > | max_questions | max_updates | max_connections | max_user_connections > | > +-----------+------+------------------------------------------- > +-------------+-------------+-------------+-------------+------------- > +-----------+-------------+---------------+--------------+----------- > +------------+-----------------+------------+------------ > +--------------+------------+-----------------------+------------------ > +--------------+-----------------+------------------+------------------ > +----------------+---------------------+-------------------- > +------------------+----------+------------+------------- > +--------------+---------------+-------------+----------------- > +----------------------+ > | localhost | root | *A0C89EBA55DB53A0AD977FE2CBFC9D3D74D2A449 | > Y | Y | Y | Y | Y | > Y | Y | Y | Y | Y | > Y | Y | Y | Y | Y > | Y | Y | Y | Y > | Y | Y | Y | > Y | Y | Y | > Y | | | | > | 0 | 0 | 0 | 0 > | > +-----------+------+------------------------------------------- > +-------------+-------------+-------------+-------------+------------- > +-----------+-------------+---------------+--------------+----------- > +------------+-----------------+------------+------------ > +--------------+------------+-----------------------+------------------ > +--------------+-----------------+------------------+------------------ > +----------------+---------------------+-------------------- > +------------------+----------+------------+------------- > +--------------+---------------+-------------+----------------- > +----------------------+ > 1 row in set (0.02 sec) > > i have tried set several variables > like:sort_buffer_size,read_buffer_size,join_buffer _size,key_buffer_size > at least 64M,but i still got error above,what's the problem? anyone > who gives suggestions will be appreciated! The error indicates the OS can't satisfy a memory request. You need to decrease the amount of memory MySQL can use, not increase it. -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ==================
|
|
|
|
|
 |
| Popular Tags in the Forum |
| engine, error, storage |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Search Engine Profile Exchange - November 03 2009 Release | David Troxell - Encourager Software | Newsgroup comp.lang.clarion | 0 | 11-04-2009 03:16 AM |
| Statement on Schildt submitted to wikipedia today | spinoza1111 | Newsgroup comp.lang.c.moderated | 56 | 09-21-2009 07:25 PM |
| Re: User calling V6 engine instead of V9 | Gerhard Hellriegel | Newsgroup comp.soft-sys.sas | 1 | 09-19-2009 01:10 AM |
| Re: User calling V6 engine instead of V9 | Scott Barry | Newsgroup comp.soft-sys.sas | 0 | 09-18-2009 02:22 AM |
| Announcement - brick engine v4.1! | hat0 | Newsgroup comp.lang.tcl | 0 | 08-29-2009 09:48 PM |
Linear Mode
