ERROR 2003: Can't connect to MySQL server on ....

Hello list: Just finished installing mySQL on a Linux Debian system and I have a question about how the 2 root users that are set up by default. When I look at my user table there is a root user allowed to log in from "localhost" and also another root user but this one is only allowed to log in f

How to select without using sub-select?

Hi, I am running MySQL 4.0.10 gamma. I have records with data: id title version 1a 1 2a 2 3b 1 4b 2 How do I select all the records with highest version for each title? (The records with id 2 and 4) I've been thinking about combinating GROUP BY and

Re: establishing a relationship

Ted, If in fact you only have a one-to-many relationship, you don't need the third table (what's also known as a join table in some circles). This type of table is only really needed if you are doing a many-to-many (people have 0 to infinity machines, and machines have 0 to infinity people).

Compiling:Not a valid library (invalid magic number).Possibly a 64-bit PA archive library (Mismatched ABI).

Hi! I am porting a program from windows to UNIX and I cannot get it to compile on the UNIX version. Any suggestions?? Are the libraries shipped with mysql correct? Am I compiling it correctly? Any help is appreciated! Thanks Eric Error exit code 1 /opt/ansic/bin/c89 -o bin/ceagtest obj/ce

Re: Problem with mysql replication

"Dan Houtz" <[EMAIL PROTECTED]> wrote: > I'm currently trying to setup replication following the directions from the mysql > manual, however, once I configure the slave server with the server-id parameter, it > fails to load. If I remove server-id=2 from my.cnf then the server starts up fine. >

establishing a relationship

I have a friend teaching me but I want more :-) (second opinions), please. A simple Database: 2 tables a one-to-many relationship each table has a Primary Key: table1 (one) Primary Key = peopleID; table2 (many) Primary Key = machinesID Normally, I would put the peopleID also in table2 as a For

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

> > When mysql is indexing You can check your data file direcory and You > > ca see that one file (the index) is growing in size. > I see it grow up to 8M and it stays there. Watching this, it grows very slowly. After 5 minutes of indexing, the file size has barely hit 2MB. > > The command I use

RE: Getting the last entered row from a relational table

Try: select * from comments where (place_holder id) = (id in main table) order by id desc LIMIT 1 Andy > -Original Message- > From: Petre Agenbag [mailto:[EMAIL PROTECTED] > Sent: 05 June 2003 11:05 > To: [EMAIL PROTECTED] > Subject: Getting the last entered row from a relational table >

RE: Suggestions on joins/merges, resolution

- Forwarded by Peter J. Milanese/MHT/Nypl on 06/05/2003 07:35 AM - Peter J. Milanese 06/04/2003 09:55 PM To: Peter J. Milanese/MHT/Nypl cc: "Mike Hillyer" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject:RE: Suggestions on joins/merges, resolution

RE: funky segfaults

This one may be very esy to solve: Just add mysqld: ALL : allow to your /etc/hosts.allow You can change ALL to IP range that suits you. Let me know if this helps. It helped me. Ivan Debnar Zoznam - Original Message - From:"sektie" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] S

Re: Getting the row back with the highest ID.

Sub-selects are supported in v4.1, which is still in Alpha release. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Petre Agenbag" <[EMAIL PROTECTED]> To: "Egor Egorov" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, 05 June, 2003 06:18 Sub

Mysql-4 binary problem for IRIX64

Hello everybody, i don´t know if i deserve a big RTFM... After install a MySQL Binary Distribution, the mysql-standard-4.0.13-sgi-irix6.5-mips in a SGI machine with IRIX64, the localhost.err was: 030604 17:50:59 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB:

Re: start innodb without transactions

Probably i need to describe the whole story: I did a huge insert, a file about 100Mb, and mysql crashed/restarted, the err file showed: -- 030605 12:11:59 mysqld restarted 030605 12:12:00 InnoDB: Database was not shut down normally. Inn

Reg my.cnf entry

Hello mysql, Just let me know whether we can create seperate binary files for seperate DBs used. And how to.. also Thanx & Regards, Charitha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED

funky segfaults

I've tried posting this to the FreeBSD-questions mailing list, but to no avail. I'm running FreeBSD 5.0, and I've had this problem on 2 builds so far. 3.23.54 works just fine for me, but 3.23.56 and all versions I've tried of 4.x get a signal 11 anytime a connection is made by anything other t

