matt ryan wrote:
Tobias Asplund wrote:
On Tue, 7 Sep 2004, matt ryan wrote:
I forgot, did you have multiple slaves on multiple machines? If so,
do they
have identical hardware/drivers?
Multiple slaves on same machine, one works fine
Do You tried to distribute replication to other machines? Is
Remigiusz Sokoowski wrote:
matt ryan wrote:
Tobias Asplund wrote:
On Tue, 7 Sep 2004, matt ryan wrote:
I forgot, did you have multiple slaves on multiple machines? If so,
do they
have identical hardware/drivers?
Multiple slaves on same machine, one works fine
Do You tried to distribute
Hi All!
Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem
annoyed, but I have used for quite some time a few GUI clients, notably
MySQL-Front, which I were relatively confortable with. Anyway, all GUI
clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) seemed to be
Hello Jose,
Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem
annoyed, but I have used for quite some time a few GUI clients, notably
MySQL-Front, which I were relatively confortable with. Anyway, all GUI
clients I used (SQLyog, MySql-Front, MySQL-CC, you name it)
Hi there,
Can MySQL can be used with BEA Tuxedo, has anybody tried this combination.
Can you tell me how the performance if anybody has tried this.
Waiting for your reply
Regs
Take care
Saseendran G.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
How can I extract a middle segment of text in mySQL. For example a column contains
this string: 'William Walker Jones'. I need to split this into the first, middle, and
last names. I can easily extract the first and last names but how do I extract the
Middle name?
Hi,
I just wondering if anyone notice or can confirm this: I tried to load
11 million records using mysqlimport using both 4.1.3b and 4.0.20.
4.1.3b took 1.5 hours, but the 4.0.20 took over 10 hours. This
includes loading the data and then build the index.
Thanks
Haitao
--
MySQL General
Miss Brasseur,
Sorry for the Mr... You are right. Id did not know.
The reason why I think it was SSL related is
because that error only comes up when I try to
compile with SSL support.
Also, on the includes where the compiler fails,
you can see:
-I.. /data/OpenSSL/include/openssl
Which
Mr. Fisher,
Yes, that seems to be the problem... It is adding a
space before the path.
Also, the path should be static; however, it is using
../data which is wrong since I am compiling under
/data/Software/mysql and the OpenSSL directory is
directly under /data.
I did a grep for /data/OpenSSL
Assuming there are no parts of a name that include more than one word
(e.g., Mary Jo being someone's first name), an easy way would be to
use SUBSTRING_INDEX.
First Name = SUBSTRING_INDEX( namefield, ' ', 1 );
Middle Name = SUBSTRING_INDEX( SUBSTRING_INDEX( namefield, ' ', 2 ), ' ', -1 );
Last
I guess that would depend on what you consider a last name or a middle
name
A typical western name has 3 parts, like your example. However there are
many names like van der Plaats or de la Hoya that are not so easy to
detect based simply on what space to split the name at.
What about people
Hi gurus,
can you pls. help a mysql newbee?
I need to load data into the following table
mysql describe test;
+--++--+-+-++
| Field| Type | Null | Key | Default | Extra |
Hi folks, Im dying here slowly. Can anyone tell me what an =
SqlState 08000 (connection exception) REALLY MEANS Is it as obvious =
as I think it is, Im NOT CONNECTED to MySQL, and if so, why not =
08003 (connection does not exist)...
I have a major problem, Im running Windows 2000
Here's the scenario...
First, my HTTP Server (Apache), PHP Server and MySQL Server are on the same
machine - an Apple Xserve.
Second, I've got a page with a long repeat region reflecting a recordset
queried out of a MySQL table. The region also displays information obtained
from fields in a
Greetings
We have installed MySQL 4.0 on a dedicated Windows Server 2003. I have the MySQL
server running
and it appears all is set to go minus one problem. We need to move a MySQL database
from the old
host to this server. To do that, I want to use a GUI - preferably DBACentral.
However;
I'm trying to get my key_buffer_size to 64m (default is 8m). I tried
putting it into my.cnf under [mysqld] with both key_buffer=64m and
key_buffer_size=64m seperately of course, and when that didn't work tried
putting it in from of the: /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
/dev/null
At 12:42 2004-09-08, you wrote:
Greetings
We have installed MySQL 4.0 on a dedicated Windows Server 2003. I have
the MySQL server running
and it appears all is set to go minus one problem. We need to move a
MySQL database from the old
host to this server. To do that, I want to use a GUI -
I have two tables, call them Parent and Child, where the records in Child have
a foreign key relation to Parent, with a Cascade on Delete. If i delete
records from Parent, the corresponding records in Child will be deleted. Is
there any way that i can get a count of the records in Child that
At 9:58 -0700 9/8/04, Patrick Campbell wrote:
I'm trying to get my key_buffer_size to 64m (default is 8m). I tried
putting it into my.cnf under [mysqld] with both key_buffer=64m and
key_buffer_size=64m seperately of course, and when that didn't work tried
putting it in from of the:
You're talking about a difference of milliseconds, tops.
Use whatever solution gives you the cleaner, easiest-to-maintain code.
Don't worry about a couple milliseconds.
http://c2.com/cgi/wiki?PrematureOptimization
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I would try not to query MySQL on each iteration of the loop. While a
dozen or so queries may not make a noticeable difference, hundreds or
thousands may. It's not a scalable technique, whether you need to scale
it or not. Even if it's only 100 iterations, what if you have 10 people
accessing
I'm confused about this response and am facing a
similar situation.
First, regarding the subject, what is the difference
between a PHP or whatever loop and a SQL query. All
the app code is doing is collecting the request and
handing it back to the database. The DBMS still has
to retrieve the
Hi
Just my two pence worth. Its not tested or scientific, and is based on gut
feeling and experience.
Connecting to mysql is resource intensive, particularly if you make a fresh
connection for each query. A query will almost certainly involve disk acces
which is slow. Sending the result of the
At 13:19 2004-09-08, you wrote:
I am going to amalgamate both Your messages.
Hi Tomasz
There are two MySQL servers - the one at the shared host and the new
one that I just set-up on the dedicated. We need to move the MySQL
database from the shared host to our dedicated. I am able to connect to
Hi,
I'm using MySql 4.1.4 Gamma and the following query returns
values containing N and Ñ instead of only those containing Ñ.
The query is as follows
Select Lastname from table1 where locate(Ñ,Lastname)0
The result set includes values like this
HERNANDEZ
NUÑES
The end result will be the same, it's just a matter of the structure
the data will have when handed to PHP for processing to display. It can
be retrieved bit by bit and broken up into multiple lists or joined and
summarized by MySQL into one list. One list will make the PHP loop
simpler,
I never thought of the return only the querying
part.
My predicament is I have a search form that queries a
table with about 7 joins. It returns it via a
Dreamweaver recordset aka SQL query. So based on what
you said below , regarding the number of users, this
is a bad way to go.
Stuart
I use foxpro to do similar loops
I've found that I get 10 queries per second on large tables, when
connecting once, and issuing individual select statements via odbc.
It is much faster if you can narrow the recordset into an array within
php, and spool through that, unfortunatly I deal with
Hi Guys,
I'm having the same problem with SQL_CALC_FOUND_ROWS
Any query involving SQL_CALC_FOUND_ROWS takes ages!! All my tables are normalized,
indexed, and optimized and the query uses the indices correctly. Many people
responded to my previous thread (when I though it was a fulltext issue
Currently we have one way master to slave replication setup.
The master has 2 innodb data files, the second has now grown
to 50gb+. The slave's innodb data files are less than 2 gigs.
How is this possible? They are both storing the exact same
data. Is there some way to trim the 50gb+ file down ?
I agree with Peter. Hit the database only when necessary. You can even
eliminate some JOINS entirely if you cache the contents of **certain**
tables in application-side arrays However(!!) _*you*_ are now responsible
for searching those arrays efficiently. Here's an example:
create table
Hello there,
I tried REPAIR TABLE to recovery the crushed temp
table and that works. Thanks a lot.
But, after reparation, there are some duplicated
records generated. Is that because the temp table has
no primary key? Or is because the table was crushed in
the middle of query?
Anyway, I tried
Hello there,
I tried REPAIR TABLE to recovery the crushed temp
table and that works. Thanks a lot.
But, after reparation, there are some duplicated
records generated. Is that because the temp table has
no primary key? Or is because the table was crushed in
the middle of query?
Anyway,
Bingo. Yeah, that works very well.
Really appreciated.
BTW, still curious about the reason of duplicate.:)
Any thoughts?
Monet
--- Jim Grill [EMAIL PROTECTED] wrote:
Hello there,
I tried REPAIR TABLE to recovery the crushed
temp
table and that works. Thanks a lot.
But, after
Monet wrote:
Hello there,
I tried REPAIR TABLE to recovery the crushed temp
table and that works. Thanks a lot.
But, after reparation, there are some duplicated
records generated. Is that because the temp table has
no primary key? Or is because the table was crushed in
the middle of query?
Bingo. Yeah, that works very well.
Really appreciated.
BTW, still curious about the reason of duplicate.:)
Any thoughts?
Monet
Several thoughts; one of which is Thank my lucky stars! I have my data
back! :-)
Other, less significant thoughts include the possibility that some esoteric
C api mysql 4.1.4 ,select many select error!
free_root fail.
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Christian:
Change your readme and hostname columns to BLOB and use the
LOAD_FILE() function to add your record.
INSERT INTO test NULL, LOAD_FILE( '/path/to/readme/file' ), LOAD_FILE(
'/path/to/hostname/file');
More on the LOAD_FILE() function:
Hello All,
MySQL : Standar Binary 4.0.20
O/S : Red Hat Linux release 9 (Shrike)
Linux 2.4.20-31.9smp #1 SMP Tue Apr 13 17:40:10 EDT 2004 i686 i686 i386 GNU/Linux
I already have setup of Three Multiple MySQL servers listening on different ports and
sockets on same machine
Option File:
The example below renames a col. But can I rename a col. w/out giving
all that type spec. at the end of the statement below. I just want to
rename everything else stays the same. Thanks.
mysql ALTER TABLE search CHANGE Description PageDescription
VARCHAR(255) NOT NULL;
--
MySQL General Mailing
I sent a previous email w/the wrong subj. - sorry.
The example below renames a col. But can I rename a col. w/out giving
all that type spec. at the end of the statement below. I just want to
rename, everything else stays the same. Thanks.
mysql ALTER TABLE search CHANGE Description
- Original Message -
From: leegold [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 08, 2004 5:31 PM
Subject: Rename a columkn
I sent a previous email w/the wrong subj. - sorry.
The example below renames a col. But can I rename a col. w/out giving
all that type
Hello:
I am trying to install Perl support with MySQL. After installing MySQL
(v4.0.20)I run the following commands:
% echo $PATH
% perl -MCPAN -e shell
Note: Answer no to auto-configure perl.
cpan install Data::Dumper
(Upto this point. Following commands are
Suppose I have two tables: parent and
child. I want to create an SQL statement
that will get the count of all children
belonging to parent. Is this possible in
one statement? The one I have works
if parent has children, but not if the
number of children is 0. Here's what
I have:
SELECT
Dears,I'm going to create a field what it not limited
to a specefy size.
Please guide me
=
-DIGITAL SIGNATURE---
///Mohsen Pahlevanzadeh
Network administrator programmer
My home phone is: +98213810146
My email address is
Dean A. Hoover wrote:
Suppose I have two tables: parent and
child. I want to create an SQL statement
that will get the count of all children
belonging to parent. Is this possible in
one statement? The one I have works
if parent has children, but not if the
number of children is 0. Here's what
I
Suppose I have two tables: parent and
child. I want to create an SQL statement
that will get the count of all children
belonging to parent. Is this possible in
one statement? The one I have works
if parent has children, but not if the
number of children is 0. Here's what
I have:
SELECT
- Original Message -
From: Pahlevanzadeh Mohsen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 08, 2004 6:59 PM
Subject: varchar or
Dears,I'm going to create a field what it not limited
to a specefy size.
Please guide me
Have you tried searching the
Jim Grill wrote:
Suppose I have two tables: parent and
child. I want to create an SQL statement
that will get the count of all children
belonging to parent. Is this possible in
one statement? The one I have works
if parent has children, but not if the
number of children is 0. Here's what
I have:
At 18:02 -0400 9/8/04, Rhino wrote:
- Original Message -
From: leegold [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 08, 2004 5:31 PM
Subject: Rename a columkn
I sent a previous email w/the wrong subj. - sorry.
The example below renames a col. But can I rename a
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; [EMAIL PROTECTED]; leegold
[EMAIL PROTECTED]
Sent: Wednesday, September 08, 2004 7:29 PM
Subject: Re: Rename a columkn
At 18:02 -0400 9/8/04, Rhino wrote:
- Original Message -
From: leegold
Hi all,
I have a Linux Database Server which runs MySQL 4.1 and a Windows Client machine which
runs MySQL 4.1 too. I have installed the latest version of MyODBC on both machines and
they have been installed successfully. Now, at the Administrative Tools in the Control
Panel on my Windows
Now, to complicate things further, suppose there is
yet another table (grandparent, let's say) and there is
a column in parent that is grandparent_id. I only want
results where parent.grandparent_id = 'Fred'. How do
I do that? Is it with a WHERE clause or some other
SQL magic?
Dean
Daniel Kasak
Dean A. Hoover wrote:
Now, to complicate things further, suppose there is
yet another table (grandparent, let's say) and there is
a column in parent that is grandparent_id. I only want
results where parent.grandparent_id = 'Fred'. How do
I do that? Is it with a WHERE clause or some other
SQL
Now, to complicate things further, suppose there is
yet another table (grandparent, let's say) and there is
a column in parent that is grandparent_id. I only want
results where parent.grandparent_id = 'Fred'. How do
I do that? Is it with a WHERE clause or some other
SQL magic?
Dean
This
Trying to get my mind around JOINs. Please help.
Scenario...
StudentTable
Fields:
StudentID
StudentName
CityID
CityTable
Fields:
CityID
CityName
I will store personal information about the student in the first table. The
second table contains information about the city. I relate
Robb:
http://dev.mysql.com/doc/mysql/en/JOIN.html
I am assuming all the information you need is student name + city
name. SELECT * FROM StudentTable AS s, CityTable AS c WHERE s.CityID =
c.CityID
Wes
On Wed, 8 Sep 2004 19:55:29 -0500, Robb Kerr
[EMAIL PROTECTED] wrote:
Trying to get my mind
What's advantage of table's join?
I can't find out it.
Please guide me.
=
-DIGITAL SIGNATURE---
///Mohsen Pahlevanzadeh
Network administrator programmer
My home phone is: +98213810146
My email address is
Hi,
I am trying to compile MySQL. I know that it is possible to install this
as a binary, that is not my goal.
My environment consists of the following: If there are other tools that
I need to specify please let me know.
gcc-3.2-7
libgcc-3.2-7
gcc-c++-3.2-7
I run configure as specified at the
I use SQLyog. It does allow you to create/delete FKs
with ON UPDATE criterias.
Yeah, it does not allow you to create Fks in graphical
manner like MS SQL Server but does my purpose. One
feature I really miss is Editing of FKs.
Karam
--- Jose_Miguel_Pérez [EMAIL PROTECTED] wrote:
Hi All!
Background:
I have one master table A, and other supplementary tables B,C and D such that
for every row of A there can be one or more corresponding rows in B,C,D.
There is another supplementary table E with which A has a one-to-one
relationship.
Problem:
Given three search criteria resulting
Hello Everyone,
Is there a reason why the Dynamic client libraries including 3.23.x
libraries (MySQL-shared-compat-4.0.20-0.i386.rpm) are only distributed as
RPM to the i386 architecture?
Updating to 4.0.20 on x86_64 is quite difficult at the moment if you want
to keep PHP working. Are there
62 matches
Mail list logo