Paul DuBois wrote:
At 15:46 +0100 12/23/03, Plinio Conti wrote:
Sorry,
I was not using any SELECT in my queries,
it's just an error typing the email
I confirm:
SHOW GRANTS FOR CURRENT_USER();
does not work,
while that query is exactly what you expect to do reading mysql manual.
I agree, one migh
> I don't believe this. I'm going to write a script to disprove this theory
> right now..
We have a lot more than 100,000,000 more than that in a single MyISAM
table at work:
mysql> select count(*) from probe_result;
+---+
| count(*) |
+---+
| 302045414 |
+---+
1 row in
I don't believe this. I'm going to write a script to disprove this theory
right now..
Cheers,
Andrew
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday 23 December 2003 20:08
To: Andres Montiel; [EMAIL PROTECTED]
Subject: Re: 100,000,000 row limit?
At 0:57 -
I have found that by dumping with --extended-insert, the subsequent import
is MUCH faster. Of course it only issues 450 odd queries for the data set
instead of ~200k...
-mike
[EMAIL PROTECTED]
12/23/03 05:02 PM
To
[EMAIL PROTECTED]
cc
Subject
Strange performance problem importing dump
actually ,mysql only return 17000 records if that means mysql select has
max record limit?
_
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi Mark,
Maybe you intentionally only replied to me (instead of the list too),
but I'm sending this to the list also so others can follow the
discussion. :-)
I never know how much I have to explain things for a person's knowledge
level, but it sounds like you understand what's going on very well.
Mark Matthews wrote :
Gilles Magnier wrote:
[snip]
I think having identical error code for unsuported exception and bad
parameter error is a bit confusing, for me at least ...
Thanks for any help,
These definitely look like typos. After the holidays, I will look into a
fix for these using constan
Hi Jeremy,
- Original Message -
From: "Jeremy Zawodny"
Sent: Monday, December 22, 2003 2:20 PM
Subject: Re: Benefits of MAX_ROWS and AVG_ROW_LENGTH
> On Fri, Dec 19, 2003 at 06:40:17PM -0600, Matt W wrote:
> > Hi Mark,
> >
> > I'll tell you what I know. :-)
> >
> > First, AVG_ROW_LENGTH
I am using 3.23.58 (server and client) on FreeBSD 5.2-RC1 and all of what
I am about to describe is being performed locally.
When importing dumped data (with something like mysql dbname <
dbname.dump) the import is being performed at ~60 queries a second. This
is MUCH slower than when I was run
At 15:46 +0100 12/23/03, Plinio Conti wrote:
Sorry,
I was not using any SELCT in my queries,
it's just an error typing the email
I confirm:
SHOW GRANTS FOR CURRENT_USER();
does not work,
while that query is exaclty what you expect to do reading mysql manual.
I agree, one might easily come to that c
I have a table which maintains a list of categories and has a field called
catID. This field is a one-to-many relationship with another table.
What I want to do is remove any "empty" categories - aka: remove any
categories which aren't used in the second table.
I thought MySQL at least partially
First let me state that this is not a question where a valid answer is to
SET FOREIGN_KEY_CHECKS=0... (no, its not *that* question..)
I have noticed that mysqldump includes the database name in foreign key
specifications within CREATE TABLEs. This is causing a bit of grief as I
would like to re
hi gang
Got a wee bit of a problem with MySQL...
Running Distrib 4.0.14, for Win95/Win98 on i32 ... on Windows XP Pro SP1 ...
as long as I keep the default setup, with no password on the root user and
nothing modder in 'user' at all, I can access the DB. But as soon as I try
adding a user or c
I have a folder with all of the files from a database that the server shot craps
(database is used for phpBB). I now have another server up and running with phpBB
setup and a database with the same name.
My question is, is there any way to merge the information into the new database? We
had q
j,
how you have set
innodb_thread_concurrency
and
innodb_log_file_size
in my.cnf?
I was able to repeat the assertion failure by setting the log file size to
only 8 MB, and setting concurrency to 500. I changed now InnoDB so that it
no longer asserts, but calls exit(1). It prints the following
At 17:43 + 12/22/03, Dale Goolcharan wrote:
Hi,
I am currently working on a web application(USING JSP AND JAVA) that
uses microsoft sql server 7.0 as the database.
I have decided to use MySql4.0 as the database. I have been able to
successfully create
the database schema in mysql and it is
t
Hi,
I am currently working on a web application(USING JSP AND JAVA) that uses
microsoft sql server 7.0 as the database.
I have decided to use MySql4.0 as the database. I have been able to
successfully create
the database schema in mysql and it is
the same as the ms sql server 7.0 database. Apach
At 0:57 -0500 12/23/03, Andres Montiel wrote:
I was informed that MySQL has a 100,000,000 row limit. Is this true? We
were planning to use MySQL for an inventory system. However, our current
data (rows) for 1 year for one area is already 8.8 million. We want to
place data for 5 years for 7 areas. T
Hi,
I think what you need is an auto increment (primary key) column. When a
record is inserted, it will automatically generate the next number in the
sequence. Being a primary key, the column must be unique (i.e no two rows
can be the same), so you can identify a specify record in the table. Wh
Plinio,
Hence my suggestion for use of a flat file. The file can be located on the
db server middle tier wherever it doesnt matter.
The important part is that you control what goes in the file and its done
ahead of time not when an enduser presses a button.
What about creating tables the users can
Michael Bacarella <[EMAIL PROTECTED]> wrote:
> We're running MySQL 3.23.56 w/ InnoDB on Red Hat Linux 8.0,
> compiled natively with bundled gcc:
>
> # gcc -v
> Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
> Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
> -
Hi, I am a beginner in using database. And I
appreciate your support and help.
When we first create a table,
1. is it possible to create a column that identifies
each record that is to be inserted?
2. If we can create this IDENTITY column, how do we
create it? Do we set a maximum to the value
The mysql list sent this back to me, so I'm resending. My apologies to
anyone who ends up getting it twice.
Data Boy wrote:
Will and Michael,
Thanks very much for the the replies. This works well.
Is it possible to use this syntax and search for cases
where they have two different kinds of equ
I'm trying to figure out how to combine these two tables. I have..
t1
date accidentInfo cost
t2
date upgradeInfo whereUpgraded Salesman cost
I want to combine the two in a way to reference each piece of data such as
t1.accidentInfo,t2upgradeInfo and so on, but I need the resultset to be
order
_
Tired of slow downloads? Compare online deals from your local high-speed
providers now. https://broadband.msn.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Data Boy wrote:
Will and Michael,
Thanks very much for the the replies. This works well.
Is it possible to use this syntax and search for cases
where they have two different kinds of equipment? Say
an Ultra 5 and a HP Plotter?
TIA, DB
SELECT User_Account FROM Users AS a, Device_Name from Device
I'm trying to figure out how to combine these two tables. I have..
t1
date accidentInfo cost
t2
date upgradeInfo whereUpgraded Salesman cost
I want to combine the two in a way to reference each piece of data such as
t1.accidentInfo,t2upgradeInfo and so on, but I need the resultset to be
order
To be honest, the fact I can't get it with only one query but I have to do:
1) SELECT CURRENT_USER();
2) SHOW GRANTS FOR valueExtractedByPreviousQuery;
is a little thing compared with work remaing to get usefull information:
I have to parse the strings returned by query 2, handle the wildcards,
Plinio Conti <[EMAIL PROTECTED]> wrote:
> Sorry,
> I was not using any SELCT in my queries,
> it's just an error typing the email
>
> I confirm:
> SHOW GRANTS FOR CURRENT_USER();
> does not work,
> while that query is exaclty what you expect to do reading mysql manual.
It means that you can use C
Sorry,
I was not using any SELCT in my queries,
it's just an error typing the email
I confirm:
SHOW GRANTS FOR CURRENT_USER();
does not work,
while that query is exaclty what you expect to do reading mysql manual.
On Tue, 23 Dec 2003 12:47:11 +0200
Egor Egorov <[EMAIL PROTECTED]> wrote:
> Plini
Yes,
I can do it with a middle tier,
but currently my app is a simple 2-tier
and introducing a middle-tier just to do
that looks excessive...
On Sun, 21 Dec 2003 18:40:40 -0330
"jamie murray" <[EMAIL PROTECTED]> wrote:
> What about creating a flat file on the middle tier from the database system
Will and Michael,
Thanks very much for the the replies. This works well.
Is it possible to use this syntax and search for cases
where they have two different kinds of equipment? Say
an Ultra 5 and a HP Plotter?
TIA, DB
> SELECT User_Account FROM Users AS a, Device_Name from Devices AS b
> WHERE
Jeremy writes: "Please give 4.1 a try."
Ah, yes - 4.1. I actually did quite a bit of testing on 4.1 alpha in
July/August which is one of the reasons why we like MySQL, but I'm not sure
that my management wants an alpha version in their production system.
Which leads me to the next question for th
> I am on 4.0.17 does it really matter how I start the
> server? whether I use /bin/safe_mysqld or
> /bin/mysqld_safe?
safe_mysqld is a link to mysqld_safe, so no, it doesn't matter.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
I am on 4.0.17 does it really matter how I start the
server? whether I use /bin/safe_mysqld or
/bin/mysqld_safe?
Thanks.
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
MySQL General Mailing List
F
On Tue, Dec 23, 2003 at 12:57:23AM -0500, Andres Montiel wrote:
> I was informed that MySQL has a 100,000,000 row limit. Is this true?
No.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
--
MySQL General Mailing Lis
On Tue, Dec 23, 2003 at 02:20:50PM +0200, Yosef Teitz wrote:
> Hi,
>
> I'm looking for prepared statement support in MySQL 4.0. I know it exists in
> 4.1 but 4.1 seems to be stuck in Alpha for forever. I looked at the
> documentation that came with the latest release and it seems to be for 4.1.
>
Thanks.
I think your help is what I needed & is highly appreciated.
Kirti
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 23, 2003 4:22 AM
To: [EMAIL PROTECTED]
Subject: Re: What am I doing wronga
"Kirti S. Bajwa" <[EMAIL PROTECTED]> wrote:
>
Hi,
I'm looking for prepared statement support in MySQL 4.0. I know it exists in
4.1 but 4.1 seems to be stuck in Alpha for forever. I looked at the
documentation that came with the latest release and it seems to be for 4.1.
Furthermore, I couldn't find a reference to MYSQL_BIND in the header file
The MacOS X package installer runs mysql_install_db itself, I've
chown-ed and chgrp-ed the relavent files (even though the installer did
that as well) and everything because I thought it was a permissions
problem.
However, I did wipe it and install mySQL 4.0.17, which works fine, so
it may
Plinio Conti <[EMAIL PROTECTED]> wrote:
>
> The manual page at http://www.mysql.com/doc/en/SHOW_GRANTS.html
> says:
>
> "To list grants for the current session one may use CURRENT_USER() function"
>
> But if I run
> "SELECT SHOW GRANTS FOR CURRENT_USER();
>
> I get syntax error (Error 1064).
>
Hi mysql-list,
1.
my installation:
[EMAIL PROTECTED]:~> uname -a
Linux rosetta 2.4.19-4GB #1 Fri Sep 13 13:14:56 UTC 2002 i686 unknown
[EMAIL PROTECTED]:~>
mysql> show global variables like "version";
+---++
| Variable_name | Value |
+---+--
"Kirti S. Bajwa" <[EMAIL PROTECTED]> wrote:
> Hello List:
>
> Please point to what am I doing wrong:
>
> I am trying to install MySQL on top of RH9. I am following steps outlined
> MySQL official documentation from Section 2.3.1 titled "Quick Source
> Installation Overview". These are the steps I
Teresa A Narvaez <[EMAIL PROTECTED]> wrote:
> We run MYSQL 3.22.30 on a TRU64 alpha server(4.0F). Our scripts found
> corruption on one of our tables. The script tried to automatically clear
> the corruption but failed. Then we cleared the corruption by manually
> running isamchk -r.Everyth
Hi,
Sorry for not responding more promptly.
To remove a index you can use a command like this one
ALTER TABLE tbl_klanten DROP INDEX klant_id;
or using phpMyAdmin - just click on the "delete" link next to the index.
Anyway as I told you before I don't think this is causing the problem - the add
Hello I need help
MySQL 3.23.47 running on localhost linux
I want to create an Test Instance. Based on my Production Instance.
My Batch (it has work for month)
head prax2test.sh
time mysqldump -u transfer -ptransfer timesheet > timesheet.temp
echo "drop database timetest;" > timetest.sql
echo "
I'm fairly sure that the ONLY limitation is the size of the table files, adn
those depend on the OS.
http://www.mysql.com/doc/en/Table_size.html
Chris
-Original Message-
From: Andres Montiel [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 9:57 PM
To: [EMAIL PROTECTED]
Subject:
47 matches
Mail list logo
