Hi,
A little over a year since the project to write this book began, the
MySQL 5.1 Cluster Certification Study Guide is now at long last
available. Covering the Certified MySQL 5.1 Cluster Database
Administrator exam, this study guide is the one authority to look to
when you're preparing for the
Hi All,
Is the circular replication is suitable for production. In my view it
becomes complex.
Thanks
Krishna Chandra Prajapati
Fantastic, thanks very much!
Adam
Rob Wultsch wrote:
On Nov 29, 2007 4:34 AM, Adam Lipscombe [EMAIL PROTECTED] wrote:
Folks
How can one conditionally drop an index in MySQL?
Googling shows that the drop index does not support an if exists qualifier
- apparently a bug
has been raised but
hi list,
i have a loop to update my table:
update tbl_idea set col1 = 'text1', col2 = NOW() where ideaID = 1;
update tbl_idea set col1 = 'text2', col2 = NOW() where ideaID = 5;
...
update tbl_idea set col1 = 'textzzz', col2 = NOW() where ideaID = XXX;
my question is can i combine above
Hi All,
Please tell me the concept of partitioning in mysql. How it help to access
the data faster. How i can implement partitioning on mysql tables. Suggest
me some link for partitioining.
Thanks
--
Krishna Chandra Prajapati
Sorry I got carried away in my former response.
When I tried this,
ALTER IGNORE TABLE tbl_name DROP INDEX seems to fail if the index does not
exist.
The DROP INDEX statement is part of a larger script, what I want is for the script to conue to
execute if this index does not exist.
e.g.
Hi,
I am working on production and thinking of implementing chain replication
A-B-C. A is replicated to B. B is being replicated to C.
I want to know that there is any script or any cron by which i can replicate
(manually or automatically) D server to C.
(D is another replication server).
I was
On Dec 5, 2007 8:48 AM, Hiep Nguyen [EMAIL PROTECTED] wrote:
hi list,
i have a loop to update my table:
update tbl_idea set col1 = 'text1', col2 = NOW() where ideaID = 1;
update tbl_idea set col1 = 'text2', col2 = NOW() where ideaID = 5;
...
update tbl_idea set col1 = 'textzzz', col2 =
Where possible I use distro builds of applications (let them worry about
security updates and testing, means I don't need build tools on a
production server), but all the distros I've checked use their own
startup scripts which do not allow me to use mysqlmanager (or even
mysqld_multi) to run
On Dec 5, 2007 7:03 AM, Adam Lipscombe [EMAIL PROTECTED] wrote:
Sorry I got carried away in my former response.
When I tried this,
ALTER IGNORE TABLE tbl_name DROP INDEX seems to fail if the index does not
exist.
Right. ALTER IGNORE means that rows that violate unique indexes won't
be
hi list,
i have two tables:
idea(iid int not null primary_key auto_increment,
completed_by int,
submitted_by int);
employee(eid int not null primary_key auto_increment,
first varchar(20),
last varchar(30));
table idea data:
1 | 4 | 10
2 | 3 | 7
table employee data:
3 | john | Doe
4
You might try this:
SELECT I.iid, CONCAT(ECOMP.last, ', ', ECOMP.first) AS 'Completed By',
CONCAT(ESUB.last, ', ', ESUB.first) AS 'Submitted By',
FROM idea I JOIN employee ECOMP ON I.completed_by = ECOMP.eid
JOIN employee ESUB ON I.submitted_by = ESUB.eid
andy
Hiep Nguyen
On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote:
Could some one please let me know a stable version of MySQL for my computer?
Version 5.0.45.
http://dev.mysql.com/downloads/mysql/5.0.html#win32
--
Tiago Cruz
http://everlinux.com
Linux User #282636
--
MySQL General Mailing List
For
-Original Message-
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2007 8:09 AM
To: MySql
Subject: REPLICATION
Hi,
I am working on production and thinking of implementing chain
replication
A-B-C. A is replicated to B. B is being
mysql select idea.iid, concat(employee.first, ,employee.last),(SELECT
concat(
employee.first, ,employee.last) FROM EMPLOYEE where
employee.eid=idea.submitted_by) from ide
a,employee where idea.iid=1 and idea.completed_by=employee.eid;
M--
- Original Message -
From: Hiep Nguyen [EMAIL
Hi everyone ,
I'm new to the mysql administration world
(couple months). Couple days ago a client came up with the following
situation he got logged out after editing a table (tt_content table part
of typo3) He thinks he was kicked out because he tried to update a
I hope a simple question,
Can a MySQL Client (5.0.14) connect to a MySQL Server (5.1.22) (or more
specifically I have a static build of PHP using the libmsqlclient.la from
MySQL version 5.0.14 as a client attempting to connect to a MySQL server
running version 5.1.22rc.)?
My thanks in
Have you considered:
http://forge.mysql.com/wiki/MySQL_Proxy
On Dec 5, 2007 5:14 PM, Russell E Glaue [EMAIL PROTECTED] wrote:
Does anyone know of an open source SQL analysis tool?
I have query logging turned on in MySQL.
And I would like to analyze all the logged SQL select queries to
Does anyone know of an open source SQL analysis tool?
I have query logging turned on in MySQL.
And I would like to analyze all the logged SQL select queries to find out how
the database is being used, and then optimize MySQL databases or the SQL
views/statements accordingly.
Perhaps it would
Hello Team
Could some one please let me know a stable version of MySQL for my computer?
Configuration is as below:
OS- Windows XP Professional Service Pack 2
Processor AMD Athlon 64 Processor 2800+ 1.8Ghz
RAM 1 GB
Actually I have downloaded one which was meant for AMD processor, but it was
Hi All,
I am getting below error when i am updating a table
ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_5dc3_0.MYI'; try
to repair it
Its a myisam engine,
mysql update user_hist t,testprod.user_tory y set
- t.billing_plan=y.billing_plan, t.referrer_info=y.referrer_info,
Hello,
EDS and MySQL are having a webinar on the subject of circular replication
today. Check out:
http://www.mysql.com/news-and-events/web-seminars/index.html
If you can't make it today, it will be archived in the On-Demand section.
-- Jimmy
Alex Arul Lurthu wrote:
Chain replication is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, Dec 02, 2007 at 09:55:23AM +0530, Alex Arul Lurthu wrote:
How about looking at the .frm file of the table.
A couple of quickie tests shows something promising:
strings table.frm | egrep 'MyISAM|InnoDB|engineA|engineB|etc'
Unknonwn
Today, I installed 5.1.22RC and 6.0.3-alpha on my PC
I used 5.0.45's client successfully to connect to both.
I don't about 5.0.14
Give it a try !!!
-Original Message-
From: Jeffrey M. Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2007 4:36 PM
To: mysql@lists.mysql.com
Chain replication is fine as long as reading stale data from the last slave
in your chain is ok. the staleness depends on the write throughput and
capacity of the intermediate slaves. But Chain replication with circular
replication is a definite no no in prod since if any intermediate fails, you
Am Mittwoch, den 05.12.2007, 17:59 +0530 schrieb Krishna Prajapati:
Suggest me some link for partitioining.
http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitions.html
http://dev.mysql.com/doc/refman/5.1/en/partitioning.html
Norbert
--
MySQL General Mailing List
For list
Maybe too much data is being pumped in through the pipe
This sounds spot on. I redid the command to take the pipe out of the
equation and it seems to be working now. Thanks for the feedback.
Rolando Edwards-3 wrote:
'errno 32 on write'
That's a broken pipe error (Run 'perror 32' in
Hello,
We're working with a MySQL 5.0.18 on a Linux System (Kernel 2.6.5-7.97-smp).
The Server got 2G of RAM and enough HDD-Space.
We use several Tables on 2 Databases.
Most of them were MyISAM-Tables and we encountered some problems:
By 96% of the time we got reaction times in the range of 150 ms
Hiep Nguyen wrote:
i have a loop to update my table:
update tbl_idea set col1 = 'text1', col2 = NOW() where ideaID = 1;
update tbl_idea set col1 = 'text2', col2 = NOW() where ideaID = 5;
...
update tbl_idea set col1 = 'textzzz', col2 = NOW() where ideaID = XXX;
Depending on what you mean by
I started using MySQL 5 a couple of months ago and I was able to handle
most of the issues OK. However there is this particular problem that is
causing untold misery for my self and particularly my users.
At unexpected times, a roque query is executed or triggered all on its
accord and starts
Yes, Is it possible or not
-Krishna Chandra Prajapati
On Dec 5, 2007 8:56 PM, Jeff Mckeon [EMAIL PROTECTED] wrote:
-Original Message-
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2007 8:09 AM
To: MySql
Subject: REPLICATION
Hi,
Does any body has tried this
On Dec 6, 2007 10:08 AM, Krishna Chandra Prajapati [EMAIL PROTECTED]
wrote:
Yes, Is it possible or not
-Krishna Chandra Prajapati
On Dec 5, 2007 8:56 PM, Jeff Mckeon [EMAIL PROTECTED] wrote:
-Original Message-
From: Krishna Chandra Prajapati
Bubble bubble bubble
-Original Message-
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2007 9:48 PM
To: Jeff Mckeon
Cc: MySql
Subject: Re: REPLICATION
Does any body has tried this
On Dec 6, 2007 10:08 AM, Krishna Chandra Prajapati [EMAIL
33 matches
Mail list logo