dbstat, general, linux, mysql, networking, php
Comments

Dbstat Update

So I thought maybe it’s time for an update.

The project is moving, albeit slowly, and I realy do not like the current PHP implementation, I want to move towards a C++ version, and I will do so as soon as I figure out how to do CLI “update/refresh” …

i.e. See how W GET works with the progress bar and kbps all in text, I have NO idea how that works.

I am also looking at adding RRDTOOL support.

Anyway here’s the current sample output:

[buzz@server01 .sysadmin]$ ./dbstat.php summary


----- mySQL dbStat v1.1 Summary Report-----


10 Databases checked


exampledb1: 13 tables (0 VIEWS 13 INNODB 0 MYISAM) 0.77MB DATA 0.64MB INDEX


exampledb2: 15 tables (0 VIEWS 14 INNODB 1 MYISAM) 0.22MB DATA 0.19MB INDEX


exampledb3: 62 tables (0 VIEWS 0 INNODB 62 MYISAM) 0.45MB DATA 0.5MB INDEX


exampledb4: 3 tables (0 VIEWS 0 INNODB 3 MYISAM) 0.02MB DATA 0.01MB INDEX


exampledb5: 4 tables (0 VIEWS 0 INNODB 4 MYISAM) 0.02MB DATA 0.01MB INDEX


exampledb6: 4 tables (0 VIEWS 0 INNODB 4 MYISAM) 39.81MB DATA 22.22MB INDEX


exampledb7: 3 tables (0 VIEWS 0 INNODB 3 MYISAM) 0.04MB DATA 0.01MB INDEX


exampledb9: 599 tables (8 VIEWS 1 INNODB 590 MYISAM) 8702.79MB DATA 4559.42MB INDEX


exampledb10: 22 tables (0 VIEWS 21 INNODB 1 MYISAM) 6.66MB DATA 2.26MB INDEX

Detail:

----- START mySQL dbStat v1.1 Detail Report: exampledb9 -----

exampledb9: 599 tables (8 VIEWS 1 INNODB 590 MYISAM) 8893.7MB DATA 4583.54MB INDEX

--- Table Index Ratio Report index:data (457 Tables) ---

exampledb9.table1: 315.0769:1

exampledb9.table2: 315.0769:1

exampledb9.table3: 157.5385:1

exampledb9.table4: 146.2857:1

exampledb9.table5: 128.0000:1

… (I’ve truncated this very long list)

--- Table Fragmentation Report (2 Tables) ---

exampledb9.atable: 0.6067

exampledb9.atable: 0.1285

--- Table Low Size Report (47 Tables) ---

exampledb9.atable: 0 bytes

exampledb9.atable: 0 bytes

exampledb9.atable: 0 bytes

exampledb9.atable: 0 bytes

exampledb9.atable: 0 bytes

… (Truncated again)

--- Table Detail Report (591 Tables) ---

SCHEMA.TABLENAME: ENGINE: ROWS: TOTAL SIZE (MB): DATA SIZE (MB): DATA PERCENTAGE OF TOTAL (%): INDEX SIZE (MB): INDEX PERCENTAGE OF TOTAL (%): LAST UPDATE TIME

exampledb9.a_table: MyISAM: 28906414: 3272.43531003: 3031.82567548: 92.6474: 204.63809450: 7.3526: 2008-05-22 11:59:42

.. (truncated)

----- END mySQL dbStat v1.1 Detail Report: exampledb9 -----
green_giant, hacking, linux
Comments

Green Giant - eBay Con Artists Part 2

So I finally got a response …


”Hello,

Thanks for asking about shipping. All shipping and handling costs are per item and as advertised on eBay. We don’t negotiate on shipping at all. Please refer to the shipping costs per item mentioned clearly at the bottom of all eBay item. Insurance per item is also not negotiable but is optional. Please note that shipping consists of various things such as packaging, handling, insurance, bar-coding, automation and 3rd party services from the Insurance co. and electronic postage processing with includes postage and automatic notification.”

Somehow I realy do not see that I am going to get £16 worth of postage from £3.96 worth of items …

Beware the eBay small print, I am quite annoyed on this realy didn’t expect this from a UK seller.




green_giant, hacking, linux
Comments

Green Giant - eBay Con Artists

So I got my “adjusted” postage … the seller has increased the combined postage to £64 and then applied a £48 discount, yeh you guessed it resulting in the same £16 (£4 per card) postage cost …

I’ve seen some blatant attempts to con people before, but just … wow … I’m giving the selling on ebay time to correct this … otherwise I’m going to name and shame.
green_giant, hacking, linux
Comments

Green Giant - Moving On

Today I have managed to find a bargain, and have ordered 4 x 1GB compact flash cards to run the nodes. (£3.96) I’m just having to negotiate postage at the moment … as £4 per card is a bit excessive!

So provided I can get combined postage current project cost is at £7.96 … Now I need to find some pico / mini itx bargains.

green_giant, linux
Comments

“Green_giant” Cluster Project

So I am still looking for a viable PICO itx motherboard supplier … but the concept is rolling along nicely, so here’s a little more information.

The “project” is to make a beowulf cluster but as efficent and therefor green as possible, current “Pico” itx power suppliers advertise a 96% efficency … not bad

So why the pico form factor?

The reason I am going for this form factor is due to it’s size and power draw, because of the lower power draw of this form factor it allow for other (greener) power options to be explored.

So what’s the spec?


The project must have the following:

  1. Have at least 4ghz (4 nodes), distibuted processing power
  2. Not draw more than a total 30w / GHZ under load (Bringing the 4 node total to just 120w)
  3. Fit into a 2u rack chasis.
The lower the power consumption per GHZ the better, obviously, and if I can reduce the power consumption under load enough, this should allow for offsetting the running of the cluster using alternative energy sources.

Anway I have now created a category green_giant and will continue to post more information as the concept progresses, I hope to get some technical diagrams up soon.