server help MySQL

[golfbound]

Hi Guys my server has used up all its memory, it says MySQL is using 96% of the memory. Just wondering if this is normal and how would you fix it.

[Lobsta]

Delete stuff

[Lobsta]

Sorry, I'm a compulsive asshole. Do you mean physical (storage) memory or RAM?

[golfbound]

its Ram its always running at 100%

[markTHEblake]

I have a Mysql database admin (technically), but I dont actually know anything, and if ours dies our entire business dies. Its a good thing that I know how to use google.

Umm, what do you use for Mysql admin? just throw up a screen shot of what its telling you and we work from there.

oh and is it running on Windows or Linux?

[Shortylook]

Sorry, I'm a compulsive asshole. Do you mean physical (storage) memory or RAM?
that made my night shift

[idgolfguy]

With Windows, SQL tends to hog RAM. Cycle the services. You might have an errant process that's looping. Perhaps while it was doing some maintenance.

[golfbound]

running linux

will try and get a screen shot in the morning. I know nothing at all about MySQL

[markTHEblake]

Is it using 96% of the servers memory or 96% of memory allocated to mysql?

In the mysql.conf file there is a setting for how much memory mysql needs. I think the default config is quite small.

There is a tool called mysqltuner that can be run that analyses your system and makes recommendations, and can auto configure the mysql.conf for you. It's quite safe, I did it on my live server once and nothing crapped itself. You can always just run it see what it suggests.

Check Client connection see where that leads.

[golfbound]

Thanks Blakey

Im not sure how to run it at all. I am so lost with servers lol

[idgolfguy]

running linux

will try and get a screen shot in the morning. I know nothing at all about MySQL
We run Oracle on Linux - meant that DBs on servers work the same way.

MTB's advice is on the money...

Then again, I'm an Architect, I don't touch tools, just Visio.

[markTHEblake]

Ben. I would be happy to have a look at it middle to late next week when I get back. I doubt I could solve it but I reckon I can give you a head start on isolating it.

You can pay me back in kind.

[golfbound]

that would be great Blakey thanks heaps just let me know when

[markTHEblake]

You might have to remind me , the next 6 days are going to be a blur

[golfbound]

now getting this error and not sure how to log in to fix it?

The file system /dev/vzfs, which is mounted at /, has reached warn status because it is 85% full.

[BenM]

Probably SSH - use putty or similar.

Hope you are comfortable with the command line.

[golfbound]

no idea on SSH might have to do some study on it