As i am using MySQL in my project and i need and
command which is equivakent to (TABLOCKX HOLDLOCKX) in
SQLServer to lock a table while opening itself in
MySQL using Visual C++.
Please respond me soon as it is very urgent for me
Regards
Phani Kiran.A
=
Bye bye
Phani Kiran.A
___
Hello all
please respond to my address to, I`m not in the list!
Look at this simple code:
SELECT
FLOOR(5000 * 0.112) AS A,
FLOOR(5000 * 11.2 / 100) AS B
/* why MySQL returns A = 560 and B = 559 ? */
I`ve tested either:
SELECT
FLOOR(5000 * 0.112) AS A,
FLOOR(5000 * 11.2 * 0.01) AS B
/* why M
Luc,
Luc Foisy wrote:
>
> MySQL version 3.23.32
> (please don't ask me to upgrade to the newest version of mysql as an answer)
I'm very sorry but an upgrade seems to be necessary:
if I recall this correctly we had to upgrade to 3.23.33 a year ago or so
because the changelog pointed towards a re
>Description:
Hi!
My name is Ales Perme. A college of mine Samo Login gave me this adress, which was
given to him by Monty, to report MySQL bugs to. The first bug report today from me is
connected with replication.
Our production comprizes of Windows and Linux machines. MySQL verson we are usi
>Description:
Hi!
My name is Ales Perme. A college of mine Samo Login gave me this adress, which was
given to him by Monty, to report MySQL bugs to.
Production configurations:
1. Windows NT 4.0, Service pack 6a, MySQL 3.23.36
2. Slackware Linux, kernel version: SMP 2.4.18, MySQL 3.23.42-l
I'm a little bit confused about what EXPLAIN is saying about a query
I'm doing with an ORDER BY clause. I've read and re-read the parts of
the manual about how ORDER BY is optimized, but it won't sink in to my
thick skull for some reason.
I've got an index on a column called price, which is an I
I'm seeing queries a little bit slower than I'd like when I try to get
them in random order, by using ORDER BY RAND(). It seems like mysql
should be able to do this quickly, especially in the simple case of:
SELECT * FROM db ORDER BY RAND() LIMIT 1
, where it could choose a random number be
Hi,
> There are (very expensive >$30,000) ram disks that
> may solve the I/O problem (it that is your problem). These are
> hardware RAM
> disks complete with onboard battery backup. It looks and acts just like a
> super fast hard disk. If you turn the server off (or it crashes) the data
> is sti
Hi!
> "Tobias" == Tobias K Tobiasen <[EMAIL PROTECTED]> writes:
mysql> select * from shop GROUP BY article;
Tobias> +-++---+
Tobias> | article | dealer | price |
Tobias> +-++---+
Tobias> |0001 | A | 3.45 |
Tobias> |0002 | A | 10.
Greetings,
I'm having a real problem with this one, so I hoped I could seek some
guidance from the guru's inhabiting the mailing list, and then hopefully in
the future I can offer some assistance myself... (Skip down four paragraphs
if in a hurry!)
My wife, who always wanted her own bookshop, de
Hello mysql,
Hello
What is .. the "Got error 127 from table handwler"
Pl send me error table ...
My english is very bad sory
--
Best regards,
maxim mailto:[EMAIL PROTECTED]
-
Before
root,
Thursday, April 4, 2002, 9:07:43 PM, you wrote:
r> When compiling Mysql on a Dec 3000 OSF1 V4.0 I get the following error:
r> sql_yacco.yy:719: Parse error before '}'
r> sql_yacco.yy:1462: Parse error before '}'
r> sql_yacco.yy:1689: Parse error before '}'
r> sql_yacco.yy:1723: Parse erro
Dan,
Friday, April 05, 2002, 3:21:46 AM, you wrote:
DE> I tried to add a user to my mysql system for the MTA (exim) but am having a
DE> hard time making it work.
DE> I used grant to give exim permissions:
DE> grant ALL PRIVILEGES on exim.* to exim@localhost IDENTIFIED BY PASSWORD
DE> ;
DE> and
maxim,
Friday, April 05, 2002, 2:35:01 PM, you wrote:
m> What is .. the "Got error 127 from table handwler"
m> Pl send me error table ...
$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
You can try to repair your table using myisamchk
or REPAIR TABLE statem
Marnix,
Friday, April 05, 2002, 10:15:56 AM, you wrote:
MV> I am setting up a mysql database and have a questions about users.
MV> I would like everybody to have the possibility to consult the database
MV> without having to introduce a user and /or password (even not showing the
MV> screen for us
prajak,
Friday, April 05, 2002, 7:50:44 AM, you wrote:
pp> mysql> select distinct(nexthop) ip from NameRoute
pp> where OwnerIP='10.0.1.1' and
pp> nexthop not in (select ip from NameIP where
pp> OwnerIP='10.0.1.1');
pp> ERROR 1064: You have an error in your SQL syntax near
pp> 'select ip from Name
Syamala,
Friday, April 05, 2002, 7:30:47 AM, you wrote:
SS> 1. Is authentication check based on user table in mysql database.
user, db and host tables are used for access control.
SS> 2. If there is a unix user, then only giving password through grant
SS> command will suffice ..How the
Satyanarayana,
Thursday, April 4, 2002, 9:53:53 PM, you wrote:
SVR> I have installed the source code of version 3.23.47, the most stable version.
The most stable version is 3.23.49, not .47.
SVR> I am working on Redhat linux 7.0 version.
SVR> I have complied it, made some changes (have
Paul DuBois wrote:
>
> You need to create another table that has a row for each date in the
> range, then use that table in a LEFT JOIN to your original table
> to find rows in the date table that are not represented by your original
> table.
Thank you Paul, your sql table building script and
I have got a backup script that locks the MySQL tables then use cp(unix) to
copy the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
--
Live
You know this sounds like a good idea, and I know this is what the utilities
are for that come provided with mysql(d). (MYODBC and mysqlaccess)I would
like to inquire, what do you mean. I don't comprehend what you just said.
Please someone give more specific details...
thanks,
John
-Original
Esteemed listers,
I am currently researching the feasibility of using MySQL to replace our
current Data Warehouse system. (Which happens to be a mix of DB2 and
IBI's Focus/WebFocus products). Does anyone have experience in doing this
who would care to share their experiences with me? Experienc
Anyone seen this yet
http://www.theregister.co.uk/content/53/24714.html
good advert for MySQL if it's true!? ("if you want a commercial grade, fully cross
platform database, then get MySQL")
Bob Cross.
Spam filter bypass: mysql database table query
Disclaimer: my opinion and no one e
On Fri, 5 Apr 2002, Richard Spangenberg wrote:
>
> I don't mean to start an opinion war, but ...
>
> Can mySQL handle many processors, many servers (clustering), load
> ballancing, etc as well as Oracle. Or should one use Oracle (some other
> database) for large volume high response requiremen
Cute story...but I have to agree with the Register when they state also
in the article, "For the record, can we just add that few subjects are
as tedious or overrated as ideological purity?"
> -Original Message-
> From: Robert Cross [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 05, 20
From: Richard Spangenberg <[EMAIL PROTECTED]>
> Can mySQL handle... ...as well as Oracle.
MySQL is different than the big databases like Oracle, Informix, etc. MySQL is
comparatively small and fast, also cheap. As such, it doesn't come with all of the
bells and whistles that others might. You
[EMAIL PROTECTED] wrote:
>
> I don't mean to start an opinion war, but ...
>
> Can mySQL handle many processors, many servers (clustering), load
> ballancing, etc as well as Oracle. Or should one use Oracle (some other
> database) for large volume high response requirements. Is mySQL too basic
hello,
mysql doesn't support sub-select yet...maybe in 4.1 ;)
>mysql> select distinct(nexthop) ip from NameRoute
>where OwnerIP='10.0.1.1' and
>nexthop not in (select ip from NameIP where
>OwnerIP='10.0.1.1');
>ERROR 1064: You have an error in your SQL syntax near
>'select ip from NameIP whe
hi,
in perl: [very simple code]
my $stime = time;
prepare();
execute();
fetchall_array_ref();
my $etime = time;
my $ftime = $etime - $stime;
print "Your query took $ftime seconds\n";
stupid filter: sql, query, mysql, db, table, select, insert, update, delete,
join, create, left join, optimi
> I don't mean to start an opinion war, but ...
>
> Can MySQL handle many processors, many servers (clustering), load
> ballancing, etc as well as Oracle. Or should one use Oracle (some other
> database) for large volume high response requirements. Is mySQL too
basic
> for these capabilities?
>
Thanks to all the reponders. Just what I needed!
sql, query = filter pass
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
Since you are writing out the file, you must select which character to
ESCAPE with. How would you expect mysql to choose?
-Original Message-
From: Cliff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 11:46 PM
To: [EMAIL PROTECTED]
Subject: Escaped by 2 things?
Short and simp
Actually, according to the objective eWeek test results at the link
provided in another reply, the gap between Oracle 9i and MySQL 4.x is
rather slim...
> I will look forward to hearing the response of the
> well-informed to this.
>
> However, my impression is that while the answer, for the ver
For what a newbies opinion may matter,
I breifly worked with Oracle, and am working with MySQL. Fact, as it may
be, I will never look for or take a job where they are using the P.O.S.
Oracle. Oracle is not stable enough, it bombs if you make one misleading
query. MySQL just says "eh, try again
I have a table whose schema contains:
id INTEGER AUTO_INCREMENT,
gen_time TIMESTAMP,
rec_time TIMESTAMP,
repeats INTEGER DEFAULT 0,
PRIMARY KEY (id),
INDEX (rec_time))
When I do an:
UPDATE table SET repeats=repeats+1
gen_time gets updated as well:
mysql> select id, gen_time, rec_time, repea
I'm currently running MySQL for a big, fast app without
problems. BUT:
I'm in the middle of specifying a new application with a high
load, and I'm consideing looking for alternatives to MySQL
because without InnoDB, it gets really slow on tables
with frequent updates and reads (no row locking).
I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt
binary version
to accept The Command - Line Tool to run a script to create a table.
My operating system is Windows 2000 Professional. I can connect with
MyODBC-3.51.02.exe without any problem and run successful queries.
At 21:45 -0800 4/4/02, Cliff wrote:
>Short and simple, is it possible to escape by two different parameters? This
>used to work:
I think you are mistaken. I just checked the grammar files for 90
versions of MySQL, and that syntax isn't legal in any of them.
I don't see how it could be legal, ei
just wanted to add another category of comparison:
mysql is fast, reliable and scalable. that's a fact! we don't
need to discuss this anymore.
BUT: the sql-set is too limited for most of the real use cases
out there. just think of the missing sub-selects or
multitable-updates/deletes or stored pr
No, this is NOT a bug.
According to the manual (you read it, right?), TIMESTAMP is created so that
when a record is UPDATEd or INSERTed, the time of the change is entered into
the record. If you want a date that does not changem use the DATE fiel
-Original Message-
From: Hihn Jason [mai
At 18:33 +0200 4/5/02, Hihn Jason wrote:
>I have a table whose schema contains:
>id INTEGER AUTO_INCREMENT,
>gen_time TIMESTAMP,
>rec_time TIMESTAMP,
>repeats INTEGER DEFAULT 0,
>PRIMARY KEY (id),
>INDEX (rec_time))
>
>When I do an:
>UPDATE table SET repeats=repeats+1
>
>gen_time gets updated as w
From: "Hihn Jason" <[EMAIL PROTECTED]>
> I have a table whose schema contains:
> id INTEGER AUTO_INCREMENT,
> gen_time TIMESTAMP,
> rec_time TIMESTAMP,
> repeats INTEGER DEFAULT 0,
> PRIMARY KEY (id),
> INDEX (rec_time))
>
> When I do an:
> UPDATE table SET repeats=repeats+1
>
> gen_time gets upd
At 10:29 -0600 4/5/02, Lenny Sorey wrote:
>I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt
>binary version
>
>to accept The Command - Line Tool to run a script to create a table.
>
>My operating system is Windows 2000 Professional. I can connect with
>MyODBC-3.51.02.ex
March 26 issue of PC Mag has a comparison of database engines, including
oracle, mysql and sql server (ack).
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 11:33 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL Power ?
I'm currently running
Hi,
> I have a table whose schema contains:
> id INTEGER AUTO_INCREMENT,
> gen_time TIMESTAMP,
> rec_time TIMESTAMP,
> repeats INTEGER DEFAULT 0,
> PRIMARY KEY (id),
> INDEX (rec_time))
>
> When I do an:
> UPDATE table SET repeats=repeats+1
>
> gen_time gets updated as well:
[snip]
> mysql> sel
First of all excuse my english...I hope someone can understand me
I am thinking in converting from MyIsam to InnoDb tables.
I have this table:
> du -sm table*
323 table.MYD
276 table.MYI
0 table.frm
How much tablespace I need to convert it to InnoDb, I found that I need a
lot
Yes I did, but it is very long, and it was very long ago.
Could someone please explain to me why this was done? It seems more
confusing to do this than to not do this. Why when you can just say "SET
field=NOW()" in the update statement would anyone build this auto update of
timestamps in? (the ki
According to the manual, the DATETIME field can be stored "As a string with
no delimiters in either 'MMDDHHMMSS' or 'YYMMDDHHMMSS' format, provided
that the string makes sense as a date." So this should provide you with the
format you require.
TIMESTAMP was created so that we would NOT have
Agreed. As soon as subselects and the Stored Procedure support is
complete I can almost ditch MSSQL entirely...
> BUT: the sql-set is too limited for most of the real use cases
> out there. just think of the missing sub-selects or
> multitable-updates/deletes or stored procedures. i worked with
I've been having an off-list discussion with gordon52 at slingshot dot co
dot nz, who is having a problem
posting anything to the list. Apparently when he sends something, the list
manager thinks it's
got attachments and bounces it. Now when he sends me a message - no
attachments.
Can any
Hey guys,
We're having a weird authentication problem. We have a .jsp (on box1) that tries to
connect to a MySQL database (on box2). The privileges have been set to give insert,
update, delete to the user.
GRANT select, insert, update
on d_name.*
to d_user IDENTIFIED by "d_user";
It works fi
At 10:43 -0600 4/5/02, Paul DuBois wrote:
>At 10:29 -0600 4/5/02, Lenny Sorey wrote:
>>I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt
>>binary version
>>
>>to accept The Command - Line Tool to run a script to create a table.
>>
>>My operating system is Windows 2000 Pr
> in perl: [very simple code]
>
> my $stime = time;
>
> prepare();
> execute();
> fetchall_array_ref();
>
> my $etime = time;
>
> my $ftime = $etime - $stime;
>
> print "Your query took $ftime seconds\n";
>
> stupid filter: sql, query, mysql, db, table, select, insert, update,
delete,
> join, crea
Hello-
Is there a console app that exists for windows 2000 pro such that i can
access mysql server(at home on windows 2000 pro machine) with it from work?
Can i use the one that is ported with the server? The server is not running
on port 3306. Thanks for the help.
Brian
-
then you need to fix your filters
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:55 AM
To: john
Subject: Re: Insert ?'s
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
We are writing a book about MySQL. There will be emphasis on using MySQL with
perl/php, .net & java. The publisher needs lots of emphasis on SPs and nested
subqueries. We need to be able to write about implementing biz rules using table
constraints, which means FKs. Your site says 4.1 is to hav
No problem Paul, I understood what you meant.
Lenny Sorey
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Lenny Sorey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 11:17 AM
Subject: Re: Command Line Tool
> At 10:43 -0600 4/5/02, Paul DuBois wr
5:40 a.m.
MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
(is that enough, to get past the filter ?)
(sent this via the website, & got a reply re the filter...)
Original #2 message
On Friday 05 April 2002 10:16 am, john wrote:
>
> Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID =
> "1";
>
> that is the command that I am attempting to issue, but states the where...
> is wrong. What's wrong with that?
It isn't valid SQL. You are, I think, trying to
At 11:17 -0600 4/5/02, Henning, Brian wrote:
>Hello-
>Is there a console app that exists for windows 2000 pro such that i can
>access mysql server(at home on windows 2000 pro machine) with it from work?
>Can i use the one that is ported with the server? The server is not running
>on port 3306. Tha
no, you need to follow the list rules when posting. That's why you see a
lot of posts that have a line at the end that just says
mysql,sql,query
or something similar.
And to answer your question, it appears that you are actually attempting
an UPDATE, not an INSERT? i.e.
UPDATE Sellers
SET Lo
On Friday 05 April 2002 10:29 am, [EMAIL PROTECTED] wrote:
> We are writing a book about MySQL. There will be emphasis on using MySQL
> with perl/php, .net & java. The publisher needs lots of emphasis on SPs and
> nested subqueries. We need to be able to write about implementing biz rules
> using
Then you need to fix your messages so that it will pass thru the filter.
That statement is wrong because INSERT INTO statement inserts a new record
to the table so you can't have a where restriction. If you wanna change the
logo value where seller_ID=1 then use UPDATE TABLE syntax. See:
http://w
Hi Gordon,
Update your settings in Eudora. You are probably currently sent a text
attachment of every email you sent out. This could occur if you have "send
both plain & styled" option checked.
By the way, there is no reason to insult the people who have created and/or
have followed this list my s
Hi,
> 5:40 a.m.
>
> MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL
> MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL
>
> (is that enough, to get past the filter ?)
> (sent this via the website, & got a reply re the filter...)
>
Pe
Do not send me any more mail , please.
--- Paul DuBois <[EMAIL PROTECTED]> a écrit : > At 11:17
-0600 4/5/02, Henning, Brian wrote:
> >Hello-
> >Is there a console app that exists for windows 2000
> pro such that i can
> >access mysql server(at home on windows 2000 pro
> machine) with it from wo
do not send me mail
I am not your friend.
Thank you
--- Gregory Junker <[EMAIL PROTECTED]> a
écrit : > no, you need to follow the list rules when
posting.
> That's why you see a
> lot of posts that have a line at the end that just
> says
>
> mysql,sql,query
>
> or something similar.
>
>
>
why do you have to pay? I was under the impression
innodb was free as well...
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2002 08:33
To: [EMAIL PROTECTED]
Subject: Re: MySQL Power ?
I'm currently running MySQL for a big, fast app without
problems.
I am using MySQL Manager to manage a database created with the tool a week or so ago.
Worked on the database last night and all was fine. Opened up mySQL Manager today and
any change to the tables (add or edit of columns) gives the error below:
Error on rename of:
'.\\.MYI' to '.\\#SQL2-a60-4f.
I agree with Chris...
Writing a book on features that do not exist yet is asking for trouble.
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:00 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MySQL Book
On Friday 05 A
6:35 a.m.
(writing this on the web)MYSQL :-)
Hi - in my first PHP file, :-
- earlier this week, Ive posted a few messages about my PHP webpage which Roger
Baklund was able to help me start off..
Anyway, - Ive been to some MySql Help sites & found some useful commands, which
ive been able to
um, I don't know you, I have no idea why you would take such an
attitude, and if you'll look closely, as a rule I send email to the
list, not to individuals. If you don't want emails from me filter me out
or unsubscribe from the list.
> -Original Message-
> From: de Chateau Thierry Axel
Hi!
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, April 05, 2002 8:51 PM
Subject: MySQL Book
> We are writing a book about MySQL. There will be emphasis on using MySQL
with perl/php, .net & java. The publisher needs lots of emphasis on S
Steve,
> With InnoDB, I'm sure this problem goes away, but as soon as we
> go to InnoDB, we have to pay for backups and support,
> which means we start looking around at 'pay' solutions.
I must correct that MySQL technical support is not free, whether you use
InnoDB or not. Note also that mysqld
Hi!
- Original Message -
From: ""Murphy, Land"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, April 05, 2002 5:52 PM
Subject: MySQL for Datawarehousing Experience
> Esteemed listers,
> I am currently researching the feasibility of using MySQL to replace our
> curr
Hi!
- Original Message -
From: ""Rodrigo Gonzalez"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, April 05, 2002 8:59 PM
Subject: InnoDB
> First of all excuse my english...I hope someone can understand me
>
> I am thinking in converting from MyIsam to InnoDb t
How can I download this version?
Regards
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 4:07 PM
Subject: Re: InnoDB
> Hi!
>
> - Original Message -
> From: ""Rodrigo Gonzalez"" <[EMAIL PROTECTED]>
> Newsgroups:
Can you please tell me, is it possible to do queries that join MySql tables
that are in different databases?
I have a couple of Delphi database programs that use Paradox tables. I'd
like to move them over to something else that is faster. These programs are
set up so that they have a shared dat
I have seen many people saying that InnoDB is a great deal, that InnoDB
rocks, etc. and I am concerced about how much better InnoDB is compared to
MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB
have foreign keys support, but I deal very well without then since now.
Hi,
actually I know about current problem in 3.23.49a on linux at least -
there's something weird with the cache I think. I've posted some reports
with my ideas to the bugs list already. For you:
I can get rid of such problems whenever they appear by doing :
mysqladmin flush-tables
They disappe
Hi,
Does InnoDB use some form of "group commit" like BerkeleyDB and Postgresql?
In Postgresql you can specify a "COMMIT_DELAY" to force a wait before the
commit returns. Disk IO to the log files can be reduced quite alot if you
tweak this setting, and it can be very useful when tuning batch-like
here's the scoop:
Basically I'm listing pieces of information from a two-key table and I am
not getting the information I want.
BACKGROUND
Consider this sample table (which although goofy, does illustrate what I'm
attempting to do)
SELECT clientid, revision, name, address FROM clients;
+--
Hi, all:
I am trying to use JDBC to connect MySQL, and use JDBC
to config the MySQL. As default root@default has the
privilege to do everything. So I use JDBC to connect
with "root". I got error. "[EMAIL PROTECTED]"
failed.
I read a note said that this only happen to Redhat.
Any suggestion how t
[EMAIL PROTECTED] wrote:
>
> Here is a FABRICATED table I have TYPED OUT to demonstrate the information
> that I'm looking for.
> I'm looking for a single query that can produce:
>
> +--+--++---+
> | clientid | revision | name
> The table has
> mysql> select count(*) from repository;
>+--+
>| count(*) |
>+--+
>| 5673838 |
>+--+
>records inside.
>
> 1. I get table a "table crashed" whenever I try to fix it or check it with MYISAMCHK
> using -r, -o or -f parameters. And t
(and I say again...)
um, I don't know you, I have no idea why you would take such an
attitude, and if you'll look closely, as a rule I send email to the
list, not to individuals. If you don't want emails from me filter me out
or unsubscribe from the list.
> -Original Message-
> From: de
Hi,
Victoria Reznichenko wrote:
VR> Martin,
VR> Wednesday, April 03, 2002, 5:45:00 PM, you wrote:
VR>
VR> MM> would anyone please explain me what are these error messages?
VR>
VR> MM> 020327 12:29:26 mysqld started
VR> MM> 020327 12:29:26 Warning: listen() on TCP/IP failed with error 98
V
Is there any sort of mysql load monitoring tools out there? If not how
can I get how many query's per/sec, users, etc, which I can log to a
flat file or db, and I could run rrdtool against it to get graphs?
-Jason
-
Before pos
(and I say again...)
> -Original Message-
> From: de Chateau Thierry Axel [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 05, 2002 1:15 PM
> To: Gregory Junker; [EMAIL PROTECTED]
> Subject: RE: Insert ?'s
>
>
> do not send me mail
>
> I am not your friend.
>
> Thank you
>
> --- G
Hi,
Is it possible to print a table from the database in
the same format as you can see it. I tried to export a
table to an outfile, but i dont get the column names.
I am using Linux so i don't have a print screen
option,
I think you can do using a software package called
EMS MySQL Manager, but
At 01:54 PM 4/5/2002, you wrote:
>I have seen many people saying that InnoDB is a great deal, that InnoDB
>rocks, etc. and I am concerced about how much better InnoDB is compared to
>MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB
>have foreign keys support, but I deal
At 10:16 AM 4/5/2002, you wrote:
>Actually, according to the objective eWeek test results at the link
>provided in another reply, the gap between Oracle 9i and MySQL 4.x is
>rather slim...
Gregory,
A point that was sadly missing from that article was what was the
cost to create the Orac
Lenny,
You might find it easier to use a GUI like MySQL Front from
http://www.anse.de/mysqlfront/. It will save you a great deal of time. Just
enter (or copy and paste) the SQL into their query window and press a
button. Editing your errors are also a lot easier. It is free or you can
> Adriano Manocchia wrote:
> Well, first off, I can't seem to get max_allowed_packet higher than 64
> MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are
> reflected in the system settings, but only up to 64 MB, then regardless
> of what I put in there, it stays at 64 MB. Bu
Hello there,
anybody here has some background using InnoDB and MySQL replication feature
? If so, would you mind sharing those information with me ?
--
João Paulo Vasconcellos
Gerente de Tecnologia - NetCard
Tel. 3852-9008 Ramal 31
[EMAIL PROTECTED]
Hi,
Try to use tee command to log all the output into a file. It will have the
column names and everything you see in the screen.
See:
http://www.mysql.com/doc/m/y/mysql.html
Gurhan
-Original Message-
From: colin o [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 4:14 PM
To: mysql
> At 10:16 AM 4/5/2002, you wrote:
> >Actually, according to the objective eWeek test results at the link
> >provided in another reply, the gap between Oracle 9i and MySQL 4.x is
> >rather slim...
>
> Gregory,
> A point that was sadly missing from that article was
> what was the
> cost
Thanks Todd and Tyler for the encouragement,
When I searched on Mysql column types, I did not find any obviously suitable
for images. I do not suppose I can use VARCHAR, can I?
Also, I need to have very good performance on data retrieval and transport,
which means I also need to have maximum re
-Original Message-
From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 4:02 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MYSQL maximum query size?
Is there a maximum number of characters you can use in a query?
I have a giant query using the UPDATE command (updati
On Friday 05 April 2002 2:54 pm, Zhao, Charles wrote:
> Thanks Todd and Tyler for the encouragement,
>
> When I searched on Mysql column types, I did not find any obviously
> suitable for images. I do not suppose I can use VARCHAR, can I?
Use one of the BLOB types.
Note that if you are running
1 - 100 of 129 matches
Mail list logo
