On Thu, Oct 30, 2003 at 12:03:58AM -0600, Adam Clauss wrote:
Narrowed it down - it doesn't seem to have anything to do with the table
locking. I removed ALL locking/unlocking and it made no difference. Still
getting there error.
What would cause the 127 error? (perror says: 127 =
Hi Avenger,
Glad it's working well. :-)
Your index was slower than mine because the ArticleID column wasn't
included in it at the end. While yours allowed MySQL to use it to find
rows matching the WHERE and to resolve the ORDER BY without using
filesort, MySQL would have to go to the data file
hi,
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]
Sent: 30 October 2003 01:14
To: [EMAIL PROTECTED]
Subject: RE: Multiuser Programming
Chris said:
I'm not familiar with that function in MS SQL, and you're a bit unclear,
but it looks like you might be
I have sorted out the root password.
Can anybody please help me find out why I can't connect to localhost.
since i tried to install and configure mysql.
I can't connect to apache server from other machines. It says
connection was refused when connecting localhost.
Any way of finding the problem
Hi there
I was wondering I you can send your comments and remarks for this my.cnf
file
o.s. redhat9
tables 20Mb
mem: 8gb
server dedicated to mysql
max_connections=2000/3000
uses only innodb tables
my.cnf
[mysqld]
port= 3306
socket =
I'd up your buffer sizes - the mysql manual has some clues as to setting
these values? You might want to increase the query cache size.
I'd then run it and watch the stats.
Greg
snipped
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Dear TS Wong,
please send the whole .err log to me [EMAIL PROTECTED]
What MySQL versions and what Linux kernel version you are running?
Thank you,
Heikki
- Original Message -
From: ts.wong [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, October 30, 2003 5:25 AM
Scot [EMAIL PROTECTED] wrote:
New subscriber to the list, searched the archives for any thread on this
with no joy so
sorry if it's a re-post.
Can I have 2 bind-addresses in my.cnf ?
No.
Changing ports is not an option.
Dual honed Sun Box running MySQL 4.x
--
For technical
Hi,
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_buffer_pool_size = 6G
it looks like your InnoDB tablespace is less than 2G.
If it is true then IMHO it doesn't make any sense to allocate 6G for
innodb_buffer_pool.
InnoDB won't use it.
Best regards,
Mikhail.
-
Hi
Rekall, the programable, cross platform, database independant, database GUI
client is no longer available from theKompany.com
Many of our supporters have sent email asking for a reason why Rekall has
been taken away from theKompany.com (TKC). Basically, the answer is TKC is
bankrupt. TKC's
Hi All
after a bit of help on how to import data from a pastel accounting database into
mysql, i also need to remove some lines out of the pastel txt file before importing
into mysql
eg 1
*PC\CC-ABS533 ,COMPUCON Abacus Celeron/Pentium PC
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,
has to end up with
You have to use bind_param() to identify the parameter as an integer.
Rudy Lippan, the author of DBD::mysql, had a message about it on the
dbi-users list:
Thanks Keith, that explains it... I do not like this new behaviour of
DBD, though. I think it should be the other way around: let those
I can login on console. I can telnet 192.168.1.20 3306 from a remote host
but when I try to connect using perl DBI i get this error:
DBI connect('database=test;hostname=192.168.1.20','root',...) failed: Access
denied for user: '[EMAIL PROTECTED]' (Using password: YES)
I added Host 192.168.1.10
* Mike Brando
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
I'm not familiar with that function in MS SQL, and you're a bit
unclear, but
it looks like you might be able to use temporary
tables.
Looks like he's asking if MySQL supports namespaces. Is there anyway
Are you saying I have to upgrade to 4.0.2? Is this the best path for me to
take?
Dickon...
- Original Message -
From: Chris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 7:24 PM
Subject: RE: show databases problem
In 4.0.2 SHOW DATABASES became a
Thanks Jeremy, I´ll try this.
Leo
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Leonardo Rodrigues [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, October 24, 2003 5:23 AM
Subject: Re: Optimizing table (so-called VACUUM on postgreSQL) and InnoDB
On Thu, Oct
This problem is bugging me for a while now:
I have a table which has three columns:
'table':
start: long integer
end: long interg
property: varchar(200)
Now I am trying to retrieve the 'property' for a 'number':
select property from table where number between start and end
well, easy
* Trevor
after a bit of help on how to import data from a pastel
accounting database into mysql, i also need to remove some lines
out of the pastel txt file before importing into mysql
You are defining your new problem to be something to be sorted out before
mysql is involved, in which case
I added Host 192.168.1.10 user root with passowrd in mysql user table.
Did you flush privileges?
did you hash the password using the 'password' function?
did you type the password correctly ?
Ideas? What else?
Thanks.
--
--
nm [EMAIL PROTECTED] wrote:
I can login on console. I can telnet 192.168.1.20 3306 from a remote host
but when I try to connect using perl DBI i get this error:
DBI connect('database=test;hostname=192.168.1.20','root',...) failed: Access
denied for user: '[EMAIL PROTECTED]' (Using
Yup...latest stable is 4.0.16!
Does anyone know what I need to do to stop SHOW DATABASE? Even though I
specify in /etc/my.cnf
Dickon...
- Original Message -
From: Fortuno, Adam [EMAIL PROTECTED]
To: 'Dickon Newman' [EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 9:16 AM
Subject: RE:
Johannes Ullrich wrote:
This problem is bugging me for a while now:
I have a table which has three columns:
'table':
start: long integer
end: long interg
property: varchar(200)
Now I am trying to retrieve the 'property' for a 'number':
select property from table where number between start
Hello All,
I have two table the look like this (greatly simplified):
ResourceTable
-
int ResourceID
var ResourceName
ResourceLinkTable
-
int ResourceLinkID
int ResourceID
var Text
I need to find all rows in ResourceTable for which there is NO entry in
Wasn't there some claus in TKC's website that said if they go out of business, they
will release all software under the GPL after one year?
Steve Lefevre
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 7:09 AM
To: [EMAIL PROTECTED]
This is a common question. The syntax looks like this:
SELECT a.*
FROM tbl_a AS a LEFT JOIN tbl_b AS b
ON a.id = b.id
WHERE b.id.id IS NULL;
The idea is you're retrieving a recordset of the two tables where the rows
are joined on the id. For tbl_b, the id field has no value (its null)
Parminder Singh Chauhan [EMAIL PROTECTED] wrote:
Thanks
Now I am able to get back the cursor
but I can't change the password
[EMAIL PROTECTED] parminder]# /usr/local/mysql/bin/mysql -u root
mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your
Dan,
SELECT ResourceTable.* FROM ResourceTable
LEFT JOIN ResourceLinkTable
ON ResourceTable.ResourceID = ResourceLinkTable.ResourceID
WHERE ResourceLinkTable.ResourceID IS NULL;
Regards,
Thomas
On Thu, 30 Oct 2003, Dan Lamb wrote:
Hello All,
I have two table the look like this
Dickon Newman [EMAIL PROTECTED] wrote:
Yup...latest stable is 4.0.16!
Does anyone know what I need to do to stop SHOW DATABASE? Even though I
specify in /etc/my.cnf
From version 4.0.2 user can't see databases if he doesn't have permissions on these
databases or SHOW DATABASES privilege.
Hi all,
I was reading the SAP DB chapter on mysql.com.
I did not find all the answers for my questions, and maybe one of you knows them.
So, I am in the designing phase of a robust enterprise database applications with a
lot of modules.
I am planning to use MySQL/InnoDB as a database server,
No, 4.0.2 is older than your version, just check the privileges, and set any
of them to 'N' where you don't want them (if any of them are set). It's just
a possible cause/solution.
Chris
-Original Message-
From: Dickon Newman [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003
What version of MySQL are you using?
Ver 4.1 supports sub-queries.
So, you may issue:
DELETE FROM table2
WHERE msg_id IN(
SELECT msg_id FROM table1
WHERE ((TO_DAYS(NOW()) - TO_DAYS(date_column)) 45)
)
Thanks
Emery
- Original Message -
From: Luis Lebron [EMAIL
Hi, I would like some more extensive logging output, so
I can see what sessions begin etc. In other words, enable
general logging. I'm running RedHat 9 w. mysql-3.23.58
I've tried to add the log=[file] to my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
I am new to the world of GIS and have an application where I would like
to use MySQL's (found in 4.1 alpha currently) Spatial Extensions. I
have a set of latitude and longitude for various locations and am trying
to figure out how to convert to the SRID units. I have started going
thru the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael McTernan wrote:
Hi Larry,
I was wondering a similar thing, but for JDBC using connection
pooling. In
your example you say that 2 people will hit the script at the same
time; if
they are using independent connections this should cause no
Alexander Barkov wrote:
Héctor,
Changing various buffer sizes can improve performance significantly,
with key_buffer_size as the first thing to tune.
Also, make sure you are using not debugging version of the server.
Please also take a look in this section of the documentation
for details:
Hello,
Can somebody give me some instructions on how to uninstall Mysql
4.1. I have a redhat 2.1 AS box. I installed the rpm dist from
mysql.com. I want to put MySql 4.0 on that machine. I would think this
is something fairly easy to do. I cannot seem to locate any
instructions though.
On Thursday, October 30, 2003, at 08:19 AM, Leonardo Rodrigues wrote:
My question are: are these commands similar to VACUUM? What´s the
difference? How can I run on InnoDB?
I don't know much about PostgreSQL, so I'm not sure. If you describe
what VACUUM does, I may be able to help explain how
Hi, List,
I looked here:
http://www.mysql.com/doc/en/String_comparison_functions.html
But I am not seeing what I need.
I want to do a string comparison like this:
SELECT * FROM sometable WHERE surname LIKE '[A-C]%' ORDER BY surname;
This works in another RDBMS. It doesn't return a syntax
This should work for you:
SELECT * FROM sometable WHERE surname BETWEEN 'A' AND 'D' ORDER BY
surname
In my quick test the first parameter is inclusive while the second is
not, which is why it is D and not C.
On Thursday, October 30, 2003, at 02:22 PM, Scott Brown wrote:
I want to do a string
Hello,
I have basic replication working between a master and slave.
I'm attempting to clarify what happens during a master failure, master
reintegration scenario using heartbeat- and mysql-3.23.52-27.
Clients connect to a movable IP managed by heartbeat.
M=master, S=slave
# my.cnf
You can use RLIKE which is regular expressions then you should be able to execute
SELECT * FROM sometable WHERE surname RLIKE '^[A-C]' ORDER BY surname;
Kelley
Scott Brown wrote:
Hi, List,
I looked here:
http://www.mysql.com/doc/en/String_comparison_functions.html
But I am not seeing
Someone told me that it is possible that MySQL will automatically change
column types in certain situations. For example the a table with a char(5)
type field might dynamically change to a varchar(5) type field. So a static
length column to a variable length column. Is this possible? If so what
Thanks for all of the responses!
Actually, Brent Baisley wins the syntax question of the day. The BETWEEN
syntax is what I needed.
REGEXP and RLIKE do not return any records, they return a count of the
number of rows matching the expression.
Thanks!
--Scott Brown
At 11:22 AM 10/30/2003, you
Thanks so much Brent, this is what I was looking for.
However, what do I do when I get to 'Z'?
I looked here, and now I am really confused:
http://www.mysql.com/doc/en/Comparison_Operators.html
It seems to say that BETWEEN returns a rowcount as well?
I am guessing that these all return
Hi everyone.
I've got a web app that I'm getting ready to make public and I'm to figure
out how well MySQL will utilize multiple processors.
Has anyone seen how MySQL would scale from 1 to 8 processors? Is it even
remotely close to linear?
My dev environment is W2K, but production will run Red
There's only one condition that I know of that will cause MySQL to
change char to varchar. If there is another variable length field
defined, like text or blob, then MySQL will change your fixed length
char to variable length char. This is because the existence of a
non-fixed length column
I am learning to query the MySQL database
artimus_article. My database is a storage of articles
with name of the creator, title of the article, the
category in which the article is classifies, ,
etc.
I try to search articles by the name of the creator
within the computer science category.
Oh, well, chalk it up to experience. RLIKE is what works the way I want. DOH!
Thanks,
--Scott Brown
At 12:34 PM 10/30/2003, you wrote:
Thanks so much Brent, this is what I was looking for.
However, what do I do when I get to 'Z'?
I looked here, and now I am really confused:
The BETWEEN operator works like and greater and less than search.
So, you can do the exact same query like this:
SELECT * FROM sometable WHERE surname='A' AND surname'D'
MySQL may actually optimize them the same way, but using BETWEEN is
more readable.
To include 'Z', just do a greater than
Hello, I'm new to SQL and MySQL, I'm developing a web application (php) and I need
some tables relationed between them with a foreing key. The idea is the following
create table persons (
cid smallint auto_increment not null unique,
name varchar(30),
alias varchar(10),
primary
I am using MySQL version 4.0.11 gamma on Linux 7.1 and have just
experienced the following problem:
INSERTed a record into a InnoDB table, then used SELECT to retrieve the
recordID (auto numbered field) from the same table using a key. The
SELECT returned the proper ID. However, when
Hi, a while ago I upgraded from version 3.23.54 to 4.0.16 I downloaded the rpm's to
usr/src/rpm
I can't remember the syntax to install all the rpm's it was something like ' U rpm '
any help appreciated
I have to write this up so best I get it right.
Thanks Bob
Greetings,
I've got two tables that I want to join on building and room. Right
now I'm doing it on Building Name, but I was wondering if it would be
better to have a column for the building number in each table and do the
join on that instead. Is it better to join on numbers rather than
Did you commit the transaction?
Kevin Carlson wrote:
I am using MySQL version 4.0.11 gamma on Linux 7.1 and have just
experienced the following problem:
INSERTed a record into a InnoDB table, then used SELECT to retrieve
the recordID (auto numbered field) from the same table using a key.
man rpm
Robert Morgan wrote:
Hi, a while ago I upgraded from version 3.23.54 to 4.0.16 I downloaded the rpm's to usr/src/rpm
I can't remember the syntax to install all the rpm's it was something like ' U rpm ' any help appreciated
I have to write this up so best I get it right.
Thanks Bob
gerald_clark wrote:
Did you commit the transaction?
Yes, the transaction was committed. I was using MyCC at the same time
the anomaly occurred, also. Could this have had anything to do with it?
Kevin Carlson wrote:
I am using MySQL version 4.0.11 gamma on Linux 7.1 and have just
Is it anyone elses experience that queries with large IN stanzas in a
WHERE clause don't scale very well?
It seems like it's beyond a linear performance hit when I have a large
number (thousands) of tokens in an IN clause, even when the matching
field is indexed.
Is this something that buffer
Hi,
No, col BETWEEN 'A' AND 'D' is not the same as col = 'A' AND col 'D'.
BETWEEN is equivalent to col = 'A' AND col = 'D'. One will include
cols that equal 'D' and the other won't. :-)
Matt
- Original Message -
From: Brent Baisley
Sent: Thursday, October 30, 2003 3:12 PM
Subject:
Kevin Carlson mailto:[EMAIL PROTECTED]
on Thursday, October 30, 2003 2:38 PM said:
Yes, the transaction was committed. I was using MyCC at the same time
the anomaly occurred, also. Could this have had anything to do with
it?
What was the star date of said anomaly?
TEEHEE!
Chris.
--
On Thu, 30 Oct 2003 15:48:05 -0700, Knepley, Jim [EMAIL PROTECTED] wrote:
Is it anyone elses experience that queries with large IN stanzas in a
WHERE clause don't scale very well?
It seems like it's beyond a linear performance hit when I have a large
number (thousands) of tokens in an IN clause,
Hi everyone,
I'm looking to execute a script directly on the server with an ODBC
application. Presently I'm using access XP (2002).
If anybody have an idea how I can do this, I'm waiting for it!
Thanks ppl,
David
Hi Jim,
It's probably the time taken to parse the query with so many IN ()
values than it is to actually look them up. You can get an idea of how
long it takes to parse the query by comparing the time with 1 IN value
vs. thousands without the IN values actually matching any rows (e.g.
dummy
Hi,
I don't think MySQL is doing what's best. *I* am the one who knows best
and I don't want MySQL changing column types.
An example is a table I have where I'd like to have a TEXT column with a
value that is basically NEVER changed after being inserted. I can run
OPTIMIZE on this dynamic row
Hello,
I have 2 databases in different places. There is 1 question and 2
problems about that..
What happens if one server fails to be in internet for some time ?
log-bin on another one grows and after the connection is
reestablished, all updates are made.. Right ?
How can I make sure that
to upgrade:
rpm -U rpm_package_name
but you must read mysql upgrading topic in mysql manual reference to avoid
any problem.
- Original Message -
From: Robert Morgan [EMAIL PROTECTED]
To: mysqllist [EMAIL PROTECTED]
Sent: Friday, October 31, 2003 5:45 AM
Subject: upgrading
Hi, a while
Dear All,
How do I know that User USER1 already login to Mysql?
I am creating multiuser program and need to set only one User Name uses at
same time. If there is 3 users that my login as User1, User2 and User3.
William
--
MySQL General Mailing List
For list archives:
Yes, the transaction was committed. I was using MyCC at the same time
the anomaly occurred, also. Could this have had anything to do with
it?
I am new to MySQL - do you *have* to commit the transaction after the
insert?
What is the benefit of the commit - does it do anything?
-Erich-
* William IT
How do I know that User USER1 already login to Mysql?
SHOW PROCESSLIST will list all connections and the corresponding user.
I am creating multiuser program and need to set only one User Name uses at
same time. If there is 3 users that my login as User1, User2 and User3.
In
* Erich Beyrent
[...]
I am new to MySQL - do you *have* to commit the transaction after the
insert?
Only if you are in an active transaction. MySQL supports multiple table
types, both transcational and non-transactional. BDB and InnoDB are the only
transcational table types in MySQL, and by
Hi all,
I am a novice in mySQL and would like to use it to embark a Ecommerce project. I have
the following OS/Hardware issues that I hope to know:
1. I plan to install in Red Hat Linux Advanced Server. What version is certified, any
pre-reqs?
2. I will use Intel server. What chip is
Hi all,
I am a novice in mySQL and would like to use it to embark a Ecommerce
project. I have the following OS/Hardware issues that I hope to know:
1. I plan to install in Red Hat Linux Advanced Server. What version is
certified, any pre-reqs?
2. I will use Intel server. What chip is
hello david, I have some questions. can you help me ? thank
you!!
such as:
I complie postfix 2.0.16 + mysql 4.0 binary mode + sasl2 but i get
'ld' errors, while it only works with sasl2 well.
env: solaris8 64bit, gcc3.3 make3.8, zlib, guntar 1.1.3,
libgcc3.2...
command: make makefiles
Run this command to list your currently installed packages:
rpm -qa | grep -i mysql
Then for each package listed, run:
rpm -e PACKAGE_NAME
This rpm -e will remove your MySQL package. There should be separate
packages for MySQL: server, client, shared libraries, etc. Remove all of
them that
73 matches
Mail list logo