Sorry, my mistake. It's "reindexing" then.
Once i should add 2 key indexes on a huge table.
But instead of alter the table in 1 single query,
I build each index 1 by 1.
And the responses of the slaves also great, too.
Anyway, im using the standard my-medium.cnf setup.
The huge table/db also located
"HA. Mooduto" <[EMAIL PROTECTED]> wrote:
> dear all,
> what is the problem sql error : 1036 ...table is read only.
> please help me..
This table is compressed with myisampack or MySQL server doesn't have permissions on
the table files.
--
For technical support contracts, goto https://order.mys
*This message was transferred with a trial version of CommuniGate(tm) Pro*
i got an error when i try to connect mysql server with
mysqlcc :
error 1130 : "Host xxx.xxx.xxx.xxx not allowed to connect this server" .
does anyone know any solution ?
thanX.
--
MySQL General Mailing List
For list a
Database Systems: Design, Implementation, and Management, Fifth Edition
by Peter Rob, Carlos Coronel.
In 1997 I bought & used the 3rd edition of this book. And from an
educational, theoretical and practical analysis, design, implementation
perspective it is very comprehensive.
See info / reviews
You need a LEFT JOIN. Check the manual for more info and let us know if you
have any more questions.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: "motorpsychkill" <[
fatih olcer wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
i got an error when i try to connect mysql server with
mysqlcc :
error 1130 : "Host xxx.xxx.xxx.xxx not allowed to connect this server" .
does anyone know any solution ?
thanX.
Have you looked at the
Is it possible to manually delete the logfiles created in innodb tables
and then do a 'touch logfilename' to recreate it?
If this is not the proper way, can somebody help me on this; there's no
specific explanations in the mysql manual..
Thanks.
BRgds,
--
Richard Bornay
Test Product Engineeri
hi
i searched the mysql doc for support of recursive sql statements, but found nothing. i
am right that mysql does not support such kind of statements?
best regards
benny
Perfomance matters the most. So, what would be the ideal setup for
permomance in
Mysql?
Machine specs:
PIII 1.0 GHz
640 MB Ram
36 Gig Hd partions as follows:
/dev/sda1
linux swap1 Gig
As much memory as you can get you hands on (we have 4 gig).
As fast disks as you can get.
Then a good multi threading operating system (64 bit would be nice).
Simon
-Original Message-
From: mixo [mailto:[EMAIL PROTECTED]
Sent: 09 July 2003 08:58
To: [EMAIL PROTECTED]
Subject: Ideal set
Hi Neil,
1) You could ask for the count of each listed item in a column.
something like:
SELECT item, count(item) from parts GROUP BY item;
2) you could then use
SELECT id,item from parts WHERE item = 'xxx';
to review the double entries.
This is just a general sample, perhaps if you give mo
Hi Faith,
You will have to check your user account privileges. Make sure that the Host
you are connecting from is entitled to connect to the server.
Login to the mysql server with the command line tool "mysql" and do this:
mysql> show grants for user;
+-
When Mysql runs on machine with multiple NIC's. Mysql server takes the
IP Address that we specify in the configuration file. This IP Address
may or may not be a primary IP Address of that machine. So we specify
secondary IP Address for the Mysql server. It listens in that IP
Address.
When Mysql
Hi Faith,
Damn, did I post a stupid GRANT command !! Doesn't seem to be my day today ;-)
Don't use the GRANT command from the previous e-mail, use the one below.
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD 'xxx' WITH GRANT OPTION;
Sorry I must have been completely out of my mind for
"Didier ROS" <[EMAIL PROTECTED]> wrote:
> I am a newbie
> I want to create a temporary table and I get the following error
> message :
>
> mysql> CREATE TEMPORARY TABLE tempemp AS SELECT * FROM emp;
> ERROR 1044: Access denied for user: '@localhost' to database 'test1'
>
You must have
Check out the EXPLAIN command
"EXPLAIN tbl_name is a synonym for DESCRIBE tbl_name or SHOW COLUMNS FROM
tbl_name.
When you precede a SELECT statement with the keyword EXPLAIN, MySQL explains
how it would process the SELECT, providing information about how tables are
joined and in which order.
Benny:
What do you mean by 'recursive sql statements'?
If you are talking about triggers and stored procedures, the answer is no.
Gerald Jensen
- Original Message -
From: "Bernhard Schmidt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 2:58 AM
Subject: recu
As a way of getting around the lack of subselect (I'm aware this is coming
soon) we're parsing sql queries, running subselects and storing their
results in a temporary table and replacing the subselect in the sql with the
temporary table name.
This has been working fine, but on upgrading to v4.0.1
Further to this, I should point out everything works fine in mysql-front or
at the mysql console.
The problem shows up when using mysql++, a BadQuery exception is thrown.
query.reset();
query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP
MAX_ROWS=1 " << subselect
Hi Benny,
May I guess that you are talking about nested queries or subseects ?
If yes than they are supported from Version 4.1. If no, than I have no clue
what you are talking about ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 20:26、Gerald R. Jensen さんは書きました:
> Benny:
>
> What d
I have a shopping cart which creates temporary tables in the format of
zorder_;
These tables are used to hold a customers order while they shop and
after checking out, it is dropped. The values of the shopping cart are
put together in an HTML table and stored as their history.
What I want to
Dear mysql users,
in the tutorial of the documentation I found an interesting
example of a complicated non trivial sql query:
URL:
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#
example-Maximum-column-group-row
3.7 Queries from Twin Project
3.7.1 Find all Non-distribu
Hi jvilla,
I know that MySQL supports some simple nested queries from 3.23 -xx, and even
includes subselects from 4.1.
However I am not clear if any of the 2 queries will work straight away in 4.1
(once its stable).
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 21:00、Jonathan Villa
for me a recursive sql statement is when the result of a query can be used for a
following query. the statement has start and stop condition. such kind of queries is
useful for tree traversal. sql is based on relational algebra that does not allow to
write such expressions. but as mentioned by r
David,
If you want to learn about Databases and normalization and Relational
Algebra, a really good book is:
Fundamentals of Database Systems, by Elmasri and Navathe
and
Understanding Relational Database Query Languages by SW Dietrich
I have studied the first book, cover to cover, and I still us
On Wed, Jul 09, 2003 at 04:20:52AM -0700, David Thompson wrote:
>
> Looking for a book to help me develop a philosophy for building
> databases (particularly on MySQL). And then taking them from concept to
> construction.
>
> Something like Start by asking which queries you will be performing,
Hello MySQL programmers,
suppose we have an Enhanced ER diagram,
with entities as classes/ subclasses connected through
some IS-A relationship.
How can this be Coded in MySQL Please?
My prerequisites are the basic database texts from
http://www-db.stanford.edu/~ullman/dscb.html
http://w
Hi Benny,
Thank you for the explanation, but I believe thats out of my reach to give any
advice here ;-)
Best regards
2003年 7月 9日 水曜日 21:30、Bernhard Schmidt さんは書きました:
> for me a recursive sql statement is when the result of a query can be used
> for a following query. the statement has start a
On Tue, Jul 08, 2003 at 09:36:11PM -0700, cmars wrote:
>
> I want to insert massive amounts of data in near real-time into a MySQL database.
> The data is in a structured binary format, and I have code that parses the data into
> logical data structures.
...
> How can I load data directly into
Mark Depenbrock <[EMAIL PROTECTED]> wrote:
>
> Can not make mysql connection -
>
> error log:
> 030708 08:53:48 mysqld started
> 030708 8:53:49 InnoDB: Operating system error number 13 in a file
> operation.
> InnoDB: See http://www.innodb.com/ibman.html for installation help.
> InnoDB: The e
"Bernhard Schmidt" <[EMAIL PROTECTED]> wrote:
>
> for me a recursive sql statement is when the result of a query can be used for a
> following query. the statement has start and stop condition. such kind of queries is
> useful for tree traversal. sql is based on relational algebra that does not
I am writing an attendance system in php for my school. We have a
little less then 1000 students. For every day of the school year one
record will be entered into a table for each student representing their
attendance status (present, absent, late, etc...). I also have several
other supporting
Paul,
Did you try using REPLACE instead of UPDATE/INSERT? Could give you some
more speed enhancement.
Cheers
/rudy
-Original Message-
From: Paul Chvostek [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 15:21
To: cmars
Cc: [EMAIL PROTECTED]
Subject: Re: Bulk loading data
On Tue, Ju
hi victoria
sorry for this mysql newbie question, but what means "planned for the near future"?
ist this weeks, months or years away?
best regards
benny
Everything from month to years. Might even be tomorrow...
/rudy
-Original Message-
From: Bernhard Schmidt [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 16:07
To: [EMAIL PROTECTED]
Subject: Re: recursive sql statement
hi victoria
sorry for this mysql newbie question, but what mea
One of these days I will maybe understand...
Using MYSQL 4.0.13, debian linux
create table members (
id unsigned int autoincrement,
name
)
create table activity (
id unsigned int autoincrement,
description
)
create table history (
id unsigned in autoincre
Hi I am trying to make mysqld max so i can create innodb tables but I am
getting the following error when i run mysqld
No Variable Match for: -0 'innodb_buffer_pool_size = 40M'
./mysqld version 3.23.56 for pc-linux on i686
I am unable to figure out what to do. This shows that it reads the my.cnf
Occasionally in checking one of the servers, I noticed that mysql shows 85% + of
cpu usage essentially leaving the server at 0% idle. After monitoring it for a
few hours, the status did not change. After a stop and start of mysql, things
progessed normally. Checking back a few days later I notic
Hello Egor,
You give me hope but...
I attempted to set up permissions but it appears that I need to start
up MySQL in order to do that.
That brings me right back to my original problem of not being able to
connect.
I am thinking of reinstalling MySQL to see if I missed something in the
origina
Rick Pasotto wrote:
One of these days I will maybe understand...
A "left join" (t1 LEFT JOIN t2 ON ) is defined as follows.
For each row in t1, find all matching rows in t2 and return the
combination of t1 and t2 found. If there are no t2s for a t1, leave the
t2 values NULL in the result.
Try
i think this should be no problem...
i'd think of some table layout like this:
date int PRIMARY
student_id int PRIMARY
status int
extra_data what-you-want
then you should get about 360,000 records per year.
i saw people on this list reporting about millions of records
hi,
> load). Is there a known issue (running on FreeBSD 4.8,
> MySQL 3.23.55 MyISAM)?
its been a known issue for quite a long time
use linuxthreaded version and it should work fine.
although much of work has been done on threads implementation,
there are still such problems with mysql. it happe
Can anyone point me to a reference on how to insert images into a column
in a mySQL database -- or is that not possible?
Thanks in advance,
Dan Anderson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Adam,
Mysql will easily handle this. This certainly doesn't constitute a large
database.
Correctly indexing the database should see you doing speedy queries on years
worth of data.
Sounds like you've used access in the past :-)
Andy
> -Original Message-
> From: Adam Gerson [mailto:[EM
Please note that InnoDB is included as from MySQL 4.0 in the "standard"
release. So the easiest way to use InnoDB would be to grab a RPM or
binary distribution and install it on your system. No need to compile
one yourself then.
However, if for some reasons you must have 3.x or are on a not suppor
Is it better to set multiple primary keys or to set one key and index
the other columns? If I have a primary key as a field in another table
should it also be set as a key?
Adam
On Wednesday, July 9, 2003, at 10:41 AM, <[EMAIL PROTECTED]> wrote:
i think this should be no problem...
i'd thin
take a look at:
http://www.php4.com/forums/viewtopic.php?t=6
or search the mailing list archive.. there are plenty of threads talking
about this:
For list archives: http://lists.mysql.com/mysql
On Wed, 9 Jul 2003, Dan Anderson wrote:
> Can anyone point me to a reference on how to insert ima
On Wed, 2003-07-09 at 10:31, Dave [Hawk-Systems] wrote:
> Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)?
> Is there something I should check when next I notice the high CPU usage?
>
I used to see the same kind of behavior a while back with a MySQL
installation I did for a
If you got the error message during creation of the innoDB files (e.g.
during install) you HAVE TO DELETE all files and restart the
installation. There is no way around this!
However, if the file got corrupted after installation (e.g. you already
used it for days) you can repair it (maybe someone
Well that all depends. The real reason for a primary key is to prevent duplicates,
therefore, if a combination of fields needs to be unique, then a multiple primary key
makes sense, especially if other tables will reference the field combination (for
example, detail items on an invoice where the
Yes it is. If you are using VB look at
www.vbmysql.com/articles/blobaccessvb.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Dan Anderson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 09, 2003 8:49 AM
> To: [EMAIL PROTECTED]
> Subject: Is it possible to dump
Why using int for date? Better suited would be DATE or DATETIME (or even TIMESTAMP,
depending how you want to use it).
For studentid, SMALLINT or MEDIUMINT would maybe suffice, esp when you make them
UNSIGNED.
For status I would choose CHAR(1), you can put a lot of information into that, which
a
Rudy, Egor, Victoria,
Thank you for keeping an eye on me. I ended up doing a reinstall of
MySQL and have successfully connected.
I feel I have broken through a wall only to find an infinite number of
walls yet to break through.
Such is the adventure I have chosen.
Be at peace,
Mark Depenbrock
Use LOAD DATA INFILE if you want to import it from the filesystem or use
INSERT/UPDATE if you do it from an application (e.g. perl, php). Make
sure that the column which stores them is defined as BLOB and not as
TEXT. Look up the BLOB definition for size limitation and variations on
BLOBs.
For get
MySQL allows only ONE primary key per table, so you can only use one. However, you can
also define UNIQUE INDEXES. The major difference here is that primary key columns may
not contain NULL values, however UNIQUE KEY columns may contain NULL values.
If your question now is: Is it better to use a
I have four tables I need to query for information;
acc,accmemo,aard,sdtik where
acc contains basic information about a customer (1 rec per acctno)
accmemo contains multiple Account Memo messages (0 or more recs per acctno)
aard contains credit card(s) information (0 or more recs per acctn
Mike,
#2 is not 100% correct. Only the columns in the "lookup" table (table2) need to be
indexed. Why? The optimizer first gets a limited set of table1 and then checks if it
can join this subset with a key from table2. So for the join condition only table2
needs to be indexed.
However, you are
As we're on this topic in another thread right now:
Say I have a SELECT query from more than one table and with some conditions, does it
matter in what order I enter the tables in the FROM clause and in what order the WHERE
conditions appear in my query? Or does it make any difference if I use W
Maybe increasing
#use for when mysql is doing a check or repair
set-variable= myisam_sort_buffer_size=64M
to a higher value will make the index happen faster on the fly.
But, for a 100 million row table doing a dump and adding that dump back
to the db might be your fastest method. Building t
"Dathan Vance Pattishall" <[EMAIL PROTECTED]> writes:
> #use for when mysql is doing a check or repair
> set-variable= myisam_sort_buffer_size=64M
>
> to a higher value will make the index happen faster on the fly.
Oops. I only adjusted the key_buffer value. Probably I should set
myisam_sor
Hi!
I'm running MySQL 4.0.13 and have problem with fulltext search.
I have a column of type 'text' which I fulltext index.
I want to search for an e-mail address but I don't get any matches.
I assume characters like @ . are ignored (stop words).
How can I create an index which contains e-mail ad
>> load). Is there a known issue (running on FreeBSD 4.8,
>> MySQL 3.23.55 MyISAM)?
>
>its been a known issue for quite a long time
>use linuxthreaded version and it should work fine.
>
>although much of work has been done on threads implementation,
>there are still such problems with mysql. it ha
>> Is there a known issue (running on FreeBSD 4.8, MySQL 3.23.55 MyISAM)?
>> Is there something I should check when next I notice the high CPU usage?
>>
>
>I used to see the same kind of behavior a while back with a MySQL
>installation I did for a client. It turned out that what was happening
>was
On 9 Jul 2003 at 19:07, Peter Engström wrote:
> I want to search for an e-mail address but I don't get any matches. I
> assume characters like @ . are ignored (stop words).
A "stop word" is a *word* that is ignored in indexing -- usually
things like "the" and "and". What you're talking about is
Trying to start mysqld for the first time after a reinstall on Mac OS X
gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: The error means
Hi everyone:
Does anyone know how to reset the auto_increment value of certain table.
Any ideas or sugestions
Greetings in advance
_
Únete al mayor servicio mundial de correo electrónico:
http://www.hotmail.com
--
MySQL General
Miguel:
Wednesday, July 9, 2003, 3:07:33 PM, você escreveu:
---[inicio]--
MP> Hi everyone:
MP> Does anyone know how to reset the auto_increment value of certain table.
MP> Any ideas or sugestions
MP> Greetings in advance
MP> __
Why are you looking to reset it? If you mean resetting when there is no data in a
table, a truncate table should start the auto_increment over again. If you are
referring to recovering some auto_increment values that were previously used by no
rows now use them, it is better to avoid this. That
Hello Nick,
You and I are just about on the same page here.
However, I just turned the page you are now baffling over.
Let me ask, Did you removed the old "Macintosh
HD/Library/Receipts/mysql-standard-4.0.13.pkg" file
before you did the new install.
If I am not mistaken, this is what cinched it
Hello all -
I'm having a small problem with the mysql startup script that ships with
MySQL-3.23.56-1.
I'm running on RedHat Linux.
It works fine, but I have a backup server that runs a script that passes
these commands remotely through ssh:
(1) ssh dbsys-dc "sudo /etc/init.d/mysql stop" (2) ssh
See http://www.mysql.com/doc/en/TODO_future.html
"Oracle-like CONNECT BY PRIOR ... to search tree-like (hierarchical)
structures."
Whatever their definition of "The Near Future" is... I'd guess v5
J
- Original Message -
From: "Bernhard Schmidt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
hi mike
you suggested the following
> If you are referring to recovering some auto_increment values that were previously
> used by no rows now use > them, it is better to avoid this.
how can you prevent this?
best regards
benny
If you are looking for ways to retrieve and store hierarchical data
(employees and managers, for instance)
I'll also recommend looking at the Nested Set hierarchy. Search news
groups for it, and look into Joe Celko's book _SQL For Smarties_, which
describes the technique. You can store a complete
I am trying to get a SELECT working and not having any luck, can someone
please help?
SELECT
strref,acc.acctno,acc.namelast,acc.namefirst,phone1,adddate,min(datein) as
fsttik, sum(amt) as sales,store FROM acc,sdtik WHERE
acc.acctno=sdtik.acctno and voidreason=0 and store>=40 and store<=59 GROU
Is it possible to issue multiple sql statements in a single php request?
(Probably not since I get a syntax error. mysql 4.0.13).
For example:
$result = mysql_query("drop table if exists tmptab;
create temporary table tmptab select * from othertab;
select * from tmptab where ");
Nick Boudreau wrote:
Trying to start mysqld for the first time after a reinstall on Mac OS
X gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB: Operating system error number 13 in a file
operation.
mysql doesn't have permissions for this file.
It is probably owned
fsttik has dashes in it and your having does not.
Either add dashes to your having or change the alias to min(datein+0)
as fsttik.
Patrick Shoaf wrote:
I am trying to get a SELECT working and not having any luck, can
someone please help?
SELECT
strref,acc.acctno,acc.namelast,acc.namefirst,ph
Thanks, worked perfectly!
At 04:17 PM 7/9/2003, gerald_clark wrote:
fsttik has dashes in it and your having does not.
Either add dashes to your having or change the alias to min(datein+0) as
fsttik.
Patrick Shoaf wrote:
I am trying to get a SELECT working and not having any luck, can someone
hello,
i'm just changing from openbase SQL to MySQL, so i'm new here.
in openbase i had images stored in a database. the 'type' was set to
'object'.
i can't find something like that here and also not in the manual.
what should i use?
thanx for advance
cheers
christian
--
MySQL General Maili
Glad I can help. The home page for the product is www.bytefx.com, however
you can post bugs/patches/suggestions at
www.sourceforge.net/projects/mysqlnet until I get those features implemented
at my site.
Reggie
> -Original Message-
> From: Kimberly Clark [mailto:[EMAIL PROTECTED]
> Sent:
You'd want to use a BLOB (binary large object) if that's what your goal
is.
But if you're using this for a web application I'd highly suggest that
you instead save images to a directory and make a reference to the path
in the database. If you have many BLOB inserts or selects on a site,
your datab
Never mind. I've solved my problem. My create statement had an unquoted
date in the select part. It works correctly now.
On Wed, Jul 09, 2003 at 03:29:11PM -0400, Rick Pasotto wrote:
> Is it possible to issue multiple sql statements in a single php request?
> (Probably not since I get a syntax err
Yep, that was it, along with what Mark said.
On Wednesday, Jul 9, 2003, at 15:10 US/Central, gerald_clark wrote:
Nick Boudreau wrote:
Trying to start mysqld for the first time after a reinstall on Mac OS
X gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB: Operatin
Hi every one :
i'm trying to make a db program using Mysql & cbuilder6 .
on my table a have fields named " patient_Id " .
its an auto_increment value but i got problem .
the problem is when i try to get the value of that fields i got nothing just
" 0 " although i execute the commands
SQLClient
You are going to have to give us more information on what those functions do
If at all possible capture the query itself and let us know more about the
details
Also what type of connection to the Database ODBC, JDBC are you
implementing.
Regards,
Martin
--
MySQL General Mailing List
For list ar
Contents are Direct Alliance Corporation CONFIDENTIAL
-
Duane,
Does mysql actually start back up? Or just get hung on step(4)?
I know I have had problems running scripts over ssh because the sudo
environment user wasn't being executed as root. (where a cron_tab was
actually execu
thanks a lot!!!
cheers
christian
You'd want to use a BLOB (binary large object) if that's what your goal
is.
But if you're using this for a web application I'd highly suggest that
you instead save images to a directory and make a reference to the path
in the database. If you have many BLOB inse
Mike Brum wrote:
I've been preparing some notes for my students on how to do this (using
PHP/MySQL), if you're
interested have a look at
http://www.scit.wlv.ac.uk/~jphb/sst/php/extra/images1.html - I've
only just put these notes together so if you can see any errors please
let me know before I
Hi,
If you send a table def (mysqldump would be good) I will be able to
experiment and come up with an answer...
Cheers,
Andrew
-Original Message-
From: Patrick Shoaf [mailto:[EMAIL PROTECTED]
Sent: Wednesday 09 July 2003 20:30
To: [EMAIL PROTECTED]
Subject: Select not producing desire
Hi,
Can anyone help?
I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline burst,
with a wd 512MB HD and I want to store George Bush in our MySQL database.
As far as table definitions are concerned, should I use a BLOB or should I
store him on disk and make a reference to the physi
On 9 Jul 2003 at 23:14, Andrew Braithwaite wrote:
> I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline
> burst, with a wd 512MB HD and I want to store George Bush in our MySQL
> database.
>
> As far as table definitions are concerned, should I use a BLOB or
> should I store him o
I'm trying to upgrade the glibc on some machines that do not yet have glibc2
in order to support > 1000 threads. It seems that some of the instructions
concerning setting a pthread maximum for older glibc's are no longer
pertinent.
I wonder if the glibc 2.3.2 is known to be compatible with MySQL
James B. Wetterau Jr. wrote:
I'm trying to upgrade the glibc on some machines that do not yet have
glibc2
in order to support > 1000 threads. It seems that some of the
instructions
concerning setting a pthread maximum for older glibc's are no longer
pertinent.
I wonder if the glibc 2.3.2 is kn
> > Further to this, I should point out everything works fine in mysql-front
> > or at the mysql console.
> >
> > The problem shows up when using mysql++, a BadQuery exception is thrown.
> >
> > query.reset();
> > query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP
> >
Hello Heikki,
Thanks for your response. Hmmm... When I run 'show processlist', I get something
like the following:
++--++--+-+-+---+--+
| Id | User | Host | db | Command
On Wednesday 09 July 2003 17:49, Cory Lamle wrote:
> Contents are Direct Alliance Corporation CONFIDENTIAL
> -
>
> Duane,
> Does mysql actually start back up? Or just get hung on step(4)?
Yes, mysql starts back up ok. I do a /etc/init.d/mysql start and the daemon
starts just as it should.
Say I have column A with 1 distinct values column B and C with 2
distinct values and for simplicity sake the column type is an int.
If I wanted a composite key why should I make the order of the key
A,B,C
I read someplace that faster lookups happen with the leftmost index,
being an index wit
Hi All,
I success ./configure my "mysql-3.23.51", after type make I got this
error
-
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmy
This is probably a dead horse but let me post a followup to let everyone
know what I did and what has happened since. Maybe I should list it
under some other error number.
Before Paul posted his message I uninstalled (using rpm -e) version
4.0.13. I then got the RedHat installation CDs and re
Hi Kevin,
In this case the error log file (hostname.err) in f.e /var/lib/mysql should
give you an idea whats going on.
Perhaps the settings inside the my.cnf from the newer version are very
different then from the older version.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 10日 木曜日 11:
1 - 100 of 116 matches
Mail list logo
