LinuxQuestions.org
Page 1 of 7 1 23 Last »
Show 50 post(s) from this thread on one page

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Mysql problems with large connections (https://www.linuxquestions.org/questions/linux-software-2/mysql-problems-with-large-connections-656381/)

Stephan_Craft 07-17-2008 09:46 AM
Mysql problems with large connections
 
I'll pay $100 is some one could help me solve this problem!
I use mysql for many years and recently I have a very frustration problem!
Here’s what I get from time to time:
Quote:
SQL error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
SQL error code:
Date: Monday 14th of July 2008 10:06:25 PM
I try to increase - max_connections=1000, but nothing…
In /etc/my.cnf file mysql.sock direction is right.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

someone write that it can be because of the localhost, so I try this
bind-address=My-Server-IP

but still this error appears((

I notice another thing, when my DB size was over 2GB, I start to get this error… maybe this is a coincident, I don’t know.

Please send me PM or stepashk@gmail.com

trickykid 07-17-2008 09:57 AM
Give us more output from your logs? Is mysqld even running and listening? Are you running InnoDB for the engine or MYISAM? The 2GB is probably coincidence.

trickykid 07-17-2008 10:01 AM
If you are exceeding the max connections, is it possible that bad SQL is being injected and these are hanging onto the connection? What type of database is this for? Commercial use, PHP or other language frontend, etc?

forrestt 07-17-2008 10:02 AM
That error is usually because MySQL isn't running. Has it crashed when this happens?

Forrest

trickykid 07-17-2008 10:10 AM
Quote:
Originally Posted by forrestt (Post 3217685)
That error is usually because MySQL isn't running. Has it crashed when this happens?

Forrest
That's my thoughts since I asked if mysqld is running or listening. But the logs should indicate if it's a max connections issue or if something is causing the crash.

Stephan_Craft 07-17-2008 10:56 AM
It’s strange, I can’t find it here:
/var/log/myslqd.log

I use Directadmin… maybe the one how installed linux disable it.

I use ipb + phpbb

this is mysql status:
Quote:
mysql Ver 14.7 Distrib 4.1.22, for unknown-linux-gnu (x86_64) using readline 4.3

Connection id: 808144
Current database: sadmin_fou
Current user: sadmin_fou@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.22-standard
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 5 hours 45 min 22 sec
PHP:
Quote:
PHP 4.4.8 (cli) (built: Feb 16 2008 12:49:24)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with eAccelerator v0.9.5.2, Copyright (c) 2004-2006 eAccelerator, by eAccelerator
with Zend Extension Manager v1.2.0, Copyright (c) 2003-2006, by Zend Technologies
with Zend Optimizer v3.2.8, Copyright (c) 1998-2007, by Zend Technologies
that’s all I know…

may be upgrading to mysql 5 will fix the problem?

Stephan_Craft 07-17-2008 11:05 AM
Quote:
Originally Posted by trickykid (Post 3217679)
Give us more output from your logs? Is mysqld even running and listening? Are you running InnoDB for the engine or MYISAM? The 2GB is probably coincidence.
i think MYISAM because i have this in my.cnf
[mysqld]
skip-innodb

trickykid 07-17-2008 11:09 AM
So what do you do when you get this sock error? Are you restarting mysql? Next time it crashes, see if it's even running.

And no, upgrades don't magically fix problems all the time, unless it's crashing due to a known bug and has been fixed in later releases.

The error you're getting usually indicates it's not even running, not a max connection issue.

Stephan_Craft 07-17-2008 11:10 AM
Quote:
Originally Posted by forrestt (Post 3217685)
That error is usually because MySQL isn't running. Has it crashed when this happens?

Forrest
It works ok until the pick up times…
in pickup times every 3 refreshes I get the error! but the mysql not crashes! i have alot of free memory and the cpu load is fine.

If you need some information, logs, status, please tell me what to do first to get it.

trickykid 07-17-2008 11:16 AM
Well, it might be a connections issue. Can you find out during these pick up times how many connections are being made?

When you get this error as well, if you can get a shot of:

mysql> show processlist;

From the MySQL console to see if you can determine what's going on, etc. Might be useful.

Also a:

mysql> show status;

Might be helpful.

Stephan_Craft 07-17-2008 11:20 AM
+---------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 1613830 | sadmin_fou | localhost | sadmin_fou | Query | 2 | Sending data | SELECT m.mgroup_others, m.id, m.name, m.members_disable_pm, m.members_display_name, m.msg_total, m.v |
| 1613948 | sadmin_fou | localhost | sadmin_fou | Sleep | 7 | | NULL |
| 1614008 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE ibf_members SET login_anonymous='0&1', last_visit=last_activity, last_activity=1216311100 WHE |
| 1613994 | sadmin_fou | localhost | sadmin_fou | Sleep | 5 | | NULL |
| 1613990 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=104933 |
| 1614023 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=99470 |
| 1614043 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | UPDATE ibf_sessions SET member_name='cheoda',member_id=140097,member_group=3,login_type=0,running_ti |
| 1614042 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE ibf_members SET login_anonymous='0&1', last_activity=1216311101 WHERE id=130048 |
| 1614065 | sadmin_fou | localhost | sadmin_fou | Sleep | 5 | | NULL |
| 1614056 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=107827 |
| 1614053 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=81613 |
| 1614115 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | DELETE FROM ibf_sessions WHERE id='ia_archiver=20923417140_session' |
| 1614106 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=98077 |
| 1614100 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | UPDATE ibf_sessions SET member_name='Dennyo',member_id=5623,member_group=3,login_type=0,running_time |
| 1614094 | sadmin_fou | localhost | sadmin_fou | Sleep | 4 | | NULL |
| 1614088 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=105843 |
| 1614082 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=70438 |
| 1614078 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | UPDATE ibf_sessions SET member_name='acc2000',member_id=188817,member_group=3,login_type=0,running_t |
| 1614072 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=70438 |
| 1614137 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | UPDATE ibf_sessions SET member_name='',member_id=0,member_group=2,login_type='',running_time=1216311 |
| 1614131 | sadmin_fou | localhost | sadmin_fou | Sleep | 1 | | NULL |
| 1614129 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=106894 |
| 1614140 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE ibf_members SET login_anonymous='0&1', last_activity=1216311102 WHERE id=73616 |
| 1614149 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=97487 |
| 1614179 | sadmin_fou | localhost | sadmin_fou | Query | 0 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=59381 |
| 1614168 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=106026 |
| 1614197 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=76269 |
| 1614210 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=85182 |
| 1614214 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=99662 |
| 1614213 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=98174 |
| 1614212 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=103092 |
| 1614221 | sadmin_fou | localhost | sadmin_fou | Query | 1 | NULL | NULL |
| 1614225 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | UPDATE ibf_sessions SET member_name='',member_id=0,member_group=2,login_type='',running_time=1216311 |
| 1614232 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Sending data | SELECT p.pid, p.queued, t.approved, t.forum_id
FROM ibf_posts p
LEFT JOIN ibf_topic |
| 1614233 | sadmin_fou | localhost | sadmin_fou | Sleep | 1 | | NULL |
| 1614236 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=106035 |
| 1614246 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=104712 |
| 1614254 | sadmin_fou | localhost | sadmin_fou | Quit | 0 | NULL | NULL |
| 1614249 | sadmin_fou | localhost | sadmin_fou | Query | 0 | NULL | NULL |
| 1614247 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=80949 |
| 1614243 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=63218 |
| 1614242 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=99470 |
| 1614240 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=108522 |
| 1614262 | sadmin_fou | localhost | sadmin_fou | Query | 1 | Sorting result | SELECT t.* FROM ibf_topics t WHERE t.forum_id IN (0,203,338,301,312,327,328,329,330,331,332,333,334, |
| 1614261 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | UPDATE ibf_sessions SET member_name='',member_id=0,member_group=2,login_type='',running_time=1216311 |
| 1614260 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | UPDATE ibf_sessions SET member_name='',member_id=0,member_group=2,login_type='',running_time=1216311 |
| 1614257 | sadmin_fou | localhost | sadmin_fou | Query | 0 | Locked | UPDATE LOW_PRIORITY ibf_topics SET views=views+1 WHERE tid=74057 |
| 1614273 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT * FROM ibf_skin_sets WHERE set_skin_set_id=2 |
| 1614272 | sadmin_fou | localhost | sadmin_fou | Query | 0 | NULL | show processlist |
| 1614271 | sadmin_fou | localhost | sadmin_fou | Sleep | 0 | | NULL |
| 1614274 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='3163f65afe327b6ef9fca5f9942 |
| 1614282 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='3a6c3a2fd4b950b85cfc240eb94 |
| 1614278 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | UPDATE ibf_sessions SET member_name='',member_id=0,member_group=2,login_type='',running_time=1216311 |
| 1614290 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='f9c9efd2a5dae5fe687f3c34c65 |
| 1614289 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='76568fba9b91fb45828ecc09b1b |
| 1614285 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='8a389c52800ea12d8e32e753e35 |
| 1614275 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='ede7eacce7648614ccd571547ea |
| 1614293 | sadmin_fou | localhost | sadmin_fou | Sleep | 1 | | NULL |
| 1614317 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='60f1eff016adac9d2d9602193b7 |
| 1614310 | sadmin_fou | localhost | sadmin_fou | Query | 0 | NULL | NULL |
| 1614309 | sadmin_fou | localhost | sadmin_fou | Query | 0 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 1614308 | sadmin_fou | localhost | sadmin_fou | Query | 0 | NULL | NULL |
| 1614307 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='f8cceb5191274b59a790b93a63f |
| 1614304 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='19c8b82ce8d6e931f7c65f6eddc |
| 1614302 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='5547b00b67011410de37508e742 |
| 1614301 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='25f12529bca05e71423423b41e7 |
| 1614297 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='60a1649e6200028169e8e30d576 |
| 1614296 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='2ccb20016a0b09a9ceb366941c4 |
| 1614323 | sadmin_fou | localhost | sadmin_fou | Query | 0 | NULL | NULL |
| 1614320 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='19c8b82ce8d6e931f7c65f6eddc |
| 1614348 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='1317da1811d65dd454d44c1f72c |
| 1614345 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='46252413a33aea9d51868de3e0d |
| 1614343 | sadmin_fou | localhost | sadmin_fou | Query | 0 | NULL | NULL |
| 1614342 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT * FROM ibf_skin_sets WHERE set_skin_set_id=2 |
| 1614341 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='eccc98ede3cbb5c7b302ee60e7d |
| 1614339 | sadmin_fou | localhost | sadmin_fou | Query | 0 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 1614333 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT * FROM ibf_skin_sets WHERE set_skin_set_id=2 |
| 1614326 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='44277bc123b65ca28ac1919dd6f |
| 1614376 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='e17d7681c6464df8f3303072a8f |
| 1614375 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='07cfe9f5c73474aea6f075bdf34 |
| 1614374 | sadmin_fou | localhost | sadmin_fou | Query | 0 | NULL | NULL |
| 1614373 | sadmin_fou | localhost | sadmin_fou | Query | 0 | NULL | NULL |
| 1614369 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='7af0b6822347e25bf4455df15ab |
| 1614367 | sadmin_fou | localhost | sadmin_fou | Query | 0 | Locked | SELECT p.*,
m.id,m.name,m.mgroup,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login |
| 1614364 | sadmin_fou | localhost | sadmin_fou | Query | 0 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 1614361 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='5e7fcbeea0e1501c11e270a62dc |
| 1614377 | sadmin_fou | localhost | sadmin_fou | Query | 1 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='6faf8f341392fb9cd2d273eaf89 |
| 1614357 | sadmin_fou | localhost | sadmin_fou | Query | 0 | Locked | INSERT INTO ibf_sessions (id,member_name,member_id,member_group,login_type,running_time,ip_address,b |
| 1614381 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='2c94b002231a7b80a0cf8c928fb |
| 1614384 | sadmin_fou | localhost | sadmin_fou | Sleep | 0 | | NULL |
| 1614385 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='35105d767fde9edf85a5d552a57 |
| 1614391 | sadmin_fou | localhost | sadmin_fou | Query | 0 | Locked | SELECT id, name, mgroup, member_login_key, email, restrict_post, view_sigs, view_avs, view_pop, view |
| 1614390 | sadmin_fou | localhost | sadmin_fou | Query | 0 | updating | DELETE FROM ibf_sessions WHERE ip_address='84.134.247.114' |
| 1614389 | sadmin_fou | localhost | sadmin_fou | Query | 0 | cleaning up | SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='946ab7f8fae9bd5e6c8d8545f32 |
| 1614386 | sadmin_fou | localhost | sadmin_fou | Query | 0 | Sorting result | SELECT * FROM ibf_topics t WHERE t.forum_id=281 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pi |
| 1614395 | sadmin_fou | localhost | NULL | Connect | NULL | login | NULL |
+---------+------------+-----------+------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
96 rows in set (0.07 sec)

Stephan_Craft 07-17-2008 11:22 AM
but it's only one user-db... how to log as admin to get from all users?

Stephan_Craft 07-17-2008 11:23 AM
+----------------------------+--------------+
| Variable_name | Value |
+----------------------------+--------------+
| Aborted_clients | 10104 |
| Aborted_connects | 3186 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 2402236719 |
| Bytes_sent | 364368838560 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1621516 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 298879 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 233188 |
| Com_insert_select | 102 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 3372 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 5108639 |
| Com_set_option | 1416 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 354 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 1 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 0 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 1996829 |
| Com_update_multi | 0 |
| Connections | 1628142 |
| Created_tmp_disk_tables | 11047 |
| Created_tmp_files | 0 |
| Created_tmp_tables | 882890 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 131178 |
| Handler_discover | 0 |
| Handler_read_first | 18664 |
| Handler_read_key | 65841541 |
| Handler_read_next | 1384389995 |
| Handler_read_prev | 6904139 |
| Handler_read_rnd | 38596221 |
| Handler_read_rnd_next | 10905965221 |
| Handler_rollback | 0 |
| Handler_update | 10707810 |
| Handler_write | 29846826 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 747021 |
| Key_blocks_used | 186081 |
| Key_read_requests | 337514878 |
| Key_reads | 309071 |
| Key_write_requests | 278323 |
| Key_writes | 225882 |
| Max_used_connections | 1001 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 814 |
| Open_streams | 0 |
| Open_tables | 1024 |
| Opened_tables | 27820 |
| Qcache_free_blocks | 15393 |
| Qcache_free_memory | 562273656 |
| Qcache_hits | 2527407 |
| Qcache_inserts | 3849267 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 1118639 |
| Qcache_queries_in_cache | 21653 |
| Qcache_total_blocks | 58837 |
| Questions | 13411584 |
| Rpl_status | NULL |
| Select_full_join | 10446 |
| Select_full_range_join | 0 |
| Select_range | 541815 |
| Select_range_check | 0 |
| Select_scan | 481720 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 29 |
| Sort_merge_passes | 0 |
| Sort_range | 154708 |
| Sort_rows | 41521387 |
| Sort_scan | 915179 |
| Table_locks_immediate | 8243660 |
| Table_locks_waited | 1439863 |
| Threads_cached | 335 |
| Threads_connected | 178 |
| Threads_created | 1241 |
| Threads_running | 146 |
| Uptime | 26266 |
+----------------------------+--------------+
but it's only one user-db... how to log as admin to get from all users?

trickykid 07-17-2008 11:32 AM
I also found this cool script to print out some info about your database, try downloading it and running it to get some verbose output: http://www.day32.com/MySQL/tuning-primer.sh

It'll even create a my.cnf file to perhaps to tune your server accordingly.

Stephan_Craft 07-17-2008 11:33 AM
How to run it?


All times are GMT -5. The time now is 04:46 PM.
Page 1 of 7 1 23 Last »
Show 50 post(s) from this thread on one page