Dear all,
I am able to install Mysql-5.1.4 o a Linux Machine without any error.
All is working fine.
But I am searching a file my.cnf which is most important and is used in
mysql but cannot able to find it.
I install mysql by yum install mysql-server and yum install mysql-client
commands.
Dear all,
I am working on some common tasks that need to be performed on regular
intervals in a large Database Servers. I find below lists of tasks that
need to be performed and Please tell me if i missed some.
1. Tacking Daily, Weekly Backups.
2. Finding Space Occupied and Remaining in Data
Is there a way to "/etc/init.d/mysql start" WITHOUT doing an integrity
check?
Can I pass in a command line parameter or set something in the my.cnf file?
Our DB is a Billion rows (with a "B") and that check can take HOURS.
All we want to do is restart the server to put another slave online bec
On Wed, Dec 29, 2010 at 04:57, Hajo Locke wrote:
> Hello,
>
> i want to talk from php to different mysql-servers with different versions.
> is it a recommend way to compile php always against newest libmysqlclient or
> not so important?
You should use the newest stable version so you can take
Hi,
why doesn't MySQL support selecting from the table being updated? The
following and any variations of it doesn't work:
UPDATE t1 (c1) VALUES (SELECT MAX(c1) FROM t1);
This restriction is documented here:
http://dev.mysql.com/doc/refman/5.5/en/update.html (at the very bottom)
Wouldn't it be
Hi all,
We have a pool of 8 MySQL servers where the first one is the
master and the others 7 are slave. Yesterday we have a hard time where the
server begin with too many lag ( 1 hour ) and then slaves start to fail with
messages like this one
thd=0x38f18130
Attempting backtrace. You ca
really really a little noisy.
这下犯众怒了吧，招人烦了~ 囧
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
2010/12/29 杨涛涛 :
> Ok, I'll not post any more! Just reading!
>
>
> David Yeung, In China, Beijing.
> My First Blog:http://yueliangdao0608.cublog.cn
> My Second Blog:http://yu
