Just wondor how InnoDB handle Multi Level Transaction, For example,
BEGIN
DELETE FORM table1 WHERE id = 123
BEGIN< New Transaction Level 2
DELETE FROM table1 WHERE id = 234
COMMIT <--- Level2
ROLLBACK <---Level1
Thanks.
hello everybody,
i was wondering, if there's a single command to drop all or selected tables from the
database, something like, where i can give the table names (1-2-3) not to be deleted.
Thanx in advance
Nitin
On 16/01/2004, at 12:32 PM, Gregory Newby wrote:
From your description, it's not clear whether you already did this.
If you installed other than with a binary distribution from
mysql.com (or a mirror), it is possible that things are in somewhat
different locations than in the INSTALL-BINARY file.
Hello Jim,
Would you please look at my comments under the thread "Not receiving list
emails", in case that puts further light on this matter.
Thanks,
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
hi all..
i'm using mysql with php4 to develop an online ordering system.
the problem:
when it comes to save, retrieve/view and update data into mysql database, it
takes a long time for the page to load.
the problem occurs after we insert / key in data ( a lot types of data ), after
we click the
Hello,
The MySQL list server sent me nothing for about 24 hours, until just
recently.
It followed my first attempt to use the support.mysql.com website and change
my details there [that might have been just a coincidence].
I started getting messages again soon after I sent a new subscription
mes
On Fri, Jan 16, 2004 at 12:04:38PM +1100, tait sanders wrote:
> well I found my hostname.err file.
> It states this:
>
> "mysqld started
> InnoDB: Operating system error number 13 in a file operation.
> The error means that mysqld does not have the access rights to the
> directory.
> mysqld ended
I'm getting an error when trting to update a table:
ERROR 1034: Incorrect key file for table: 'Jan04'. Try to repair it
So I ran CHECK TABLE,
What does this result mean:
mysql> CHECK TABLE Jan04 QUICK;
+---+---+--++
well I found my hostname.err file.
It states this:
"mysqld started
InnoDB: Operating system error number 13 in a file operation.
The error means that mysqld does not have the access rights to the
directory.
mysqld ended."
so okay - how do I give mysqld the rights to the directory??
I've got mysq
On Thu, Jan 15, 2004 at 02:39:36PM +0100, Stefaan Van Dooren wrote:
> Since some days I don't get any mail from this list anymore.
> After some investigation, I found that it's blacklisted and our mailserver
> refuses any mail from it.
>
> DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is liste
I have created a sql statement that enables me to select all entries in
to MySQL that are dated today, I am trying to do the same for all items
that are now one day old and also two days old etc
I am doing this:
SELECT *
FROM table
WHERE category = 3 AND show = 1 AND date = NOW()-1
I have it wo
I have not received any emails from this list since last Sunday - if this
post comes through and anybody has an idea what is wrong please reply to me
off list
Thanks
Freddie
never mind... just discovered the --columns= option for mysqlimport. :-)
On Jan 15, 2004, at 3:43 PM, Ari Denison wrote:
Hi. I'm new to MySQL (and LOVING it) and have a simple question about
importing tab delimited files into MySQL.
I have a table in mysql called form_instances with the followi
Hi. I'm new to MySQL (and LOVING it) and have a simple question about
importing tab delimited files into MySQL.
I have a table in mysql called form_instances with the following three
fields:
id
student_id
form_id
I want to import records from a tab-delimited file with only two fields:
student_i
Hi, Tait. It sounds like your server is never actually
starting properly. There could be any number of reasons for
this - it's best to work through the installation instructions
that came with the package.
To see what failed, chances are good there is an entry
in the error log (it will probably
First we cut to the chase with a resolved stack trace from
the most recent crash:
0x80c23d5 handle_segfault__Fi + 425
0x40022f54 _end + 935506260
0x822cdef btr_search_build_page_hash_index + 4771
0x82281c3 btr_search_info_update_slow + 919
0x8213f9e btr_cur_search_to_nth_level + 3154
0x81e9dce row
Hi,
I'm a newbie to mysql.
I'm running an os10.3 server with mysql v. 4.0.16
When I try to start mysql with 'mysqld_safe &' I get a message that:
"Starting mysqld daemon with databases from /var/mysql"
"040116 10:07:57 mysqld ended"
then
nothing... the terminal is blank.
when I then do 'ps auwx |
Hi,
Maccess helps to analyse data in databases; it is a Web interface to
MySQL server. License is GPL.
Main features:
--
* user friendly query creation for MySQL server
* selective, grouped, and crosstab queries
* various outputs (XML, HTML, TXT, graphs)
* data ungrouping in grouped q
Hi,
It contains only 240 records... I have an another table without longblob
field with much much more records, and the query result is less than one second with
joins!
240 records with 11-15 sec... i think something wrong.
If i start a query, MySQL read 30-40 MB to memory! Why? I think, this
rea
Gregory
mysql,select,query
I agree with Joe, use multiple-column index. Much more efficient.
All queries should be sub 5-10 seconds or less.
David
> -Original Message-
> From: Gregory Newby [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 15, 2004 11:53 AM
> To: [EMAIL PROTECTED]
> S
And then Eve said...
>After some trouble with rpm, I managed to create a file of installed
>packages. Redhat 9 says I have installed:
>MySQL-client-4.0.1-2
>perl-DBD-MySQL-2.1021-3
>mysql-3.23.58-1.9
>mysql-server-3.23.58-1.9
That's right. That's what you get with RH9. I'm repeating myself here
It looks like having a multiple-column index would help more than having
a number of individual indices, at least for the example query. An
index on (termid, docid, whichpara, offset) might work better than just
having one on termid.
joe
On Thu, 2004-01-15 at 10:53, Gregory Newby wrote:
> I'm us
>Description:
< In install mysql ver 2.23.49 from the SCO site, and untarred
it under the /usr/local/src/mysql-3.23.49 dir.
Then I ran configure as : ./configure --prefix=/usr/local/mysql
Result: No error
Then I ran make as: make
>Description:
< my .configure, make & make install works with out any error
But when I try to run scripts/mysql_install_db , it hangs after
Installing all prepared tables >
>How-To-Repeat:
< Run mysql_install_db>
>Fix:
>Submitter-Id:
>Originator:sh
Chris L. White wrote:
Ok how does one run scripts from the mysql prompt? I tried .\
mysql_install_db and that didn't work.
If you are at the mysql prompt, the database has already been installed.
Also the next question I have do you
have to have a messageboard.user table setup in a DB to allo
After some trouble with rpm, I managed to create a file of installed
packages. Redhat 9 says I have installed:
MySQL-client-4.0.1-2
perl-DBD-MySQL-2.1021-3
mysql-3.23.58-1.9
mysql-server-3.23.58-1.9
And I am not having any luck with these...starting them, installing them,
compiling them. I have
Ok how does one run scripts from the mysql prompt? I tried .\
mysql_install_db and that didn't work. Also the next question I have do you
have to have a messageboard.user table setup in a DB to allow different
hosts to connect to it?
Chris L. White
Network Administrator
Coe-Truman Technologi
Hi Guys,
I am running winxp with mysql 5.0.
I am attempting to run this statement
mysql> load data infile "c:\\mysql\\pop.txt" into table population
(lastname,firstname,age,sickness);
after waiting about a minute I get
ERROR 2013 (HY000): Lost connection to MySQL server during query
and then a m
On Thu, Jan 15, 2004 at 02:52:30PM -0500, Brent Baisley wrote:
> It sounds like you are trying to do full text searching, but you
> implemented it "manually". Was MySQL's full text indexing not
> sufficient for your needs or am I totally missing what you are trying
> to do?
You're absolutely ri
From: Paul DuBois [mailto:[EMAIL PROTECTED]
> At 11:31 -0500 1/15/04, Mike Johnson wrote:
> >This is in reference to 4.0.16, FWIW...
> >
> >I can't find any direct references to the actual grant permission
> >for controlling a slave thread in the online docs. The closest I saw
> >was the 5th par
It sounds like you are trying to do full text searching, but you
implemented it "manually". Was MySQL's full text indexing not
sufficient for your needs or am I totally missing what you are trying
to do?
On Jan 15, 2004, at 1:53 PM, Gregory Newby wrote:
I'm using MySQL for an information retri
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Somehow the mysql mailserver got listed in spamcop?
Probably the usual SpamCop GIGO problem. If people send false reports,
systems that don't deserve it get listed. I don't use Spamcop anymore for
that reason.
-
Hi All,
Please pardon the test as I have received no messages from the list in a few
days
Allen
At 11:31 -0500 1/15/04, Mike Johnson wrote:
This is in reference to 4.0.16, FWIW...
I can't find any direct references to the actual grant permission
for controlling a slave thread in the online docs. The closest I saw
was the 5th paragraph on
http://www.mysql.com/doc/en/Replication_HOWTO.html.
Hi,
I would like to turn off caches completely to do some performance testing. I
have version 3.2 of the mysql server installed.
Could you tell me how can I achieve this.
Thanks,
Priyanka
_
There are now three new levels of MSN Hot
I'm using MySQL for an information retrieval application where word
occurrences are indexed. It seems that performance is not as good as
I would expect (it seems nearly linear with the number of rows).
Any advice would be welcome. I'll lay out a lot of detail.
Some details follow. The basic sce
> -Message d'origine-
> De : Tobias Asplund [mailto:[EMAIL PROTECTED]
> Envoyé : Wednesday, January 14, 2004 1:53 PM
> À : Ugo Bellavance
> Cc : [EMAIL PROTECTED]
> Objet : Re: setting a variable
>
>
> On Wed, 14 Jan 2004, Ugo Bellavance wrote:
>
> > mysql 4.0.17 on redhat 9 or debian
At 11:00 -0600 1/15/04, Eamon Daly wrote:
I have a table that's used for logging. We do a ton of
SELECTs and INSERTs on this table, but no UPDATEs. In order
to keep the SELECT speed high, we archive most items older
than 30 days by moving them out from this table to another.
This, of course, create
>From the sounds of it, it's not clear if the database is the issue. Of the
1000 records, did the first 100 get in, then no other ones. Or were the
missed-messages intermittent - some were missing in the middle?
You need to figure out if the MySQL connections are throwing an exception.
One thing
How about from the php api, or something similar:
mysql_num_rows()
Cory
On Thu, 2004-01-15 at 10:43, Alejandro D. Burne wrote:
> I'm testing store procedures, and I want to know the number of
> records returned from a query.
> There is a function or variable to get it through odbc?
> I'll be
Hi!
We are a hardware store(similiar to usa's home depot) here in venezuela.
We have 14 stores that moves a very heavy load of traffic.
Many of our retails runs in a home brew POS that uses mysql. Then sales
are uploaded to a bigger in-store server and then move to the central
office. The prices,
Hi David,
Thanks for you prompt reply. I'll try to answer
your questions to the best I can currently. Please
see my replies below.
David Griffiths wrote:
So your application tracks incoming HTTP-GETS.
When you say that it's not able to "capture" all 1000 entries, what do you
mean? Does an
Hi Gurus,
I'm currently building an application which is expected
to take very high loads. What the app does is essence is
to 'log' and incoming entry into MySQL, do something then updates
the 'log' entry.
To test MySQL in handling high load, I used siege
on another server to send 1000 HTTP
So your application tracks incoming HTTP-GETS.
When you say that it's not able to "capture" all 1000 entries, what do you
mean? Does an exception get thrown? Do some of the HTTP-GETs just not show
in the database?
You need to provide alot more information:
Do all the HTTP-GETs happen on the same
Hi Gurus,
I'm currently building an application which is expected
to take very high loads. What the app does is essence is
to 'log' and incoming entry into MySQL, do something then updates
the 'log' entry.
To test MySQL in handling high load, I used siege
on another server to send 1
I have a table that's used for logging. We do a ton of
SELECTs and INSERTs on this table, but no UPDATEs. In order
to keep the SELECT speed high, we archive most items older
than 30 days by moving them out from this table to another.
This, of course, creates a ton of holes which we optimize
away ni
I'm testing store procedures, and I want to know the number of records returned from a query.
There is a function or variable to get it through odbc?
I'll be trying with mysql_num_results() but makes me en error (seems to be made for c api)
select field1 from table where field2=1;
select
This is in reference to 4.0.16, FWIW...
I can't find any direct references to the actual grant permission for controlling a
slave thread in the online docs. The closest I saw was the 5th paragraph on
http://www.mysql.com/doc/en/Replication_HOWTO.html. It would seem logical that it's
covered by
>I was going to output a new list of installed packages to ensure that mysql
>was in there, but rpm -qa | ./installed_packages doesn't seem to work at the
>moment...I can't restart the server right now, so perhaps I could kill and
>restart some process? However, this is from yesterday's output:
T
I have had some help on my mysql install woes, and here's the latest.
rpm -qa | grep MySQL - this just hung and never returned anything (see
below)
# service mysqld start
or
# service mysql start - these just returned a new command prompt, so
couldn't tell whether or not they worked. I checked my
Hi!
On Jan 15, Stefaan Van Dooren wrote:
> Since some days I don't get any mail from this list anymore.
> After some investigation, I found that it's blacklisted and our mailserver
> refuses any mail from it.
>
> DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is listed
Thanks for alerting us
We are a developer of Point of Sale software and are launching a Linux based
product shortly. We wanted to know if there were any plans for MySQL to
support eSQL any time soon. Thanks.
Regards,
Blair M. Melton
Vice President, Grocery and Merchandise Division
Sweda Corporation
(416) 246-5487
Kiszely Ákos wrote:
Hello list,
I have a MySQL 3.23.49 under Debian Linux with this table:
--
CREATE TABLE `fajl` (
`fajl_id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`fajl` LONGBLOB,
`letoltesek_szama` INTEGER(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(80) DEFAULT NULL,
`fajl_tipus
Hello list,
I have a MySQL 3.23.49 under Debian Linux with this table:
--
CREATE TABLE `fajl` (
`fajl_id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`fajl` LONGBLOB,
`letoltesek_szama` INTEGER(11) NOT NULL DEFAULT '0',
`filename` VARCHAR(80) DEFAULT NULL,
`fajl_tipus` VARCHAR(20) DEF
Jonathan Tullett wrote:
>
> Further to the email below,I performed the upgrade last night and we are
> now running mysql 4.0.16.
>
> the last on the syncronization hasnt reduced any, so if anyone knows how
> else I can keep these two databases in sync, I would be very interested
> in knowing how!
Hans,
> I use it as a temporary file. Putting data in it sequential and after that
> reading it out sequential. I don't want a auto increment field or
> whatsoever because I want the date in sequential order of the data... the
> data itself cannot (always) be used as a primary key
If you don't ha
After posting a message you get some more messages of mailservers around
the world which are not accepting your message (send to the list). So there
a lot of people who aren't receiving this mail because there server is
checking spamcop. I don't know you can contact spamcop to ask to delete the
Hi Martijn,
Yes your right, thanks a lot for ANY help! Monitoring component is a good
Idea
Hans
At 15:09 15-1-2004, you wrote:
Hi Hans,
> And the ODBC driver?? He cannot construct an UPDATE either?
I'm not saying this is the problem, but it might give you a
direction where to look.
> Upda
I use it as a temporary file. Putting data in it sequential and after that
reading it out sequential. I don't want a auto increment field or
whatsoever because I want the date in sequential order of the data... the
data itself cannot (always) be used as a primary key
At 14:46 15-1-2004, you wro
Hi Hans,
> And the ODBC driver?? He cannot construct an UPDATE either?
I'm not saying this is the problem, but it might give you a
direction where to look.
> Updating the table is done in code only.. its temporary data wich is
> collected in this tables before "serieus" update..\
Instead of try
Stefaan Van Dooren wrote:
Since some days I don't get any mail from this list anymore.
After some investigation, I found that it's blacklisted and our mailserver
refuses any mail from it.
DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is listed
Can this be fixed ?
Yes. Ask your mail admin.
Joc
On 15 Jan 2004 at 12:33, Matthew Stuart wrote:
> ASP and VB
>
> I have created a search web page searching a MySQL table with the
> following code:
>
> CREATE TABLE tbl_allarticles (
> fld_ID mediumint(8) unsigned NOT NULL auto_increment,
> fld_category tinyint(2) unsigned NOT NULL default '0'
Hello Martijn,
And the ODBC driver?? He cannot construct an UPDATE either?
Updating the table is done in code only.. its temporary data wich is
collected in this tables before "serieus" update..\
hans
At 14:40 15-1-2004, you wrote:
Hi Hans,
> I had created a table without a primary key (for s
* Matthew Stuart
[...]
> SELECT *
> FROM tbl_allarticles
> WHERE fld_headline OR fld_summary OR fld_body LIKE '%userinput%' AND
> fld_show = 1
This statement does not do what you probably intended it to... the above is
similar to this:
WHERE
fld_headline+0 != 0 OR
fld_summary+0 != 0 OR
fld_
it cannot b related with primary key. i do not hav any idea how u update it,
but it's supported to update any dat in any table with or without PK
- Original Message -
From: "Hans van Dalen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 15, 2004 6:20 PM
Subject: tabl
Hi,
Since some days I don't get any mail from this list anymore.
After some investigation, I found that it's blacklisted and our mailserver
refuses any mail from it.
DNSBL/WARNING: bl.spamcop.net/213.136.52.31: IP is listed
Can this be fixed ?
Stefaan
--
MySQL General Mailing List
For list
Hi Hans,
> I had created a table without a primary key (for some reasons). This give
> some strange errors.
>
> When I edit a field trough ODBC he said: no transactions supported. If I
> edit trough direct access components (DAC for MySQL = native access)
> nothing is editted at all.
>
> With the
Hi group,
I had created a table without a primary key (for some reasons). This give
some strange errors.
When I edit a field trough ODBC he said: no transactions supported. If I
edit trough direct access components (DAC for MySQL = native access)
nothing is editted at all.
With the mysql shel
Hi,
As my database has grown I have found that the dump isn't completely restoring to my
development machine (XP Pro).
The file is now up to about 30 MB but it only imports about half the tables. The
command I'm using to restore the db is:
d:\mysql\bin\mysql.exe -h localhost -u username -ppas
Matthew P Ryder <[EMAIL PROTECTED]> wrote:
>
> Quick question since I can't see to find version information online.
> What version was enum first supported under?
>
It's supported from 3.21.0:
http://www.mysql.com/doc/en/News-3.21.0.html
--
For technical support contracts, goto http
"Ron McKeever" <[EMAIL PROTECTED]> wrote:
> I'm trying to use mysqimport instead of LOAD DATA INFILE from a shell
> script. I notice an option for mysqlimport is not working or im doing it
> wrong.
>
> This works with LOAD DATA INFILE :
> mysql -e "LOAD DATA INFILE 'x' INTO TABLE x IGNORE 2 LINES
ASP and VB
I have created a search web page searching a MySQL table with the
following code:
CREATE TABLE tbl_allarticles (
fld_ID mediumint(8) unsigned NOT NULL auto_increment,
fld_category tinyint(2) unsigned NOT NULL default '0',
fld_updateddate timestamp(8) NOT NULL,
fld_createddate timesta
"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> I am using 4.1.0 and 4.1.1 on Windows
> On WinXP, it even crashes the server when I add extra date fields.
> On Win2k AS, it doesn't crash the MySQL server but it returns unexpected
> results.
Thanks for report! It's a known bug:
ht
Andrew DeFaria <[EMAIL PROTECTED]> wrote:
> Victoria Reznichenko wrote:
>
>> Andrew DeFaria <[EMAIL PROTECTED]> wrote:
>>> As you can see I when I delete from user (the parent table) the
>>> useropts (child table) entry remains. Shouldn't it be deleted?
>>>
>>> Heikki Tuuri asked me to look at my
This is a fuzzy issue.
There are questions regarding redistribution. Any distribution requires
that you either comply with the terms of the GPL or that you get a
licence.
Additionally, MySQL AB have recently changed the licence terms of their
libraries - now absolutely everything that the fine an
Well pals,
Today I am not writing this message to bother you with
my problems but to pass my warmest thanx to you guys
all. Duncan, Peter , Mike, Cory ... I appreciate your
time and energy in solving the problems I faced on the
above subject.
Special thanx to Duncan for his precise and priceless
> Then the next problem is with WinMySqlAdmin. How in the heck do I change
it
> to login in as root and show all the databases etc. Right now it is
showing
> only the test DB and user as Administrator. Everything appears in grey
and
> can't be changed?
Add the following lines to your my.ini
Matt,
One last question and then I promise to drop the topic ... what would be
the best way to force a complete load of an index into the key buffer ?
Thanks very much for your time.
John
"Matt W" <[EMAIL PROTECTED]>
2004-01-15 02:06
To: <[EMAIL PROTECTED]>
<[EMAIL PROT
Further to the email below,I performed the upgrade last night and we are
now running mysql 4.0.16.
the last on the syncronization hasnt reduced any, so if anyone knows how
else I can keep these two databases in sync, I would be very interested
in knowing how!
now that we are running the 4.0 se
79 matches
Mail list logo