On Mon, Feb 17, 2003 at 01:37:59AM -0600, Jason Maskell wrote:
Perhaps the subject will get someone to actually read this and offer even
one reply with a suggestion?
I admit that the topic got my attention - perhaps not in the best way
though.
I can offer a few suggestions:
Provide
Hi!
On Feb 16, Dan Nelson wrote:
In the last episode (Feb 16), Michael T. Babcock said:
At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote:
Well, MySql stores all its index information in one index file,
so when you add another index it has to rebuild the WHOLE file.
:)
Anyone
The tables I am querying the most are quite small. I just query them a lot.
The system processes about 500k requests a day, and each request involves
multiple queries.
I have just enabled a bunch of logging to try and puzzle out what is going
on, but I can't see it being a help.. The same queries
Hi!
On Feb 16, david wrote:
Hi
I have one table with 12 million records. I'm trying to create an index
on one of the fields and it's taking hours ( over 6 so far)! Am I doing
something wrong?
The command I issued was
create index title on article ( title);
The table files are
Hi!
On Feb 17, Brandon Young wrote:
Hello, all. I have been staring at this problem for an entire day.
Googling turns up very little in the way of helpful information for
solving my problem.
I started a new tutorial, and ran into a problem. When I attempt to add
a new database, I get
Hi all,
Can I just check, does MySql v.3.23.52 do table locking or row locking? If
it only does table locking, are there any versions of mysql that do row
locking?
Thanks
---
Rob
**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business
Hi all,
Can I just check, does MySql v.3.23.52 do table locking or row locking? If
it only does table locking, are there any versions of mysql that do row
locking?
Thanks
---
Rob
**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business
On Mon, Feb 17, 2003 at 11:00:37AM +0200, Rob wrote:
Hi all,
Can I just check, does MySql v.3.23.52 do table locking or row locking? If
it only does table locking, are there any versions of mysql that do row
locking?
Detailed in the fine manual:
Can I just check, does MySql v.3.23.52 do table locking or row locking?
If
it only does table locking, are there any versions of mysql that do row
locking?
Always Read The Fine Manual:
From http://www.mysql.com/doc/en/Locking_methods.html:
Currently MySQL only supports table locking for
Thanks
It would appear that MySql does table locking. Then I would like to ask the
following:
We have a documents table in our Document Management System, which obviously
gets used quite a
lot :-). We're running stress tests on our application (which is a PHP,
Apache, MySql combo)
and we're
On Mon, Feb 17, 2003 at 11:22:27AM +0200, Rob wrote:
Thanks
It would appear that MySql does table locking. Then I would like to
ask the following:
Hi Rob,
I think that you missed some important details.
Taken from the manual:
MySQL only supports table locking for ISAM/MyISAM and
È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí.
ÎÒ˾ÍƳöÆóÒµ½¨Õ¾×¨Óÿռ䣬ȫÃæÖ§³ÖJSP¡¢ASP¡¢PHP¡¢ASP.NET£¬ÏÖÕýÃæÏòÈ«¹ú¸÷µØ³ÏÑû´úÀí£¬ÀûÈó¿É´ï40%£¡
*ÉêÇëʱ´´ÍøÂçµÄ´úÀí£¬³ýÁË¿ÉÒÔÏíÊÜÈ«·½Î»µÄ»¥ÁªÍø²úÆ··þÎñ£¬»¹¿ÉÒÔÃâ·Ñ»ñµÃÓòÃû¡¢¿Õ¼ä¡¢ÖÇÄܽ¨Õ¾¡¢¶¯Ì¬IPµÈµÄÔÚÏß×¢²á´úÂ룬·½±ãÄú¼°Ê±¿ªÕ¹ÒµÎñ¡£
It would appear that MySql does table locking. Then I would like to ask
the
following:
From what I've read,
it would seem that SELECTS get a lower priority than INSERTS and UPDATES,
meaning that if all 30 users
insert into that table at the same time (given the way the stress test is
Can somebody confirm this please?
Martin
Subject: UPDATE over 3 tables crashes in InnoDB
Description:
I have 3 InnoDB-tables with about 6000 records each:
customer 1:n orders 1:n invoices
When trying to make the following update:
update customer, orders,
Hi,
If you only want to move database Protein (and not all your databses)
you can use symbolic links to do that.
You can move your database to the desired path (external drive) and
create a symbolic link in /var/lib/mysql/ to it like:
localhost:/var/lib/mysql# ln -s /desired_path/Protein Protein
* Lewis Watson
I have a table with three fields. In the first field I have a range of
numbers 1-20; all repeated more than once. In the third field I have a
number ranging from 1 to 20 in each row. I need to choose the
lowest amount in the third column for each distinct value in the
On Mon 2003-02-17 at 03:38:07 -0600, [EMAIL PROTECTED] wrote:
Reply when you have a job, dumbass.
I have a system that makes more in a week than you make in a year
crashing because of this buggy piece of shit.
If a system supposedly making millions a year is unstable you are a
fool that you
Sergei Golubchik wrote:
Which decision, putting all the indexes in one file, or rebuilding all
indexes whenever you ALTER TABLE or add an index? If the latter, I
agree with you. Modifying unrelated indexes or columns should not
force a rebuild of every index.
Of course not.
And it won't
On Mon, 2003-02-17 at 12:57, [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query,queries,smallint
If you just reply to
* Dee
I have a table that contains ids for several other tables. Setup is as
followed:
+--+--+--+-+-+
+
| Field| Type | Null | Key | Default | Extra
|
Anybody can help this???
thanks
regards
sunil
Hi,
I am facing mysql shutdown process hanging problem on Solaris 5.8,
mysql 3.23.40
I am running our product Web NMS which uses MySQL DB, on solaris
machine.
While shutting down the application, except MySQL process, all other
process are
Hi,
I have installed the 4.0.10-gamma with support from the openssl v. 0.9.7
on the Debian Woody:
mysqlstatus
...
SSL:Cipher in use is DHE-RSA-AES256-SHA
...
mysqlshow variables like '%openssl%';
+---+---+
| Variable_name | Value |
+---+---+
On Solaris I always use :
/etc/rc3.d/S99mysqld stop
/etc/rc3.d/S99mysqld start
Jerry
- Original Message -
From: Sunil Gavaskar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Sinisa Milivojevic [EMAIL PROTECTED]
Sent: Monday, February 17, 2003 2:50 PM
Subject: Re: mysql shutdown
On Mon 2003-02-17 at 12:14:12 +0100, [EMAIL PROTECTED] wrote:
[...]
Please disregard this mail. It was not supposed to go to the list.
(forgot to remove the CC that my mailer is set up to automatically
append for mails going to my -mysql address).
My apologies about that, Jason.
Bye,
What you have there is a subselect, which are not supported in mysql 3.2x,
but I *believe* are supported in 4.0+ (gamma and 4.1alpha). Don't take my
word for it and check the docs first.
--Joe
--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
Label makers are proof God wants Sys Admins to
thanx joe, i checked.
I just thought that there could be a way around this problem!
From: Joe Stump [EMAIL PROTECTED]
To: Inandjo Taurel [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: How to write delete query??
Date: Mon, 17 Feb 2003 09:46:53 -0800
MIME-Version: 1.0
Received: from
Inandjo,
- delete from table1 where table1.field1 in (select distinct field2 from
table2).
Subselects (or nested queries) like that are supported as of MySQL
4.1. At this moment, you will have to compile 4.1 yourself; it's
expected to be out as a binary version in the next couple of weeks.
The
Inandjo
- delete from table1 where table1.field1 in (select distinct field2 from
table2)
From what I've read subqueries are not yet supported. We worked around
this by converting the distinct list to a comma delimited list of
values. E.g.,
Hi all,
Just jumped on the list, hoping someone can give me a hand. The query below
uses a join, I guess, to select records from table stat_1_1 based on
information in table stat. I'd like to be able to turn this query into a
delete query but only want records removed from stat_1_1. Can anyone
mysql:ÄúºÃ!
Èç¹ûÄãÏÖÔÚÏëÕõÇ®µÄ»°£¬http://platinum-mails.ebiz-enterprises.com/?r=chenggong´ò¿ªºó×¢²á£¬×¢²áÓÐ$50£¬Ã¿½éÉÜһλÓÐ$15,$200Æð¸¶
[×¢Òâ]Ҫ׬Ǯ¾Í¿´°¡~ºÃ¶«Î÷~
׬ǮµÄºÃ·½·¨£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
²»ÂÛÄãÐŲ»ÐŶ¼²»·ÁÊÔÊÔ°É
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?
Thanks,
Ed
mysql
-
show tables from databasename;
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 February 2003 16:11
To: [EMAIL PROTECTED]
Subject: Checking existence of a table.
What query would I use to check for an existence of a table within a
database? I'm
At 11:10 -0500 2/17/03, [EMAIL PROTECTED] wrote:
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?
You can check the output of SHOW TABLES or
At 9:32 -0600 2/17/03, Mayo, Chuck wrote:
Hi all,
Just jumped on the list, hoping someone can give me a hand. The query below
uses a join, I guess, to select records from table stat_1_1 based on
information in table stat. I'd like to be able to turn this query into a
delete query but only want
At 9:32 -0600 2/17/03, Mayo, Chuck wrote:
Hi all,
Just jumped on the list, hoping someone can give me a hand. The query below
uses a join, I guess, to select records from table stat_1_1 based on
information in table stat. I'd like to be able to turn this query into a
delete query but only want
Thanks for all the replies. I've got a hnadle on it now.
Ed
On Mon, 17 Feb 2003, Paul DuBois wrote:
At 11:10 -0500 2/17/03, [EMAIL PROTECTED] wrote:
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this
Hello,
When using the following on MySQL:
select count(xFld) from aTbl group by xFld;
I get twice the time it takes to process:
select xFld from aTbl group by xFld;
Can any one explain this and maybe help find a solution?
I'm using MySQL version 3.23.54 on NT and 3.23.41 on Linux, both
On 17-Feb-2003 [EMAIL PROTECTED] wrote:
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?
Thanks,
function tableexists($tbl) {
Hello,
I've tried to rename a temporary table, and I got an error
ERROR 1017: Can't find file: './GOdevel/xgp.frm').
I guess it does not make too much sense to rename a temp table ... .
However,
I thought this might be worth mentioning.
regards,
Arne
not to be bounced:
sql,query,queries,smallint
HI all
I'm searching in how to generate a auto_increment number starting form 1
every year
I mean
ID DATE
1 2003
2 2003
1 2004
2 2004
etc
maybe possible or I've to use some c code to make it possible ?
Yes, this is possible.
Ed,
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?
In MySQL, you can issue:
SHOW TABLES [FROM your_database] LIKE 'your_pattern'
Where
Martin,
this bug in multi-table UPDATE on InnoDB tables was reported 3 weeks ago and
Sinisa has fixed it to upcoming 4.0.11.
Regards,
Heikki
Innobase Oy
sql query
..
Subject: Bug? Update on 3 tables crashes in InnoDB
From: Martin Thoma
Date: Mon, 17 Feb 2003 11:57:12 +0100
Hi!
I have the same problem in my new Red Hat 8.0 / Athlon 1.8 GHz laptop.
If I build MySQL-4.0.10 from source with
./BUILD/compile-pentium-debug
it crashes in installing MySQL system tables. If I use a MySQL binary distro
to install the system tables, then the mysqld I built may crash in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jerry, et al --
...and then Jerry said...
%
% Is it just me or is everyone on the list getting junk/spam from naver.com ?
Haven't seen any, assuming you spelled it right. I just checked through
my entire mysql folder and have only your and
Hi,
Compilation of mysql 3.23.55 fails ONLY when using --with-mysqld-ldflags=-all-static
results in broken mysqld.
Segmentation fault?
Resolving stack trace:
0x808f4d4 _Z15handle_segfaulti + 404
0x81bc67a __pthread_sighandler + 122
0x81ceb4d __strtol_internal + 1421
0x8096cf6
I have encountered what appears to be a bug in MySQL regarding ORDER
BY related to a date field when also used in conjunction with
DATE_FORMAT() or UNIX_TIMESTAMP(). When these functions are applied
to my date field, MySQL ignores any included ORDER BY within the
query. I first noticed this
On Monday 17 February 2003 04:20, Lewis Watson wrote:
I have a table with three fields. In the first field I have a range of
numbers 1-20; all repeated more than once. In the third field I have a
number ranging from 1 to 20 in each row. I need to choose the
lowest amount in the third
It would be nice to extend the user permissions table to have per-user
limits like max_user_connections and the various timeouts applying
directly to specific user/host combinations.
Just a thought / suggestion.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. SQL
6@74 is obviously not a real email address but this is happening on a
fairly regular basis from this mailing list. I can't see the message so
I can't tell if it is spam or not but if you are not seeing your
messages on the group then you might want to see if your email client is
confused about who
Server version 3.23.55-entropy.ch
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Apple PowerBook G3 running Mac OS X 10.2.4
I'm using the distribution provided at Marc Liyanage's site:
On Mon, Feb 17, 2003 at 02:33:05PM -0500, Michael T. Babcock wrote:
It would be nice to extend the user permissions table to have per-user
limits like max_user_connections and the various timeouts applying
directly to specific user/host combinations.
Agreed. We've had a few circumstances
At 04:58 PM 2/17/03 +0100, you wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query,queries,smallint
If you just reply to this message, and include
sql,query,queries,smallint
I am in the process of designing a form and I am a little confused.
I would like to have a scrolling window, in which the user can
select multiple
items. For example, the scrolling window may contain operating
systems, and the
user has the ability to select multiple
Michael,
It would be nice to extend the user permissions table to have per-user
limits like max_user_connections and the various timeouts applying
directly to specific user/host combinations.
As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt
from my mysql.user table:
Stefan Hinz wrote:
It would be nice to extend the user permissions table to have per-user
limits like max_user_connections and the various timeouts applying
directly to specific user/host combinations.
As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt
from my
Hello,
I tried to insert a # as part of a field and got an error from the server
saying that I had an error in my SQL statement at line 1
F:\\BL. The error number is (8000) and the value is supposed to be F:\\BL#.
I understand that MySQL is interpretting that as a comment identifier. I
Greetings,
In trying the MySQL and Apache links found on the page
doc/en/Apache.html
I was trying the second option
Why when I tried the CustomLog |mysql -host... option above it
didn't work ?
I like the second option over the first because the SQL database is
updated instantly a log entry
Howdy,
Running MySQL 3.23.54 on master, 3.23.55 on all slaves, I'm experiencing the
following situation:
slave1 slave4 both receive 0 length packets from the server.
slave2 slave3 both work fine.
slave1 2 are identical machines both in hardware and configuration
slave3 4 are different from
Robby,
How can I get MySQL (via ZeosDBO in Delphi 5) to accept the #
sign? Add extra quotes or a backslash before the character? Use double
quotes? Some other method?
I know about nothing of Delphi and Zeos, but I'd try a backslash
before the # character. Here's what I get with the mysql
I solved the issue (eventually) by using a different control.
It seems the batch component interprets #'s differently than regular table and query
components. I'll use query components in the future.
Thanks anywaym,
Rob
-Original Message-
From: Stefan Hinz [mailto:[EMAIL
Just installed mysql nice one i though
set it all up read the nessasary docs nice one i thought
tried to connect remotly
[root@tasha root]# mysqladmin -h 192.168.0.2 version -uroot -ppassword
mysqladmin: connect to server at '192.168.0.2' failed
error: 'Lost connection to MySQL server during
Hi,
This is my first post to this mailing list, so please forgive me if my
message is not structured in the correct format.
My query is this. Where a column used as a unique identifier for a
record contains the values 1,2,3,5. Is a mysql query possible that will
retrieve 4 as an available
This is actually more a PHP question but since it refers to a MySQL
database I thought I would ask here.
I may not be looking in the right places but, I can't seem to find a way
to do a database backup through PHP (other than BACKUP TABLE, which I
don't want to use if possible)
What I mean is
Sorry I am in a bit hurry and just post some hints on your question. It is
more than one way to do your job. One of the trival way is to use php
function 'exec'. This function can execute shell programs. It means that you
can execute mysqldump etc. and create dump file.
From my experience, you
You should add a user who allow to connect from 192.168.0.2 before you can
connect to MySQL remotely.
Further more, make sure that your host can reverse lookup 192.168.0.2. This
can be done by add an entry in the /etc/hosts or create a DNS entry.
Regards,
Just installed mysql nice one i
First, an update. After waiting a few days for a FULLTEXT index to build on
a 3.23.5* database, I updated the database server to MySQL 4.0.10 on advice
from Sergei Golubchik on this list:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:132146:200302:cdpckkcecgnggcboabda
The index rebuild took
Hello folks
(BIs it possible to install a MySQL server into the /home/*username*
(Bdirectory in a typical Linux Installation. If so
(B1. where to put those my.cnf files and set the global options for a
(Bparticular user.
(B2. How to connect to that database from a remote machine, knowing
My problem is that my fulltext searches run quite slowly.
I have a 2300MB table with 4.3M rows and an index (primarily a fulltext
index) of 1300M. My hardware is a dual Athlon MP1500+ with 2GB of memory.
I am running MySQL 4.0.10.
My my.cnf includes:
set-variable = key_buffer=16M
Hi Ed,
What query would I use to check for an existence of a table within a
database?
SHOW TABLES LIKE 'table_name';
might help.
prosit
Klaus
-
Before posting, please check:
http://www.mysql.com/manual.php (the
That's exactly what I was looking for and the way I hoped it could be
done, only I hadn't seen anything about this 'exec' function.
Thanks. I should be able to figure it out myself but I will get back
with you if I need further help.
--
Loren McDonald AKA MisterrMac
Gods Of Music
SELECT * FROM EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50;
I'm surprised you happened to get anything in order. Maybe the message got
simplified by the list manager, but did you really mean to order by a
constant string?
Why not:
SELECT * FROM EventList ORDER BY `EventDate`,
does mySQL have
rowid or rownum
if yes please give an exampl
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
-
Before posting,
i can coneect from localhost
and all machines can see all machines
i made users with access from hosts
i made users with database access from hosts
still the same
- Original Message -
From: Bryan Lipscy [EMAIL PROTECTED]
To: 'Poodle' [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003
Well thats the thing,
I did an more than one user that was allowed to connect TO 192.168.0.2 from
various hosts on my network
and all hosts can reverse lookup from my dns server.
no good
- Original Message -
From: KH Chiu [EMAIL PROTECTED]
To: Poodle [EMAIL PROTECTED]; [EMAIL PROTECTED]
74 matches
Mail list logo