Jump to content
Sign in to follow this  
steve k.

we have more memory

31 posts / 4811 viewsLast Reply

Recommended Posts

The momory problem with the server has been resolved. We now have more RAm and hopefully enough to sustain the traffic.

steve k.

how much memory was it/is it now? just curious... ;)

Share this post


Link to post
Share on other sites

1gb? That still seems small. I am used to my 2850s with 4gb of RAM :P

Anyway, create a bash script to nuke those log files once a week.

I can help you if you want.

What version of mysql we running? What does the my.cnf look like? You can streamline that... and I can also build you apache 2.2 rpm (assuming you use redhat) as well. It will really fly then. :)

Share this post


Link to post
Share on other sites

the issue with logs is that fior some reason the setting for the slow.query one gets reset every time we reboot the box. A little strange. So it logs every query run without an index. There are lot of them.. All i want is queries that take more them 5 seconds. And those practically do not exist.

steve k.

Share this post


Link to post
Share on other sites

Whats the /etc/my.cnf look like? Keep in mind that my.cnf does NOT get installed with mysql... so if you set something via mysql command line and restart the service or the box you will lose the setting.

Inside my.cnf... (among other things):

You could change the value of:

long_query_time=6 and slow queries will be greater than 6 seconds.

Also you can set the location:

log_slow_queries=/var/lib/mysql/slow-queries.log

Also when you do a "mysqladmin", it will tell you what places it is reading the my.cnf from by default.

What version of mysql are we running? 5.0.something ?? 5.0.26 is current.

Share this post


Link to post
Share on other sites

I do the same thing with my logs but every hour actually! We get about 500,000 page churns a day so we need it. We also need 4 machines with 16 gigs of memory each because we are running an enterprise Java application. No PHP kiddies here ;)

Share this post


Link to post
Share on other sites

Yea you need 16GB of ram just load JVM itself ... thats without any programs :)

PHP here. All I can say is LAMP rules. We are at 40-50 million searches a day on one of our products.

Share this post


Link to post
Share on other sites

Dont get me wrong. I also use PHP, but mostly only for quick and dirty things and personal projects. I dont think I would like to build a large e-commerce site on PHP again after knowing Java really well.

I also find that PHP allows developers to be extremely slopping and write one-use only code. That being said, anyone can write bad code, I just find that PHP structure lends itself to that.

Share this post


Link to post
Share on other sites
woot!!

top.jpg

the swap isn't even being touched!!

but.. there's 1 zombie!! AHHHHH.

Man, at my new job there's a solaris box with 1500day uptime.

Bind quit on it and I had to log in to see what happened. .booya.

Share this post


Link to post
Share on other sites
woot!!

top.jpg

the swap isn't even being touched!!

but.. there's 1 zombie!! AHHHHH.

Man, at my new job there's a solaris box with 1500day uptime.

Bind quit on it and I had to log in to see what happened. .booya.

its holloween.. there's always one zombie!!

it was there just for a sec while I did the screen grab.

Steves controlling my.conf looks pretty groovy to me.

join_buffer_size=1M

key_buffer_size=50M

max_allowed_packet=128M

max_connections=500

max_connect_errors=10000

open_files_limit=65536

read_buffer_size=1M

sort_buffer_size=1M

table_cache=500

thread_cache_size=20

wait_timeout=200

long_query_time=5

Might be time to up the key_buffer_size since the new memory ..

sorry steve for exposing the guts.. its like letting someone look in your engine uninvited.

i'll quit

Share this post


Link to post
Share on other sites

i don't know nuthin about any of that stuff. But I do know we need to decapitate or scramble the brains of that zombie, before we have more zombies.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  



×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.