Got error 12 from storage engine
ljian
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!
Johannes Keßler
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,71414,71667#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-----
Jerry Stuckle
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.
jstu...@attglobal.net
==================