Re: Question about MySQL 4.0.20 and make test failure on Linux

Jeff Smelser wrote: On Friday 18 June 2004 11:48 pm, Tom Williams wrote: Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to). The compile runs smoothly, but make test fails. Here is my configure command: Whoa.. 2.

Re: Question about MySQL 4.0.20 and make test failure on Linux

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:48 pm, Tom Williams wrote: > Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux > system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to). > The compile runs smoothly, but make test fails. Here i

Question about MySQL 4.0.20 and make test failure on Linux

Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to). The compile runs smoothly, but make test fails. Here is my configure command: $ ./configure --prefix=/usr/local/mysql-4.0.20 --enable-assembler --enable-

Re: DBD::mysql problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 03:00 pm, Kairam, Raj wrote: > After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from > CPAN ), in the DBD-mysql-2.9003 directory I tried the following > mkdir /tmp/mysql-static > cp /usr/lib/mysql/*.a /tmp/my

Re: Too Many Connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 12:52 pm, Michael McTernan wrote: > Dear Mark, > > The best way to fix this is by correctly setting your from address in your > mailer to [EMAIL PROTECTED] Your email software seems to be wrong. All these people can't be doing

RE: Clustered Index - Where is data inserted ? Not Answered

Appreciate any help at all Thanks, Paul -Original Message- From: Paul Chu [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: Clustered Index - Where is data inserted ? Hi, Can someone explain how the data is stored in a table using a cluste

RE: Full Text Index on Large Tables - Not Answered

Appreciate any help at all Thanks, Paul -Original Message- From: Paul Chu [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: Full Text Index on Large Tables Hi, If I have a table with 100 - 200 million rows and I want to search For record

RE: Fastest way to load a master table removing duplicates - Not Answered

Appreciate any help at all Thanks, Paul -Original Message- From: Paul Chu [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: Fastest way to load a master table removing duplicates Hi all, I want to load a Master table millions of rows f

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

on 06/18/2004 05:16 PM, Kevin Brock at [EMAIL PROTECTED] wrote: > We have a table with a primary index which is INT NOT NULL > AUTO_INCREMENT. > > After inserting ~87,000,000 entries, we started seeing error 1062, > ER_DUP_ENTRY. > > We can get going again after doing an ALTER TABLE to reset the

AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

We have a table with a primary index which is INT NOT NULL AUTO_INCREMENT. After inserting ~87,000,000 entries, we started seeing error 1062, ER_DUP_ENTRY. We can get going again after doing an ALTER TABLE to reset the auto_increment starting point, but this takes about an hour... I've seen a

REPOST: DBD::mysql::db do failed: Table 'abcd' is read only

Sorry about the characters in the last post. Spambots didn't like it I hope someone can help me with a problem. I recently changed one of my web servers over to a new box and this server has an internal MySQL server which is used to store several web queried databases. My old server ran Apache

DBD::mysql::db do failed: Table 'xxxxx' is read only

I hope someone can help me with a problem. I recently changed one of my web servers over to a new box and this server has an internal MySQL server which is used to store several web queried databases. My old server ran Apache 1.3.27 and my new one is running 2.0.49 - Old MySQL was 3.2.23 and the

RE: EXISTS/NOT EXISTS

Thanks, I just found that relevant section in the manual, too. I wish it was clearer what version the manual documents -- I am using (almost) the latest stable release, and I should expect that the manual documents that. -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED]

DBD::mysql::db do failed: Table 'xxxxx' is read only

I hope someone can help me with a problem. I recently changed one of my web servers over to a new box and this server has an internal MySQL server which is used to store several web queried databases. My old server ran Apache 1.3.27 and my new one is running 2.0.49 - Old MySQL was 3.2.23 and the

Re: EXISTS/NOT EXISTS

Subqeries require mysql 4.1. The manual offers some suggestions on rewriting subqueries as JOINs . In your case, you want something like: SELECT product FROM products p LEFT JOIN products_by_product_areas a ON p.product = a.product

Re: EXISTS/NOT EXISTS

You are using a subquery. Subqueries are only supported in version 4.1 and later. You will eithe rneed to rewrite your query so that it doesn't use a subquery, or upgrade. Cheers Andrew. - Original Message - From: "Anton Ivanov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday,

Re: MySQL Installation Problem

First, you'll get more help if you post to the list (Mysql General mailing list <[EMAIL PROTECTED]>) All the --console does is directs error messages to the console, i.e., the dos window you have open. If you leave it off the error messages go to a file. What you describe below > without --console

EXISTS/NOT EXISTS

Hi, I'm trying to figure out how to apply these from the manual, but to no avail. Is it possible that my version (4.0.18) does not implement these? I have two tables: products and products_by_product_area. Both have a field "product". I try SELECT product from products WHERE NOT EXISTS (SELECT

Re: Recommendation on god MySQL books

I really like the Certification Study Guide we just ordered last week. Great info that I'd wish I had when I started. I have no plans to take the test, but I love the way the info is presented and the questions at the end help ensure I "got it." Lou - Original Message - From: "Bartis, Ro

Re: Fresh 4.1.2 install on Redhat 9

It looks like mysql does not own the data directory. [EMAIL PROTECTED] wrote: Hello List, I have done some googling around but can't find an answer to this one. Brand new box, installed with RedHat 9 and trying to run 4.1.2. This is what I get. --ja [EMAIL PROTECTED] mysql]# scripts/mysql_instal

Tuning mysql performance

Hello, I need some help tuning mysql. I'm running 3.23.58-Max-log on a Red Hat Linux Enterprise server with 1 gig of memory and 4 cpus. The database is used by a web application which runs on a separate machine. The performance is not so good. Can anybody tell me if my configurations are incorrect

DBD::mysql problem

I am unable to install DBD::mysql in my environment shown below RedHat Linux 9 perl v5.8.0 DBI-1.42 mysqld Ver 4.0.18-standard After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from CPAN ), in the DBD-mysql-2.9003 directory I tried the following mkdir /tmp/mysql-static cp /usr/

RE: GROUP BY across UNION

I agree with Mike. In order to use the aggregate functions across both tables' worth of data you will have to combine them into one large table. That can be a real table or a temporary one but in either case you are stuck combining them BEFORE the calculations or MySQL won't be able to crunch the

RE: GROUP BY across UNION

Hi Mike, This is a good suggestion. We ended up changing the requirements to not require the functionality I was trying to develop at the time. However, I did just change a temporary table I'm using for a similar process to HEAP and saw a very nice perfomance improvement. Should have thought a

RE: GROUP BY across UNION

Hi John, Depending on the size of your datasets, you could merge the data into a TEMPORARY table and then compute from there? If the temp table is small enough it will fit in RAM as a heap table, and will probably be more efficient than fetching all the results and computing them in code. Of cou

Re: load data into 2 tables and set id

welcome to a basic overview of bulk importing and normalizing as you go [ author's note: if you are seeing this thread for the first time and certain items seem to be introduced out of context, please review all previous posts in this thread. There has been a lot of informat

Best practice question

Hello All, I have a design question I have a table that represents a Newsletter page. This newsletter can be single or 2 columns Here is my question. Currently the table is defined as Int articleID Int pagenum Texttitle Textbody Texttitle2 Textbody2 So here is my ques

RE: Too Many Connections

Dear Mark, The best way to fix this is by correctly setting your from address in your mailer to [EMAIL PROTECTED] Thanks, Mike > -Original Message- > From: Michael McTernan > Sent: 08 April 2004 10:33 > To: [EMAIL PROTECTED] > Subject: Too Many Connections > > > What is the best way to

RE: Using PHP to copy tables

Dear Mark, You also seem to have used my email address before. Please correctly configure your mailer such that the from address is correctly reported as [EMAIL PROTECTED], and not mine. Thanks, Mike > -Original Message- > From: Michael McTernan > Sent: 08 April 2004 18:36 > To: [EMAIL

RE: Corruption and my.cnf

Dear Mark, I think your emailer has also experienced corruption since your from address is actually mine. Please set it to your own email address, such as [EMAIL PROTECTED] Thanks, Mike > -Original Message- > From: Michael McTernan > Sent: 09 April 2004 12:18 > To: [EMAIL PROTECTED] >

RE: Dumping mass inserts?

Dear Mark, > And when I go to move them to the new db, I do use the mysqldump command > since I am dumping to the new db? You need to correctly setup your mailer such that the from address is [EMAIL PROTECTED], and not my email address. Thanks, Mike > -Original Message- > From: Michae

RE: PHP + MySQL Not Playing Nice Any More

Dear Mark, Please set your from address to [EMAIL PROTECTED], and don't use my email address. Thanks, Mike > -Original Message- > From: Michael McTernan > Sent: 16 April 2004 10:21 > To: Joseph A. Nagy, Jr.; MySQL General > Subject: Re: PHP + MySQL Not Playing Nice Any More > > > On 4/1

Professional certification

I took the certification exam this morning and passed. When should I expect to receive the certificate (and other items) in the mail? --bmansell -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL4 and phpBB

Dear Mark, > Is anyone experiencing problems with MySQL 4.0.17-max (other > versions) and a > lot of I/O type errors on large databases or especially running phpBB? This can be fixed by sending emails from your own email address ([EMAIL PROTECTED]), and not mine. Thanks, Mike > -Original M

RE: Mysqld stalls

Dear Mark, You should be tweaking your mailer such that your mails originate fom [EMAIL PROTECTED], and not my own email address. Thanks, Mike > -Original Message- > From: Michael McTernan > Sent: 27 May 2004 10:00 > To: [EMAIL PROTECTED] > Subject: Mysqld stalls > > > I've been trying

RE: DROP TEMPORARY TABLE and implicit commits

Hi, I guess since it is documented, it is a new feature - I agree with the principal of not backporting it. Many thanks for the reply - can't wait for 4.1 to mature :-) Thanks, Mike > -Original Message- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > Sent: 15 June 2004 13:00 > To: Mys

Fresh 4.1.2 install on Redhat 9

Hello List, I have done some googling around but can't find an answer to this one. Brand new box, installed with RedHat 9 and trying to run 4.1.2. This is what I get. --ja [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user mysql --log Installing all prepared tables 040618 11:06:51 Wa

Re: Dying query ....

Ivan, - Original Message - From: ""Ivan Latysh"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, June 17, 2004 7:44 PM Subject: Dying query > Hello! > > I am running: > Server version 4.1.2-alpha-max-log > On linux RedHat. > > When I execute a simpl

Fastest way to load a master table removing duplicates

Hi all, I want to load a Master table millions of rows for other sources with a unique index on e.g. ssn social sec number. If inserted records have a duplicate SSN I don't want to insert those but put them in a duplicate table or flag them. . The primary key will be an auto-increment fiel

Full Text Index on Large Tables

Hi, If I have a table with 100 - 200 million rows and I want to search For records with specific characteristics. Ex. Skills varchar(300) Skill id's 10 15 Accounting finance etc. Is it advisable to created a field with skill ids and then use the

Clustered Index - Where is data inserted ?

Hi, Can someone explain how the data is stored in a table using a clustered index. Does this mean that the data is inserted in the .myd file in sorted index order ? If so, how is space made to insert the new records ? Does this make inserting records slow because data is being inserted in physi

Re: MySQL SQL Case Stetement

The CASE function is documented in the manual . SELECT CASE WHEN other_col < 100 THEN 'low' WHEN other_col BETWEEN 100 AND 1000 THEN 'medium' WHEN other_col > 1000 THEN 'high' END AS col FROM your_table; Michael Ra

Re: MySQL & Web Clustering...

The meaning of that was client-side being sending inserts/updates to the master server. This would be done in the program/script upon an insert query. A daemon could forward insert/update requests to a master and all others round-robin and simply pass packets. This is if you have to make it

RE: MySQL SQL Case Stetement

I have used the CASE statement for ordering many times. It's very useful... SELECT myDATA, CASE WHEN data2 = SomeValue THEN 0 ELSE WHEN data2 = SomeOtherValue THEN 1 ELSE 2 END AS mySort from MyTable Where myConstraints. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web techno

Re: Ask again about comparing cast string to date

Cao, Wenhong wrote: I am trying to select the records where the field activationtimestamp is within a certain range. Unfortunately the field activationtimestamp is defined as character(14) in the table. Perhaps you should change the type of activationtimestamp: ALTER TABLE SubscriptionVersion

Re: MySQL & Web Clustering...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Miller wrote: > Unless you have a specific need for it, you could save yourself a lot of > trouble by putting select tables or databases or even clients on each > server. This also means you don't incur the added

MySQL SQL Case Stetement

Hi list. Can someone give me a working example of a SQL CASE statement(in SELECT)? I have examples for stored procedures, but none for use within the DML side of SQL. I am trying to in my SELECT (used in PHP) create a variable/col for example: status='high' where value in a other col is withini

Re: MySQL & Web Clustering...

Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tel

Re: tricky timetable based query

Harald Fuchs wrote: "Sam Russo" <[EMAIL PROTECTED]> writes: I recieve a delimited file whose fields are: day,slot,subject,room An example of this file is: 2,1,Mat,R1 3,1,Sci,R6 1,2,Sci,R6 3,2,Mat,R3 1,3,Eng,R2 2,3,Eng,R5 1,4,Mat,R7 3,4,Eng,R9 I need a mysql query that will generate a timetable whi

ERROR 1045: Access denied for user: 'foo@host' (Using password: YES)

I'm using mysql-3.23.58-1.9 installed from RPM on Red Hat Linux release 9 (Shrike). First, I create a database and user to connect to this database using the following commands: mysql> CREATE DATABASE foo; mysql> GRANT ALL PRIVILEGES ON foo.* TO foo@'%' IDENTIFIED BY 'password' WITH GRAN

Re: MySQL & Web Clustering...

I currently run LVS (pre-distribution) on my farm, which gets about 100M hits/month. Good points about LVS are that it is completely rock solid, and runs on minimal hardware. I have never run MySQL behind it, as I think that would be a bit flaky for a live site. Probably worth checking out tho

RE: Replication - promoting slave to master

[EMAIL PROTECTED] wrote on 18/06/2004 15:09:58: > I would need log-bin and log-slave-updates enabled on the slave, correct? > > So to automate the process it would be better to start both servers > without the Master-host info in the conf file, letting Heartbeat issue the > commands on star

problems with 4.0.20 (icc)

Hi, yesterday I installed the 4.0.20 binaries, compiled with Intel C++ Compiler from mysql.com. I tried to transfer one of our (small) databases from the production-system (4.0.20 gcc binaries installed) to the test-system and came across the following problem: I did a "mysqldump --opt ... | my

Re: load data into 2 tables and set id

Shawn, Thanks for the email below - I will go through it over later tonight in more detail (going home time now!) although I can already see good points there. JS, I need one more piece of information to help make that query work for you, I need the structure of the table that you use (or would u

Re: load data into 2 tables and set id

JS, I need one more piece of information to help make that query work for you, I need the structure of the table that you use (or would use) to bulk import those logs into. If you are running out of room you may consider further normalizing you data (which saves space, but creates more data main

Re: tricky timetable based query

In article <[EMAIL PROTECTED]>, "Sam Russo" <[EMAIL PROTECTED]> writes: > I recieve a delimited file whose fields are: > day,slot,subject,room > An example of this file is: > 2,1,Mat,R1 > 3,1,Sci,R6 > 1,2,Sci,R6 > 3,2,Mat,R3 > 1,3,Eng,R2 > 2,3,Eng,R5 > 1,4,Mat,R7 > 3,4,Eng,R9 > I need a mysql que

Re: MySQL & Web Clustering...

Go for a simple MySQL master <-> slave configuration. I'm runing 1 master 3 slaves for performance issues and doesn't have any problem at all for 1 year.. Of course in this case you should change some code in your webservers to direct SELECT queries to slave machine to gain performance on the m

skip through records (dbf->mysql)

Hi all, i try to simulate dBase-like record-skips through a compound (dbf-) order. Anybody did that before? Please give me a hint. thx in advance, TomH -- PROSOFT EDV-Lösungen GmbH & Co. KG phone: +49 941 / 78 88 7 - 121 Ladehofstraße 28, D-93049 Regensburg cellphone: +49 174 / 41 94 97 0

RE: Replication - promoting slave to master

If the server has log-bin enabled it will log writes. If you have a daisy-chained master, one that serves as a master to other slaves, you will need to have log-slave-updates enabled. If this server is just another machine pulling from the master it is not necessary to log slave updates but it is n

RE: Replication - promoting slave to master

I would need log-bin and log-slave-updates enabled on the slave, correct? So to automate the process it would be better to start both servers without the Master-host info in the conf file, letting Heartbeat issue the commands on startup to convert one box to slave. During a fail-over, heartbe

Re: tricky timetable based query

What you are trying to do is an example of what is called "pivoting" a table or "creating a pivot table". SELECT slot , max(if(day=1, concat(subject,' ',room), '')) as day1 , max(if(day=2, concat(subject,' ',room), '')) as day2 , max(if(day=3, concat(subject,' ',room), '')) as d

MySQL & Web Clustering...

Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller ser

Re: load data into 2 tables and set id

Shawn, Thanks for helping on this. I really appreciate it. No problem!! Please post the structures of your "big_table" and your "url_table" (whatever you called them) and I will help you to rewrite step 4 to count how many times a URL appears in the "big_table". mysql> desc internet_usage; +--

Re: load data into 2 tables and set id

No problem!! Please post the structures of your "big_table" and your "url_table" (whatever you called them) and I will help you to rewrite step 4 to count how many times a URL appears in the "big_table". Is this bulk import a process you need to do repeatedly? if so we need to worry about updat

RE: strange query result

Your explain plan should not change based on the client you are using. The explain plan is the path for the query not the return of data to the client. Are you using sockets when connecting locally on the Free-BSD machine? Sockets are normally faster than using the tcp/ip port. -Original Messa

tricky timetable based query

I recieve a delimited file whose fields are: day,slot,subject,room An example of this file is: 2,1,Mat,R1 3,1,Sci,R6 1,2,Sci,R6 3,2,Mat,R3 1,3,Eng,R2 2,3,Eng,R5 1,4,Mat,R7 3,4,Eng,R9 I need a mysql query that will generate a timetable which looks like: Day1Day2Day3

RE: Group Query

You can use a Left Outer Join. Left Outer Join will include all that matches as well as that which doesn't. The resulting NULL entries for the count will evaluate to 0. SELECT COUNT(B.Booking_ID), U.User_Location FROM Users U LEFT OUTER JOIN Bookings B ON U.User_ID = B.User_ID GROUP BY(U.User_Lo

Re: Group Query

Hi, you can use: SELECT COUNT(B.Booking_ID), User_Location FROM Users U LEFT JOIN Bookings B ON U.User_ID = B.User_ID GROUP BY(U.User_Location); /Johan shaun thornburgh wrote: Hi, The following table produces a query that shows all bookings that user has made and groups the number of bookings by t

Group Query

Hi, The following table produces a query that shows all bookings that user has made and groups the number of bookings by the users location code. mysql> SELECT COUNT(B.Booking_ID), User_Location FROM Bookings B, Users U WHERE U.User_ID = B.User_ID GROUP BY(U.User_Location); At the momnet if no

RE: Losing some records

Losing some message body too :-? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 18 June 2004 13:11 > To: [EMAIL PROTECTED] > Subject: Losing some records > > > Disclaimer http://www.shoprite.co.za/disclaimer.html -- MySQL General Mailing List For list

Losing some records

strange query result

Hi, ppl! I have a MySQL-server on FreeBSD-5.2.1 computer and a client on another computer under windows xp. I have the following simple query SELECT internal_number,page_no FROM pages WHERE docs=307 ORDER BY page_no that results in 587 lines with two integers only. Simple query with low output

Re: ODBC error

You should check your privileges in mysql server. Look at the Host field in mysql.user table. Probably that is the problem and change the value to the Windows IP address. And don't forget to make " FLUSH PRIVILEGES".. Ref: http://dev.mysql.com/doc/mysql/en/User_Account_Management.html Best Regar

ODBC error

>From a Windows2000 machine, I use "ODBC Data Source Administrator" to connect to mysql server on RedHat ES 3. I got the following message. "[MySQL][ODBC 3.51 Driver] Host 'IP_address' is not allowed to connect to this MySQL server" Any idea? Thanks, Joseph -- MySQL General Mailing List For

Re: load data into 2 tables and set id

Mos forgot to populate the url_id column in your user table. I would use his same process but re-arrange it like this: 1) create table BIG_TABLE 2) load data infile 3) create table URL_TABLE ( url_id bigint not null auto_increment, url varchar(25) not null primary key, c