hello.
My server uses "SunOS dns2 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-250",
and my web server software is APACHE 1.3.20 configured with PHP 4.0.6 which was build
with the support of mysql.
The mysql server has several databases that are used by several virtual hosts.
On Wed, Sep 12, 2001 at 03:18:37PM +0200, Marcin Pyla wrote:
>
> Hello,
>
> How I can make my mysql faster ? Can I compile it with special
> options ?
(1) good database design
(2) properly indexed tables
(3) write fast queries
(4) tune the mysql server
(5) add hardware if still necessary
Here'
On Wed, Sep 12, 2001 at 07:55:05PM +0200, Sander Pilon wrote:
> Dear List,
>
> I need to store a set of flags in SQL, as in 20 true or false
> values. The logical choice seems to be the SET type, but does it
> use an index?
I don't think so... It is implemented as a bitmask behind the scenes.
On Wed, Sep 12, 2001 at 09:35:37PM -0500, adam wrote:
>
> I got an idea and thought i would ask around about a recovery plan
> about databases? Currently all i do is dump the databases on to a
> share on an NT box thru a SMB share from the RH 7.1 Linux DB
> server. The NT box is a Compaq CL1850 wh
On Sat, Sep 15, 2001 at 01:12:31AM -0500, Ed Carp wrote:
>
> In http://slashdot.org/article.pl?sid=01/09/13/154222&mode=thread, it is
> written:
>
> - Writing and reading to the same innodb MySQL tables can be done since it
> does row-level locking. But as load increases, it can start being less
hello.
My server uses "SunOS dns2 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-250",
and my web server software is APACHE 1.3.20 configured with PHP 4.0.6 which was build
with the support of mysql.
The mysql server has several databases that are used by several virtual hosts.
At 8:22 PM -0700 9/15/01, Carl Schrader wrote:
>MYSQL
>
>I have a table with a date field. I have a query that needs to output
>only if NOW()
>The issue is this:
>select * from thesites where ED3>NOW()
>
>ED3='1999-12-31 00:00:00'
>
>the above query will output when ED3 is as above. NOW()='2001-09
MYSQL
I have a table with a date field. I have a query that needs to output
only if NOW()NOW()
ED3='1999-12-31 00:00:00'
the above query will output when ED3 is as above. NOW()='2001-09-15
18:10:44'
???
-
Before posting, ple
Hello All!
> Can someone recommend an intro MySQL book. I'm looking for a
> book with info on MySQL
Yes, as others have said, the Paul Dubois book is -excellent.-
> Teach Yourself MySQL in 21 Days ...SAMS..by Maslakowski.. (Takes you
> from Ignorant to Working Project).
Avoid it like the PLAG
Paradox should allow you to export your data in some sort of flat file
format, such as comma separated values (CSV). If so, you can use the MySQL
"mysqlimport" program or the MySQL "load data infile 'filename' into
table..." statement to load the flat files into your MySQL database.
- Origi
MYSQL
I have a table with a date field. I have a query that needs to output
only if NOW()NOW()
ED3='1999-12-31 00:00:00'
the above query will output when ED3 is as above. NOW()='2001-09-15
18:10:44'
???
-
Before posting, ple
Hi!
On Sep 15, Ronald Willis wrote:
> Hello Serg,
>
> I have a quick question. I am new to MySQL but not databases. I have
> installed a default installation of MySQL with Mandrake 8.0. It runs but for
> the life of me I cannot remember the password for any user including root.
>
> I was able t
As I said, I don't know anything about BDB, but I don't see how they could
possibly prevent chaos without locking both all table pages and all index
pages that are being modified by a transaction. And indeed, that would make
a deadlock possible for multi-phase updates on the same row and thereby
q
I can totally understand that, but the problem is, my queries are only
interested in one row each ( accessed by primary key ). Perhaps it has to do
with the extra unique index?
The flow is this:
insert row.
grab newly created primary key ( autoincrement ) + generate a unique 32 byte
char string
Hi list,
Can anyone recommend an ERD modeler for MySQL?
I've tested the evaluation version of "Dezign for databases" and while I
like it and was able to generate an initial schema with it, I couldn't get
it to create SQL to alter the schema after I had modified the initial ERD.
(I was only able
Dana,
a deadlock can easily occur on a single table with row-level (or page-level)
locking. What happens is something like the following:
connectionhas lock on wants lock on
alpha object Aobject B
beta object Bobject A
With page-level locking this would
I've found the answer to my problem in the bdb source...
>From bdb/include/db.src:
#defineDB_LOCK_DEADLOCK(-30996)/* Deadlock. */
So the question is: how can a bunch of simultaneous connections that only
work on 1 table create a deadlock. And how can I write my code to avoid this
At 1:54 PM -0700 9/15/01, Jack Y. Su wrote:
>The www.mysql.com/Contrib/Examples Webpages doesn't exit anymore,
>please tell me where I can get samp_db, or another sample for me
>learn mySQL.
It's available at:
http://www.kitebird.com/mysql-book/
>
>--
>Best regards
>
>Jack Su
--
Paul DuBo
Im getting this error from attempted inserts into a BDB table using
mysql-3.23.42 ( same error but more often in 3.23.38 ):
Could not insert new row into SESSION_DATA: Got error -30996 from table
handler
First - I have not been able to find what this error means in either the
source code, online
The www.mysql.com/Contrib/Examples Webpages doesn't exit anymore,
please tell me where I can get samp_db, or another sample for me
learn mySQL.
--
Best regards
Jack Su
-
Before posting, please check:
http://www.mysql.com/
Bob,
As soon as you compiled and installed perl itself, the Config
module of perl will tell any Makefile.PL driven package where to
install itself: under the directory structure of perl.
I don't know for sure, but I suppose DBI DBD installs via
Makefile.pl script... If not, do a perl -V to see w
i use the paradox and i want move my apps to mysql, but how?
Regards
otro correo: [EMAIL PROTECTED]
---
Runbox Mail Manager - www.runbox.com
Free online email application
-
Before
Other than the manual, "Sam's Teach Yourself MySQL in 21 Days" is a great
book.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "rjtalbo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 15, 2001 3:24 PM
Subject: intro mysql book
> Subject:
>
I think your confusion stems from the fact that
a AND b NOT c
is not a valid boolean expression. You probably
mean to say
a AND b AND NOT c
Lezz Giles
- Original Message -
From: "Libor Matyáš" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 15, 2001 5:25
Subject:
intro mysql book
Date: Fri, 14 Sep 2001 14:18:29 -0700 (PDT)
From: another oracle dba <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Can someone recommend an intro MySQL book. I'm looking for a
book with info on MySQL
**
Now that I have the correct Install procedure for the Perl DBI and MySQL
DBD,
Where is the most common and preferred Location for the Install??
I was considering the following.
/usr/local/
/usr/local/share/
/usr/share/mysql
/usr/share/perl5/
Sometimes a script or program will
First off, the line of code where he has this is wrong::
if (mysql_create_db ($DName, $Link)) {
it should have DBName, not DName. That could be a big issue when executing.
Second, I have no expirience with PHP but am great with ASP and believe that
the term 'echo' would work better than 'print'
I am unable to compile the following code.
I am using Borland 5.5 compiler, Windows 98 & MYSQL for windows I am also using the
C++ API for the connectivity available at the site www.mysql.com
Following are the locations of all the installations
1. Borland :- D:\program files\borland
2. MYSQL
At 4:50 PM +1000 9/15/01, mike wrote:
>I am new to both PHP and MySQL (I have experience in ASP) and am trying
>to get my server running both. I can connect to the MySQL server under
>DOS using the command line and can create new databases this way. I want
>to create a web data site so I need to a
> OK quick question, Is there a limit to the amount of data the can
> be defined
> when I create a field as a set.
64. RTFM.
> I am looking to have about 39
> words in there
> at the moment I have them in another table and have an index pointing to
> them, but would like to move them to a set
Hi list,
I have a question that hopefully someone can help me with.
We have a mysql database which contains 3000 records, and these records need
to be searched.
The table has 4 fields which need to be searched, so we created a full text
index for the 4 fields. Now 1 of the fields contains da
hi,
i'm having the following problem that sort of makes my life miserable :-)
i've been working on a search script that could take a query like this:
(car and bus) or apple not (orange and table)etc.
...basicly any logical statement...and return the right references based on
searching specifi
32 matches
Mail list logo
