Hello Sinisa,
Sunday, February 04, 2001, 3:15:21 PM, you wrote:
SM Peter Zaitsev writes:
SM Hello Andreas,
SM
SM Thursday, February 01, 2001, 7:42:31 PM, you wrote:
SM
SM
SM I must confirm the problem with table locks. Mysql realy may deadlock
SM sometimes, and the funny thing
Can someone please give me a rough estimate of how much RAM MySQL would
require to run something like :
A connection pool of around 50 connections
20,000 users every week re-using these 50 connections
around 50 inserts per user (each row around 30 bytes)
around 20 queries per user
Installation
Hi,
I hope that someone can help me with a SQL statement.
I dont know if this is the right place to ask the question, if not please redirect me.
I have a table in my MySQL database named "data" with the following fields
date: UNIX Timestamp
Datasize : Int
now i would like to do
Description:
My udf function and an equal udf function I found in the internet
seem to work well as does substring_index. Only when I call them
together I get a bug. As my function (quotet below) is so simple
that it doubtly has a bug I guess substring_index has
Hello, I don't understand why my queries are so incredibly slow.
We have MySQL on a 800MHz Linux machine with 513Mb.
Most queries look like this:
SELECT B.* FROM maintable AS M, wordindex AS YL1,
wordindex AS YL2, wordindex AS YL3
WHERE
YL1.Word = 'billy' AND
YL1.RecordNumber =
Hi,
Because of various political issues during the development of our web
site, it has been suggested that the web server and php scripts should
be connected to the database server via a shared 2Meg WAN connection. As
I am rather green when it comes to setting up internet sites which use
Does anybody know what is the fastest way to run a large multiple
AND type query on a many-many table and the least memory hungry.
Sir, what is a type query, and what in the world is a many-many table?
For example if I have
create table test (id int, value int);
which has many-to-many on
Sir, in the first SQL statement, you could use
HAVING cnt = (DAYOFYEAR(min)-DAYOFYEAR(max)) + 1
Of course, this won't work if min is in the year 2000 and max is in
2001. I think this will actually be easier to work out in your
client, assuming you have a programmable client.
Hi Bob,
Many
Tim Samshuijzen [EMAIL PROTECTED] writes:
Anyone out there who wants to save me and our company?
You missed the important first step: EXPLAIN the query.
--
Dave Hodgkinson, http://www.hodgkinson.org
Editor-in-chief, The Highway Star
Hello
Another possibly related FULLTEXT problem: in 3.23.32, if the table
contains one row only, then a fulltext match occurs regardless of the
pattern you search for:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
id mediumint unsigned NOT NULL auto_increment,
tag char(6) NOT NULL
Eric Fitzgerald writes:
Let's try this one more time, just in case it got scimmed over :)
Hello everyone.
I'm hoping the developer of MyODBC hangs out on this list, but here goes. I
browsed through the sources a bit, and I noticed several places where you
are mapping SQL_BIT type
Scott C Strecker writes:
Description:
When I try to run the install-db script I get an error stating that
the script Can't create interrupt-thread. I can get the script to run as
root. We are installing into /usr/local/mysql as per the instructions.
Hi,
I attempted to install MySQL 3.23.32 on a Solaris 8 Intel.
The version of cc I have is gcc 2.95.2.
The version of tar I have is gnu tar 1.13.
I encountered a problem while issuing this command :
o ./configure --prefix=/usr/local/mysql
The error message is :
o checking return type of
Are "Heap Tables" possible solution for Real Time Data Base ?
Is there other options in MySql world ?
Thanks
Paulo Roberto
we are setting up an Arabic web site using PHP with MySQL 3.23.22.
Our problem is that we can not sort data correctly when retreiving it
from Arabic text fields. This seems to be a character set problem.
Has anyone any idea about using the Arabic character set with MySQL?
Hi,
This is
Have you create a startup script in /etc/rc.d?
I believe you haven't created a startup script and you should type in ps -gax
to see if mysql is running.
On Tue, 06 Feb 2001, Vadim Selitskiy wrote:
Hi
How are you?
No, I used rm command to delete, because rpm told that it is unable to
Could someone point me in the right direction with this problem please?
I ran a perl script and this was the error message
$ perl connect.pl
install_driver(mysql) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.so' for module
DBD::mysql: Shared object
Have you tried checking the Path info for your mysql account?
Sometimes, the Path does no point to the correct gcc, I would test this
withtwo commands:
gcc -v or it is gcc -version (can't remember right now)
which confirm what you said.
AND
type 'which gcc' to make sure your installation is
Tim,
1. i'd remove 1 Mb from your 513 Mb machine... maybe it's an very old edo
simm or something.
2. you put an index on all requested fields (maintable.recordnumber and
wordindex.word) ? I bet not.
- Original Message -
From: "Tim Samshuijzen" [EMAIL PROTECTED]
To: [EMAIL
Dear Dave,
Thanks for your reply.
(The table actually works with word numbers, as the words
are present in a hash table. I explained it the way I did
because functionally it is the same. So the actual search
is for WordNumber values instead of Word values.)
I did the EXPLAIN as you
You need to install DBD mysql DBI, you can download these at cpan
(www.cpan.com) or at the mysql website (www.mysql.com) the installation is
fairly simple, you need to extract the source to a directory and then do:
perl Makefile.pl
make
make test
if the make test succeeds
make install
you
Description:
We have a mysql-slow.log activated. We found many queries with a Time of 0.
See here:
# Time: 010206 13:54:51
# User@Host: xx[xx] @ xx.mobilcom.de [xx]
# Time: 0 Lock_time: 0 Rows_sent: 18
select st_klasse,st_wert from stati group by st_klasse,st_wert order by
[EMAIL PROTECTED] writes:
Description:
Sometimes, when you get a resync error, you need to skip
a particular update and restart with the next bit.
How-To-Repeat:
Insert conflicting records and try to re-sync without deleting one.
Fix:
Apply this patch.
Can anyone help?
In this script is one bug but i can't find it :(
create table top(
Id int(11) DEFAULT '0' NOT NULL auto_increment,
nadalnumeric,
kuupaev DATE,
usa1 text,
usa2 text,
usa3 text,
usa4 text,
usa5 text,
hi..could someone pls help me
i had created mysql server before in my pc but this morning i discovered
that i cant access my mysql server.this is what i typed:
shell mysql
this is what i got:
ERROR 2002:Can't connect to local MySQL Server through socket
'/tmp/mysql.sock'(111)
what
Is there any idea in using both a INDEX() and UNIQUE() index on the same
table field ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Please help me I'm going nuts...
I installed mysql with the DBD adn everything on two machines running PB. One one (my
home computer), everything is fine, on the other one (the server in my office), when I
try to run something based on the DBD (such as the bench), I get:
As an example to my problem, I have 2 tables, T1 and
T2.
T1's fields are Common,T1Field1,T1Field2 (Common is
the primary key and it is autoincrement)
T2's fields are T2Field1,Common,T2Field2 (T2Field1 is
the primary key)
I created a view using "SELECT
Dear Dave,
Here is the output from vmstat 5:
vmstat 5
procs memoryswap io system
cpu
r b w swpd free buff cache si sobibo incs us sy
id
0 0 0 3936 2980 10568 218856 8 411 33 9 0 3
10
0 0
Hi Tom,
I see from your error message that you have already installed DBI
yes? Your problem is you need to add the mysql library to your
ldconfig (Dynamic library list). I don't know what platform you are
one, for my plaforms I edit /etc/ld.so.conf and add the line
/usr/local/lib/mysql
i've heard it said that every so often (eg every month) you need to rebuild
indexes on tables, as over time they lose their performance enhancement.
could that be true?
dan
-Original Message-
From: Tim Samshuijzen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 February 2001 04:50
To:
How do you decide when a table should go into another database. For
example, I have a database with about 12 tables and growing. I keep
them in one database because I am doing joins that periodically involve
all of the tables. Is this the right way to do it?
Richard
I am a DELPHI developer and I need to know if exists
a MySQL driver for DELPHI.
Does MySQL have a driver for DELPHI???
If it does, please send me it...
My e-mails: [EMAIL PROTECTED]
[EMAIL PROTECTED]
... at least I´d like to know if it does or it
doesn´t and
Sorry I really wouldn't know this one :-) You might consider asking the
question also on one of the website where the perlfreaks are. www.cpan.com
or www.perlmonks.com. Personally I'd try installing the latest version of
perl DBD DBI mysql, however I don't know the strtol.o file and it might
be
Hello,
I'm trying to install MySQL without success.
I have installed MySQl with the RPMs (server+client), everything works
well, I do "mysql_install_db" and I launch the daemon "safe_mysql ".
But when i tried to shutdown it, I've got an error whitch is :
mysqladmin: connect to server at
in manual:
-
DECIMAL[(M[,D])] [ZEROFILL]
An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR
column: ``unpacked'' means the number is stored as a string, using one
character for each digit of the value. The decimal point and, for
Ren,
Ok, here is a real representation of the tables
involved:
mysql EXPLAIN maintable;
+---+-+--+-++---
-+
| Field | Type| Null | Key | Default| Extra
|
Hi,
I am a new user of Linux and mysql and i have installed suse7.0 on my pc to
start working on mysql.
(my pc is not connected to network).
I had some problems running mysql because (i think) MySQL server was not
running.
I read some part of the manual
Dear Dan,
Thanks for your reply.
I've already done OPTIMIZE for all tables.
I suppose that's the same as rebuilding the indices.
Tim
At 01:26 AM 7-2-2001 -0800, you wrote:
i've heard it said that every so often (eg every month) you need to rebuild
indexes on tables, as over time they lose
On my linux distribution of Suse 7.0 kmysql was installed as part of the kde
window manager. If you do a web search for kymsql you can find it there also.
Joel Holtzman wrote:
Thanks. WHere do I find this? Are the instructions in english? It's
frustrating getting spanish/german sites since I
What it looks like i'm going for is the following setup
30gb eide hdd
celeron 700Mhz processor
256MB RAM
red hat linux
mysql
apache/tomcat
I'm a bit worried because the database is on the same server as the website.
Will the machine fall over because it doesn't have enough ram/CPU power (for
Hi,
well, the query is over a network. Single switch with two VLANs between the
systems, network speed is *200MBit/s*. The php code structure executing was:
... prepare query ...
mysql_connect();
mysql_query();
mysql_fetch_row();
mysql_close();
... process and send data to browser ...
The table
Bob Hall wrote:
I want to do a select like
select id from test
where id in (select id from test where value in (1,2,3)
and id in (select id from test where value in (4,6,7)
and id in (select id from test where value in (1,6,25)
Even if MySQL supported subqueries, this query would
Greetings.
I just installed mySQL( mysql-3.23.29a-gamma-sun-solaris2.8-sparc) on a
E150 using the script mySQL/configure..
One of the msg that was printed was to change the root password.
however to change the root password you need to know the original
password(s).
What are the default
In the process of converting over to 3.23.30-gamma from 3.22
It appears that a table with field 'key varchar(16) binary' as a
primary key.
Whenever I write a record to this table and then do a select the value
of the field seems to be zero.
I do a 'select * from table where key=0x0' I get all
Paulo Serra wrote:
I am a DELPHI developer and I need to know if exists
a MySQL driver for DELPHI.
Does MySQL have a driver for DELPHI???
If it does, please send me it...
MySQL doesn't have a BDE driver. Actually, I don't know of many vendors
doing that for windows
Andreas Steinmetz writes:
Hi,
well, the query is over a network. Single switch with two VLANs between the
systems, network speed is *200MBit/s*. The php code structure executing was:
... prepare query ...
mysql_connect();
mysql_query();
mysql_fetch_row();
mysql_close();
...
It took me all of about 2 seconds to locate this;
http://www.fichtner.net/delphi/mysql.delphi.phtml
try hotbot it works great :p
Paulo Serra wrote:
I am a DELPHI developer and I need to know if exists
a MySQL driver for DELPHI.
Does MySQL have a driver for DELPHI???
If it
HI PEOPLE:
WHAT CAN I DO TO NOTE WHEN A NEW REGISTER IS INSERTED
INTO A TABLE.
THANKS , SEE YOU LATER.
=
there are too many more mindS to free
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
Try this
SELECT * FROM maintable AS M, wordindex AS YL
WHERE
YL.Word IN ('billy' , 'bob' , 'john' )
AND
YL3.RecordNumber = M.RecordNumber
AND
M.Price = 1000
LIMIT 0,50;
Your query is probably slow because you are cubing the size of the wordindex
by invoking it three times
-Original
How many times can I join tables together? What about joining a table to itself?
I checked the maillist archive/manual but cannot find a definite answer (searched on
"max number of joins", "joins")...I'd though it would be in section 7.20 of the manual
but it wasn't.
Thanks.
Bill
---Reply to mail from Daniel Kirk about MySQL Memory Requirements...
What it looks like i'm going for is the following setup
30gb eide hdd
celeron 700Mhz processor
256MB RAM
red hat linux
mysql
apache/tomcat
I'm a bit worried because the database is on the same server as the website.
On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote:
Date: Mon, 5 Feb 2001 13:11:51 -0800
From: [EMAIL PROTECTED]
To: Gus Constan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Port 3306
Add --skip-networking to your my.cnf file or pass it on the command line to
safe_mysqld. This will
Hi,
the inserts did not change the state after the select finished. The network is
running full duplex but the only problem I ever encountered with the cards was
initalization on fast systems. I fixed this and posted it to the linux kernel
mailing list (search for epic100).
If the problem
hi:
Here is my SQL statement to select a range of number from 0-9
Is there a short cut to this?
id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id
like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%'
thank you
seng
Im new to the list, apologies if this has been asked before.
Im developing a backend for a personal site (www.russd.com) using mySQL.
The site is hosted on NT4 and has myODBC installed, I have some database access
working, but I'm looking for a way to implement boolean types.
Using Access/SQL
Maybe you need to add the -p option so that it asks you for your password
before you can shutdown
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
woops, my fault :)
I'll subscribe to the MyODBC list and see what I can find there, thanks :)
- Original Message -
From: "Sinisa Milivojevic" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 4:03 AM
Subject: Re: MyODBC and SQL_BIT type
Description:
I have a perl script which gathers data and then performs multiple inserts
into a mysql database via DBI and DBD::mysql. On a OBSD 2.7 box runing
the same version of mysql, the script works just fine. However, when i run
the exact script on
Unix sockets are about 30% faster than TCP connections on the local machine
-- at least according to TCX's tests and some of my own.
"William R. Mussatto" [EMAIL PROTECTED] wrote:
On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote:
Date: Mon, 5 Feb 2001 13:11:51 -0800
From: [EMAIL PROTECTED]
To:
Description:
Sometimes, when you get a resync error, you need to skip
a particular update and restart with the next bit.
How-To-Repeat:
Insert conflicting records and try to re-sync without deleting one.
Fix:
Apply this patch.
Index: noris.38/sql/mysqlbinlog.cc
-Original Message-
From: Ung, Seng
Sent: Tuesday, February 06, 2001 9:03 AM
To: [EMAIL PROTECTED]
Subject: Select a range from 0-9 or A-z
hi:
Here is my SQL statement to select a range of number from 0-9
Is there a short cut to this?
id like '1%' or id like '2%' or id like '3%' or
Redhat comes with mysql already installed as a RPM usually. I had the
same problem until I unstalled the RPM that came with Red Hat. A fix
for this problem if you don't want to uninstall the original can be found
at:http://www.mysql.com/doc/I/n/Installing_many_servers.html
I copied and pasted your create table query into mysql and it created the
table without a problem. I'm using 3.32.32.
mysql describe top
- ;
+-+---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
I am working with an NT4.0 platform, mySQL 3.23 and using ASP and myODBC to access my
data.
I was hoping to find a BOOLEAN data type within mySQL which would allow me to pass
either 'True' or 'False' in - but it appears there isn't one?
Using 'BOOL' as the column type appears to create a
"Ung, Seng" wrote:
hi:
Here is my SQL statement to select a range of number from 0-9
Is there a short cut to this?
id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id
like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%'
see REGEXP
Try using this function on your data before inserting into the database.
http://www.php.net/manual/en/function.addslashes.php
If that doesn't work show us what error you are getting.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05,
Serveur d'application JBossI got a problem with my connection to a Mysql Database. (
am
programming with JSP, using a JDBC driver...)
The problem is that I got an Error 500 when I am trying to
connect to my database ... Actually, There is a "Bad Handshake"
error ...
I don't know what is it
I have a Perl program that gathers data and inserts it into a Mysql
database via DBI (DBD::mysql). The program performs multiple inserts, one
right after the other.
On my OBSD 2.7 box, everything works just fine -- but when I try to run
the same script on my OBSD 2.8 box, it will run through a
Try:
select whatever from whatever where field like '[0-9]%'
http://www.mysql.com/doc/P/a/Pattern_matching.html
-Original Message-
From: Ung, Seng [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 9:03 AM
To: [EMAIL PROTECTED]
Subject: Select a range from 0-9 or A-z
hi:
i just answered my own question:::
shell mysql -u root mysql
mysql UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql FLUSH PRIVILEGES;
You can, in MySQL Version 3.22 and above, use the SET PASSWORD statement:
shell mysql -u root mysql
mysql SET PASSWORD
Why not try using ENUM?
http://www.mysql.com/doc/E/N/ENUM.html
You could setup your table like this:
CREATE TABLE logInfo2
(
logID INT NOT NULL UNIQUE,
ipAddress VARCHAR(20) NOT NULL DEFAULT 'None',
boolVarsENUM ('T', 'F') DEFAULT 'F'
)
SELECT ipAddress
Check out REGEXP in the manual.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
-Original Message-
From: Ung, Seng [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 11:03
To: [EMAIL PROTECTED]
Subject: Select a range from 0-9 or
In the process of converting over to 3.23.30-gamma from 3.22
whenever I set the field to a binary field to a value it stores it in
the database as zero.
Does anyone have any suggestions.
I am having a problem with the binary data type... Here is the log to
demonstrate.
Can/should MySQL be started *without* --skip-locking on Redhat
6.1 Linux?
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
-
Before posting, please check:
Thanks for the suggestion, but this would still mean converting the data
type from within ASP (the 'True' type) down to a char ('T') would it not?
It is more sensical than using 1/0 but still involves the same number of
processes?
Russ Davies
- Original Message -
From: "Oson, Chris
Maybe, but you could define a constant..
CONST TRUE "T"
CONST FALSE "F"
INSERT INTO logInfo2 (logID, ipAddress, boolVars) VALUES (null,
'192.192.192.192', TRUE)
-Original Message-
From: Russ Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 11:44 AM
To: Oson, Chris
How do I save an images to a unix file that is saved in mysql? I know how to view the
image with PHP and I know how to write a file to unix. I just can't get the data from
mysql into a format that will allow me to read it then write it.
Hi All,
I'm trying to port MySQL 3.22.32 to HPUX 10.20 and am encountering some
problems. I'm on an HPUX 10.20 box with GCC 2.95.2, the configure script
works fine when I build I get:
mysqld.cc: In function `void close_connections()':
mysqld.cc:262: implicit declaration of function `int
Terribly simple question, but I'm fairly new at this.
I'm building a database based off a model built in MS Access. The table
that I'm currently working on appears to have two Primary Keys, although I'm
assuming one of them must be secondary. How would I specify this in
creating the table in
"RD" == Russ Davies [EMAIL PROTECTED] writes:
RD Thanks for the suggestion, but this would still mean converting the data
RD type from within ASP (the 'True' type) down to a char ('T') would it not?
then use
ENUM('False','True')
instead. Enum can have any string you want. I personally
Hi,
Do you mean that the table has two unique indices, or that the primary index
has two columns?
Either way, it is easy to define this in mysql:
create table foo (
col1 varchar(20) not null,
col2 int not null,
col3 smallint not null,
primary key(col1, col2),
unique second_idx(col1, col3));
Enum would allow me to have two values such as 'True' and 'False' ?
The problem is when I pass in this SQL statement to mySQL:
INSERT INTO tableName (fieldName) VALUES (True);
-mySQL does not recognise the word True - it would need to be in quotes,
which means changes in the code on the web
Couldn't you just do:
boolVarsENUM ('True', 'False') DEFAULT 'False'
-or-
boolVarsENUM ('TRUE', 'FALSE') DEFAULT 'FALSE'
unless I'm misunderstanding what you are saying about ASP.
-Original Message-
From: Russ Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
It's ok for a table to have 2 keys that COULD be the PIKE. only 1 of them
can actually BE the PIKE, the other is a Candidate Key. (CK)
As to whether you should make them both part of the PK, that's a different
question. I usually avoid compound PK's unless there is NO OTHER WAY AROUND
IT.
Cal
When a True data type is passed in from ASP, the resultant SQL command will
look like this :
INSERT INTO tableName (fieldName) VALUES (True);
Not this :
INSERT INTO tableName (fieldName) VALUES ('True');
So produces an error as the value is not enclosed in quotes, which it would
need to be for
I have read that IBM has concluded that Linux is ready for the big time.
That may be true for Linux but I would doubt that the same could be said
for MySQL. For example the missing host.frm has been in threads in the
archive for a long time, I have been
bitten by the beast with no success yet in
I use True/False fields all the time from MS Access through myODBC. While
I've not used ASP, it would seem that the functionality would be the same.
If this is the case, then True is represented by -1 and False is
represented by 0. Simply use the TINYINT that mySQL provides to store
these two
http://www.mysql.com/doc/A/d/Adding_functions.html
Could this help him out? Creating a User Defined Function?
Gregg
- Original Message -
From: Russ Davies [EMAIL PROTECTED]
To: Matt Friedman [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 3:42 PM
Let me add to this. I meant to say: He could create a function that would
do it, and use it in his queries?
Gregg
- Original Message -
From: Gregg Housh [EMAIL PROTECTED]
To: Russ Davies [EMAIL PROTECTED]; Matt Friedman [EMAIL PROTECTED];
MySQL List [EMAIL PROTECTED]
Sent: Tuesday,
Hi,
mysql -vvv samp_db create_member.sql
should tell what commands mysql is executing.
Regards
Quentin
-Original Message-
From: Michael Tuminello [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 7 February 2001 10:05
To: [EMAIL PROTECTED]
Subject: creating tables from the shell
Hey -
Thanks for the responses. Both those comments will no doubt help me
out next time. this time around, pathetically enough, it was bad
line breaks due to the fact I decompressed it on a mac and then
uploaded it.
how embarasskin.
MT
I am trying to setup some sort of loadbalancing and more importantly
fail-over-services for my mysql servers. I would like to have all the data
stored on a RAID interface that will mirror the data and provide the data to
two separate mysql daemons on two separate boxes. That way if one daemon
Take your pic - personally, I usually use a tinyint, and assign a 0 or 1
- I suspect the options you describe would work just as well.
regards,
P
On Tue, 6 Feb
2001, John Halladay wrote:
If I am using MS Access and linking to tables in MySQL through MyODBC, what
is the equivalent format of
Woah! 800,000 visits a day!? Wow... try 80,000.
-Original Message-
From: Ryan Hadley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 5:25 PM
To: [EMAIL PROTECTED]
Subject: Performance issues.
I'm not much of a db admin so I really don't know how to get better
performance
Thanks for the quick response.
The response time is slow... and the mysqld processes are what is hogging up
the system.
We do have indexes on the fields, but from what I understand, when you use a
"LIKE" statement, it rarely uses an index.
-Ryan
-Original Message-
From: Kent Hoover
How do you decide when a table should go into another database. For
example, I have a database with about 12 tables and growing. I keep
them in one database because I am doing joins that periodically involve
all of the tables. Is this the right way to do it?
Richard
Richard, I'm not
Nope...
It's stated explicitly in the docs that this is a *Bad Idea* (with caps,
even! *grin*). You'll need to look at other options - replication,
possibly, either on to the same machine with your db on a different
drive, or (probably preferable) onto a seperate box.
regards,
P
On Tue, 6
thanks for your advice vivek rafael.
can anyone tell me why someone tried unsubscribing me from this list? Bit
rude I thought, esp with no explanation. I don't mind being told if my
questions are in the wrong place or anything like that.
dan
-Original Message-
From: Vivek Khera
Just a side note... you can do JOINs on tables from different databases on the same
mySQL server
eg
SELECT t1.UserName FROM db1.table AS t1, db2.anothertable AS t2 WHERE t1.UserName =
t2.UserName
As for database layout... I would go with what makes the most sense... If having 84
tables in
1 - 100 of 136 matches
Mail list logo
