Re: Questions about building a dedicated MySQL server.

On 17-03-2014 16:21, Mister Vlad wrote: I am looking at building a dedicated MySQL server... was wondering about the downside to using SSD drives? My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1) configuration. Is this a good idea? I was originally thinking about going

Questions about building a dedicated MySQL server.

I am looking at building a dedicated MySQL server... was wondering about the downside to using SSD drives? My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1) configuration. Is this a good idea? I was originally thinking about going Raid5(3+1) and Raid 1 (Mirrored) but that

Error when building libmsyqlclient 5.5

Hello Everyone, We needed to install the mysql header files on the client machines (i.e., libmysqlclient) therefore, the entire server is not required. We are using MySQL 5.5 with the following cmake: cmake ../ -DWITHOUT_SERVER=1 -DCURSES_LIBRARY=/usr/lib/libncurses.a -DCMAKE_INSTALL_PREFIX=/usr

building mysql 5.5.8 with default charset

Hello, is it a bug or a feature that if building mysql 5.5.8 from source with the options 'cmake . -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci' the charset in include/config.h remains latin1: #define MYSQL_DEFAULT_CHARSET_NAME "latin1" #define MYSQL_DE

Re: Any faster building primary/unique indexes after Load Data Infile?

Then before loading alter table table_name disable keys; load data alter table table enable keys; This will enable faster data load and faster index rebuild. regards anandkl On Fri, Feb 26, 2010 at 8:03 AM, Baron Schwartz wrote: > Hi, > > On Sun, Feb 21, 2010 at 1:42 PM, mos wrote: > > I am

Re: Any faster building primary/unique indexes after Load Data Infile?

Hi, On Sun, Feb 21, 2010 at 1:42 PM, mos wrote: > I am loading 35 million rows of data into an empty MyISAM table. This table > has 1 primary key (AutoInc) and 1 unique index and 2 non-unique indexes. > > Is it going to be any faster if I remove the indexes from the table before > loading the dat

Re: Any faster building primary/unique indexes after Load Data Infile?

