[pLog-svn] Database layout
Ayalon
ayalon at blog.nl
Mon May 22 12:53:31 GMT 2006
> | 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
More information about the pLog-svn
mailing list