Re: mySql Command Console

hostname: localhost username: root password: rgds - Original Message - From: "Richard Adler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 06, 2003 11:13 AM Subject: mySql Command Console can you help me with mySql control console. it is presenting me with a window to

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

> I think your index is corrupted because I expect a 1.5 GB index and not 8M! > You can see word list wit a utility (sorry I don't remember te name ft_dump). I agree with this :-) > I suggest You to drop fulltext index, duplicate database and remove > some rrecords. > Then create index index aga

pre-compiled libmysqlclient.a for MinGW?

Hello, I'm currently trying to install the MySQL++ API on a MinGW system. Unfortunately, I'm lacking of a libmysqlclient.a for that sake. In the web, I found some (broken) links to a site named http://www.johnydog.cz/projects.php, where there ought to be a MinGW port of libmysqlclient for mysql-3

Re: Getting the row back with the highest ID.

Thanks, I presume that subselects is not yet featured in MySQL 4.0.13? ( Sorry, can prolly get this by RTFM ), If it does, how would the query look? Thanks On Thu, 2003-06-05 at 11:44, Egor Egorov wrote: > Petre Agenbag <[EMAIL PROTECTED]> wrote: > > > > I think I'm having a very off day and ne

Re: Problem with adding a new user by non root user with GRANT OPTION

"Marcin Blazowski" <[EMAIL PROTECTED]> wrote: > I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS to > that database. When logon with that new user and want to create a new user > with some privileges a get an error. > > How I do it: > > mysql> grant all privileges on temp.

Re: Getting the row back with the highest ID.

Petre Agenbag <[EMAIL PROTECTED]> wrote: > > I think I'm having a very off day and need some confirmations on how > MySQL works with it's result sets. > > I have a couple of relational tables , the first holding the person's > name and address for instance, and the other tables holds comments and

mySql Command Console

can you help me with mySql control console. it is presenting me with a window to register a server. I am running mySql locally on my workstation. It wants a Name for the server. I called it TestMySql host name: I put [EMAIL PROTECTED] User name: I put root Password: I don't know what password it i

Re: I thought single UPDATE statements were atomic

On Thu, Jun 05, 2003 at 09:09:36PM -0500, Paul DuBois wrote: > At 18:52 -0500 6/5/03, Mark Rages wrote: > >According to the docs, single update statements are atomic. > > That's correct. > > Consider what happens if MySQL tries to update the first record and > then the second, version what happen

Getting the last entered row from a relational table

Hi List. I think I'm having a very off day and need some confirmations on how MySQL works with it's result sets. I have a couple of relational tables , the first holding the person's name and address for instance, and the other tables holds comments and complaints respectively. Each table has it'

Re: threads not being killed

On Thu, Jun 05, 2003 at 10:01:23AM +, Gustavo A. Baratto wrote: > Greetings, > > we running mysql 4.0.13 compiled statically with linuxthreads on > freebsd 5.0 (SMP). > > The problem is that a few connections are not dying after the > wait_timeout and interactive_timeout expired. > > The

load file

Hi, I have a a text file delimited with | and I don't how to load the data into a table and say delimited by '|' I think it is this: LOAD DATA INFILE 'C:\data.txt' INTO TABLE table2 FIELDS TERMINATED BY '|'l Any clarification would help. Anthony -- MySQL General Mailing List For list archiv

ANN: EMS MySQL Manager for Linux 1.3 released

EMS HiTech company is pleased to announce MySQL Manager for Linux 1.3 -- the next version of our powerful MySQL administration and development tool! You can download the latest version and user's guide from http://www.ems-hitech.com/mymanager/download.phtml What's new in version 1.3? 1. We've ad

Re: myisamchk - error 28

Hi Fraser, Thats a famous one (I like it - you probably wont ;-) It means that your hard disk (partition) is full. http://www.knowd.co.jp/staff/nils/mysql-error-codes.html Best regards Nils Valentin Tokyo/Japan 2003年 6月 6日 金曜日 10:27、Fraser MacKenzie さんは書きました: > I am using mysql 3.23.54 and a

Exploring Session variables

Hello Mysql Fans, I tried the following statements: select @@session.sql_big_selects; would return a value while SHOW SESSION VARIABLES LIKE '%sql%'; would return only the value for sql_mode, but not for sqlbig_selects, sql_big_tables, sql_log_binlog ... etc. Is this not implemented yet in

Getting the row back with the highest ID.

Hi List. I think I'm having a very off day and need some confirmations on how MySQL works with it's result sets. I have a couple of relational tables , the first holding the person's name and address for instance, and the other tables holds comments and complaints respectively. Each table has it'

Re: another replication question..

Hi Ross, On Wed, 2003-06-04 at 16:44, Ross Simpson wrote: > I have another question that doesn't seem to be addressed in the mysql > manual. > > Does any sort of locking occur while a slave is updating it's local > databases? Can I still read any/all tables while this process is > occurring? >

Problem with adding a new user by non root user with GRANT OPTION

Hi! I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS to that database. When logon with that new user and want to create a new user with some privileges a get an error. How I do it: mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by 'haslo' with grant

RE: 2 different Mysql DB on the same server

u need two different instances , totally different source directories for instance , an they run on ifferent pors say one on 3306 and one on 3307 mind u php ha problems connecting to something not on 3306 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday,

RE: REPOST: FULLTEXT searching help needed. Please somebody help.

create fulltext index Name on Table(field) i didnt get this i usually do add fulltext field (field) i think , is that wrong ?? -Original Message- From: Santino [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 6:14 PM To: [EMAIL PROTECTED] Subject: Re: REPOST: FULLTEXT searching he

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

I think your index is corrupted because I expect a 1.5 GB index and not 8M! You can see word list wit a utility (sorry I don't remember te name ft_dump). I suggest You to drop fulltext index, duplicate database and remove some rrecords. Then create index index again. Some questions: Do You have d

Re: Stripping off commas

http://www.php.net/manual/en/function.substr-replace.php - Original Message - From: "delz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 8:57 AM Subject: Stripping off commas > Hi All, > > I'm using Mysql as my database and php as my script to connect to the

Re: 2 different Mysql DB on the same server

This ? http://www.mysql.com/doc/en/Installing_many_servers.html Jerry - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 8:55 AM Subject: 2 different Mysql DB on the same server Hi to all, I need to have on the same PC (that is the Ser

Stripping off commas

Hi All, I'm using Mysql as my database and php as my script to connect to the MySQL server. Supposed I have a number with a value of 10,000. How do I strip off the comma using php. I manage to use the number_format to put a comma. How do I go about this. Any help will be appreciated. Regards, De

2 different Mysql DB on the same server

Hi to all, I need to have on the same PC (that is the Server) 2 different mysql DBs; I need it because I need some data on the standard mysql dir (for example ...\mysql\data\) and some data on a different dir. I installed mysql simply installing phpdev423; therefore I found out automatically the D

REPOST: FULLTEXT searching help needed. Please somebody help.

Hello All. I am using Redhat 9.0 with MySQL 4.0.12-0. I've hit something of a dead-end with fulltext searching and I don't know where to look next. I have a table that is about 1.5GB with about 400 records. As you can tell, every record is about 4MB, all of which is text. I've created a fullte

testing concurrent connections

Hi, Does anyone know of a program/good way to test the number of concurrent connections a MySQL server can handle? I get errors building super smack (and I've also tried an old script called mysql-con_stress (by Sascha) with similar results...) Can anyone help? I'm using SuSE 8.2, gcc version

Re: mysqld CPU usage is almost 100% !!!

On Thu, Jun 05, 2003 at 11:33:23AM +0800, Ahmad Rezal Ibrahim @ PNSB wrote: > > check either your using ODBC - trace is on ? How would that impact the server? I'm not terrible ODBC-literate, so I don't know. Jeremy > -Original Message- > From: nino [mailto:[EMAIL PROTECTED] > Sent: Thu

failure to build MySQL v4.0.13 on Solaris-9

Hi, I am struggling to compile version 4.0.13 under Solaris-9 using GCC version 3.2.3 : according to "http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html";, I have set the following variables BEFORE running configure: CFLAGS="-O3" CXXFLAGS="-O3 -felide-constructors -fno-

Re: mysqldump

Hi Massimo, sorry for the late reply. I lost your e-mail for a moment (so many) ;-). I dont understand if you want to export to another database server or a completely other format. In case you are looking to transfer the datbase and /or tables then I think you can do the following: Export al

Re: mysqld CPU usage is almost 100% !!!

On Thu, Jun 05, 2003 at 10:05:00AM +0700, nino wrote: > Hi folks, > > I'm experiencing some phenomenon that mysqld is consuming CPU at > almost 100%. At this time, I only assemble a few database with > record size is about 37000 rows. Is mysqld likely gonna crash or > something ?? > > I also not

Re: good or bad?

Anthony, I think 5.2.1 Explain Syntax in the manual covers what you are asking about. PB - Original Message - From: Anthony Ward To: [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 2:26 PM Subject: good or bad? Hi, going to back to the thread of best SQL statment i d

Installation - libmysqlclient.so (Redhat 8)

Hi All, Newbie question. Stock Standard Redhat 8.0 install with MySQL 3.23. Have not started using, so thought I can upgrade to Version 4.0 it before I face more problems later on. RPM -e mysql* libmysqlclient.so.10 needed by perl-DBD-MySQL from the Mysql manual, it says that we can in

No Session Setup-Refused Connection

Hi All, Can someone help me debug this? [2003/06/05 09:24:45, 3] smbd/reply.c:reply_sesssetup_and_X(858) Domain=[] NativeOS=[Windows 2000 2195] NativeLanMan=[Windows 2000 5.0] [2003/06/05 09:24:45, 3] smbd/reply.c:reply_sesssetup_and_X(868) sesssetupX:name=[] [2003/06/05 09:24:45, 1]

Re: MySQL Errno: 2013

Hi Kevin, thats alright, let me know when it worked, thats what I want to hear ;-) Best regards Nils Valentin 2003年 6月 5日 木曜日 00:12、Kevin A. Miller さんは書きました: > Nils: > > sorry for the delay getting back to you. > > this morning we modified the variables mentioned below. Following are > current

Re: nested ORDER BY statements

Hi David, can't give you detailed advice but I believe you look for SELECT...GROUP BY ... ORDER BY Please see the docs like "info mysql". Best regards Nils Valentin Tokyo/Japan \ 2003年 6月 4日 水曜日 22:37、Dave Terrio さんは書きました: > Hello - I'm a relative newcomer to development with MySQL and am

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

Hi Heikki, Thank you for the reply. I understand that this is related to the host.frm. Thank you very much. The part which I don't get is why would a standard my.cnf file (skipping innodb) start up and the my.cnf file containing the innodb settings give me such an error ? I understood your adv

Re: authentification intranet

Dont forget "FLUSH PRIVILEGES" ;-) otherwise you might be wondering why the new settings dont apply. Best regards Nils Valentin 2003年 6月 5日 木曜日 02:55、jinal jhaveri さんは書きました: > I guess the problem is with your authentication. Mysql 4.1 uses a new auth > schema. You might want to try use mysql;

Re: detailed FULLTEXT index and search help needed

Hi Kunzmann, I might be wrong but to answer your question I think three things are necessary: 1) we will need to know the table structure(s) 2) we wil need to know which column you indexed 3) we wil need to know which request(s) you used Is it possible that you indexed a column in the big tabl

