subqueries are introduced in 4.1 only
- Original Message -
From: Emmanuel Ohannessian [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 26, 2004 12:10 PM
Subject: subqurey syntax error
I am getting the error message:
mysql SELECT s1 FROM t1 WHERE s1 IN(SELECT s1
Hi group?
What do you recommend someone who wants to install MySQL on RedHat?
Using RPMs or installing from SOURCE?
What are the main differences and/or benefits?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone:
Here is the /tmp directory after doing a ls -al listing:
Kevins-Computer:/tmp kevinbarry$ ls -al
total 16
drwxrwxrwt 6 root wheel 204 25 Jan 20:23 .
drwxr-xr-x 5 root wheel 170 25 Jan 16:17 ..
drwx-- 3 kevinbar wheel 102 25 Jan 16:44 501
-rw-r--r-- 1 kevinbar wheel 818 25
Hi,
I have a 4.0.7 mysql server which services requests from several virtual
web sites. Most of the times all works well but periodically the mysql
server suddently gets loaded to impossibly high values - load average up
to several hundred. During such periods the server sleeps and is not
I cannot seem to allocate any large amounts of memory to Mysql on our
system...
Can anyone suggest any settings/changes/etc to get this running to the
best of it's ability?
Dual 2Ghz G5, 4G ram, OSX 10.3.2, 73G-10Krpm Sata Raptor drives
Using both the 'Complete Mysql4.0.15 and Standard binary
Hi group?
What do you recommend someone who wants to install MySQL on RedHat?
Using RPMs or installing from SOURCE?
Install from the rpm's on mysql.com webseite.
What are the main differences and/or benefits?
By compiling your own mysql you can tune it better to your environment. If
you
Hello all,
I have a C function which makes various calls to the MySQL C API.
Every few times through the loop, the program SEGFAULTs on
mysql_free_result(). Now, tracing through the code using steps in GDB
and running inside of a memory profiler (valgrind) shows me nothing
concrete aside
How can I use the output string of the yearweek() function
(for example, 200346 below):
mysql select dayname(2003-11-12), yearweek(2003-11-12);
+---++
| dayname(2003-11-12) | yearweek(2003-11-12) |
Bill Thomason [EMAIL PROTECTED] wrote:
Here is my scenario:
I have 3 linux boxes - 2 with mysql 4.0.16 and 1 with 4.0.17.
I have a 4.0.16 master (sys1) replicating a database (db1) that is
roughly 1.5GB to a slave system (sys2) running 4.0.17. For the sake of
a formal representation I'll
Hi all,
Me needs to change the format of some telephone numbers which are placed in
a mysql database.
Current format: 49xyz
Wanted format: 0xyz
Now i know how to remove the leading 49:
UPDATE table SET field=(TRIM(LEADING '49' FROM field));
But how can i replace the 49 with a 0?
Or maybe in 2
When I try to upgrade from v4 to v4.1, I get the following dependencies
problems:
[EMAIL PROTECTED] trevor]# rpm -Uvh MySQL-shared-4.1.1-0.i386.rpm
error: Failed dependencies:
libcrypto.so.0.9.6 is needed by MySQL-shared-4.1.1-0
libssl.so.0.9.6 is needed by MySQL-shared-4.1.1-0
hi, i was solving same problem before month and i finished it by this way:
select dayname(2003-11-12), yearweek(2003-11-12),ADDDATE('2003-01-06',
INTERVAL 7*(WEEK('2003-11-12')-1) DAY),ADDDATE('2003-01-06', INTERVAL
7*(WEEK('2003-11-12')-1)+6 DAY);
but there is constant '2003-01-06', that's
On Monday 26 January 2004 13:17, Trevor Smith wrote:
When I try to upgrade from v4 to v4.1, I get the following dependencies
problems:
[EMAIL PROTECTED] trevor]# rpm -Uvh MySQL-shared-4.1.1-0.i386.rpm
error: Failed dependencies:
libcrypto.so.0.9.6 is needed by MySQL-shared-4.1.1-0
Mike Tuller [EMAIL PROTECTED] wrote:
I am trying write a shell script to check to see if a record exists and if
it does, update information, and if it doesn't insert information. Is there
a way to do an if else statement in MySql?
If you have PRIMARY KEY or UNIQUE index, take a look at
Hello,
I'm using the same sqls to append a new user to the MySQL-DB since 2
years.After upgrading from 3.23.57 to 4.0.17 I added a replication-user
with the same script that always worked right. When controlling the new
entry I was really surprised that I found two entries for the new user
Perhaps you could use an autoincrement field?
[EMAIL PROTECTED] wrote:
I would like to do the following:
INSERT INTO tt (a,i) VALUES ('text',MAX(i)+1);
This doesn't work b/c MAX() isn't allowed here. Does
anyone know how I can still achieve this with ONE
query?
Thanks.
Dan
--
MySQL
I figured out a little trick yesterday, I do not recommend it, but I did
work for me. I installed the rpm of MySQL-server, installed the client via
rpm, then when it came to the shared libraries. I went and downloaded the
binary build of MySQL then found the files I needed and put them in the
Chris Boget [EMAIL PROTECTED] wrote:
Can you UNION 2 queries and use the result to JOIN with another table?
(SELECT tableA.name, tableC.company FROM tableA)
UNION
(SELECT tableB.name FROM tableB)
LEFT JOIN tableC ON tableA.name = tableC.name;
This doesn't work. But I don't know if it
On Monday 26 January 2004 14:08, Donny Simonton wrote:
I figured out a little trick yesterday, I do not recommend it, but I did
work for me. I installed the rpm of MySQL-server, installed the client via
rpm, then when it came to the shared libraries. I went and downloaded the
binary build of
Title: Test!!!Please ignore this message
Hi fellows,
...just a test.Please ignore this message.
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER
Permanent e-mail address :
[EMAIL PROTECTED]
[EMAIL
smrtalec wrote:
whenever I try to connect to mysql logged on as anyone besides root I get teh error below. This isnt' making sence to me. The ps-ef output and the permissions info is also included.
mysql 2524 2500 0 15:41 pts/100:00:00 /usr/sbin/mysqld-max --basedir=/usr
You may be hitting an OSX limit. While you can install more than 2GB on
a system, I don't think any one process is allowed to allocated more
than 2GB of RAM to itself. It's not a 64-bit OS yet. You should be able
to search the Apple website for this limit.
On Jan 26, 2004, at 6:10 AM, Adam
ok, I have a table with 100,000+ records. 98% of these records are jobs that
have been completed. I have created an index for status. Status=4 is one
of 4 different states a job can be in prior to completion so we aren't
talking about a lot of records that meet that status level.
query = SELECT
I have an question about the design of a database. What is the best way
to design tables. Is it better to create many small tables, or create
fewer big tables. Which of those two options will get the best performance?
TIA,
Alex Croes
--
MySQL General Mailing List
For list archives:
At 11:19 -0800 1/22/04, David Blomstrom wrote:
I'm using a preconfigured package that includes PHPMyAdmin, which
seems to be a pretty good program. However, I just read that similar
programs are available, including MySQL Control Center, EMS MySQL
Manager, urSAL, PremiumSoft MySQL Studio
Alex croes said:
I have an question about the design of a database. What is the best
way to design tables. Is it better to create many small tables, or
create fewer big tables. Which of those two options will get the
best performance?
Don't worry about performance. If performance is really
Others on this list have claimed to be able to set over 3G, and my
failure is with even less than 2G (though, I am unsure if there is a
combination of other memory settings working together to create an 2GB
situation combined)
Even at 1.6G, which seems to work (though, -not- why we got 4G of
My bad... I was sure I had created a status index, however, after inspection
it appears I had not. I created it and presto! Performance is as good if
not better than when I had +- 20,000 records last week.
Thanks to anyone who concidered commenting,
Larry
-Original Message-
From:
I have an question about the design of a database. What is the best way
to design tables. Is it better to create many small tables, or create
fewer big tables. Which of those two options will get the best performance?
If you are asking whether to store the data all in one big table or a bunch
I realize that this might be problematic/devastating if you had an AI PK and
did this, however in my case there is no problem as there is no related data
in the database yet lol.
My question is, how can I reset AI? For example I deleted several rows and
now my AI starts with the AI number after
On Mon, Jan 26, 2004 at 10:40:02AM -0600, Paul Fine wrote:
I realize that this might be problematic/devastating if you had an AI PK and
did this, however in my case there is no problem as there is no related data
in the database yet lol.
My question is, how can I reset AI? For example I
2GB was the per-process memory limit in Mac OS X 10.2 and earlier. 10.3
increased this to 4GB per-process. I've gotten MySQL running with 3GB
of RAM on the G5 previously.
This is an excerpt from a prior email to the list from back in October
when I was first testing MySQL on the G5:
Hi,
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.
Thanks.
Hassan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
This statement works if I enter it directly into mysql:
UPDATE BEX_USER_REG_INFO SET STATUS_ID=5 WHERE
BEX_USER_REG_INFO.BEX_USER_REG_INFO_ID=2
Utilizing the openquery command I'm trying to do the same thing from a
MS SQL Server
SELECT * FROM OPENQUERY(MYSQLTEST, 'UPDATE BEX_USER_REG_INFO
* Bernd Tannenbaum
Me needs to change the format of some telephone numbers which are
placed in a mysql database.
Current format: 49xyz
Wanted format:0xyz
Now i know how to remove the leading 49:
UPDATE table SET field=(TRIM(LEADING '49' FROM field));
But how can i
I am stuck on this problem, and know there has to be a solution.
I have a shell script, where I want to check to see if a record exists, and
if it does then update the record with new information. If it doesn't then
insert the information gathered by a script.
How, in MySql, using a shell
the crashes below happen in independent areas of code. The 2 first are
inside InnoDB, and the third inside MySQL. This looks like random thread
crashes, or random memory corruption.
My colleague tells me that the third stack trace (the one inside MySQL)
is from a RESET MASTER. This
* Roger Baklund
UPDATE table SET field=CONCAT(0,TRIM(LEADING '49' FROM field));
.. and this will of course prefix _all_ numbers with a '0', not only those
that started with '49'... you should append WHERE field LIKE '49%' to you
update statement.
--
Roger
--
MySQL General Mailing List
For
how come no one response to my email?
thanks!
My question is below:
Hi,
I have some question on JOIN and INDEX usage on GROUP BY. Hope you can help
me. thanks!
1. If there is any performance differenct for join from a small table to a
big table and join from a big table to a small table?
2. If
you SURE you want to do that in a shell script? I'd do it in perl
On Monday 26 January 2004 11:39 am, Mike Tuller wrote:
I am stuck on this problem, and know there has to be a solution.
I have a shell script, where I want to check to see if a record exists, and
if it does then update the
We have a large database that consists of 1 table with 400 fields. I know,
the first thing you are thinking is normalize, it's not an option right now
and the database gets reloaded every 3 months. The table contains marketing
data so it is not as easy to normalize as an employee database, or
I have a fairly simple query where I feel it takes too long to run.
SELECT Products.NSIPartNumber,Products.Cost, Products.ModelNo,
Products.USPrice, Products.VendorPart, Products.Description ,
Products.ProductID, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products
LEFT JOIN tblInvTransaction ON
Jacque Scott wrote:
I have a fairly simple query where I feel it takes too long to run.
SELECT Products.NSIPartNumber,Products.Cost, Products.ModelNo,
Products.USPrice, Products.VendorPart, Products.Description ,
Products.ProductID, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products
LEFT JOIN
Yes, I saw this port before... I am not sure why I cannot allocate more
ram on this box- It is a clean 10.3 install, with 10.3.2 update. I got
this box as I love OSX, and have always loved apple, but, this is not
working out great. Much less powerful (and less expensive) units can do
a better
At 12:23 PM 1/26/2004, you wrote:
We have a large database that consists of 1 table with 400 fields. I know,
the first thing you are thinking is normalize, it's not an option right now
and the database gets reloaded every 3 months. The table contains marketing
data so it is not as easy to
In Access 2.0 and mySQL Products.ProductID is indexed but
tblInvTransaction.ProductID is not. I tried to set
tblInvTransaction.ProductID as indexed but it still took a long time.
Daniel Kasak [EMAIL PROTECTED] 1/26/2004 12:18:46 PM
Jacque Scott wrote:
I have a fairly simple query where I
At 02:18 PM 1/26/2004, you wrote:
Jacque Scott wrote:
I have a fairly simple query where I feel it takes too long to run.
SELECT Products.NSIPartNumber,Products.Cost, Products.ModelNo,
Products.USPrice, Products.VendorPart, Products.Description ,
Products.ProductID, Sum(tblInvTransaction.Qty) AS
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 Bottlenecks
Have you tried reworking your queries a bit? I try to avoid using IN
as much as possible. What does EXPLAIN say about how the long queries
are executed? If I have to match something against a lot of values, I
select the values into a HEAP table and then do a join. Especially if
YOU are going
Im looknig for the function that will allow me to export the database
structure into a static file, without the actual data.
I would like to create an ERD diagram with the output file.
David
How did you determine the bottleneck was the left join? I would have
thought it was the WHERE clause.
I'd be curious what the times are on these queries:
SELECT count(*) FROM Products
LEFT JOIN tblInvTransaction ON Products.ProductID =
tblInvTransaction.ProductID Where ((NSIPartNumber Like
David Perron wrote:
Im looknig for the function that will allow me to export the database
structure into a static file, without the actual data.
I would like to create an ERD diagram with the output file.
David
mysqldump -d
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77
The primary server (Dual Athlon) has several U160 scsi disks, 10K and
15K rpm... Approximately half the full size images are on one 73G U160,
the other half on another (about 120G of large images alone being
stored... I am trying to get him to abandon/archive old/unused images).
The
I have added these settings to my newer my.cnf, including replacing the
key_buffer=1600M with this 768M... It was a touch late today to see if
it has a big effect during the heavy load period (~3am to 4pm EST, site
has mostly european users)
I did not have any of these settings explicitly set
phpMyAdmin also give a nice, simple frontend for doing this... copy
tables or db's with/without data.
Personally, I don't think mysql should be used on a box without
phpMyAdmin on it, at least as a backup admin tool;)
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 26, 2004,
Can I install MaxDB 7.5 on Suse 9?
If yes How?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The first query that you wrote took 5.93 seconds with count of 523. The
second query took so long I aborted it. The way I figured it was the
'Left Join' was by running the following query.
#1: This takes out the join and sets 'Products.ProductID =
tblInvTransaction.ProductID' to join the two
Mike,
I used Explain and I don't see anything that says indexes. I use the
Control Center for all of my stuff. Would it show in there?
88 rows are returned both in mySQL and Access.
Brent Baisley [EMAIL PROTECTED] 1/26/2004 2:03:10 PM
How did you determine the bottleneck was the left
Chris,
We have found the same thing, the more indexes you add the longer it takes
to add another index. This is because at least from what I understand is
the index/MYI file is recreated when you add another index.
I don't know enough about INNODB but based on what I do know you would do
much
Hi all,
I've been away from the list for a while and am wondering if the
following question has been answered:
Given that the extremely funky InnoDB is going to gain a new file format
in the future, would it be a fair guess to say that any additions to
InnoDB requiring file format changes would
i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back
reporting heaps of errors like the following:
from Perl.xs:1:
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:380:
30: sys/types.h: No such file or directory
Hello
I found today that some data on slave server were different than on master
server. I dont know how that can happen. Slave server was running, show
slave status show no errors
If I make some updates on slave server. Does this updates will be reflected
on
master server? Or slave cannot
Setup: MySQL 4.0.17 Source Install, Linux 2.4.20
I am trying to specify the locations of the lib, include, and share
directories with the configure script. When I use a --prefix (as is
mentioned in the manual in section 2.1.8) I get the locations such as
lib/mysql, include/mysql, share/mysql.
I installed DBI and dbd:mysql on 10.3.2 a few months ago and had all
sort of problems but I finally got it to work.
I don't exactly remember what finally did it, though. I think it might
have been running the install with sudo, as in:
sudo perl -MCPAN ... etc.
but I'm not sure. If you
i'm already logged in as SU so sudo won't help.
thanks anyways.
ta
tait
On 27/01/2004, at 12:12 PM, Douglas Sims wrote:
I installed DBI and dbd:mysql on 10.3.2 a few months ago and had all
sort of problems but I finally got it to work.
I don't exactly remember what finally did it, though. I
I just installed the server logistics package of mysql 4.0.15 and am getting
the following error entry in the error log on attempting to start the
server:
040126 20:43:45 mysqld started
/Library/MySQL/libexec/mysqld: ERROR: unknown variable
'innodb_buffer_pool_size = 70M'
040126 20:43:45
Hi everyone,
Sorry to ask this question, because this is going to get complicated...
Okay - what I need to do is be able to search for data across multiple
fields which are organized in multiple tables. Here is a basic
description of my database schema (not quite all of the fields...):
Table
At 0:49 + 1/27/04, Mike Mapsnac wrote:
Hello
I found today that some data on slave server
were different than on master server. I dont
know how that can happen. Slave server was
running, show slave status show no errors
If I make some updates on slave server. Does this updates will be
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 - Free web
Anything after the ? is a URL variable and you can use that in your Perl
code by referencing the $ENV{'QUERY_STRING'}.
A quick hack example (you will obviously want to check to make sure the
data is what you think it is and does not contain garbage stuff::
$someData = $ENV{'QUERY_STRING'};
Fink works excellent for DBI, and even for mysql. You can also change
the mysql.info file to add compiler options, like G5 optimizations,
openssl, etc.
http://fink.sourceforge.net/
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 26, 2004, at 8:50 PM, tait sanders wrote:
Try commenting out the entry in the file /Library/MySQL/var/my.cnf
If it does not exist, copy one of the files from
/Library/MySQL/dist/my-small,medium,large.cnf
renamed to the above location, or, to /etc/my.cnf
Though, you may want to try uninstalling the package and reinstalling
it
72 matches
Mail list logo
