swooningfish / mysql-cacti-templates

Automatically exported from code.google.com/p/mysql-cacti-templates
GNU General Public License v2.0
0 stars 0 forks source link

Sphinx Graphs #84

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Please create Sphinx Graphs:)

Original issue reported on code.google.com by ryan.a.l...@gmail.com on 5 Nov 2009 at 6:12

GoogleCodeExporter commented 9 years ago
I need to know what metrics Sphinx exposes, and how, and I don't know that.  Do 
you?
 Or do you have a URL I should read?

Original comment by baron.schwartz on 7 Nov 2009 at 10:49

GoogleCodeExporter commented 9 years ago
You can use SHOW META, or use API call status().

http://sphinxsearch.com/docs/current.html

It's not the biggest set of meta-data in the world, but it's a start!

Original comment by ryan.a.l...@gmail.com on 10 Nov 2009 at 12:08

GoogleCodeExporter commented 9 years ago
http://sphinxsearch.com/docs/current.html#api-func-status

How do you suggest we do this?  The PHP script needs to have the Sphinx API 
available
to it, IMO.  We could make it configurable so that it can connect via the mysql
protocol too, if they use the SphinxSE storage engine, but that won't be 
universal.

Should we ship the API with the scripts?

Original comment by baron.schwartz on 10 Nov 2009 at 4:25

GoogleCodeExporter commented 9 years ago
Quoth Shodan:

The official way is to embed sphinxapi.php and use that.  We keep
backwards compatibility.

Status() is a very simple call though.  The exchange should be
as follows (use PHP API code to verify me.. or Wireshark):

C: (connect)
C: 00 00 00 01 // int32 proto_version=1
S: 00 00 00 01 // int32 proto_version=1
C: 00 05 01 00 00 00 00 04 01 // int16 cmd_status=5, int16 cmd_ver=0x100, int32
req_len=4, byte dummy_body=1
S: int32 rows, int32 cols
S: int32 str_len, byte str_data[str_len] // repeate rows*cols times
S: (disconnect)

That's it.  All ints are of course in network order.

Original comment by baron.schwartz on 13 Nov 2009 at 4:50

Attachments:

GoogleCodeExporter commented 9 years ago
Percona customer issue number 7952 is the only place I'm aware of a real-life 
0.99
Sphinx install.

Original comment by baron.schwartz on 22 Nov 2009 at 11:29

GoogleCodeExporter commented 9 years ago
For future reference, I've told Ryan that 4 billable hours is enough to sponsor 
this.

Original comment by baron.schwartz on 3 Feb 2010 at 10:01

GoogleCodeExporter commented 9 years ago
You can use the --status command, see here for the documentation:
http://sphinxsearch.com/docs/current.html#ref-searchd

I've attached an example output. You can get these data as normal unix user, 
too.

Original comment by amaufde on 30 Mar 2010 at 10:30

Attachments:

GoogleCodeExporter commented 9 years ago
Thanks, I didn't know that.

Original comment by baron.schwartz on 30 Mar 2010 at 2:59

GoogleCodeExporter commented 9 years ago
Removing unused labels.

Original comment by baron.schwartz on 16 Apr 2010 at 2:14

GoogleCodeExporter commented 9 years ago

Original comment by baron.schwartz on 21 Apr 2010 at 2:08

GoogleCodeExporter commented 9 years ago
I would love to see this feature added. I use all of the available templates 
right now and I also use Sphinx. In addition to the status data, it would also 
be nice to get some stats around the number of documents/keywords in the index.

DOCUMENT_COUNT=$(indextool --dumpheader <indexname> | grep total-documents | 
awk ' { print $2 } ')

I don't know how to count keywords...

Original comment by btimby@gmail.com on 24 Aug 2010 at 2:41

GoogleCodeExporter commented 9 years ago
I would also like to have sphinx stats on my cacti.
Keep up the good job!

Original comment by igor.gua...@gmail.com on 11 Nov 2010 at 9:19

GoogleCodeExporter commented 9 years ago
Sphinx stats can be retrieved by MySQL connection and SHOW STATUS command. It 
could be easy to modify MySQL template for sphinx. Check this:
http://sphinxsearch.com/docs/1.10/sphinxql-show-status.html

Original comment by hristo.i...@gmail.com on 3 May 2011 at 9:19

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
Is there any detail about what each metric represents? Some are obvious, but, a 
bit more documentation would be aweseom.

Original comment by ianwin...@gmail.com on 22 Jun 2012 at 4:06