Hi
I am a new MySQL dba tuning a busy Apache/MySQL installation. Here are
some of the
statistics for the last 24 hours:
Com_admin_comma nds 978,760
What "Admin_Commands " does this include - at 11.3 per sec this is a
lot!
Com_analyze 0
The indexes have not been analyzed at all: so the optimizer assumes no
data skew. How good is the optimizer: will having accurate stats cause
if to scan too much, or is it safe to assume that any stats are good
stats? Does everyone out there analyze their tables?
Connections 536,998
So it is processing about 6.2 connections per second. Lots. It is
configured for a max of 700 connections, and generally has about 300
connection processes. My question is if it has a connection pool (from
apache) are these really new connections (i.e. start a new connection
process, allocate memory etc) - or is it efficiently re-using existing
connections from the pool and just incrementing the counter?
Sort_merge_pass es 25
Sort_range 57,128
Sort_rows 11,368,012
Sort_scan 126,770
The machine has a 1MB sort_buffer_siz e - which for 300-700 connections
is 300-700MB that I would prefer to use for the key_buffer. Is there
any wany I can tell from these stats that it is safe to reduce the
sort_buffer_siz e?
Ive got as much info as I can from newsgroups and the manual: but
tuning MySQL seems more like magic than science. Any comments much
appreciated!!
Mark
(p.s. heres the full list of changes for 24 hours:
Aborted_clients 11
Aborted_connect s 0
Bytes_received 726,146,766
Bytes_sent 3,574,227,784
Com_admin_comma nds 978,760
Com_alter_table 0
Com_analyze 0
Com_backup_tabl e 0
Com_begin 0
Com_change_db 1,510,345
Com_change_mast er 0
Com_check 0
Com_commit 1,787
Com_create_db 0
Com_create_func tion 0
Com_create_inde x 0
Com_create_tabl e 0
Com_delete 33,768
Com_drop_db 0
Com_drop_functi on 0
Com_drop_index 0
Com_drop_table 0
Com_flush 0
Com_grant 0
Com_insert 164,361
Com_insert_sele ct 12
Com_kill 0
Com_load 0
Com_load_master _table 0
Com_lock_tables 0
Com_optimize 0
Com_purge 0
Com_rename_tabl e 0
Com_repair
Com_replace 20,631
Com_replace_sel ect 1
Com_reset 0
Com_restore_tab le 0
Com_revoke 0
Com_rollback 0
Com_select 5,780,420
Com_set_option 103
Com_show_binlog s 0
Com_show_create 103
Com_show_databa ses 0
Com_show_fields 103
Com_show_grants 0
Com_show_keys 0
Com_show_logs 0
Com_show_master _status 0
Com_show_open_t ables 0
Com_show_proces slist 0
Com_show_slave_ status 0
Com_show_status 4
Com_show_innodb _status 0
Com_show_tables 3
Com_show_variab les 0
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tabl es 0
Com_update 895,584
Connections 536,998
Created_tmp_dis k_tables 7,928
Created_tmp_tab les 57,552
Created_tmp_fil es 50
Delayed_insert_ threads 0
Delayed_errors 0
Flush_commands 0
Handler_delete 157,555
Handler_read_fi rst 19,825
Handler_read_ke y 31,733,152
Handler_read_ne xt 1,109,099,218
Handler_read_pr ev 0
Handler_read_rn d 9,864,713
Handler_read_rn d_next -102,644,059
Handler_update 3,657,710
Handler_write 9,068,562
Key_blocks_used 0
Key_read_reques ts 123,092,508
Key_reads 1,090
Key_write_reque sts 1,221,214
Key_writes 470,310
Max_used_connec tions 0
Not_flushed_key _blocks 0
Not_flushed_del ayed_rows 0
Open_tables 0
Open_files -1
Open_streams 0
Opened_tables 256
Questions 8,944,173
Select_full_joi n 10,210
Select_full_ran ge_join 0
Select_range 4,898
Select_range_ch eck 2
Select_scan 1,629,106
Slave_running 0
Slave_open_temp _tables 0
Slow_launch_thr eads 0
Slow_queries 1
Sort_merge_pass es 25
Sort_range 57,128
Sort_rows 11,368,012
Sort_scan 126,770
Table_locks_imm ediate 7,149,531
Table_locks_wai ted 136,276
Threads_cached 0
Threads_created 8,738
Threads_connect ed 48
Threads_running 1
Uptime 86,400 0 2334 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: mr_burns |
last post by:
hi,
i want to put some useful marketing stats onto a web site but cant
really think of many. ones that i have thought of that would be useful
for marketing are:
- which URL did a user come from? see what paid online advertisements
are working the best.
- ...also, what did that user then go on an buy (if anything).
|
by: Bob II |
last post by:
Hey, I've never used PHP before. I was wondering if it is possible to use
PHP to generate web stats. My web host's stats aren't very good. So I
want to generate some custom stats for myself.
At a minimum, I want a log of the IP, referrer, environment variables, time
stamp, etc., and dump it into a comma delimited text file that I can import
into access or Excel. I don't need to generate gifs with PHP. Just need
the raw data.
Can...
|
by: Peter Sands |
last post by:
Hi,
I am trying to run an update stats command but keep getting a syntax error:
Looking at the doco it looks like I can use:
update stats <table_name>;
but when I use:
mysql> update stats x_balance;
ERROR 1064: You have an error in your SQL syntax near 'x_balance' at line 1
|
by: barthome1 |
last post by:
Hello,
My company collects data from non-US sources. We are starting projects
where this data will be output in an XML document and passed around to
our applications and third party tools.
The data includes some of the extended characters. We get strange
accent marks, italics and the like. These characters have decimal
value in the 200+ range.
|
by: MKoool |
last post by:
Is there any decent library for basic stats? I am just looking for the
basics, like quartiles, median, standard deviation, mean, min, max,
regression, etc.
I was going to use SciPy, but I use Python 2.4, and it seems to be
supported primarily for 2.3...
What other statistical packages have any level of public support at
this point?
| |
by: ankitdesai |
last post by:
I would like to parse a couple of tables within an individual player's
SHTML page. For example, I would like to get the "Actual Pitching
Statistics" and the "Translated Pitching Statistics" portions of Babe
Ruth page (http://www.baseballprospectus.com/dt/ruthba01.shtml) and
store that info in a CSV file.
Also, I would like to do this for numerous players whose IDs I have
stored in a text file (e.g.: cobbty01, ruthba01, speaktr01, etc.)....
|
by: GavinCrooks |
last post by:
The indices method of slice doesn't seem to work quite how I would
expect when reversing a sequence.
For example :
'43210'
'43210'
So a slice with a negative step (and nothing else) reverses the
sequence. But what are the
corresponding indices?
|
by: Monu |
last post by:
HI All,
I am getting problem in using hotshot profiler.
When I hotshot with lineevents=0, it works fine,
but when I use lineevents=1, I get error in stats
here is my code:
import hotshot, hotshot.stats
prof = hotshot.Profile("test.prof",lineevents=1)
prof.start()
|
by: Rodney Maxwell |
last post by:
The following are apparently legal Python syntactically:
L
L
But they don't seem to work on lists:
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
TypeError: list indices must be integers
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |