[pLog-svn] Database layout

[Ayalon]

> | Created_tmp_disk_tables    | 46041      |

Can you verify which queries causes this?

----- Original Message ----- 
From: "Jon Daley" <plogworld at jon.limedaley.com>
To: <plog-svn at devel.lifetype.net>
Sent: Monday, May 22, 2006 2:39 PM
Subject: Re: [pLog-svn] Database layout


> 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
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn