long the
lines of "What's the most interesting thing to do
in DB development" and similar have almost always been answered with
"Getting an optimizer to actually optimize queries
really well."
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
How heavy is your usage of TEMPORARY TABLES? I don't use them much
myself, but
I'm sure that the others on the list will have something to say in that
regard.
To get a better look at MySQL's usage of memory, you could try looking
at the output of
SHOW STATUS .
Regards,
hardware. A change in
the number of files used to store the data is extremely unlikely
to resolve these problems given all other variables in the environment
remain fixed.
What does everyone else think?
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
kes the BIT field act just like a
single-bit field.
Regards,
Chris
Sure -- but I did say it was only 'slightly annoying'.
TINYINT(1) which works fine but is slightly annoying because
> of the extra type conversion needed every time you use it.
It just means with an ODBC programming
can then try again if it doesn't feel totally
small and humiliated.
Hope this helps!
Regards,
Chris
Chris,
When my MySQL database gets into a deadlock situation like
that, I just shutdown the server, power off the machine and go home.
Works every time.
Mike
(Sorry, it
On Tue, Dec 16, 2003 at 10:13:39PM +1100, Chris Nolan wrote:
> There are a few things that could be happening:
>
> Are you using persistant connections from your web servers,
Yes - with Apache::DBI under mod_perl
> 2. Which FS are you using? The native Solaris FS needs a bit of
ro Administration" they reckon. Log files do not
exist seperately, they exist inside the
same file that holds everything else! Not good! You need to do a
"reorganise" every few weeks or things start
to...well..err...suck! Give me MySQL any day!
Regards,
Chris
--
MySQL
Chris Allen wrote:
On Tue, Dec 16, 2003 at 10:13:39PM +1100, Chris Nolan wrote:
There are a few things that could be happening:
Are you using persistant connections from your web servers,
Yes - with Apache::DBI under mod_perl
Well, that's one option out of the way,,,
2. Whi
On Wed, Dec 17, 2003 at 03:53:04AM +1100, Chris Nolan wrote:
> >
> >The DB is on a vanilla UFS partition. Do you have any references about
> >this? I couldn't find anything on the MySQL site...
> >
> >
> >
> There's nothing on the MySQL site
force'.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Please could you shed some light on what has gone wrong.
Many Thanks
Chris Man
Business Systems International
BSI House,
59 Markham Street,
London SW3 3NR
Tel: 020 7352 7007
Fax: 020 7352 7
32-bit filesystem limits?
Looking at any modern Linux FS, your file size limits are not hindered
by 32-bit anything or even
the FS itself. On kernel 2.4, internal kernel structures limit the
maximum size of block devices to around 1 TB.
As a result, you can "only" have files of about that size (
.d script that starts mysql; then (assuming the
kernel is going to allow it) mysql will be able to change the number
of file descriptors it can open, to the best of my knowledge.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
QL to use it. My question is how much larger is the distribution
going to be by Embedding MySQL and were can I read more about embedding
MySQL? I am planing on doing my development with Borland Kylix, and C++
Builder.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysq
ithout issue for a good 3
months. Recently the load has increased, but only from .3 to .5 queries
a second.
Anyone have any ideas on where I should start looking?
Thanks,
Chris
--
Chris Cameron
UpNIX Internet Administrator
ardvark.upnix.net
bitbucket.upnix.net
--
http://www.upnix.com
BoyID INT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (BoyID)
);
#slight change here
CREATE TABLE toy (
ToyID INT NOT NULL AUTO_INCREMENT,
BoyID INT NOT NULL,
name CHAR(30) NOT NULL,
PRIMARY KEY (ToyID)
);
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysq
Michael Stassen wrote:
mos wrote:
Ok, put your thinking caps on because this one bit of a toughie.
I an Update statement that will insert a '/' in front of the *first*
lowercase letter of a field value.
Example: "ABCDef" becomes "ABCD/ef".
Of course it doesn't always end in "ef" and could be an
2 or 3
lower case letters at the end of the string.
I love arguing about regular expressions... but maybe not the best topic
for a MySQL list I guess we should take any further discussion on this
off the list.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
se SQL_CALC_FOUND_ROWS.
Documented in http://www.mysql.com/doc/en/SELECT.html
You run your first query with SQL_CALC_FOUND_ROWS, then once you're
done with it, you run another ("SELECT FOUND_ROWS()") and you get the
total resultcount you would have got, had you not LIMIT'ed it.
--
Chr
word',
'$Email', '$FName', '$LName', ";
$query .= "'$StreetAddress', '$AddressLine2', '$City', '$State', '$ZIP')";
$result = mysql_query($query);
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am having trouble revoking the rights of the anonymous user or setting
a password for that user. Can some one help. I can just do an update
or delete but I want to do it with revoke and set password.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Caroline Jen wrote:
Hi, I tried to create a table. This table has
seventeen fields. My create table syntax gets too
long and I was only able to specify 5 fields at the
mysql prompt in the DOS window (DOS does not accept a
command beyond certain length). How do I put the rest
12 fields in the ta
gt; >delete from new_table;
CREATE TABLE new_table LIKE old_table;
Available from MySQL 4.1 up:
http://www.mysql.com/doc/en/CREATE_TABLE.html
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
alues on the ordered
attribute AND you put the effort into ensuring that the table's ordering
characteristic didn't change much.
Regards,
Chris
On Sat, 2004-01-03 at 09:50, Casey Sheridan wrote:
> In MS SQL Server 2000, it is possible to create what MS refers to as
> "clustered i
around seems to have not produced any
fruitful results.
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL manual stating
they were related. The only reason I didn't use TIMESTAMP from the
outset is because we don't want the time part of the field. I think we
can spare the extra few bytes per row though, so I'll probably use
TIMESTAMP fields anyway.
Thanks again!
Regards,
Chris
On
m using MySQL 3.23.56 on Linux RedHat 8, and have tried inserts via
Perl DBI as well as via SQL command line.
-Chris Seidel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n't realize there was a max_allowed_packet parameter.
Thanks,
Chris
On Mon, 5 Jan 2004, Keith C. Ivey wrote:
> On 5 Jan 2004 at 13:06, Chris Seidel wrote:
>
> > However, I found my inserts failing when some of my
> > strings exceeded 1 MB (e.g. a string of 1125921 bytes fails
have thought
this could be specified in my.cnf, but it doesn't seem so.
I can now insert large entreis into a mdeiumtext field with no problems.
Thanks!
Chris
On Mon, 5 Jan 2004, Chris Seidel wrote:
> Hello,
>
> I have a table in which one of the column types has been
> d
Roger Baklund wrote:
. . . one could check with the Oracle of Delphi...[2] ;) . . .
I think that is the best possible answer the question.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
g in the relevant mailing lists.
4. (Dare I say it) Pick another RDBMS that uses a process-per-connection
model like that evil Oracle contraption or that funky-lookin'
elephant-promoting feature-heavy bohemeth PostgreSQL.
5. Use FoxPro, realise how lucky you are and manufacture some
contentment in running MySQL on a single machine. :-)
Hope this helps / amuses!
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, 2004-01-09 at 20:58, Andy Bakun wrote:
> On Thu, 2004-01-08 at 05:24, Chris Nolan wrote:
>
> > 3. Wait for a while. Linux 2.6 includes (as does the RedHat 9.0 and
> > ES/WS/AS 3.0 kernels) NPTL - the Native POSIX Threads for Linux
> > implementation which is superi
I was wondering if anyone could recommend a good web hosting company for
an Apache - php - MySQL project. I don't need much bandwidth or disk
space to start out, but may need more if the site gets big. I would
also like to have ssh access to the server, preferably a linux server.
Ch
I have the following 2 tables.
CREATE TABLE User (
UserKey INT NOT NULL AUTO_INCREMENT,
UserIDCHAR(16) NOT NULL UNIQUE ,
Name VARCHAR(20),
PRIMARY KEY (UserKey)
);
CREATE TABLE FriendList(
UserKey INT NOT NULL,
FriendKey INT NOT NULL,
PRIMARY KEY (UserKey, FriendKey)
I have the following 2 tables.
CREATE TABLE User (
UserKey INT NOT NULL AUTO_INCREMENT,
UserIDCHAR(16) NOT NULL UNIQUE ,
Name VARCHAR(20),
PRIMARY KEY (UserKey)
);
CREATE TABLE FriendList(
UserKey INT NOT NULL,
FriendKey INT NOT NULL,
PRIMARY KEY (UserKey, FriendKey)
Can anyone tell me if mysql supports Merge Replication as per MS SQL Server?
This is a prerequisite for us considering a move
Regards
Chris Wruck
Pro-Ma Systems (Aust) Pty Ltd
aving cnt>1 order by cnt;
Is perfectly valid syntax.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I wanted to run by everyone what I am doing in my application to help
prevent someone from inadvertently or intensionally breaking the system
and compromising security. First some quick background. This is an
Apache/php/mysql project. It is a wish list database where people can
create an account
and funky folk at
MySQL AB ship falls under the GPL. Previously, many libraries appeared
under the LGPL, allowing you to link against them without needing to use
a GPL-compatible licence.
Hope this helps! I went through a very similar issue recently myself.
Regards,
Chris
On Fri, 2004-01-16 at 02
s a shortcoming that means it compares ENUM values based on
their string representations, not their index in the enumeration).
Otherwise, using InnoDB tables with foreign keys might make you feel
safe with the object_class specifiers being in a seperate table.
Hope this helps!
Regards,
Chris
On F
n application for it.
Regards,
Chris
On Fri, 2004-01-16 at 18:18, Dan Nelson wrote:
> In the last episode (Dec 31), Harta Teo said:
> > Just wondor how InnoDB handle Multi Level Transaction, For example,
> >
> > BEGIN
> > DELETE FORM table1 WHERE id = 123
> > B
.
Regards,
Chris
On Fri, 2004-01-16 at 23:21, Ugo Bellavance wrote:
> > -Message d'origine-
> > De : I.P. [mailto:[EMAIL PROTECTED]
> > Envoyé : Friday, January 16, 2004 6:41 AM
> > A : [EMAIL PROTECTED]
> > Objet : Mysql 4.1.1 and PHP
> >
>
volved in your query around the rows that have been returned bt a
SELECT ... FOR UPDATE. As your selects return nothing, InnoDB doesn't
find any index sections to place any locks on.
Perhaps you should look at using the SERIALIZABLE level of transaction
isolation.
Regards,
Chris
>
Hmm...have you looked at Rekall?
www.total-rekall.co.uk
Also, you might want to check out OpenOffice.org's database interface
features
Regards,
Chris
On Sat, 2004-01-17 at 11:12, Bryan Koschmann - GKT wrote:
> I wanted to thank everyone for their responses and information regarding
&
Hi!
You're looking for the function my_free(). Enjoy!
Regards,
Chris
John McCaskey wrote:
I have the following code:
//try the mysql connection
mysql_init(&mysql_connection);
if(!mysql_real_connect(&mysql_connection, db_host, db_user, db_pass,
db_d
SC LIMIT 10
Then just don't use the EntryDate column from the query. It's worth a try.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
' );
The above query obviously does not work. But I hope you get the
idea of what I am trying to do. I won't have the value of '3' to specify
in the WHERE part of the query as that value is going to be a result
of the set. But using that value, I need to get the records fro
columnA 's value
was, instead, '1,4,6,8,9,13,14,15', that row would still match (when it really
shouldn't) because of the '13' within the string. The '3' from table2.columnA
is part of the table1.columnA string.
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
trieve any entry that has
startdate < '2004-01-%' and enddate > '2004-01-%' ?
Just use startedate < '2004-01-01' and enddate > '2004-01-31'
That will find anything with a start date before Jan of 2004 and an end
date after Jan of 2004.
he
wrong syntax or if it's simply not possible with SQL/MySQL.
thnx,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
x27;" part of the query, once side (or the other)
of the operand would have data, supplied by my code, in the quotes.
If the variables aren't set, the value won't be part of the operation and
as such, that particular CASE would resolve.
Thanks for any help anyone can provide. I'
I've had some very weird issues that I've posted about here in the
past, but no one was able to help. I posted a bug report on mysql.com
and have received some advice on how to suppress the problems I was
having. The problem seems to be exploited when running a slave server
on OSX 10.3.x; alt
n a comment at the
bottom:
http://www.mysql.com/doc/en/ALTER_TABLE.html
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that our
cardinality would create such an accurate graph (graph the points and see).
You can see by the times above that this is unnacceptable. Creating the same
indexes on a MS SQL takes much less time and each index (aside from the
initial cluster index) takes the same amount of time.
Thanks.
Mike,
Thanks for the input. I also received this tip from Peter of the MySQL team.
We'll see if it works.
Chris.
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 3:03 PM
To: Chris Fossenier
Cc: MySQL List
Subject: Re: Index Creation Bottle
would be made after the release of
the new compressed format?
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is the general format for querying a database
using hyperlinks?
example: http://www.site.com/page? (then what?)
I can't seem to find an easy way to do that?
-C
=
Chris Ripley
[EMAIL PROTECTED]
KOZE Radio
__
Do you Yahoo!?
Yahoo! SiteBuilder - Fre
lcome!
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL, but
don't bug poor Heikki about adding FULLTEXT to InnoDB as some of us are
of the opinion that no one
at Innobase Oy ever sleeps or goes home (or MySQL AB for that matter).
Regards,
Chris
Ugo Bellavance wrote:
-Message d'origine-
De : Andy Fletcher [mailto:[EMAIL
n mysql -h 192.168.1.2 -u cdw
-pxx and hit enter.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> > How do I reset an AUTO_INCREMENT column? My table type is InnoDB and
> > the method mentioned in the manual is not applicable. I am using MySQL
> > 4.0.17.
> Otherwise you should recreate the table.
Or, if you no longer need any of the data, simply use TRUNCATE.
Chri
in
the command. I can login from the linux machine just fine though.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-+
| 10 |
+------+
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP has changed their superglobals, no longer can you just put a $ infront
of the assigned name attribute. (You can change this in the php.ini file,
but it's discouraged)
Instead use
$_GET['name']
Or
$_POST['name']
So for $manufacturer
$_POST['manufacturer']
-Original Message-
From: See
I am getting the following log entry when ever I try to connect to mysql
from the network.
mysqld[2857]: refused connect from 192.168.1.28
This is on an SuSE 9.0 linux box and I haven't enabled any firewall yet
so I don't know why this would be happening. Any ideas?
Chris W
--
MyS
ng able to move .MYD and .MYI files around and have
any mysqld use them; InnoDB seems a bit picky about that.
Does the new one-file-per-tablespace format change any of that? Is
there any actual advantage to using it?
Thanks for any replies,
--
Chris
--
MySQL General Mailing List
For list arch
12. MySQL AB weren't responsible for afflicting the world with the Jet
database engine (Access) or Visual FoxPro, thus they are more
trustworthy than MS! :-)
13. You'll have my eternal gratitude if you use MySQL over MS SQL
Server...I'll send you a postcard.
Regards,
Chris
Martij
op looks pretty!").
Regards,
Chris
[EMAIL PROTECTED] wrote:
Hi,
I could not find the binary for SCO Unixware (Intel based) in download
section. I suppose mysql supports this environment too. May I know as to
where can I find this binary. Do I need to build this myself?
TIA
Regards,
Anup Maha
widely adopted).
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Martijn!
It seems that whenever we both comment in a thread, you enlighten me
greatly!
Martijn Tonies wrote:
Hi Chris,
I understand that you like MySQL but ...
Hmmfor practical purposes:
1. MySQL is going to cost you a lot less, no matter which way you do
things.
This is
Martijn Tonies wrote:
Hi Chris,
It seems that whenever we both comment in a thread, you enlighten me
greatly!
;-) ... I'm learning more about MySQL with every post. Ok, maybe
not every post, but still ... *g*
I tend to be a critic sometimes, but I'm a really nice guy. Believe
best interest though.
* The compiler you use.
I'm pretty sure that Skunkware includes GCC 2.95.x . This is one of the
recommended compilers for building MySQL binaries. If you install this
and can get a clean compile, you'll probably be fine.
Regards,
Chris
[EMAIL PROTECTED] wrote:
Hi
Hi!
For formatted text, you may be able to get away with using FULLTEXT
searches on MyISAM tables, depending on the definition of "formatted".
Regards,
Chris
On Wed, 2004-02-11 at 18:55, Veysel Harun Sahin wrote:
> Hello list,
>
> What is the best way to store and se
On Wed, 2004-02-11 at 22:29, Jochem van Dieten wrote:
> Chris Nolan wrote:
> > Martijn Tonies wrote:
>
> > Additionally, it is an accepted fact that MySQL is faster than the
> > mighty, mighty PostgreSQL.
>
> No, it is not. It is an accepted fact that MySQL is
st table has 30 columns (it indexed
very fast because it only had one index) and my smallest table has 3
columns.
Thanks.
Chris.
s the database being used?
- no. It's a Quad Xeon machine attached to an EMC fibre storage system. My
iostat indicates the disks are hardly moving and my top shows that very
little CPU is being used.
What version of MySQL?
- 4.0.17
Chris.
-Original Message-
From: [EMAIL PROTECTED] [mai
on my system?
myisam_sort_buffer
- I have 8GB of RAM, what should I set this to?
- my machine is dedicated to MySQL
Thanks.
Chris.
-Original Message-
From: Peter Zaitsev [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 2:03 PM
To: Chris Fossenier
Cc: 'MySQL List&#x
Can you provide a better explanation of these variables? I have yet to find
a thorough explanation of each one of them.
My myisam_max_sort_file_size = 3M
I am running the indexes with an "ALTER TABLE ENABLE KEYS" command after I
load the data into the tables.
Chris.
-Origin
None of my individual tables are larger than 12GB, however, I have no idea
if MySQL creates a separate TMP file for each indexing job or if it creates
a new one for each instance.
Also, where would it create this file? In the tmp dir?
Chris.
-Original Message-
From: [EMAIL PROTECTED
nothing over 20mill for records.
Chris.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:47 PM
To: Chris Fossenier
Cc: 'Peter Zaitsev'; 'MySQL List'
Subject: RE: Indexing Woes
These files will be created in the /tm
ine is a bit of an
insult. If one more of my clients calls me saying "Help! Our medical
management software won't start! Help!" and it turns out that a reindex
was attempted while someone was busy inserting pictures of fresh
incissions I'll be very annoyed (and charging accor
abase
engine is required (thus requiring a few changes to the embedded lib
before compilation). A quick scan through the docs involved doesn't seem
to point me in the right direction for a definitive answer on this.
Regards,
Chris
--
MySQL General Mailing List
For list arch
Ed Leafe wrote:
On Feb 11, 2004, at 7:31 PM, Chris Nolan wrote:
Yes, we all know that Microsoft *bought* FoxPro's underlaying
technology, that is *FoxBASE*! Everything ever called FoxPro has been
a Microsoft product.
Sorry, you're off by a few years. FoxPro had been out f
tally incorrect!
Regards,
Chris
This goes back to my original assumption that I thought the BLOB contents
would be stored outside of the normal column data, meaning that you have to
do an additional seek to retrieve a BLOB value, but that a BLOB column
doesn't inflate the data over which a ta
n the challenge or run
screaming in the other direction and have a somewhat easier year.
Regards,
Chris
Heikki Tuuri wrote:
Chris,
- Original Message -
From: "Chris Nolan" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, February 12, 2004 2:45 A
ng, backup methods and anything else worthy of note
(forms of logical volume management, impatient users that reboot servers
because they can't look at www..com due to
proxy/firewall restrictions)?
Regards,
Chris
Schmuck, Michael wrote:
Hello
I've got a big problem. My MySQL serve
Hi!
You might want to keep your eye on MySQL Cluster - to be demonstrated at
the 2004 MySQL conference, where you might get a chance to swim with the
dolphins!
Regards,
Chris
Are Pedersen wrote:
Hello
I am looking for software/hardware solutions to provide loadbalancing
and redundancy for
substrings in the TEXT column for rows between two dates with
certain values for the ENUM columns. There are indexes on the ENUM,
TIMESTAMP and TEXT columns (prefix indexes of course). Unless I specify
FORCE INDEX(date), MySQL does a full table scan, resulting in queries
that take 2 minutes t
slave
after it successfully completes on the master.
Thanks,
David
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Basically, only error-free statements are replicated.to the slave, thus
ensuring that constraints are satisfied.
Regards,
Chris
David Griffiths wrote:
Thanks for the reply.
So InnoDB (and even MyISAM) use transactions (expected with InnoDB) and
slaves track their position in the binary log
Hmm
I'd check for hard disc problems (turn on SMART monitoring and look
through your kernel logs), RAM problems (look at memtest) and rootkits.
Regards,
Chris
On Sun, 2004-02-15 at 15:45, Juan E Suris wrote:
> I just installed 4.0.16 linux (x86, libc6) rpms on a fresh RH7.3 install
using
one thread per connection?
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this
case being the JDBC element of the test.
As I've said in other threads, I can't wait for MySQL AB to release
their new benchmarks - it will hopefully give us a simple, definitive
source for comparison across architectures, operating systems and access
methods.
Regards,
Chris
On Mon
one day that the software I am currently building will also
contribute to both the commercial software world and the open source
community. The fact that you've achieved this with such success and that
you post to the MySQL mailing list so often is why I ask you these
questions.
Regards,
Chris
Hi!
Next-key locking essentially doesn't work on rows - it works on indexes.
It ensures that "phantom reads" can't happen.
InnoDB does indeed do row-locking. In fact, it has one of the most
efficient representations of locks of any relational database.
Regards,
Chris
On M
this helps!
Regards,
Chris
On Tue, 2004-02-17 at 00:05, Andreas Pardeike wrote:
> Hi List,
>
> Can someone explain the results below? It seems that MySQL has a hard
> time choosing keys for 'or' searches. The example here is very simple
> but reflects the more complex cas
Hello again!
Andreas Pardeike wrote:
On 2004-02-16, at 14.13, Chris Nolan wrote:
MySQL's optimizer has a slight problem. OR queries cause it to get very
confused.
Try the following to get the best performance:
Rewrite SELECT FROM table WHERE (condition1) OR (condition2);
As:
(SELECT
eployable and an original open source work.
Regards,
Chris
Curtis Maurand wrote:
checkout http://www.dbmail.org
On Sun, 15 Feb 2004, Chris Nolan wrote:
Hi all,
I'm currently designing an open-source messaging server that will use
MySQL as the data store (in embedded form).
High perf
Yes, it does. Both of the following statements give you the locks you'd
expect:
SELECT * FROM table WHERE id BETWEEN 4 AND 20 FOR UPDATE;
SELECT * FROM table WHERE id BETWEEN 40 AND 50 LOCK IN SHARE MODE;
Regards,
Chris
James Kelty wrote:
Does it have exclusive and shared?
-
You might be able to cheat and replicate the required database to the
local machine.
Regards,
Chris
Terence wrote:
you'll need to create temporary tables in one of the servers based on the
results of the other and then join.
- Original Message -
From: <[EMAIL PROTECTED]>
Sure! Just remember that your slave will have to be able to keep up with
all the UPDATE, INSERT and DELETE statements issued on the master servers.
Regards,
Chris
[EMAIL PROTECTED] wrote:
That looks like a good solution...
Do you know if i can replicate multiple databases from diferent
901 - 1000 of 2093 matches
Mail list logo
