Re: Problem with mysql

> Jørn Dahl-Stamnes : > I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' > resovl to the same IP-addresse. > What's wrong? Reverse resolution? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche & Developpement +26

mysqld occupies 100$ cpu

Hi mysqld process taking high cpu utilization (100%), how to reduce the cup utilization it is running under solaris 8 with 16GB ram and 1 multicore cpu (2 core) anyone help please? Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com

MySQL InnoDB memory performance tuning

Hi, I have a fairly small (data dir is 1.2GB) InnoDB database managed by MySQL 5.4.3-beta on an 8-core x86_64 Linux box with 16GB RAM. I'd like to use as much of the memory as possible, but despite specifying (e.g.) --innodb-buffer-pool-size=30, mysql only ever takes up 374M of resident mem

reaction to mysql remote buffer overflow 0day being posted online?

Apologies in advance for spamming the list. My name is Brian Krebs, and I'm a investive reporter who writes about computer security issues. I've just interviewed the founder of a Russian security firm who says he's getting close to posting pointers to and in some cases exploits for a large number

Re: Can't open file error number 24

In the last episode (Jan 11), Sathish said: > We have been using MYSQL in our dedicated server for long time without > problem, Suddenly we noticed an error stating " Can't open file error > number 24". > > When we rebooted the machine , MYSQL started working again fine. We have > to fix this pro

RE: Can't open file error number 24

> problem, Suddenly we noticed an error stating " Can't open file error > number 24". If I recall correctly, error 24 means the disk partition is full. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net MySQL pre-installed on a virtual private server for $25/mo Unmetered band

Can't open file error number 24

Hi, We have been using MYSQL in our dedicated server for long time without problem, Suddenly we noticed an error stating " Can't open file error number 24". When we rebooted the machine , MYSQL started working again fine. We have to fix this problem not to happen again, We have Opened t

tmp tables

Hi; I have a shopping cart that will spawn a tmp table for every shopping cart instance. Would it be better to create a separate database for these instead of having them in the same database as all the other tables for the shopping cart? TIA, Victor -- The Logos has come to bear http://logos.13g

Re: Problem with mysql

On Sunday 10 January 2010 12:34, sureshkumar...@gmail.com wrote: > Hi, > The grant stmt has to be as below. > Grant all on databasename.tablename to usern...@iporhostname identified by > 'password'; > > Use as above > Grant stmt doesn't require a flush stmt. Woops... Seems like the * in my first

Re: Problem with mysql

Hi, The grant stmt has to be as below. Grant all on databasename.tablename to usern...@iporhostname identified by 'password'; Use as above Grant stmt doesn't require a flush stmt. Suresh Kuna MySQL DBA --Original Message-- From: Jørn Dahl-Stamnes To: mysql@lists.mysql.com ReplyTo: sq.

Problem with mysql

Hello I have installed mysql, apache and phpmyadmin on a new server running Fedora Core 12. For some unknown reason I cannot connect to the local host using a full hostname. This is what I have done: r2-d2# mysql -u root -p grant all on . to 'root'@'r2-d2' idenfified by 'secret-password'; gran