[pLog-svn] Database layout

[Jon Daley]

Yes, you are right, there are other databases besides lifetype, but I 
think I have most everyone on postgres.  There is one agora shopping cart, 
and a couple homemade picture databases in mysql.

Lots of fun statistics though

| Threads_created            | 66485      |
| Threads_running            | 1          |

| Slow_launch_threads        | 3          |
| Slow_queries               | 71         |

| Qcache_free_blocks         | 1481       |
| Qcache_free_memory         | 5580144    |
| Qcache_hits                | 2143617    |
| Qcache_inserts             | 743683     |
| Qcache_lowmem_prunes       | 54028      |
| Qcache_not_cached          | 117544     |
| Qcache_queries_in_cache    | 3929       |
| Qcache_total_blocks        | 9581       |


| Bytes_received             | 550354478  |
| Bytes_sent                 | 2794570568 |

| Created_tmp_disk_tables    | 46041      |
| Created_tmp_files          | 6749       |
| Created_tmp_tables         | 125230     |



On Mon, 22 May 2006, Oscar Renalias wrote:
> I suppose you have other applications running, but what do you get if
> you type this at a mysql console prompt:
>
> show status like 'qc%';
>
> It should show number of cache hits, etc.
>
> On 5/20/06, Jon Daley <plogworld at jon.limedaley.com> wrote:
>> On Sat, 20 May 2006, Oscar Renalias wrote:
>> > By the way, does anybody have MySQL's query cache enabled? I was playing 
>> with
>> > it a couple of days ago and the results where quite good (most of the 
>> queries
>> > were being cached and served a lot faster from the cache!)
>> 
>> Debian's defaults are the following. I have not played with the settings
>> at all.
>> 
>> query_cache_limit   = 1048576
>> query_cache_size        = 16777216
>> query_cache_type        = 1
>> 
>> 
>> **************************************
>> Jon Daley
>> http://jon.limedaley.com/
>> 
>> A fellow can't keep people from having a bad opinion of him,
>> but he can keep them from being right about it. -- Unknown
>> _______________________________________________
>> pLog-svn mailing list
>> pLog-svn at devel.lifetype.net
>> http://devel.lifetype.net/mailman/listinfo/plog-svn
>> 
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>

**************************************
Jon Daley
http://jon.limedaley.com/

Nothing is as easy as it looks.
-- Murphy's First Law