Re: Setting up multiple daemons

Devi wrote: Hi MySQLeers, How can I setup multiple daemons, One daemon for one database? So that they can act independenly. What might be the pitfalls over here? In what situation one can opt for multiple daemons? What about maximum_connections. Is it for all the server instances? You m

Re: mysql_upgrade shows errors

Yves Goergen wrote: Hello, I noticed that the current MySQL 5.0 release is not available as binary, so I downloaded the source and compiled it on my testing machine. Compilation went fine and I can connect to the new MySQL server version. But then I tried to run the mysql_upgrade script to fix p

Master -> Slave/Master -> Slave problem.

I'm working with two distinct databases on four different boxes. Databases A on Server A needs to be present everywhere (Server B, C and D). Database B needs to be present on Server C. So I setup replication from Server A to Server B and Server D and then I setup replication from Server B to Serv

MySQL spatial is glacial.....ly slow

Spatial Extensions in MySQL 5.0.16 (the version I'm on) seem really slow. I must be missing something, but can't figure out what. Some background: I'm trying to speed up a query that fetches the nearest 10 records (essentially, latitude/longitude pairs, stored in a Geometry point column)

Re: Repairing a table

Ian Barnes wrote: Im having another problem with a large db. I have a 160Gig drive dedicated to the database partition and I have on database in particular that is taking up the space. My .MYD is 78Gig and my .MYI is 34 gig. Thats fine i have a couple of gig left, but whenever i try and do anyth

Re: 2 ways replication

Thanks for the links. It seems helpful for me. I will read it then. BTW, does anyone implement multi-master replication successfully? I have read a lot of document and they all don't recommend to do it. On 2/13/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote: Dear all, We can view interes

Binlog file changes its name

Hi, I have also found that the master bin log file changing its name from myhostname-bin. to mysql.XXX and to other different names. I am running mysql Ver 11.12 Distrib 3.23.33, for hp-hpux11.00 (hppa2.0w). When I did sar -v 5 I found that inod-sz is on maximum: 14:39:05 text-sz ov

Re: ODBC connector 3.51/5.0

C K wrote: I HAVE TO TRY IT OUT. BUT THE PROBLEM IS THAT I HAVE MYSQL 5.0.17 AND I THINK 3.51.06 CAN NOT CONNECT TO 5.0.17. BUT I HAVE TO TRY. THANKS AND REGARDS CPK LESS CAPITALS THANKS. If you want to use MyODBC-3.51.x you should use 3.51.12.2. If that doesn't work for you, then you should

Re: mysqldump on Freebsd 5 -- out of memory error

Ronan Lucio wrote: > > Graham, > > > I was under the impression that in FreeBSD 5, you didn't need to change > > the kernel, just the entry in /boot/loader.conf... > > Even if you use kern_securelevel="1"? > > Ronan > I'm running kern.securelevel: -1 Graham -- MySQL General Mailing List For lis

Re: mysqldump on Freebsd 5 -- out of memory error

Graham, I was under the impression that in FreeBSD 5, you didn't need to change the kernel, just the entry in /boot/loader.conf... Even if you use kern_securelevel="1"? Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c

Re: mysqldump on Freebsd 5 -- out of memory error

Ronan Lucio wrote: > > Graham, > > > /usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes) > > when dumping table `Attachments` at row: 24285 > > Did you changed the values of MAXDSIZ in the kernel file? > > I use this: > > options MAXDSIZ=(1536UL*1024*1024) > > for MySLQ

Re: mysqldump on Freebsd 5 -- out of memory error

Graham, /usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes) when dumping table `Attachments` at row: 24285 Did you changed the values of MAXDSIZ in the kernel file? I use this: options MAXDSIZ=(1536UL*1024*1024) for MySLQ can you up to 1,5 Gb of RAM memory. I r

Re: mysqldump on Freebsd 5 -- out of memory error

Gerald L. Clark wrote: > Graham Dunn wrote: >> The error: >> >> /usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes) >> when dumping table `Attachments` at row: 24285 >> >> Platform details: >> >> Client: >> >> mysqldump Ver 10.9 Distrib 4.1.12, for portbld-freebsd5.3 (i386) >>

Re: ODBC connector 3.51/5.0

I HAVE TO TRY IT OUT. BUT THE PROBLEM IS THAT I HAVE MYSQL 5.0.17 AND I THINK 3.51.06 CAN NOT CONNECT TO 5.0.17. BUT I HAVE TO TRY. THANKS AND REGARDS CPK On 2/14/07, Ron Alexander <[EMAIL PROTECTED]> wrote: CPK, I'm not from MySQL but I had the same issue with MyODBC-3.51.12. The way I resol

Re: MySQL docs: Replication Chapter Revamped

Very cool - looking forward to reading it with the new replication options in 5.1 David Stefan Hinz wrote: Replication Chapter Revamped We have completely reworked the replication chapter for the 5.1 manual. This targets a number of issues, including a major rede

ODBC connector 3.51/5.0

Dear developers from MySQL, can i know when the MySQL connector/ODBc 5.0 will be released. I am facing few major problems regarding 3.51.12 on windows as application crash and wrong data display. please reply thanks, CPK -- Keep your Environment clean and green.

Re: Query Two Databases

Perhaps, you can use the CONCAT function, SELECT CONCAT(a.Fields, " - ", b.Fields) FROM database1 a, database2 b On 13/02/07, Neil Tompkins <[EMAIL PROTECTED]> wrote: Following on from the email below, if I run the query SELECT * FROM database1.table, database2.table I get the data back, but

MySQL docs: Replication Chapter Revamped

Replication Chapter Revamped We have completely reworked the replication chapter for the 5.1 manual. This targets a number of issues, including a major redesign (to make it easier to read and find topics), some updates to the information and processes, and incorporation

How to generate efficient backups?

Hi, Yesterday I had a problem in a InnoDB table that I needed to DROP and reimport the table. When I tryed to reimport the table, most of the data was lost. So, I´ve tryed to reimport the data from the backups (created via mysqldump) and these datas were still corrupted. So, it brings to my min

replication stability w/5.0.27

all, I recently completed upgrading the core database pool for our site from 4.0.18 (32-bit) to 5.0.27 (64-bit) but am now experiencing intermittent replication instability. we replicate ~20M DMLs/day across 18 DB nodes in three datacenters. about once/week I'm getting a 2013 error (error readi

Re: mysqldump on Freebsd 5 -- out of memory error

Graham Dunn wrote: The error: /usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes) when dumping table `Attachments` at row: 24285 Platform details: Client: mysqldump Ver 10.9 Distrib 4.1.12, for portbld-freebsd5.3 (i386) # /usr/local/bin/mysqldump -u dba -h seisei -p rt3

mysqldump on Freebsd 5 -- out of memory error

The error: /usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes) when dumping table `Attachments` at row: 24285 Platform details: Client: mysqldump Ver 10.9 Distrib 4.1.12, for portbld-freebsd5.3 (i386) # /usr/local/bin/mysqldump -u dba -h seisei -p rt3 --set-variable=max_a

RE: [Fwd: search issue]

Right. And "+cap" will not find "caps" - whats downside too. Though, my marketing director (who is in charge for this) will rather acept that then ANY word that contains "cap", as you mentioned. :) But, Lars was right, the problem was in ft_min_word_len. It's by default 4 and I have to change to 3

RE: [Fwd: search issue]

Don't forget that LIKE "%cap%" will find "captain", "recapture", and anything else that has the substring "cap" in it. Your Boolean match against "+cap" will only find the word "cap". Make sure that's what you want. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmi

Re: NOT EMPTY, like NOT NULL

Hello Nils and Jerry, Thanks you for your quick reply! IMO, using trigger looks cleaner and prettier than Excel-like if(char_length) hack so I will probably give triggers a try. Searching on the net, I found some articles on check constraints in MySQL. http://gilfster.blogspot.com/2005/11/check

Borland C++ Builder 2006 DLL Woes

We just purchased The Borland Developer Studio 2006 IDE and are having significant problems using dbExpress objects to communicate with MySQL servers (both 4 and 5). Curiously, we can perform inserts but not selects, even though identical code in C++ Builder 6 worked just fine. The DLL in C++ B