Re: [Correction] MySQL List Stats for May, 2003

Hi Bill, Such a pitty. For a moment I thought I am the new No.1 ;-) (see previous posted data) Best regards Nils Valentin Toko/Japan 2003年 6月 5日 木曜日 07:29、Bill Doerrfeld さんは書きました: > --- > Please ignore my prior post on this. The numbers were wrong as it > turned out I inadv

Re: MySQL List Stats for May, 2003

I am not sure if I will use it often, but definitely well done ;-) Very clear organization of the data. Thats definitely something which will be highly appreciated by most list members (and MySQL AB) I am sure !! Best regards Nils Valentin Tokyo/Japan 2003年 6月 5日 木曜日 06:55、Bill Doerrfeld

Re: FW: MySQL for our production reporting data warehouse

1) www.mysql.com >> look at the top left corner 2) - Gamma (widely deployed, no more critical bugs reported by users, thus "almost production"), - Beta (not so widely deployed, so the server might still contain critical bugs that show up only in certain environments / situations), - Alpha (no b

RE: bug in replication?

Let me clean up my grammar and explanation a bit. I rushed the email message. -->-Original Message- -->From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, June 04, 2003 5:26 PM -->To: [EMAIL PROTECTED] -->Subject: bug in replication? --> -->Before I send this to [

bug in replication?

Before I send this to [EMAIL PROTECTED] I would like to see if anyone else is hitting a replication bug in 3.23.5x Last_Errno Last_error 4294967295 | error 'unexpected success or fatal error' on query 'UPDATE member_stats1 SET view7=0' Notice the Errno, it's the not the errorno for the error

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

> You have to remember that the manual is kept in sync with the _latest_ > version of the server ... I know. I chose to avoid that in my comments, even though the original post was regarding v3.23.54 > This change happened in 4.0.13 (implictly and quietly) :) I saw that after I checked out the

Cannot build mysql 3.23.56 on AIX 4.3.3

[Second copy just in case] >Description: makeinfo fails to build the manual.txt file and kills the build Also having the same problem with 3.23.51 (needed to build the upgrade). >How-To-Repeat: after running the configuration program, run gmake >Fix: No idea - hoping you could

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Becoming Digital wrote: [snip] > from http://www.mysql.com/doc/en/CREATE_TABLE.html: > a.. A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT > NULL. If they are not explicitly declared as NOT NULL, it will be done > implicitly

MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

Hi, We agree that statements of the form CREATE TABLE table-name (column1 INT PRIMARY KEY) should be legal -- it should not be necessary to say CREATE TABLE table-name (column1 INT PRIMARY KEY NOT NULL) The requirement, that primary keys should explicitly be declared as NOT NULL

RE: How to exporting MySQL table for web publishing

>Could you please advise me on how to export data in > LINUX/MySQL table > for web publishing? If you need the data in a mysql table displayed in an HTML table, a quick and dirty way to get a static file is to run this from the command line... #mysql -uroot -p -H -e"SELECT * FROM Employee"

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

I'm unsure what you see as a problem here? The only conflict with relational theory would occur if MySQL *permitted* NULL values in primary keys. According to the error message you received, MySQL is doing a fine job of preventing this. CREATE TABLE test ( col1 INT PRIMARY KEY,

Re: Replication over SSL

Hi Gareth. On Tue, Jun 03, 2003 at 09:59:52AM +0100, Gareth Davis wrote: > I guess this is right place for this. I'm trying to setup replication > between two hosts over the Internet. > > My problem is that i can't seem to solve an authentication problem > between the slave and the master. Before

[Correction] MySQL List Stats for May, 2003

--- Please ignore my prior post on this. The numbers were wrong as it turned out I inadvertently based a portion of the report on numbers from June, 2003. Please find below the correct report. --- As some of you know, we host the MySQL list searchable archives at

Re: MySQL: standard SQL compliancy: primary keys: default: should be NOT NULL

Hi Neil. On Wed, Jun 04, 2003 at 02:33:22AM -0230, Neil Zanella wrote: > I believe that MySQL is in error in reporting the following message just > because I did not specify that the PRIMARY KEY should not be NULL. These > days there are standards and SQL92, AFAIK, specifies that if the primary >

How to exporting MySQL table for web publishing

Could you please advise me on how to export data in LINUX/MySQL table for web publishing? Thanks Lili -- MySQL General Mailing

Count on Multiple Tables

I've been stuck on this one all morning. Can't seem to figure it out. I have 2 tables, one with affiliate sales and another with affiliate clickthroughs. I have to query both tables, so that I can get clickthrough dates, hits, and then query affiliate sales table to get number of orders for each d

MySQL List Stats for May, 2003

As some of you know, we host the MySQL list searchable archives at ListSearch.com as a free service to the MySQL community. To access said archives, visit . The archives not only allow you to search on various fields of information (body, date, subject, au

Re: RH 8.0 InnoDB: Assertion failure in thread 122911infilemem0pool.c line 477

Hello Heikki, On Wed, 2003-06-04 at 16:27, Heikki Tuuri wrote: > actually, it probably is reporting the right query :). It is the TEXT column > `FEEDBACK` text. TEXT is essentially the same as a BLOB. > > > > I have exorcised the code we have that updates and interacts with this > > table in o

RE: NEWBIE QUESTION: Copying Databases from local to server

You can see more in-depth descriptions in the documentation, but for a simple shot at migrating data and database structures from one machine to another, you can try: Prompt> mysqldump --add-drop-table <> -uroot -ppassword | mysql --host=new.host.ip.add -uroot -ppassword You can dink around wit

URGENT: Problems compiling mysql 3 and 4 on IRIX indy 6.5 IP22 mips

Hi! > "Jason" == Jason Buchanan <[EMAIL PROTECTED]> writes: Jason> hi, Jason> I'm having a hard time getting mysql 4 and mysql 3 to compile on IRIX 6.5... Jason> Does anyone have a solution to this? Jason> Below is an example of compiling mysql 4.0.13 (looks practically Jason> identical

Re: FW: MySQL for our production reporting data warehouse

Sonia, >> My company is thinking of using MySQL for our production reporting data >> warehouse. If you intend to use MySQL for production purposes, you should go to http://www.mysql.com/ and download the database server labeled "Production" (currently 4.0.13). MySQL has fast release cycles, and i

Re: RH 8.0 InnoDB: Assertion failure in thread 122911infilemem0pool.c line 477

Richard, - Original Message - From: "Richard F. Rebel" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 10:28 PM Subject: Re: RH 8.0 InnoDB: Assertion failure in thread 122911infilemem0pool.c line 477 > > Hello Heikki, > >

RE: NEWBIE QUESTION: Copying Databases from local to server

Thanks everyone for the replies. I know I should probably be using phpMyadmin or the command line to export my info out of my local mySQL setup but... I'm using mySQL control center. Using this tool I can't seem to export. There is a button to do it but it is always greyed out. Is there a step

Re: mysql4 query cache pruning unnecessarily?

The tables certainly get updated and therefore those queries should be ejected from the cache, but it's not a memory issue. Does that mean that Qcache_lowmem_prunes is actually the sum of low memory prunes and dirty queries? The manual doesn't seem to suggest this, so it would be cool if someone co

Problem with mysql replication

I'm currently trying to setup replication following the directions from the mysql manual, however, once I configure the slave server with the server-id parameter, it fails to load. If I remove server-id=2 from my.cnf then the server starts up fine. I'm hoping someone can help me out: Master and

Re: MySQL for our production reporting data warehouse

Sonia Ghadially <[EMAIL PROTECTED]> writes: > Dear Sir/Madam: > > My company is thinking of using MySQL for our production reporting data > warehouse. > > Could you please tell me: > > 1) > What is the latest release of MySQL, and what is the latest stable release > of MySQL? Go to http://www.

Re: mysql4 query cache pruning unnecessarily?

LS <[EMAIL PROTECTED]> writes: > Hi- > Can anyone tell me why mysql4 would prune queries from the cache if the > Qcache_free_memory is still very big? I'm confused why we get so many > Qcache_lowmem_prunes: Mysql will prune queries if the tables are updated, maybe this is what you are experienc

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 infilemem0pool.c line 477

Hello Heikki, On Wed, 2003-06-04 at 14:29, Heikki Tuuri wrote: > Richard, > hmm... maybe mysqld is reporting a wrong query in a crash. Do you have any > BLOB (or TEXT) tables and what kind of queries you run on them? How big are > the BLOBs if any? > > The hex dump looked like parts of some lo

good or bad?

Hi, going to back to the thread of best SQL statment i did: this EXPLAIN SELECT * FROM `zip` WHERE longitude BETWEEN - 98.315 AND - 94.662 AND latitude BETWEEN 31.696 AND 34.587 AND 3963 * acos( cos( latitude ) * cos( 33.1414 ) + sin( latitude ) * sin( 33.1414 ) * cos( - 96.5883 - longitude )

MySQL for our production reporting data warehouse

Dear Sir/Madam: My company is thinking of using MySQL for our production reporting data warehouse. Could you please tell me: 1) What is the latest release of MySQL, and what is the latest stable release of MySQL? 2) On the MySQL website, what is the difference between the following (releases?)

FW: MySQL for our production reporting data warehouse

> -Original Message- > From: Sonia Ghadially > Sent: Wednesday, June 04, 2003 12:59 PM > To: '[EMAIL PROTECTED]' > Subject: MySQL for our production reporting data warehouse > > Dear Sir/Madam: > > My company is thinking of using MySQL for our production reporting data

Mysqlhotcopy usage problem

Hello All, I am facing following error while I am trying to use mysqlhotcopy utility for hot backups. I am not sure that how can I check the perl correct installation. Please see below [EMAIL PROTECTED]:/usr/local/mysql/bin > mysqlhotcopy --help Can't locate DBI.pm in @INC (@INC contains: /opt/pe

Re: NEWBIE QUESTION: Copying Databases from local to server

I'd suggest using phpMyAdmin on the remote server for your setup. Depending on the application, it might make further transfers easier in the future. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Creative Solutions New Media" <[EMAIL PROTECTED]> To:

mysql4 query cache pruning unnecessarily?

Hi- Can anyone tell me why mysql4 would prune queries from the cache if the Qcache_free_memory is still very big? I'm confused why we get so many Qcache_lowmem_prunes: | Qcache_queries_in_cache | 175011 | | Qcache_inserts | 343244 | | Qcache_hits | 4041221| |

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 infilemem0pool.c line 477

