On Wed, Mar 20, 2002 at 12:17:58AM -0700, zxcv wrote:
>
> An Oracle DB programmer reviewed a query that I wrote and told me
> that putting constants at the beginning of the query would make it
> slower. I thought I'd go to the experts on MySQL and be told the
> truth one way of the other.
Perhap
hii all,
I want to knowledge about blob.
how can write or read blob to/from MYSQL database by using Visual C++.
Can any body help me.
Ibrahim Kivanc Cihan
Anadolu University - Turkey
-
Before posting, please check:
I have downloaded the latest sRPM: MySQL-3.23.49-1.src.rpm
I am trying to run rpm --rebuild MySQL-3.23.49-1.src.rpm on a redhat 6.2
machine with gcc ver: gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2
release) with the latest 2.2.19-6.2.16smp kernel.
I get the following error after a whil
On Wednesday, 20. March 2002 05:06, jrfoutin wrote:
> session_start();
> include("$DOCUMENT_ROOT/php/main.home.php");
> ?>
>
> The environment variable in this code on index.php is not invoking
> main.home.php page in php folder in htdocs on new server.
>
> Code worked on previous server setup, b
Hi,
I finally after 2 weeks battle with asp.net - mysql - myodbc got a
connection.
my only problem now is that I got the connection because I downloaded
microsofts ODBC.NET component and I'm using the Microsoft.Data.Odbc
namespace.
but I can't find any documen
I use HEAP table as cache DB. But there are not enough infomation about
HEAP table.
Anybody else knows where the information is? If you inform me I will
really appreciate.
For example I wanna know what kind of lock HEAP table uses. Is that
same as MyISAM table lock?
If there are many UPDATE quer
An Oracle DB programmer reviewed a query that I wrote and told me that
putting constants at the beginning of the query would make it slower. I
thought I'd go to the experts on MySQL and be told the truth one way of
the other.
Example query:
SELECT
TABLE1.COL,
TABLE2.COL
FROM
On Tue, Mar 19, 2002 at 06:14:14PM -0700, Michael Halcrow wrote:
>
> My only saving grace is that we are allowed to use any tools that
> are freely available over the Internet.
That rocks! :-)
> I was thinking about using bison and RUBY to implement it. However,
> since I noticed that MySQL is
Hello all,
this is more MySQL/PHP topic, I hope someone will have an idea.
We have a soccer site, and we want to give our users ability to predict
the result of upcoming matches. So, if we have 32 matches, for each
match user select 1 (home win), x (draw), or 2 (guest win). We expect
that about
jake williamson 28 expounded:
>
> hello mike,
>
> i've got a similar set-up on my g4 - only i'm not quite at the hosting
point
> yet.
>
> the way i think i would go about it is create a database per domain and
use
Do you mean a database within a single instance of MySQL, or a separate
instance
Hi Mike,
You queried:
> Just a quick question, if I am going to make a database using MYSQL and
have
> front end applications, is it better to give each user a username/pass and
> have them enter it into the front end to be passed to the server, or
should
> I give the app a password, hardcode i
David Ayliffe queried:
> So how (forgive me if this is a simpleton's question), how will UTF-8
> and UCS2 be used? Can you elaborate a bit.
These are the kinds of questions I would like answers for:
I am expecting that UTF-8 will be stored in CHAR, VARCHAR, TEXT, and BLOB
fields, just as curre
Sir/Madam,
It's me IMON.I want to know that how I use JDBC driver
on Java for application or applet.I am interested on
internet programming and for this purpose I want to
use mySQL for back-end database also I want to know
that which one is the best driver.Pleae send me some
guidline on this pu
On Tue, Mar 19, 2002 at 09:14:36PM -0600, Dan Nelson wrote:
>
> ( I'm assuming you really want to run mysql with > 512MB of cache here )
>
> FreeBSD by default sets a hard max datasize limit of 512MB. To
> raise that, say, to 1gb, you'll either need to rebuild your kernel
> with "options MAXDSIZ
alan4100:
If you reply to this, please CC the list.
Keep reading the manual while you try things. From your questions, I am
wondering if you are not reading the manual, or are just too impatient and
are trying things before you read the whole story.
If your processor is faster than 100MHz and h
At 22:13 2002-03-19, Young Sul wrote:
>Hi,
>
>I've got a website that uses a mysql backend database. Due to the way in
>which
>the database and development has been architected, I'm unable to
>load-balance
>the database between multiple DB servers, taking advantage of replication
>inherent
>in mys
The environment variable in this code on index.php is not invoking
main.home.php page in php folder in htdocs on new server.
Code worked on previous server setup, but fails on new server. Other php
calls to MySQL db in ported site code that uses environment variable
seems to work fine, but this
On Tue, Mar 19, 2002 at 10:13:09PM -0500, Young Sul wrote:
> Currently, I mirror the master DB on another server, and can switch over
> ...manually...
> if the master dies.
>
> I'm wondering if others on this list have encountered a similar situation --
> how did
> you finally architect your DB e
In the last episode (Mar 19), Jeremy Zawodny said:
> Running the latest build from bitkeeper (as of Saturday or so) on my
> 4.0.x slave (FreeBSD 4.3), after several hours, I start getting these
> messages when apps try to connect to the server:
>
> ERROR 1041: Out of memory; Check if mysqld or
Hi,
I've got a website that uses a mysql backend database. Due to the way in
which
the database and development has been architected, I'm unable to
load-balance
the database between multiple DB servers, taking advantage of replication
inherent
in mysql. (this is due largely to developmental const
At 13:28 +1100 3/20/02, Kim Kohen wrote:
>G'day Paul
>
>Thank you for your response.
>
>> Sure, but no index will be used for the LIKE pattern match part of the
>> query because your pattern doesn't begin with a literal string.
>
>I realised after I sent the previous post that I should have
> >> >I have to plan a content retrieval system and am thinking of
using
> >mysql
> >> >cause it's always been very reliable and convenient for my needs.
> >> >Now, I do not have any experiences with databases of this size.
> >> >
> >> >The situation is as follows:
> >> >We have round about
At 18:37 -0800 3/19/02, Allon Bendavid wrote:
>Thanks Paul for all of the clarifications
>
>Actually what I was saying was this:
>
>I obviously didn't assume that sticking a semi-colon between statements
>creates a transaction. I was leaving out the transaction/table lock
>statements but I meant
On Wed, Mar 20, 2002 at 02:02:49AM -, Rob Moore wrote:
> Hi there
>
> Apologies if this has been asked before; couldnt find anything
> in archives...
>
> We have a mysql database on a web server that I transfer manually to
> an office machine, and a different database on the office machine
>
Thanks Paul for all of the clarifications
Actually what I was saying was this:
I obviously didn't assume that sticking a semi-colon between statements
creates a transaction. I was leaving out the transaction/table lock
statements but I meant to illustrate that for instance:
LOCK TABLES Orders
> >Hello,
> >
> >I have to plan a content retrieval system and am thinking of using
mysql
> >cause it's always been very reliable and convenient for my needs.
> >Now, I do not have any experiences with databases of this size.
> >
> >The situation is as follows:
> >We have round about 15gig of user
G'day Paul
Thank you for your response.
> Sure, but no index will be used for the LIKE pattern match part of the
> query because your pattern doesn't begin with a literal string.
I realised after I sent the previous post that I should have omitted the
first '%'. I had mentally noted this f
I'm using the following syntax to backup one of my Mysql databses using
mysqlhotcopy:
#/usr/bin/mysqlhotcopy --allowold MyDatabase MyDatabase_copy
There is no error message & there is no difference between the two
folders /var/lib/mysql/MyDatabase & /var/lib/mysql/MyDatabase_copy when
I do a
Thanks for the lead Jeff, maybe you can elaborate?
We need to essentially do this:
Insert into orders (number, comment) select max(number) + 1, 'comment' from
orders where user = 'user_name';
(Not supported in MySQL)
Another user suggested using a select first to get the value, then doing an
At 2:20 +0100 3/20/02, Andreas Dau wrote:
>Hello,
>
>I have to plan a content retrieval system and am thinking of using mysql
>cause it's always been very reliable and convenient for my needs.
>Now, I do not have any experiences with databases of this size.
>
>The situation is as follows:
>We have
Hi there
Apologies if this has been asked before; couldnt find anything
in archives...
We have a mysql database on a web server that I transfer manually
to an office machine, and a different database on the office machine
that I transfer to the web server.
In each case only the database on the m
I'm using the following syntax to backup one of my Mysql databses using
mysqlhotcopy:
#/usr/bin/mysqlhotcopy --allowold MyDatabase MyDatabase_copy
There is no error message & there is no difference between the two
folders /var/lib/mysql/MyDatabase & /var/lib/mysql/MyDatabase_copy when
I do a
At 11:59 +1100 3/20/02, Kim Kohen wrote:
>Hi All,
>
>My apologies for asking what may be a very newbie question. I'm having
>trouble getting my head around searching multiple indexed columns. I have
>read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured
>Paul's book but haven'
Hi,
I tried to read the documentation, but there are only examples instead of
specific/explicit documentation
My question is-which ADO objects/methods/properties does myODBC support? I
can easily found the entire ADO programming model, all the objects, and
their methods/properties in MSDN.
But,
At 16:45 -0800 3/19/02, Allon Bendavid wrote:
>Hi All-
>
>We are using the mm driver for MySQL and multiple statements in one
>connection do not seem to be supported:
No. Multiple statements in one *string* are not supported, in the MM.MySQL
or any other API. The client-server protocol supports
Hi All,
My apologies for asking what may be a very newbie question. I'm having
trouble getting my head around searching multiple indexed columns. I have
read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured
Paul's book but haven't been able to find an answer.
We have a table
Hello,
I have to plan a content retrieval system and am thinking of using mysql
cause it's always been very reliable and convenient for my needs.
Now, I do not have any experiences with databases of this size.
The situation is as follows:
We have round about 15gig of user documents (mainly MS Of
I'm taking a database implementation course, and my professor has flipped
his lid this semester and assigned one of the labs to be an SQL parser and
optimizer (using equivalence rules, etc.). Given an SQL statement and a
database schema (with some statistical metadata on the contents), I am to
par
Hi All,
My apologies for asking what may be a very newbie question. I'm having
trouble getting my head around searching multiple indexed columns. I have
read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured
Paul's book but haven't been able to find an answer.
We have a table
Hi All-
We are using the mm driver for MySQL and multiple statements in one
connection do not seem to be supported:
I.e.
SELECT @a:=MAX(Number) FROM Orders;insert into orders (Number) values (@a+1)
The driver throws a syntax error. You can do either one of these statements
on their own, and
I'm installing MySQLto a Corel /Debian platform, following
directions in the book Beginning PHP4. Successfully
did ./configure, make, make install, and mysql_install_db
as described on page 387. The book says I'll now need to
start and stop the Mysql server using two sample
scripts, to wit:
If you are running RH7.2, start your GUI and go to System / Service Manager.
Locate mysqld, and make sure it is checked to automatically start on bootup,
then save your settings, and click the start button.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesd
On Tue, Mar 19, 2002 at 04:02:46PM -0800, Jeremy Zawodny wrote:
[snip]
> Here's the relevant entry from the error log, repeated over and over:
>
> 020319 15:57:33 /home/mysql-4-bk/libexec/mysqld: Out of memory at line 100,
>'net_serv.cc'
> 020319 15:57:33 /home/mysql-4-bk/libexec/mysqld:
Running the latest build from bitkeeper (as of Saturday or so) on my
4.0.x slave (FreeBSD 4.3), after several hours, I start getting these
messages when apps try to connect to the server:
ERROR 1041: Out of memory; Check if mysqld or some other process
uses all available memory. If not you m
not quite sure what you mean by locking.
each table will be locked during "readout" for the dump automaticly for the
time the select runs and delivers data to the dumping program.
it is not needed to lock the tables (more than one) in advance for a dump, but
that, might better for dataintegrety.
I dont know what I have done now but I have locked myself out of mysql. When
I type mysql I get an access violation. At first I thought it might have
been something on my end since I am a remote user. But when I attempt to
enter mysql from linux box. I get the same access violation...
Please someo
Yes. Setup replication and peform the backup on the slave. Provided this is your only
purpose for having a slave, and there are no queries running on the slave, the specs
can be a lot lower than your master/production machine.
-Original Message-
From: Kathy Reyes [mailto:[EMAIL PROTECTE
In the last episode (Mar 19), Brad Phinney said:
> Hello all.
>
> I have an application that does a lot of table creation and writing for
> a FreeBSD 4.4 SMP machine. Over time, I begin to see the following
> errors.
>
> DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Er
NetWare recently (relatively) has added some support for C code running on
the servfer. You should, however, evaluate the NetWare environment
carefully, and take advantage of porting it native to NetWare.
I am sure that you can acquire evaluation software from Novell for NetWare
5.1 and 6, the o
So how (forgive me if this is a simpleton's question), how will UTF-8
and UCS2 be used? Can you elaborate a bit.
DA
Hi,
Unicode in 4.1 will use UTF-8 and UCS2 with a possibility to recode
between them (as well as between any supported character sets).
> Some (VERY) technical documentation
Hi Brad,
You are running out of file descriptors, type this:
kes# sysctl -a | grep files
kern.maxfiles: 2
kern.maxfilesperproc: 18000
kern.openfiles: 5230
kes# limit -h
cputime unlimited
filesizeunlimited
datasize1048576 kbytes
stacksize 262144 kbytes
coredumps
I am trying to backup a table in mysql without locking my tables it this
posible
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
probably something wrong with the permissions in the mysql database.
as a workaround, try to connect not via the local socket, but via a
tcp/ip-connection:
# mysql -h 127.0.0.1 -u my-user -p my-database
or insert the real ip of the machine instead of the loopback address.
check if there
this file is created when MYSQL starts
check the directory to ensure it has the correct read-write permissions
check the list archives; this question has been asked almost every day
-Original Message-
From: colin o [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 3:05 PM
To: mys
With out knowing your system configuration it sounds to me like you've
got some problems with locking.
I suggest looking into that.
Brad Phinney wrote:
>
> Hello all.
>
> I have an application that does a lot of table creation and writing for
> a FreeBSD 4.4 SMP machine. Over time, I begin to
Hi all:
I am having a huge problem setting up replication between 2 mysql
databases on the same server. The reason for doing this is to use the
slave database for backups thus avoiding the need to down the master
database.
I am consistently getting "Error 1200: The server is not configured as a
Hi,
When i try to access the database which is on my Linux
machine i get the following error:
ERROR 2002; Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111)
There is nothing in this file, although i dont know
how to edit it.
I have gone through the Manual pages and the l
I'll bet there are several people in Provo, Utah that could be convinced to
do the port.
Curtis
Sinisa Milivojevic said:
> Adolfo Amo writes:
>> Hi!
>> We are ineterested in the possibility of using MySQL on Netware
>> plataform.
>> After visit MySQL website, we've found that you are interested
All,
I can't seem to perform an update on my database with MySQL++. The
execution of the query always throws an exception. Here's a snippet of what
I did.
Query query(&conn);
query << "update employee set children = 3 where id = 9";
query.execute();
The above code throws an exception everyti
Hello all.
I have an application that does a lot of table creation and writing for
a FreeBSD 4.4 SMP machine. Over time, I begin to see the following
errors.
DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode: 2) at
/var/SAMT/code/SAMTlib/SAMTdb.pm line 2552, chun
Try
mysql -uODBC -p
(-p assuming you have a password on the account)
the formula is -optVAL
alan4100 wrote:
>
> I typed SELECT SYSTEM_USER() ..The output is
>
> ++
> | system_user() |
> ++
> | ODBC@localhost |
> ++
> 1 row in set (0.00 sec)
>
At 20:02 18/03/02 -0600, Gerald R. Jensen wrote:
Hi,
For to avoid the install of the service in local account I will
add code for to verify if the user that is making the install
process has administrator rights and display the error message
if he/she doesn't have.
Regards,
Miguel
>Alex:
>
>I d
> thanks for the reply, but when I typed "mysql" I meant it without
the "d".
Yes, I understand, and I see that it is in the help, but it was my
understanding the the character set (at this time) MUST be selected on
the server and cannot be selected on the client, but perhaps I am
wrong. This
Just a quick question, if I am going to make a database using MYSQL and have
front end applications, is it better to give each user a username/pass and
have them enter it into the front end to be passed to the server, or should
I give the app a password, hardcode it into the app for database
conne
Hi Howard,
I am trying to think of ideas. I have several databases with
tables over 1.4G and rows still add quickly. How about available
descriptors, what are these values:
| Open_tables | 2738 |
| Open_files | 5013 |
| Open_streams | 0
hello ken,
thanks for the reply, but when I typed "mysql" I meant it without the "d".
I'm using the client for lots of batch i/o, little utilities and quick
maintenance. I'm using it on quite a couple of systems (linux in all flavors
and FreeBSD), but only on one of this systems it shows this
Hi Sasha,
I assume it not a mistake (as you typed 'mysql' twice), but mysql
is the name of the client program, you must start the server program
(safe_mysqld) with the --default-character-set=latin_de. First use
mysqladmin to shutdown the server, then restart it with safe_mysqld.
Also I woul
Howdy, I'm about to put together a book on MySQL (in Peachpit Press'
Visual QuickStart Guide series) and am looking for a tech reviewer. The
book itself will be a step by step beginner's text to the world's best
open source database. Running about 300 pages it will not be as
comprehensive or p
http://www.mysql.com/doc/M/y/MySQL_Benchmarks.html
Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216
> -Original Message-
> From: Kathy Reyes [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 19, 2002 1:51 PM
>
Have you looked at:
http://www.mysql.com/information/benchmarks.html
On Tuesday 19 March 2002 11:50 am, Kathy Reyes wrote:
> Hello all its me again
> Does any one now of any database benchmarking utility that I can use on
> mysql database???
--
Hello all its me again
Does any one now of any database benchmarking utility that I can use on
mysql database???
Kathy Reyes
Live Technology International
2975 Westchester Avenue
Suite 103
Purchase, NY 10577
Tel: (914) 490-7096
[EMAIL PROTECTED]
www.LiveTechnology.com
--
UPDATE sequence_table
SET sequence = LAST_INSERT_ID(sequence + 1)
Further calls to LAST_INSERT_ID on the same connection will return the value
"sequence + 1". It's connection specific, so multiple connections can update
your sequence table without interfering with each other.
There's a great exa
On Tue, 2002-03-19 at 10:02, David Ayliffe wrote:
> Hello,
>
> I need some details on the EXACT type of Unicode that MySQL will use
> 4.1.
> Ideally I'm looking for information on which type of Unicode MySQL will
> use internally, and which type it will return data to the user in; and
> is the My
On Mon, 18 Mar 2002, Aaron D. Turner wrote:
> I've read the docs on mysql.com about the BDB and InnoDB table formats, as
> well as their pro's & con's and I was wondering if anyone could give their
> opinion on the matter. I don't need row-level locking or other fancy
> features other than tran
i am running mysql version 3.22.32. yes i am planning an upgrade. in the
meantime, i need to check (and possibly) repair my tables without bringing
down the mysql daemon.
thanks,
Shon Stephens
540.942.7292 office
540.649.3508 mobile
shon8work aim
---
I asked this the other day but didn't get any responses. Is there anyone
out there with experience running mysql 4 with ssl connections?. I would
like to get this setup but can't find any good documentation on how to do
it. In particular, it seems that one has to specify a key and certificate
t
Hi,
Thanks I DID read the documentation.
BUT there documentation gives no information about how to choose values
for these settings. There are no clues at all. What are good values, and/or
what is the effect on performance etc. of the values?
Howard
Egor Egorov writes:
> mysql,
>
Is this the correct file to have in your class path?
addpath /home/launi/JBuilder6/lib/mm.mysql-2.0.11/mm.mysql-2.0.11-bin.jar
--
Lonnie Wormley
[EMAIL PROTECTED] [Linux and Java]
[EMAIL PROTECTED] [Window$ and graphics]
http://www.lau
I just rmdir/s the old mysql and downloaded from Wisconsin mirror site...
Then I tried C:\mysql\bin>mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Any idea?
I know that I have mysql in NU-SPHERE directory from previous installation
about a month ago...
Adolfo Amo writes:
> Hi!
> We are ineterested in the possibility of using MySQL on Netware
> plataform.
> After visit MySQL website, we've found that you are interested in
> someone to do this port.
> Our questions are: What are the requeriments to do this? You need
> someone to compile the source
At 16:32 2002-03-19, Victoria Reznichenko wrote:
>MySQL doesn't look at bits when sorting data and MySQL doesn't support Tamila
>scripting.
Then what does MySQL look at?
Are you aware Tamil is a human language? How would MySQL support Tamil - is there a
character set that supports it for MyS
Rykov,
Monday, March 18, 2002, 4:54:50 PM, you wrote:
R> My question is - are the MySQL query parsing source codes available?
For sure! Take the source code distribution and go with it.
R> Vladimir Rykov
--
For technical support contracts, goto https://order.mysql.com/
This email is s
Art,
Monday, March 18, 2002, 5:51:46 PM, you wrote:
AF> I done the chown, now using MySQL Navigator, I get Access denied for user:
AF> afore@localhost (using passowrd: YES). I get the same for user mysql and
AF> root using both my password and root password.
Is your MySQL server running?
Looks
> Must I install MySQL on a client workstation/PC in order to run
> perl/DBI scripts that query a local MySQL server?
>
> I know I do need to install DBI, DBD:MySQL, however, I'm not sure what,
> if anything else I need to install on the client?
You only need the DBI and DBD modules AFAIK :)
c
Hi !
Is it possible to log mysql queries into a fifo created by :
# mkfifo -m660 queries.log
I've search with google but i found only one thread of one email where
somebody is getting an error 29. That's my case too.
Thanks a lot !
-
Thank you for the reply. However, unfortunately the documentation that
you refer to -- while instructive in respect to DBI usage -- does not
answer my question, which is simply:
Must I install MySQL on a client workstation/PC in order to run perl/DBI
scripts that query a local MySQL server?
Hello,
I need some details on the EXACT type of Unicode that MySQL will use
4.1.
Ideally I'm looking for information on which type of Unicode MySQL will
use internally, and which type it will return data to the user in; and
is the MySQL Unicode implementation going to be phased in or with v4.1
wi
Hi!
We are ineterested in the possibility of using MySQL on Netware
plataform.
After visit MySQL website, we've found that you are interested in
someone to do this port.
Our questions are: What are the requeriments to do this? You need
someone to compile the source in a netware platform?
Univers
Hey, you know what? You're right! I'm an idiot.
Thanks. :)
BD wrote:
> Gabriel,
> I have a sneaky suspicion your primary key is a CHAR or
> VARCHAR, right? If so, your select statement is using an integer which
> means it has to convert it for each record. If you put quotes around
>
Alex,
-Original Message-
From: BAUMEISTER Alexandre <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: Michael Widenius <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Tuesday, March 19, 2002 5:14 PM
Subject: Re[4]: InnoDB: Assertion failure in thread 10 in file
Uma,
Tuesday, March 19, 2002, 4:06:41 AM, you wrote:
VR>>Uma,
VR>>Monday, March 18, 2002, 11:34:07 AM, you wrote:
VR>>
VR>>UST>To get German sorting order, you should start mysqld with
VR>>UST>--default-character-set=latin_de. This will give you the following
VR>>UST>characteristics.
mysql,
Tuesday, March 19, 2002, 4:27:40 PM, you wrote:
mmlu> I have a very large mysql table (1.5G) and so will need to implement the
mmlu> table
mmlu> RAID option soon.
mmlu> How do I pick the CHUNKSIZE and number of chunks values?
You can read about RAID_TYPE option, RAID_CHUNKSIZE and RAID_
I need help from the administrator of this MySQL list.
I am receiving multiple(about 8-13) same mails from the same issue on the list.
I successfully unsubscribed to MySQL list but the mails still coming in.
I tried to unsubscribe a second time but it says that I am not a subscriber.
Can the per
HT> 616e647265747469 andretti
HT> 616e6472e9737069 andr.spi
HT> there is a character e9 in your string. It is not an ordinary character and
HT> can cause an error in the sorting order between InnoDB-.41 and InnoDB-.49.
ok :)
>>mysql> insert into popup select * from popup2;
>>ERROR 1213: Dead
alan4100,
Tuesday, March 19, 2002, 3:15:39 PM, you wrote:
a> I typed SELECT SYSTEM_USER() ..The output is
a> ++
a> | system_user() |
a> ++
a> | ODBC@localhost |
a> ++
a> 1 row in set (0.00 sec)
a> I then tried mysql -h localhost -u ODBC
a> Welc
I need help from the administrator of this MySQL list.
I am receiving multiple(about 8-13) same mails from the same issue on the list.
I successfully unsubscribed to MySQL list but the mails still coming in.
I tried to unsubscribe a second time but it says that I am not a subscriber.
Can the pe
I just installed mysql fresh out of the box on a fresh SuSE linux 7.1.
mysql does not let me enter german umlauts, though. I tried to start it with
"mysql --default-character-set=latin_de", but it complained about the
character sets not being installed. Then I installed the mysql server, which
Correct me if I'm wrong, but a timestamp field is not meant to be human
updateable (ie. it's solely to record the last change to the record).
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 1:31 AM
To: [EMAIL PROTECTED]
Subject: Leap
You have written the following:
I have a mysql database table that is currently 1.5G in size with well over
a
million records. It is running on a twin pentium 3 1G processor machine with
SuSE Linux version 1.4.
Recently inserts have become VERY slow (several seconds). As I am adding
around
I have a very large mysql table (1.5G) and so will need to implement the
table
RAID option soon.
How do I pick the CHUNKSIZE and number of chunks values?
Howard
-
Before posting, please check:
http://www.mysql.com/ma
1 - 100 of 137 matches
Mail list logo