Generally, you should find that removing and re-adding the indexes will speed up your operation. I do not believe that ALTER TABLE with just index additions will require a table rebuild, but even if it does, doing a table copy will be a fairly fast operation (much faster than loading from othe

Any faster building primary/unique indexes after Load Data Infile?

I am loading 35 million rows of data into an empty MyISAM table. This table has 1 primary key (AutoInc) and 1 unique index and 2 non-unique indexes. Is it going to be any faster if I remove the indexes from the table before loading the data, load the data, then do an Alter Table .. add index ..

MySQL University session on October 8: Building MySQL Releases on Unix

Building MySQL Releases on Unix http://forge.mysql.com/wiki/Building_MySQL_Releases_on_Unix This Thursday (October 8th, 13:00 UTC), Jörg Brühe will give a talk on Building MySQL Releases on Unix. Jörg will describe the tools used by the MySQL Build Team for release builds on Unix-style platforms

Re: Building 5.1 on Tru64 5.1b

urs earlier, in the compile phase for the > individual module(s). Of course, but using the -pthread earlier causes the use of the -lpthread and others to be used at link time. > TTBOMK, MySQL AB never had their own Tru64 box, and definitely there is > none available now. When MySQL AB prev

Re: Building 5.1 on Tru64 5.1b

Hi Didier, all, just a follow-up on my own mail: Joerg Bruehe wrote: > Hi Didier, Walter, all! > > > Didier Godefroy wrote: >> [[...]] >> I already had looked at this and I do have all the right flags. I was able >> to build 5.1.33 and not 5.1.34, so something may have changed. > > Sure, 5.1.

Re: Building 5.1 on Tru64 5.1b

good programms should be tested on >> more. > > It's Tru64 that is being neglected too much these days, we are still many > users of it and it won't go away, but the support for it is lagging. And it > seems posting on the mysql list about tru64 doesn't trigger much i

Re: Building 5.1 on Tru64 5.1b

on 4/28/09 10:01 AM, walter harms at wha...@bfs.de uttered the following: >> cxx: Error: ../../sql/log.h, line 140: identifier "pthread_mutex_destroy" is >> undefined >> ~st_log_info() { pthread_mutex_destroy(&lock);} >> ---^ >> cxx: Error: ../../sql/log.h, line 401: id

Re: Building 5.1 on Tru64 5.1b

Didier Godefroy schrieb: > Hello all, > > I've been having troubles building mysql on Tru64 v5.1b. > I tried several versions and there are always some kind of issues with > undefined symbols and things to be changed in the source to allow the build > to continue. >

Building 5.1 on Tru64 5.1b

Hello all, I've been having troubles building mysql on Tru64 v5.1b. I tried several versions and there are always some kind of issues with undefined symbols and things to be changed in the source to allow the build to continue. Lately I've been trying to get 5.1.33 compiled, and

Building MySql for Windows with SSL

In the MySql manual section 5.5.7.2 it specifies how to build MySql on a Unix/Linux platform with SSL by using 'configure'. I need to build MySql for Windows with SSL support. In section 2.4.15.6.1 for building MySql for Windows itr specifies the available options for using win/confi

MySQL University session on September 4: Building MySQL Client Applications

Hi, this Thursday, Hartmut Holzgraefe will give a MySQL University session: http://forge.mysql.com/wiki/Building_MySQL_Client_Applications (topic: Building MySQL Client Applications) Please register for this session by filling in your name on the session Wiki page. Registering is not required

Building 5.0 under Windows - new set of detailed instructions published

Hi - I've written a page on how to build MySQL 5.0 under Windows. http://www.45mercystreet.com/computing/mysql/index.html It covers every step in detail - you should be able to build fully by following the instructions. I was originally using the MySQL 5.0 manual page of instructions; http:/

Re: Building MySql 5.0.45 on Solaris 6

In the last episode (Aug 02), Giulio Troccoli said: > Anyway, as I said I managed to build it and it seems to work. We're > having some issues on upgrading to Solaris 8, that's why we still > have Solaris 6. I hope the pre-build package for Solaris 8 will work > without any intervention. But if it

RE: Building MySql 5.0.45 on Solaris 6

> Sent: 02 August 2007 12:06 > To: Giulio Troccoli > Cc: mysql@lists.mysql.com > Subject: Re: Building MySql 5.0.45 on Solaris 6 > > Hi Giulio ! > > > Giulio Troccoli wrote: > > Since my original post has been hijacked I'm writing a new one with > > maybe s

Re: Building MySql 5.0.45 on Solaris 6

il. Finally I took the -DHAVE_TERMIOS_H but left the -I/usr/include. Again, it failed. So now I'm stuck. I don't know what to do. I just need a new version of MySql client (I'm currently on 3.22.32) because the new server (5.0.27) uses privileges that my client does not support.

Building MySql 5.0.45 on Solaris 6

Since my original post has been hijacked I'm writing a new one with maybe some more info. I have downloaded the GNU TAR source code. I'm using gcc 3.0.2 and GNU make 3.76.1 I have configure as follows CC=gcc CFLAGS="-O3" \ CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \ .

Re: building comma-separated list of strings from subquery

You probably want to look at the group_concat function. It doesn't work as a subselect, but it allows you to group a set of records and "rollup" the different values in the grouping. Christian Hansel wrote: I'ld like to accomplish something like: set @myvar=concat_ws(",",(SELECT column from t

RE: building comma-separated list of strings from subquery

>I'ld like to accomplish something like: > >set @myvar=concat_ws(",",(SELECT column from table1 order by column; >where ...)) > >or > >select concat_ws(",",(SELECT column from table1 order by column where ...)); > >for further usage in sql-scripts I forgot to mention: As I need it in a function, i

building comma-separated list of strings from subquery

Hi y'all, I'ld like to accomplish something like: set @myvar=concat_ws(",",(SELECT column from table1 order by column; where ...)) or select concat_ws(",",(SELECT column from table1 order by column where ...)); for further usage in sql-scripts -- MySQL General Mailing List For list archive

Re: Building RPMs with ICC

Having just tried building MySQL 6.0 SRPM on CentOS/RHEL 5, it would appear that it doesn't even build cleanly with the default settings with GCC! Has anyone got any information as to why this might be? It seems to build OK, but then all the tests (mysql-test-run) seem to fail. Is this know

Building RPMs with ICC

4 in there, and this is not a valid value for ICC v9.1 (thus causing it to abort). Instead it now just issues a warning and says that it is overriding pentium4 with -msse3, but proceeds with building. Then I tried: rpmbuild --define "__cc icc" --rebuild MySQL-6.0.0-0.glibc23.src.rpm

Re: Building MySQL Under low memory conditions (CFLAGS not working?)

Hi Weston, all! Weston C wrote: Joerg Bruehe <[EMAIL PROTECTED]> wrote: Also, "virtual memory" is not just RAM, it also includes your paging space (aka "swap device"): check its size and usage. This is a really good point. Are there some other parameters (either compiler or environment) I sho

Re: Building MySQL Under low memory conditions (CFLAGS not working?)

Joerg Bruehe <[EMAIL PROTECTED]> wrote: Also, "virtual memory" is not just RAM, it also includes your paging space (aka "swap device"): check its size and usage. This is a really good point. Are there some other parameters (either compiler or environment) I should be trying to tweak in addition

Re: Building MySQL Under low memory conditions (CFLAGS not working?)

Hi Weston, all, Weston C wrote: Hi, I'm trying to build MySQL 4.1.22 on a VPS where it looks like our available memory could be as low as 32MB, and compilation is erroring out partway through with a "virtual memory exhausted: cannot allocate memory" message. 32 MB isn't much, nowadays - cons

Building MySQL Under low memory conditions (CFLAGS not working?)

Hi, I'm trying to build MySQL 4.1.22 on a VPS where it looks like our available memory could be as low as 32MB, and compilation is erroring out partway through with a "virtual memory exhausted: cannot allocate memory" message. I tried invoking configure with the "--with-low-memory" flag, and th

Building MySql and Qt from source.

I'm trying out the MySql database connection example from "C++ Gui programming with Qt". I'm using the binary build of Qt open-source edition from the books cd, and a binary build of MySql 5.0.27 downloaded from the official MySql website. The Qt libraries includes a MySql driver, which howe

Re: building mysql-5.0.22 from src

have thought that building by source would have been ok... .. so you'll have to install the -devel rpm with the new mysql headers (I think that's the one) and then compile the other apps, or use the .src.rpms for those apps and create your own versions. It's pretty much an

RE: building mysql-5.0.22 from src

building by source would have been ok... -bruce -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, August 03, 2006 5:38 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: building mysql-5.0.22 from src bruce wrote: > hi... > > i have FC3/

Re: building mysql-5.0.22 from src

bruce wrote: hi... i have FC3/4 systems. i'm going to need to have mysql-5.0.22, but there appears to be numerous dependencies that yum can't easily resolve from the RPM i've found. can i reasonably easily build mysql-5.0.22 from src for my FC3/4 systems... the systems are pretty much standard

building mysql-5.0.22 from src

hi... i have FC3/4 systems. i'm going to need to have mysql-5.0.22, but there appears to be numerous dependencies that yum can't easily resolve from the RPM i've found. can i reasonably easily build mysql-5.0.22 from src for my FC3/4 systems... the systems are pretty much standard systems. thank

building index table, duplicate .MYD

Hi, I wonder if anyone could explain the rational behind the following: (MySQL-5.0.22) We have a MyISam table with ~100Gb size. We start creating an index. The procedure starts making temporary files: -rw-rw 1 mysql mysql11430 Jun 7 10:27 #sql-79d6_cc.frm -rw-rw 1 mysql mysql

Building Client Program

Hi all, I am building client program on MySQL 4.0.16 with C API. But I always get error like: make all-recursive gcc -I. -I/usr/home/vpopmail/include -I/usr/local/include/mysql -g -O2 -c user.c user.c: In function `delalert': user.c:357: syntax error before `*' user.c:

Re: frustration building

Peter Matulis wrote: --- [EMAIL PROTECTED] wrote: Peter Matulis <[EMAIL PROTECTED]> wrote on 11/15/2005 02:47:56 PM: but in phpmyadmin I get these types of warning for five tables: table 1: UNIQUE and INDEX keys should not both be set for column `email` table 2: More than one INDEX key wa

Re: frustration building

--- [EMAIL PROTECTED] wrote: > Peter Matulis <[EMAIL PROTECTED]> wrote on 11/15/2005 02:47:56 > PM: > > but in phpmyadmin I get these types of warning for five > tables: > > > > table 1: > > UNIQUE and INDEX keys should not both be set for column `email` > > > > table 2: > > More than one INDE

Re: frustration building

Peter Matulis <[EMAIL PROTECTED]> wrote on 11/15/2005 02:47:56 PM: > I am still trying to create a schema. I do not get errors when I do > so but in phpmyadmin I get these types of warning for five tables: > > table 1: > UNIQUE and INDEX keys should not both be set for column `email` > > table

frustration building

I am still trying to create a schema. I do not get errors when I do so but in phpmyadmin I get these types of warning for five tables: table 1: UNIQUE and INDEX keys should not both be set for column `email` table 2: More than one INDEX key was created for column `mail_id` More than one INDEX ke

Re: Problem building 4.1.12 on HP-UX 10.20

On Mon, Jun 06, 2005 at 04:19:16PM -0500, Dan Nelson wrote: > In the last episode (Jun 06), Albert Chin said: > > I'm trying to build mysql-4.1.12 on HP-UX 10.20 with gcc-3.4.3. HP-UX > > 10.20 has CMA threads. > > > > I have the following build failure: > > gmake[4]: Entering directory `/opt/bu

Re: Problem building 4.1.12 on HP-UX 10.20

In the last episode (Jun 06), Albert Chin said: > I'm trying to build mysql-4.1.12 on HP-UX 10.20 with gcc-3.4.3. HP-UX > 10.20 has CMA threads. > > I have the following build failure: > gmake[4]: Entering directory `/opt/build/mysql-4.1.12/innobase/srv' > gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./

Problem building 4.1.12 on HP-UX 10.20

I'm trying to build mysql-4.1.12 on HP-UX 10.20 with gcc-3.4.3. HP-UX 10.20 has CMA threads. I have the following build failure: gmake[4]: Entering directory `/opt/build/mysql-4.1.12/innobase/srv' gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I./../../include -I../../include -I/opt/TWWfs

Re: [PHP] building php, using mysql for apache2

--with-mysql is supposed to be the directory in which configure can find the mysql header (.h) files and the mysql library (mysql.so) underneath that directory. /usr/bin/mysql_config is a program -- a "binary" if you will It's incredibly unlikely that your MySQL header files and the mysql.so libr

Re: building php, using mysql for apache2

hi, have you installed php4-mysql ? look at http://www.coagul.org/article.php3?id_article=169 for example. Mathias Selon bruce <[EMAIL PROTECTED]>: > hi... > > trying to build php4 with mysql4.1-12, for use in apache2. i have the > following "./compile" that works for php5. however, when i try

building php, using mysql for apache2

hi... trying to build php4 with mysql4.1-12, for use in apache2. i have the following "./compile" that works for php5. however, when i try to use it for php4, i get a msg, stating that it can't find the MySQL Headers... can anybody provide any pointers as far as what the Headers are for mysql, an

Re: Why building obsolete versions.

On Fri, May 20, 2005 at 10:50:29AM -0700, Fredrick Bartlett wrote: > The documentation indicates that there are three active versions being > worked on. Is this true? Why not just release the current one with the most > bug fixes? > > D.1.1. Changes in release 5.0.7 (not released yet) > D.1.2. Cha

Why building obsolete versions.

The documentation indicates that there are three active versions being worked on. Is this true? Why not just release the current one with the most bug fixes? D.1.1. Changes in release 5.0.7 (not released yet) D.1.2. Changes in release 5.0.6 (not released yet) D.1.3. Changes in release 5.0.5 (to be

Re: Building C string for Insert!!

ration - Spruce Pine <[EMAIL PROTECTED]> wrote on 12/13/2004 04:36:07 AM: > > Hi, > > I am building the insert string for inserting into particular table t1 > using C program. The below string is stored in a variable. > > > say sqlstmt = 'INSERT INTo T1 value

Re: Building C string for Insert!!

Hello. I don't know if it is exactly what you want, but look at this: http://dev.mysql.com/doc/mysql/en/SQLPS.html http://dev.mysql.com/doc/mysql/en/C_API_Prepared_statements.html >I am building the insert string for inserting into particular table t1 >using C program

Building C string for Insert!!

Hi, I am building the insert string for inserting into particular table t1 using C program. The below string is stored in a variable. say sqlstmt = 'INSERT INTo T1 values(:id,:ename);' The values for the field's id, name will come from the front end. The sql string will be exe

Building C string for Insert!!

I am building the insert string for inserting into particular table t1 using C program. The below string is stored in a variable. say sqlstmt = 'INSERT INTo T1 values(:id,:ename);' The values for the field's id, name will come from the front end. The sql string will be executed

Re: Building new db linux box, Hardware questions

> 1) would it be better to go brandnew with a single processor or like a quad > p4 that's a year or two old. Depends on how your application runs. BTW, I don't think they made quad p4's. You can't run p4 chips in SMP -- they must be Xeon's. > > 2) I am going to running raid 5, so I assume that I

Building new db linux box, Hardware questions

Hello, I am building a new linux box , just to be an mysql server I have a couple of questions. 1) would it be better to go brandnew with a single processor or like a quad p4 that's a year or two old. 2) I am going to running raid 5, so I assume that I should run scsi drives? 3) my dat

Query Building Help

I have 2 tables, category and ticket (relevant description follows): mysql> describe ticket; +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +-+--

Re: Optimize index building

Haitao Jiang <[EMAIL PROTECTED]> wrote: > We are using following steps to re-load and re-build a table every day: > > truncate the table > disable index > load data > enable index > > What are the important parameters I should be watching out to make the > "ebale index" step faster? Out table is

Optimize index building

Hi, We are using following steps to re-load and re-build a table every day: truncate the table disable index load data enable index What are the important parameters I should be watching out to make the "ebale index" step faster? Out table is over 10million rows and has two fulltext indexes. T

trouble building mysql 4.1.3

I am getting an error from make test when trying to build MySQL 4.1.3 beta The error is as follows: ERROR: .../mysql-4.1.3-beta/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting make: *** [test] Error 1 I read online about using the --with-extra-charset=complex with configur

Re: Sum/Join Query Building

WHERE GROUP BY Username, First_Name, Last_Name If I don't do any joining.. and sum up session time by itself i get the correct # of hours. With this joining I get roughly a factor of 10x the correct amount.. Why is this the case? Can anyone help me fix it? I couldn't find any advance

Re: Sum/Join Query Building

fo ON (VPN.Username = userinfo.Username) > LEFT JOIN Dialup ON (userinfo.ID = dialup.User_ID) > WHERE > GROUP BY Username, First_Name, Last_Name > > > If I don't do any joining.. and sum up session time by itself i get > the correct # of hours. > With this joining I

Re: Sum/Join Query Building

the case? Can anyone help me fix it? I couldn't find any advanced sql query building topics on this through google, so I'm trying my luck here. thanks Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Sum/Join Query Building

HERE GROUP BY Username, First_Name, Last_Name If I don't do any joining.. and sum up session time by itself i get the correct # of hours. With this joining I get roughly a factor of 10x the correct amount.. Why is this the case? Can anyone help me fix it? I couldn't find any advanced

RE: building mysql-5.0 clarification

rom: bruce [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 10:35 AM To: [EMAIL PROTECTED] Subject: building mysql-5.0 hi... i'm building mysql-5.0 from src for rh8.0. my question has to do with how/where i find the libmysqlclient.so.10 lib. when i've built the mysql-5.0 i haven&#

building mysql-5.0

hi... i'm building mysql-5.0 from src for rh8.0. my question has to do with how/where i find the libmysqlclient.so.10 lib. when i've built the mysql-5.0 i haven't found this file. it appears that this file has been included in the mysql-shared-compat* file, but i can't find

RE: [PHP] building php5.0 as an apache module, with mysqli functionality

ds the required rpms) i then install the rpms rpm -ivh MySQL-server-4.1.3-0.i386.rpm rpm -ivh MySQL-devel-4.1.3-0.i386.rpm rpm -ivh MySQL-shared-4.1.3-0.i386.rpm (if you're building php on a client system with mysql/mysqli on another box, you can leave off the server rpm) at this point, yo

RE: [PHP] building php5.0 as an apache module, with mysqli functionality

-wi th-ldap --with-pgsql thanks... -bruce -Original Message- From: Curt Zirzow [mailto:[EMAIL PROTECTED] Sent: Sunday, July 18, 2004 7:23 PM To: bruce Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] building php5.0 as an apache module, w

Re: [PHP] building php5.0 as an apache module, with mysqli functionality

Curt Zirzow wrote: i'm trying to use the following "configure" ./configure --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc --with -mysql=/usr/include/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config - -with-ldap --with-pgsql If you read the installation at http://php.net/mysqli, you

building mysql from 4.1.3 source

hi... is there any way of building the separate mysql rpms from the mysql 4.1.3 src rpm. i know you can do a rpmbuild --rebuild foo.src.rpm. but this gives you all the underlying rpms. i'm curious as to whether or not i could more or less pull/build a given package, and if so, how??? bas

building php5.0 as an apache module, with mysqli functionality

m both rpm/src) -php-5.0 (building from source) -MySQL-4.1.3 (beta) tried with src/rpms.. -MySQL-Server -MySQL-devel -MySQL-shared my dir structure is pretty much the default i'm trying to build php using the following process ./configure .make clean make make install i'm trying t

Re: Index Building on Large Tables Stalling

Nope. As far as I'm aware the only disk space being used is in the database's directory, and that file system has 200Gb spare. (/tmp has 19Gb free anyway) Regards, Tim. gerald_clark wrote: Are you running out of temp space? Tim Brody wrote: binary MySQL 4.0.20-standard on Redhat 7.2/Linux Dual-pr

Re: Index Building on Large Tables Stalling

Are you running out of temp space? Tim Brody wrote: binary MySQL 4.0.20-standard on Redhat 7.2/Linux Dual-proc, 4Gb ram, raid I'm trying to change an index on a 12Gb table (270 million rows). Within an hour or so the entire table is copied, and the index reaches 3.7Gb of data. Then the database app

Index Building on Large Tables Stalling

binary MySQL 4.0.20-standard on Redhat 7.2/Linux Dual-proc, 4Gb ram, raid I'm trying to change an index on a 12Gb table (270 million rows). Within an hour or so the entire table is copied, and the index reaches 3.7Gb of data. Then the database appears to do nothing more, except for touching the In

Re: building 4.0.20 on Solaris2.7-x86 - make errors after configure

Not sure if this will help, but we recently ran into a problem building MySQL on a Solaris 9 system - the build failed at the point of trying to make "readline" because of a missing file Makefile.in. It turned out that automake wasn't available, and automake is required to do the

building 4.0.20 on Solaris2.7-x86 - make errors after configure

--with-innodb THEN run make >Fix: >Submitter-Id: Bill Lane >Originator:same >Organization: GloryWorks >MySQL support: none...first time admin >Synopsis: make aborts with readline building mysql-4.0.20 >Severity: serious >Priority: high >

Re: Problems building readline on Solaris 7

, 2004 8:44 AM Subject: Problems building readline on Solaris 7 > Hi- > I have not been able to build readline on Solaris 7. No matter > what I change in the configuration, it still gives me the same error. > Any ideas would be greatly appreciated. > Thank you all in ad

Problems building readline on Solaris 7

Hi- I have not been able to build readline on Solaris 7. No matter what I change in the configuration, it still gives me the same error. Any ideas would be greatly appreciated. Thank you all in advance for the help. Regards, Erek System Configuration: gcc: 3.3

Re: building mysql 4 on RH8

Hi! Marius Stan wrote: Hello all, While trying to build MySQL-4.0.18-0.src.rpm downloaded from mysql.com on a RedHat 8 I get these: /usr/lib/gcc-lib/i386-redhat-linux/3.2/../../../libncurses.a(lib_termcap.o): In function `skip_zero': 8< Are you sure you _do_ have ncurses devel pack

building mysql 4 on RH8

Hello all, While trying to build MySQL-4.0.18-0.src.rpm downloaded from mysql.com on a RedHat 8 I get these: /usr/lib/gcc-lib/i386-redhat-linux/3.2/../../../libncurses.a(lib_termcap.o): In function `skip_zero': lib_termcap.o(.text+0xcc): undefined reference to `__ctype_b' /usr/lib/gcc-lib/i386-

Re: Building super-smack on freebsd 4.9

On Wed, Mar 24, 2004 at 06:29:40PM -0700, Sasha Pachev wrote: > [EMAIL PROTECTED] wrote: > > Hmm.. Looks like Jeremy did not quite fix everything on FreeBSD in version 1.2. > For a hack, change ERESTART to EINTR in client.cc for now until we've figured it > out. 1.3 builds cleanly on FreeBSD.

Re: Building super-smack on freebsd 4.9

whether time.h and sys/time.h may both be included... yes >> checking return type of signal handlers... void >> checking for gettimeofday... yes >> checking for strerror... yes >> updating cache ./config.cache >> creating ./config.status >> creating Makefile >>

Re: Building super-smack on freebsd 4.9

error... yes updating cache ./config.cache creating ./config.status creating Makefile creating src/Makefile creating config.h Building with the following options: MySQL Support. yes PostgreSQL Support no Oracle Support no If this is not wha

Building super-smack on freebsd 4.9

cache ./config.cache creating ./config.status creating Makefile creating src/Makefile creating config.h Building with the following options: MySQL Support. yes PostgreSQL Support no Oracle Support no If this is not what you intended, please r

Building MySQL with Visual Studio .NET 2003

Hi everyone. Has anyone tried building MySQL with Visual Studio .NET 2003? I find two problems: 1) The files /strings/Strings.asm and /strings/Strxmov.asm do not compile due to a command-line parameter in the custom-build call to ml.exe. It seems the upgrade from the .dsp file shipped with the

Re: Losing indexes after building from dump.

Toby wrote: I finally figured out that we had been running large databases without indexes working at all. It turns out that if I use mysqldump to dump out a database, then drop/create the database and build from the dump, none of the indexes work. Things slow to a crawl. I found inadvertantly th

Losing indexes after building from dump.

I finally figured out that we had been running large databases without indexes working at all. It turns out that if I use mysqldump to dump out a database, then drop/create the database and build from the dump, none of the indexes work. Things slow to a crawl. I found inadvertantly that by issuin

looking for a MySQL DBA, San Francisco, building large system from scratch

We have a job opening at MyPoints.com in San Francisco for a MySQL database administrator/database developer. We are building a new system from scratch with distributed and replicated MySQL databases, Apache, Java, Linux. Actual duties will depend on the particular skills and interests of the

Building mysql apps with CodeWarrior on Mac OS X

I'm tring to use CodeWarrior 9 to build a Mach-O target application on Mac OS X that uses the embedded mysql server library (libmysqld.a). I'm using the library that comes from standard Mac OS X binary distribution (the .dmg package). I can add libmysqld.a to the CodeWarrior project but whenlin

building link error

Dear sirs, I have mysql 4.01 installed on my pc (not source,only binary)on win98 (I tried in win XP too).I downloaded myodbc source (3.51)and tryed compiled release with nmake (using makefile included in source)but aving a link error "unresolved esternal _aulldvrm in mysqlclient" (same message

Building from the develepment tree (windows)

I'm trying to build mysql from the development sources of mysql 4.1., retreived using bitkeeper under win2k using cygwin. I have made "bk -r edit", and now I'm having a problem running aclocal: aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library When I make "automake --version" a

Building DBD-mysql on HPUX 11.11

Hi, I am trying to build DBD-mysql-2.1012 perl and mysql database driver on HPUX 11.11 operating system. I am getting this error, if I say 'make'. Can you help me to resolve this. Mysql 3.23.42 and DBI 1.37 are installed on the machine. ipvbs:/tmp/DBD-mysql-2.1012>make /bin/sh -c true

Building keys that simulate a key spanning multiple tables

I've distilled my problem down to this: I am trying to figure out how to build some indices on a couple of different tables so as to speed up a search that involves searching on multiple columns from each of the tables. Let's pretend I have two tables as follows and that I need to do a query that

Building DBD::mysql

Hi, This caused me a little grief, so I thought that I would post it. I wanted to be able to use the perl module DBD::mysql, to access a mysql database. I installed 'MYSQL 3.23.56' and 'perl 5.004'. I installed the DBI module. I compiled the DBD:mysql module. When I ran 'make test', I got the fo

Programmatically building table

Hello All: I'm working on an application that has to drop and then recreate tables programmatically and does not have 'file' privileges. i.e., I can't use 'load data infile'. On a smaller venue, I programmatically create a .sql script file that drops, then re-creates the table, and then writes

Building a Data Warehouse

in process of building a data warehouse with MySQL. The primary database holds todays data. The warehouse holds a years worth of data. In order to pipe the data from the primary to the warehouse, was considering using an audit program that would port changes to specific primary tables to the

building MySQL on Alpha-Dec-OSF4 with gcc

Hi! >>>>> "Ralf" == Ralf Hupfer <[EMAIL PROTECTED]> writes: Ralf> Hi, Ralf> I do face problems building MySQL 3.22.32 with gcc 3.2.2 on an Alpha- Ralf> DEC-OSF4 workstation. MySQL 3.22 ? Ralf> CC="cc -pthread" CXX="cxx -pthread -

Re: building MySQL on Alpha-Dec-OSF4 with gcc

On 24 Mar 2003 at 10:37, Dan Nelson wrote: > In the last episode (Mar 24), Ralf Hupfer said: > > I do face problems building MySQL 3.22.32 with gcc 3.2.2 on an Alpha- > > DEC-OSF4 workstation. > > > > CC="cc -pthread" CXX="cxx -pthread -O" ./conf

Re: building MySQL on Alpha-Dec-OSF4 with gcc

In the last episode (Mar 24), Ralf Hupfer said: > I do face problems building MySQL 3.22.32 with gcc 3.2.2 on an Alpha- > DEC-OSF4 workstation. > > CC="cc -pthread" CXX="cxx -pthread -O" ./configure > --with-named-thread-libs="-lpthread -lmach -lexc -lc&

Re: building MySQL on Alpha-Dec-OSF4 with gcc

P.S.: Sorry for the strange layout, but somehow all the underlines (i.e. in "__cxa_pure_virtual") got removed. Ralf -- Ralf Hupfer Fraunhofer Institut für Verkehrs- und Infrastruktursysteme Dresden WWW : www.ivi.fhg.de www.intermobil.o

  1   2   3   >