RE: Removing space characters ... char(160)? ... char(194)?

The character set used by Windows is not the same as UTF-8. That causes problems when you feed Windows text into an interface that is expecting UTF-8. I know it drives me crazy. If you pull up a web page that is in French, and check the page encoding in your browser, you can try changing it from U

Re: [Fwd: search issue]

hi afan, depending on your mysql conf you have a minimum word length. check your config for: ft_min_word_len and change it to 3. hth: lars On 2/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: hi to all! I'm trying to get some products from products table using fulltext search but someth

[Fwd: search issue]

hi to all! I'm trying to get some products from products table using fulltext search but something doesn't work correctly - and can't find what. this is table products: CREATE TABLE `products` ( `prod_id` int(8) unsigned NOT NULL auto_increment, `prod_no` varchar(50) NOT NULL default '', `p

Re: Query Two Databases

Neil Tompkins wrote: > Following on from the email below, if I run the query > > SELECT * FROM database1.table, database2.table > > I get the data back, but all the data is in the same row. > > How can I seperate the records ? > > Regards > Neil > > Barring an upgrade, it seems your best bet

Query help for Select

Hi All, I need help in this procedure, i am limiting the result to single row by using 'limit' in select statement. But i am using a variable here, mysql is throwing error as i am using variable, please give some suggestions. create procedure Report_login_Activity2() begin declare count,i int D

Re: Query Two Databases

Following on from the email below, if I run the query SELECT * FROM database1.table, database2.table I get the data back, but all the data is in the same row. How can I seperate the records ? Regards Neil ~~ At the moment we are using mysql 3.23.58. It

Re: Query Two Databases

At the moment we are using mysql 3.23.58. It would appear I can't use UNION in this version ? Do I have any other options, without upgrading the database server version ? Regards, Neil From: Nils Jünemann <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Re: Query Two Databases Date:

Re: 2 ways replication

Dear all, We can view interesting tipic into : http://www.onlamp.com/lpt/a/6549 Regards, Juan Eduardo On 2/12/07, Atle Veka <[EMAIL PROTECTED]> wrote: 2 way replication, also referred to as dual master replication, has been available for quite some time. However implementation can be tric

Call for Submissions: ICIMP 2007 & ICDT 2007 & ICGD&BC 2007, Silicon Valley, July 1-6, 2007

Call for Submissions: ICIMP 2007 & ICDT 2007 & ICGD&BC 2007, Silicon Valley, July 1-6, 2007 SUBMISSION DEADLINE: FEBRUARY 20 Invitation: Please consider contributing to the conferences ICIMP 2007 , ICDT 2007 and ICGD&BC 2007 as well as to the associated workshops listed below. Date: July

Re: Update failing with error 1062

Hi Michael Here is the table schema : DROP TABLE IF EXISTS `clients`.`calendarentry`; CREATE TABLE `clients`.`calendarentry` ( `idCalendarEntry` int(10) unsigned NOT NULL auto_increment, `Sujet` varchar(80) NOT NULL, `Debut` datetime NOT NULL, `Fin` datetime NOT NULL, `Notes` varchar(2048)

Re: 2 ways replication

Here are some links for you... http://www.howtoforge.com/mysql_master_master_replication http://sequoia.continuent.org/ http://www.howtoforge.com/loadbalanced_mysql_cluster_debian_p5 --- Rilawich Ango <[EMAIL PROTECTED]> wrote: > Hi all, > > I know it is an old question and I have read from

Re: Removing space characters ... char(160)? ... char(194)?

Hi all. I'm trying to weed out garbage that comes from copying and pasting stuff from a web page. Some of the data has spaces, but a *different* kind of space ... a char(160) kind ... I think ... I figured this out by copying the space character and pasting it into mysql thus: select ascii

MySQL is broken

Okay, now that I have your attention. :-) What I actually mean is, Spatial Extensions in MySQL 5.0.16 (the version I'm on) seem so slow as to appear broken. Why: I'm trying to speed up a query that fetches the nearest 10 records (essentially, latitude/longitude pairs, stored in a Geometry