Richard, - Original Message - From: "Richard F. Rebel" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 8:38 PM Subject: Re: RH 8.0 InnoDB: Assertion failure in thread 122911 infilemem0pool.c line 477 > Hello Heikki, > > O

Re: URGENT: Problems compiling mysql 3 and 4 on IRIX indy 6.5 IP22 mips

Look at http://gcc.gnu.org/ml/gcc-bugs/2000-11/msg00293.html (I don't know anything about this, but that page seems very relevant.) -S > > From: Jason Buchanan <[EMAIL PROTECTED]> > Date: 2003/06/04 Wed AM 08:22:29 CDT > To: [EMAIL PROTECTED] > Subject: URGENT: Problems compiling mysql 3 and

Re: authentification intranet

I guess the problem is with your authentication. Mysql 4.1 uses a new auth schema. You might want to try use mysql; update user set password=old_password("your password") where user='your username'; J. - Original Message - From: antoine druon <[EMAIL PROTECTED]> Date: Wednesday, June 4

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in filemem0pool.c line 477

Hello Heikki, On Wed, 2003-06-04 at 13:26, Heikki Tuuri wrote: > the memory deallocation seems to happen usually in > > " > if (prebuilt->blob_heap != NULL) { > mem_heap_free(prebuilt->blob_heap); > prebuilt->blob_heap = NULL; > } > " > > select M

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in filemem0pool.c line 477

