Marc
mysqld runs on a very powerful Operton machine with
16GB memory and barely any other application process
running, it is hard to believe that a simple select
that runs under 2 second will utilize all the
resources...that is why I tend to think there is
something in the mysql set up that
Daniel Kasak wrote on Tuesday, June 08, 2004 00:38;
Emmanuel van der Meulen wrote:
Hello all,
Does anyone have an estimate of when MySql 4.1 will be released for
production.
MySql.cm says soon.
Please advise, would that likely be weeks/months?
Kind regards
Emmanuel
On Monday, June 07, 2004 07:54, Jeff Smelser wrote;
On Monday 07 June 2004 12:49 am, Emmanuel van der Meulen wrote:
I've looked in several books and searched Google but cannot get a way of
doing this. It seems Oracle has a 'FIRST' in their select
which they use
for such a use case. But
On Mon, 7 Jun 2004, Haitao Jiang wrote:
Marc
mysqld runs on a very powerful Operton machine with
16GB memory and barely any other application process
running, it is hard to believe that a simple select
that runs under 2 second will utilize all the
resources...that is why I tend to think
Dimitri,
please upgrade to a newer MySQL version.
Starting from MySQL 4.0.13, you can use SHOW INNODB STATUS to display a
detailed explanation of the latest InnoDB foreign key error in the server.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for
Hi again!
This query is ok:
create table TEST (id int,saturs char(255) charset utf8 )
alter table TEST add fulltext (saturs);
drop table TEST;
,
create table TEST (id int,saturs char(255) charset utf8 collate utf8_bin )
alter table TEST add fulltext (saturs)
Can't create table
Hello Everybody,
I am totally new to MySQL. Wanted to know if MySQL supports any options
using which users can specify the row storage order. For instance, Let
us consider the Employee table, Now I want to store rows of this table
in EmpId column order. The rows should be physically stored in
We're looking for a client-server instant messaging system (opensource),
powered by MySQL if possible. Anyone know of one?
I've been taking a look at Gaim, Sim etc, but these all piggyback on Yahoo,
MSN etc which is not what we're looking for since it must run on our lan.
Thanks for any ideas...
We're looking for a client-server instant messaging system (opensource),
powered by MySQL if possible. Anyone know of one?
I've been taking a look at Gaim, Sim etc, but these all piggyback on
Yahoo,
MSN etc which is not what we're looking for since it must run on our lan.
Thanks for any
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 08 June 2004 01:56 am, Terence wrote:
We're looking for a client-server instant messaging system (opensource),
powered by MySQL if possible. Anyone know of one?
I've been taking a look at Gaim, Sim etc, but these all piggyback on Yahoo,
It appears as though Jabber does support MySQL. Thanks for the lead :)
- Original Message -
From: Jeff Smelser [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 3:06 PM
Subject: Re: Know of a MySQL powered Instant Messaging system
-BEGIN PGP SIGNED MESSAGE-
Working around optimizing some queries, I tried to get a better key
improvement.
This is what I get:
mysql explain select ID,reply,nome,email,dataora,titolo,testo,status,thread from board where
articolo=50966 AND status2 and (thread102741 and thread101548) ORDER BY ID DESC;
Hi,
I am new to database programming. I want to get input from user about their academic
qualification or skills they have so how could i create database. I mean i am bachelor
having few other computer certification and 20 other skills related to computer so my
qualification would be like :-
My requirement was 6 fields and 2nd guy need 12 filed.
You should setup two tables. The first one will track common
data for each user (e.g. name, address...) like:
create table users (
name varchar(255),
address varchar(255),
...
userid integer unsigned auto_increment primary key
In a table called 'advisers' I have a column called 'surname' which
contains the surnames of a number of people. Using a query like:
'select * from advisers order by surname' lists the people in the
correct order but some people have surnames like 'du Sautoy' and
'van den Berg' and these are
Hello Andy,
I don't known if this is possible without handle string, what I don't guess
recommended, because of performance and legibility of code.
One suggestion will be store in column 'surname' (or other) the data already
in format of sort.
In other words, will be two columns in table, and,
Hi Robert,
Thanks for the reply but unfortunately I am still using version 3.23.54 and
I am unable to change it!
From: Robert A. Rosenberg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: DELETE from more than one table
Date: Mon, 7 Jun 2004 18:04:38 -0400
At 14:01 + on 06/07/2004,
Hi,
it is not possible to handle all cases proper.
You can just handle all cases you know with the REPLACE-function,
so you simply delete the prefixes in the WHERE-clause.
But that only works for all prefixes you know.
If you do like
ORDER BY REPLACE(REPLACE(surname,'du',''),'de','')
you get all
I have never done anything like this but after looking at the spec's I have
a possible direction for you
In String functions there is
LOCATE(substr,str,pos)
The first syntax returns the position of the first occurrence of substring
substr in string str. The second syntax returns the position
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 08 June 2004 03:19 am, Terence wrote:
It appears as though Jabber does support MySQL. Thanks for the lead :)
its open source, it always can.. :)
Jeff
- --
Death? Life? I never did understand Zen.
-BEGIN PGP
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 08 June 2004 03:19 am, Terence wrote:
It appears as though Jabber does support MySQL. Thanks for the lead :)
Not true:
http://docs.myjabber.net/howto/mysql.htm
Just do a jabber+mysql from google, there are clients too, but thats the
On Tue, 8 Jun 2004, Paul McNeil wrote:
I have never done anything like this but after looking at the spec's I have
a possible direction for you
In String functions there is
LOCATE(substr,str,pos)
The first syntax returns the position of the first occurrence of substring
substr in
Andy Eastham put me on the right track for this solution. I just ran the
following and it works so please give him the credit.
I tested with 'van der Plas' and 'McNeil'
SET @tmp = 'van der Plas';
SELECT @tmp,
Reverse(
SUBSTRING_INDEX(Reverse(@tmp),' ',1)
)
as myOrder
FROM MyTable;
If surname is a field, then use it without the single quotes ('),
otherwise it is treated as a literal string and 0 is the correct result:
select locate(' ',surname,1) from advisers
andy thomas wrote:
Yes, this is the approach I was thinking of using but:
select locate('
Dear friends,
I have a question about mysql.
I installed mysql on windows 2000, after I started the mysql, I tried to create a
database, but I was denied, I got message:
mysql show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql
On Tue, 8 Jun 2004, Vadim P. wrote:
If surname is a field, then use it without the single quotes ('),
otherwise it is treated as a literal string and 0 is the correct result:
select locate(' ',surname,1) from advisers
Thanks a lot, this is working. I now need to figure out how to use
Look at using the Reverse() function, then take the substring up to the
first space, then reverse the result.
Andy
-Original Message-
From: Paul McNeil [mailto:[EMAIL PROTECTED]
Sent: 08 June 2004 14:04
To: [EMAIL PROTECTED]
Subject: RE - Order By Problem
I have never done
On Tue, 8 Jun 2004, Andy Eastham wrote:
Look at using the Reverse() function, then take the substring up to the
first space, then reverse the result.
Well, 'select substring_index(surname,' ',-1) from advisers' does the
trick as far as extracting the wanted parts of surnames at the end of
the
c s wrote:
Dear friends,
I have a question about mysql.
I installed mysql on windows 2000, after I started the mysql, I tried to create a
database, but I was denied, I got message:
mysql show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
Has anyone seen a post on this issue? If not, can anyone offer any advice?
I have a TBL of users and I have created a search screen where you can type
in first or last name and it will retrieve the appropriate records. Here is
the statement:
Select * from STUDENTS WHERE FName LIKE '%
A few days ago, Dennis T Cook asked this list if it is OK to abort a
OPTIMIZE that is taking a very long time. I am also wondering this.
Will it cause any damage to the half-optimized table, adnd is there a
right and a wrong way to stop this process?
Any help appreciated!
-Jim
--
MySQL
Andy,
Just:
select substring_index(surname,' ',-1) as r from advisers order by r;
works.
Andy
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]
Sent: 08 June 2004 15:57
To: Andy Eastham
Cc: Mysql List
Subject: RE: RE - Order By Problem
On Tue, 8 Jun 2004, Andy
Are you spitting out an output of the query string to verify that the data
from the form is making it to the query correctly?
GOD BLESS AMERICA!
To God Be The Glory!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
The manual describes wait_timeout thusly:
The number of seconds the server waits for activity on a non-interactive connection
before closing it. On thread startup, the session wait_timeout value is initialized
from the global wait_timeout value or from the global interactive_timeout value,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Terence wrote:
| We're looking for a client-server instant messaging system (opensource),
| powered by MySQL if possible. Anyone know of one?
| I've been taking a look at Gaim, Sim etc, but these all piggyback on
Yahoo,
| MSN etc which is not what
Hello,
My ISP is using the old version 4.0.15a and have no early plans to upgrade it.
I'm trying to issue LOCK/UNLOCK TABLES commands at my ISP's MySQL, and I'm getting an
access denied error.
I asked them to give me the lock tables permission, but they answered this permission
option isn't
The manual says ON DELETE CASCADE with foreign keys is available for InnoDB
tables starting with mysql 3.23.50
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html.
Michael
shaun thornburgh wrote:
Hi Robert,
Thanks for the reply but unfortunately I am still using version
Our Opteron server should be arriving today, so I can't provide a whole
lot of insight.
First, what version are you using? 4.0.20? The 64-bit or 32-bit version?
Knowing the version might help. If this is not a production machine, you
might want to try using the version from the MySQL website
How do you determine the average time per query in MySQL?
Jeff Johnson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The proposed solution to sort on a portion of the surname field will work,
but it has a drawback. If you sort on the result of a function applied to a
column, you prevent the use of any index on that column. If your data set
and user base are both small, this may be a problem you can ignore,
Hi,
Yes. There is the ISP's DNS. And of course it is unavailable
when the adsl connection is down.
I've deleted this DNS configuration but the problem persists.
And of course I have no explanation about why at the same time
others machines on the same local net, running Linux ( same version)
Version 4.0.15 comes after version 4.0.2 (15 2), so the version is not a
problem here.
From the manual: As of MySQL 4.0.2, to use LOCK TABLES you must have the
global LOCK TABLES privilege and a SELECT privilege for the involved
tables. http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html
The
Hi,
I would appreciate help on the following.
I have installed myODBC 3.51 on my Windows 2000 computer.
I am trying to connect mysql database on a linux server.
I configured the ODBC data source adminstrator from the
administrative tools.
After trying to add a new data source and entering all
Each of 4 individual query only took 0.6 seconds,
there is no other clients, it hardly to believe taht
mysql query performance will degrade 300% (from 0.6s
to ~1.9s) if we have 4 concurrent connections...
As far as I know, MySQL should be able to handle
hundreds of connections on a single CPU
First, what version are you using? 4.0.20?
4.0.18 as provided by Suse with 9.1 Professional. 64 bit
4.0.20 64bit crashes 'out of the box' (segfault as I start it). I just
filed a bug report for that
By key-cache, are you referring to the variable key_buffer_size? If
so, keep in mind that
Annie,
Try opening a telnet session from your Win2K box to your Linux box using
port 3306. If your MySQL server is there, you will see the version number
of your server embedded in some other data. You can either close the
connection or wait for it to time out. IF you got your version number,
Hi,
I've tryed that after reading this message,
But couldn't get the route correctly established.
I'm giving some more details in this example
Server (SuSE 8.2) IP 192.168.10.34
Win2k IP 192.168.10. 5 Gets slow when adsl is down
Lin_box1 (SuSE 8.2) IP 192.168.10. 3
I have three machines which I'm working with a specific database on.
One is a development server, the second a production server, and the third a
testing server for when code may cause the development server to crash
(which is the development server for numerous applications and sites so this
is
In the High Performance MySQL book, on page 124, the author suggests:
If you have all your MySQL data on a single disk, you can try moving pieces to
another disk. If the majority of activity is focused on a small group of tables,
consider moving them to a separate disk.
How do you accomplish
On Tue, 8 Jun 2004, Haitao Jiang wrote:
Each of 4 individual query only took 0.6 seconds,
there is no other clients, it hardly to believe taht
mysql query performance will degrade 300% (from 0.6s
to ~1.9s) if we have 4 concurrent connections...
As far as I know, MySQL should be able to
In the last episode (Jun 08), Lou Olsten said:
In the High Performance MySQL book, on page 124, the author suggests:
If you have all your MySQL data on a single disk, you can try moving
pieces to another disk. If the majority of activity is focused on a
small group of tables, consider
From: Mauricio Pellegrini
Hi,
I've tryed that after reading this message,
But couldn't get the route correctly established.
I'm giving some more details in this example
Server (SuSE 8.2) IP 192.168.10.34
Win2k IP 192.168.10. 5 Gets slow when adsl is down
Fernando Monteiro wrote:
Hello, Michael,
Version 4.0.15 comes after version 4.0.2 (15 2), so the version is
not a problem here.
(...)
I asked them to give me the lock tables permission, but they
answered this permission
option isn't available on versions prior to 4.0.2. They also told me
they
Ah, the symbolic links.. Forgot about them... Thanks.
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Lou Olsten [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 3:49 PM
Subject: Re: Moving tables to different disks (High Performance MySQL)
In the last
I am just beginning down this roadso the answer may be obvious
Is there an efficient way to design a database where the table data
contains fields with multiple languages ?
like the Artist Table:
artist_id
english_name
spanish_name
portuguese_name
english_biography
spanish_biography
On Tue, 2004-06-08 at 12:57, John Fawcett wrote:
From: Mauricio Pellegrini
Hi,
I've tryed that after reading this message,
But couldn't get the route correctly established.
I'm giving some more details in this example
Server (SuSE 8.2) IP 192.168.10.34
Win2k
Doesn't look like my reply last night made it to the list, resend...
Hello Seth,
On Mon, 7 Jun 2004, Seth Brundle wrote:
1. The timeout is set to 5 min, because of the number of queries, there
are a lot of unused http processes that linger with connections, and the
only way to seeminly
...called Practical Query Analysis (PQA) is now available here:
http://pqa.projects.postgresql.org/
It produces HTML reports on slowest queries, most frequent queries,
queries by type (select/insert/update/delete), and all that sort of
thing for PostgreSQL and MySQL database logs. Here's an
Hi
I exported data from a mysql database to a csv file. Null values are exported
as \N. When I import this csv file with the dts service from MSSql then I
receive the following error when a null value (\N) is read:
Error: -2147213268 (8004202C); Provider Error: 0 (0)
Error string:
From: Mauricio Pellegrini On Tue, 2004-06-08 at 12:57, John Fawcett
wrote:
From: Mauricio Pellegrini
Hi,
I've tryed that after reading this message,
But couldn't get the route correctly established.
I'm giving some more details in this example
Server (SuSE 8.2) IP
The only thing strange about this is that in your previous
post you mentioned that the wk2 machine had an ip of
192.168.10.5.
Yes, that example was from another machine on the same net
The above route print output seems to be for a machine
with an ip of 192.168.10.2.
Yes. In this
Emmanuel van der Meulen wrote:
Daniel Kasak wrote on Tuesday, June 08, 2004 00:38;
Emmanuel van der Meulen wrote:
Hello all,
Does anyone have an estimate of when MySql 4.1 will be released for
production.
MySql.cm says soon.
Please advise, would that likely be weeks/months?
Kind regards
Emmanuel
Hi,
AFAIK 4.1.3 should be beta.
Regards,
Jocelyn
- Original Message -
From: John Murphy [EMAIL PROTECTED]
To: Emmanuel van der Meulen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, June 09, 2004 12:31 AM
Subject: Re: Production release of MySql 4.1
Emmanuel van der Meulen
From: Mauricio Pellegrini
Oh no.. The reason is I've changed my seat. All IP's are static.
Sorry :)
It generally helps to keep the problem conditions the same while
investigating. :)
I forgot that Here is the result of Ipconfig /all on the same machine
(192.168.10.2)
C:\ipconfig /all
MySQL Version 3.23.52 on Red Hat Linux
Trying to establish an ODBC connection to the MySQL server from a windows 2000 server
and get the error:
MySQL ODBC Driver ver 03.51.06
Lost Connection to MySQL server during query
On the MySQL server, there is only one my.cnf and it has no reference
According to the docs, one of the first things I'm supposed to do is give
root a password:
shell mysql -u root mysql
mysql SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql --user=root --password=new_password
ERROR 1045: Access denied for user: '[EMAIL
At 08:25 PM 6/8/04, Frank Bax wrote:
According to the docs, one of the first things I'm supposed to do is give
root a password:
shell mysql -u root mysql
mysql SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql --user=root --password=new_password
ERROR 1045:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.2, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.2 is a new feature release for the ALPHA tree that is
suitable for use with either MySQL-4.1 or MySQL-5.0 (and is required
when
I am having problems installing 4.0.20 (64 bit version), on
Suse 9.1 (64 bit as well).
'mysqld' and the mysql client segfault on start.
'mysql-max' appears to be running (but of course, the client
still segfaults).
4.0.18, which is included with 9.1 works ok, but has issues
with loading tables
Why not set the DB character set to utf8 and probably cover all of them?
CHARACTER SET utf8;
Respectfully,
Ligaya Turmelle
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I am just beginning down this roadso the answer may be obvious
Is there an efficient way to design a
Why not set the table to -
CHARACTER SET utf8;
Respectfully,
Ligaya Turmelle
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I am just beginning down this roadso the answer may be obvious
Is there an efficient way to design a database where the table data
contains fields with
Frank Bax wrote:
At 08:25 PM 6/8/04, Frank Bax wrote:
According to the docs, one of the first things I'm supposed to do is
give root a password:
shell mysql -u root mysql
mysql SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql --user=root
Check out the BENCHMARK function
http://dev.mysql.com/doc/mysql/en/Information_functions.html
On Tuesday 08 June 2004 20:22, Jeffrey M. Johnson wrote:
How do you determine the average time per query in MySQL?
Jeff Johnson
--
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
--
73 matches
Mail list logo