Not signed in (Sign In)

Scaling and Performance: apache and mod_php

Bottom of Page

21 to 26 of 26

  1. <
  2. 1
  3. 2
  4. >
    •  
      CommentAuthormandric
    • CommentTimeApr 7th 2009
     permalink

    Cool thanks, will keep you posted...

    •  
      CommentAuthormandric
    • CommentTimeApr 21st 2009 edited
     permalink
    So for now going with ...

         # mount -t ramfs ramfs /mysql_ramfs/
         # chown mysql:mysql /mysql_ramfs/
         # grep tmp /etc/mysql/my.cnf 
         tmpdir		= /mysql_ramfs
         tmp_table_size = 256M


    I just haven't added the ramfs mount to my fstab ... looking into it.
    •  
      CommentAuthormandric
    • CommentTimeApr 21st 2009
     permalink
    Well that didn't work, I started getting bunch of 403 errors from the drupal install. I will try again later ... but I found one thread on drupal that explains how to do a ramdisk on osx, just need to find a similar recipe for debian.

    http://drupal.org/node/369204#comment-1274786
    • CommentAuthorblender
    • CommentTimeApr 23rd 2009
     permalink
    TMPFS seems to be the best practice when used with MySQL for this purpose. cf:

    http://www.bigdbahead.com/?p=121

    Maybe give it size=512M instead of the size=2048M in the article to start.

    Note that tmp_table_size is limited by size of max_heap_table_size which you have set to 128 (yes, I saw your post on groups.drupal.org ;-) You should've posted that to High Performance group instead of MySQL - you still can if you want a second opinion, you won't hurt my feelings :-) )

    Cheers
    •  
      CommentAuthormandric
    • CommentTimeApr 23rd 2009 edited
     permalink
    Wow this article looks great ... (still reading)

    Also here's my post on the mysql list ... which is only gathering dust. The complete silence makes me feel like I'm on the wrong track.

    http://lists.mysql.com/mysql/217219
    •  
      CommentAuthormandric
    • CommentTimeApr 28th 2009
     permalink
    went ahead and followed the bigdbahead article and mysql took it just fine. monitoring the server, but looks promising so far.

    http://andric.us/load/

    Thanks again for your help, blender.

21 to 26 of 26

  1. <
  2. 1
  3. 2
  4. >