Richard, - Original Message - From: "Richard F. Rebel" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 7:50 PM Subject: Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in filemem0pool.c line 477 > Hello Heikki, > >

Re: efficient query or not?

Hi, ok thank you, If i do the following SELECT userid FROM location WHERE longitude BETWEEN -80 and -94 AND latitude BETWEEN 30 and 49 AND 3963 * acos(cos(radian(90-place.lat)) * cos(radians(90-mylat)) + sin(radians(90-place.lat)) * sin(radians(90-mylat)) * cos(radians(place.lon-mylon))) < 100

detailed FULLTEXT index and search help needed

Hello All. I have a table that is about 1.5GB with about 400 records. As you can tell, every record is about 4MB, all of which is text. I've created a fulltext index on the table, with > alter table table2002 add fulltext data (data); After this is done (takes about 20 minutes to do) I check out

FW: WWDC 2002 Tracks

FYI -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anjo Krank Sent: Monday, June 02, 2003 1:41 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: WWDC 2002 Tracks Hi everybody, I haven't seen a message yet, so: Apple has made the video tracks from last

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in file mem0pool.c line 477

Hello Heikki, Sorry, last version of the MySQL-Max rpm was missing the symbols file. This version has it, so I did as you asked. Here is the output of the most recent 4. Regarding mem usage, the machine has 1gb, mysql is using 374MB which is fine as far as I am concerned. I can decrease the nu

Re: malloc'ing 2GB+ of memory in mysql

> best to test first with a borrowed Opteron. I want to see the stability and > that fsync() and other kernel calls work fast. A customer tested recently a > big Itanium II box and its performance looked ok. Tom's Hardware did some benchmarking of MySQL 3.23.52 with the Opteron: http://www.tomsha

RE: table copying/replication

Hi Ross, On Wed, 2003-06-04 at 16:35, Ross Simpson wrote: > This sounds like the best idea yet :) > > I have a couple of questions: > > - I need to keep the data in x_shadow while still creating table x.. > will copying accomplish the same thing? I'm guessing it will be slower, > but keeping t

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in file mem0pool.c line 477

Richard, please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it. Also note that you should make sort buffer and record buffer smaller, s

another replication question..

I have another question that doesn't seem to be addressed in the mysql manual. Does any sort of locking occur while a slave is updating it's local databases? Can I still read any/all tables while this process is occurring? If there is locking, is the lock table-based or for the entire db? My sl

  1   2   >