Hello,
I just took over and restructured an existing web site
running on IIS/PHP/ODBC/MS Access.
The site is up and running now (thanks to your help too..), but now
the customer is speaking of adding MUCH more content to the database,
(~10/50x increase) and to add search capability all over its
On Sat, Jan 26, 2002 at 07:06:57PM +0200, Michael Widenius wrote:
> Jeremy> I think that the "walking backwards" optimizations were introduced
> Jeremy> in the MySQL 4.0 tree.
>
> That's correct. Simon, could you please download MySQL 4.0.1 and try
> if this works better for you.
>
> We shall a
Hello list,
I am planing to design high-available mysql servers which serve as one
single virtual mysql server to application servers. My criteria is:
1. HA(High Availability)
Due to mission critical services, we hope the mysql clusters can provide
high availability to application servers. In t
In the last episode (Jan 26), Harriet Wheeler said:
> I recently moved from Mac OS X Server 1.x (rhapsody) with MySQL 3.23.27 to
> Mac OS X 10.1 (darwin) with MySQL 3.23.47. Due to an oversight the only db
> backups after the move were in non-gzip'd tarballs that were ftp'd in ASCII
> mode -- ugh
I recently moved from Mac OS X Server 1.x (rhapsody) with MySQL 3.23.27 to
Mac OS X 10.1 (darwin) with MySQL 3.23.47. Due to an oversight the only db
backups after the move were in non-gzip'd tarballs that were ftp'd in ASCII
mode -- ugh. Lots of missing and corrupt files.
All tables are ISAM.
The MySQL documentation (2.6.1 Linux Notes) states that is essential to
run the 'mysqld' process with the highest possible priority on the Linux
2.4 kernel and this can be achieved by adding 'renice -20 $$' to
'safe_mysqld'. Where is the appropriate place in the 'safe_mysqld'
script to place the
i tried to start mysql thinking it was preinstalled on OS X Server.
is it not installed on OS X Server? apparently all of the usual files are
not there?
any insight?
-
Before posting, please check:
http://www.mysql.com/manu
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
At 3:10 PM -0800 1/26/02, Shankar Unni wrote:
>Of course, in the interests of fairness, I should note that typical doubles
>(64-bit IEEE) have about 15 digits of accuracy, which are generally enough,
>as long as you never exceed 10**13 dollars (i.e. no US govt budget work
>:-)). You only have to w
For currency, it depends on your use of course, but fixed-point is
usually easiest. Where you fix the point depends on the precision
you require.
For display purposes it is easiest to use the smallest currency
unit as an integer (e.g. cents). For conversions, daily interest,
etc, you can do
>Description:
Under either mysql 4.0.1 binary RPM from mysql, locally built 4.0.1, or bk set
1.1079,
adding an index to a table causes the number of expected parts in that table
to be set
to 0.
>How-To-Repeat:
State of table (dirty, clean, just rebuilt, doesn't ma
[database,sql,query,table]
Shankar Unni wrote:
> Float has accuracy problems at large ranges. A typical float has a fixed
> number of so-called "significant digits". For 32-bit IEEE floats, that's
> about 6.
Of course, in the interests of fairness, I should note that typical doubles
(64-bit
[database,sql,query,table]
Mark Matthews wrote:
> Or download version 2.0.11 released today which fixes that bug (as far as
> I can tell):
Absolutely. Quick work, indeed. I've already switched over to 2.0.11 and
it's been smooth.
Thanks for the fantastic support!
--
Shankar.
--
> Wednesday, January 23, 2002, 9:43:00 PM, you wrote:
> >> How did you install MySQL? Is it the binary distribution from MySQL or
> >> you have compiled the software from the sources?
>
> AT> I used the rpm inside the SuSE's distribution.
>
> Download the binary distribution from http://www.mysql.
At 14:58 -0700 1/26/02, Mark Stringham wrote:
>What about converting MySQL data to Oracle ?
There's something for this somewhere on Oracle's web site.
That's all I know, never used it.
-
Before posting, please check:
http://
Shankar Unni wrote:
> That's right:
> Do the following in a temp directory:
> jar xvf mm.mysql-2.0.10-you-must-unjar-me.jar
> This will create a directory called mm.mysql-2.0.10. Inside that, you'll
> find a mm.mysql-2.0.10.jar file, which is what you need to put in your
> classpath (you can
What about converting MySQL data to Oracle ?
Thanks
Mark
-Original Message-
From: theOtherOne <[EMAIL PROTECTED]>
To: Ed Lazor <[EMAIL PROTECTED]>; Paul DuBois <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Saturday, January 26, 2002 2:34 PM
Subject: Re: Converting MS
You're right Paul thoses product are realy good, thanx for theses
information.
theOtherOne
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Ed Lazor" <[EMAIL PROTECTED]>; "theOtherOne" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 26, 2002 10:10 AM
S
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Fournier Jocelyn [Presence-PC] writes:
>> Hi,
>>
>> Yes it is 4.0.1.
>> But the first query has also to make a temporary table with 2 million rows,
>> it's why I don't understand the delta between the query without DI
Hi All,
Can anyone tell me if this can be done in a single SQL statement?
Well I have this data stored in a table called _worsdallm which looks
like this:-
id int(10) NOT NULL auto_increment
objectives_id int(10)
data varchar(254)
staff_id int(10)
date timestamp NOT NULL
PRIMARY KEY (id))
I tried (and got back) this:
[mbase:~] ted% safe_mysqld
touch: /usr/var/mbase.err: No such file or directory
chown: mysql: invalid user name
Starting mysqld daemon with databases from /usr/var
/usr/bin/safe_mysqld: no such file or directory: /usr/var/mbase.err [229]
/usr/bin/safe_mysqld: no such
Hi,
I apologize for this too basic question.
I installed MySQL using rpm. But I can't fine
mysql.h and mysql_config on my server. Where are they
from?
More Details:
Environment: MySQL server 3.23.46 and client 3.23.47
on RedHat7.2. MySQL database is running.
Objective: To install MySQL dri
Michael Collins wrote:
> Using MySQL 3.23.47, is the best data type for small currency float(4) ?
> This is for prices of items in a shopping cart for example t-shirts.
>
> What is the difference in using float vs decimal? I know I don't need
> double.
Float has accuracy problems at large ra
On Sat, Jan 26, 2002 at 08:11:12PM +, Paul Reilly wrote:
>
> Hi MySQLers,
>
> What's the best data type to use for a text field of say 500 words
> (~5000 chars)? Can I use VARCHAR(5000) or should I use TEXT or
> MEDIUMTEXT?
>
> Also whats the best column type for a binary upload of an imag
Hi.
I am running Windows 98 and have installed MySQL 3.23.47 under
D:\Program Files\MySQL\. I created C:\my.cnf and it contains the
following:
[mysqld]
skip-innodb
basedir=D:/Program Files/MySQL/
datadir=E:/mysql/
When I start mysqld, I get the following in the error file:
D:\Program Files\MyS
Hi MySQLers,
What's the best data type to use for a text field of say 500 words (~5000 chars)?
Can I use VARCHAR(5000) or should I use TEXT or MEDIUMTEXT?
Also whats the best column type for a binary upload of an image or word
document of say a max 3 MB in size? Should this be a BLOB, MEDIUMBLO
On Sat, Jan 26, 2002 at 07:53:35PM +, John Murdie wrote:
>
> I'd like to see an explicit statement that it is possible to install
> a binary distribution of MySQL in some non-standard place, or not,
> as the case might be. If it *is* possible, I'd like to see full
> instructions for doing this
Using MySQL 3.23.47, is the best data type for small currency
float(4) ? This is for prices of items in a shopping cart for example
t-shirts.
What is the difference in using float vs decimal? I know I don't need double.
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services |||
Using MySQL 3.23.47, is the best data type for small currency
float(4) ? This is for prices of items in a shopping cart for example
t-shirts.
What is the difference in using float vs decimal? I know I don't need double.
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services |||
I've read the document `Installing a MySQL Binary Distribution' that
comes with each Unix binary distribution, and the MySQL manual
(http://www.mysql.com/documentation/mysql/full/), and the DynamicFAQ under
`Installation'
(http://swfaq.mysql.com/sw/bin/17/supportwizard.cgi/07375836),
but have foun
Hi, guys!
Sorry not to provide you with a complete bug report, but it's indeed
the huge amount of time needed to provide you with a "clever" bug
report and it's maybe clear enough case.
This bug appeared right after 3.23.43 version, up to this all tests
were passed just fine. Since 3.23.44 and u
Hi,
> -Original Message-
> From: Mike Nelson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 25, 2002 11:43 PM
> To: [EMAIL PROTECTED]
> Subject: MyODBC
>
>
> Any plans to upgrade the MyODBC driver to support .NET?
>
> I downloaded a copy of MySQL and tested it with a .NET app and
I am sure Paul would not plug his own book, but I will it would help
to have a practical example to follow, so I recommend the book
"MySQL" by Paul Dubois, published by New Riders (check Amazon.com or
your local computer book store).
This will help you with error checking. I know it helped me!
At 9:59 -0800 1/26/02, Ed Lazor wrote:
>At 12:51 PM 1/26/2002 -0800, you wrote:
>>I Scotland,
>>
>>It's not the first time i give this adress:
>>http://www.urbanresearch.com/software/utils/urbsql/
>>
>>Hope This Help ;)
>>
>>theOtherOne
>
>It looks like urSQL allows you to view data from various d
Okay - that was silly of me. I was checking the return values of the
insert and the select, but I never did one for the connect.
It's failing on the connect - I'm assuming that all I have to do is ask
them what the proper way to connect to their database is.
Thanks for your help!
Lisa
At 11
At 12:51 PM 1/26/2002 -0800, you wrote:
>I Scotland,
>
>It's not the first time i give this adress:
>http://www.urbanresearch.com/software/utils/urbsql/
>
>Hope This Help ;)
>
>theOtherOne
It looks like urSQL allows you to view data from various database
formats. Does it handle data conversion
At 9:42 -0800 1/26/02, mike vogel wrote:
>can anyone recommend a command line shell to admin mysql that will
>run under osX? thanks in advance!
What does that mean? From the wording of the question (command line shell),
it sounds like you're asking about tcsh, bash, etc., but from "admin mysql
At 12:36 -0500 1/26/02, Lisa M. Venezia wrote:
>Hi, I am new to this list and was wondering if someone can help me.
>
>I am running very simple SQL through PHP and mySQL to connect to a
>database, add data to it, and display this data. This will
>eventually be used for a guestbook for my organi
can anyone recommend a command line shell to admin mysql that will run
under osX? thanks in advance!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the l
Hi, I am new to this list and was wondering if someone can help me.
I am running very simple SQL through PHP and mySQL to connect to a
database, add data to it, and display this data. This will eventually be
used for a guestbook for my organization, the New York Skyliners Sr. Drum
and Bugle C
hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Fri, Jan 18, 2002 at 12:40:00AM -0800, Simon Kirby wrote:
>>
>> MySQL appears to be having problems walking backwards on the index when
>> starting from a known row.
>>
>> On the web documentation, it looks like this
I have instaled MYSQL on Solaris 2.8 on Intel plataform, and did this
as says the manual, but when try to run it sends a message :
Segmentation fault - core dumped
# bin/safe_mysqld --user=mysql &
# Starting mysqld daemon with databases from /usr/local/mysql/data
Segmentation Fault - core dumped
Thanks for that BB.
How large was the test table (rows and cols)?
Did you test the alternative expressions by conducting a number of queries (to note
the impact of any caching)?
Did putting an index on age have any impact? (I would expect ORDER BY to improve)
Please advise,
=dn
- Origin
Mike Nelson writes:
> Any plans to upgrade the MyODBC driver to support .NET?
>
> I downloaded a copy of MySQL and tested it with a .NET app and received an
> error that this version of ODBC wasn't supported. Just wondering if this is
> on the development horizon.
>
Hi!
We are in the planning
Jeremy Zawodny writes:
> On Fri, Jan 25, 2002 at 03:40:37PM +0200, Sinisa Milivojevic wrote:
> > >
> >
> > Hi!
> >
> > There is a wide choice.
> >
> > You can use either admin modules of mysqlgui or mysql module in
> > MOODSS.
> >
> > Depends on what exactly you need, and on your taste ...
>
I Scotland,
It's not the first time i give this adress:
http://www.urbanresearch.com/software/utils/urbsql/
Hope This Help ;)
theOtherOne
- Original Message -
From: "oliverjd" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 26, 2002 3:34 AM
Subject: Converting MS Acc
Hello again all,
Greetings from Scotland.
Can anyone direct me to where I can get some free software which will
convert an MS Access database to My SQL.
Thanks,
James Oliver
-
Before posting, please check:
http://www.mys
Hello again all,
Greetings from Scotland.
Can anyone direct me to where I can get some free software which will
convert an MS Access database to My SQL.
Thanks,
James Oliver
-
Before posting, please check:
http://www.mysq
Hi There !
I am quite new to this MyODBC topic, though I am used to create Perl
programs connecting to MySQL DBs. Currently I am able to fetch rows from the
DB via MyODBC and show them in a blank document as a table.
Usually this is how I add data into my documents (like invoices, etc.):
I open
49 matches
Mail list logo
