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. This would exceed 100,000,000. Is
there a possi
There is a MySQl/Innodb bug with Mysql-Max 4.0.17
on mac osx 10.3 panther. A google search showed
a similar problem with another platform (I think
it was windows).
I am running 4.0.14 without any problems. After
upgrading to 4.0.17, copying the data directory
from 4.0.14 to 4.0.17 and then startin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gilles Magnier wrote:
> Hi,
>
> i'm trying to write a java application which handle SQLException
> correctly.
>
> To achieve that i use declarations found in sqlstate.h and SQLError.java.
>
> Note that if someone have a good URL about SQLState error c
On Mon, 22 Dec 2003, Aleksei Wolff wrote:
> I just installed the server and I am getting this
> message in the mysql.log when I execute:
>
> ./bin/safe_mysqld --user=mysql &
Hi Alex,
You might want to check the permissions of your /tmp directory. Is it
"drwxrwxrwt"? :)
Regards,
Tan Shao Yi
--
I just installed the server and I am getting this
message in the mysql.log when I execute:
./bin/safe_mysqld --user=mysql &
Thanks in Advance.
Alex-
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Hi,
I have a question regarding failover in a master/slave replication
enviroment. Any advice/comments/links to materials are very much
appreciated!
Setup: Server A is Master, B is Slave. Upon A's failure, all clients
requests are routed to B.
Question: Upon recovery of A, how do I configure it
You may find the location of the log files by executing:
% mysqladmin variables | grep datadir
Under this directory you will find a fle named hostname.err. That file
will give some info on what's happenning.
Hope this helps you,
-Teresa
-
Hi Malka,
Kindly re-install the Calendar & DBD-mysql Perl Packages,
problem will be resolved.
-Aman.
ITSSG -Vetri Software, Lason Inc.,
Malka Cymbalista wrote:
We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql
3.23.49 on a Sun Solaris machine. Every now and then, one of the
s
Hello,
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.Everything seemed okay until we tried to pull data
f
If there is a better place to post this question
please advise.
I am following the instructions from mysql.com.
to start the server I type the following command as
'root'
./bin/safe_mysqld --user=mysql &
The following error displays:
"Starting mysqld daemon with databases from
/usr/local/mysql
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 have performed:
# cd /usr/local
Note: on RH9 group (mys
Hi,
i'm trying to write a java application which handle SQLException
correctly.
To achieve that i use declarations found in sqlstate.h and SQLError.java.
Note that if someone have a good URL about SQLState error codes
i'm really interested.
then i've greped Connector/J source for SQLException thr
--- John Nichel <[EMAIL PROTECTED]> wrote:
> Zsombor Papp wrote:
>
> > I did try to install php-mysql-4.3.4-1 (I just
> noticed
> > that I mistyped the PHP version numbers below, I
> tried
> > 4.2.x and 4.3.4-1), and everything else the RPM
> > dependency checks were complaining about. I gave
> u
Zsombor Papp wrote:
I did try to install php-mysql-4.3.4-1 (I just noticed
that I mistyped the PHP version numbers below, I tried
4.2.x and 4.3.4-1), and everything else the RPM
dependency checks were complaining about. I gave up
when it looked like I would have to install two
conflicting versions
I did try to install php-mysql-4.3.4-1 (I just noticed
that I mistyped the PHP version numbers below, I tried
4.2.x and 4.3.4-1), and everything else the RPM
dependency checks were complaining about. I gave up
when it looked like I would have to install two
conflicting versions of openssl to avoid
Mike,
set insert_id=1;
> can the auto_increment value be reset back to '1' withou recreate the
> entire table again ?? The table would be emptied first, but we would like
> to reset the auto_increment value back to '1' without having to drop and
> recreate the table, if possible.
Regards
On Mon, Dec 22, 2003 at 04:43:07PM +0200, Warren Burstein wrote:
>
> I am running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) on
> RedHat 6.2 (so shoot me, I'm using an old scratch computer so I
> won't break anything on the real development machine)
>
> I tried to create a user by inserti
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 is only needed for dynamic row-length tables (it's
> ignored with fixed-length rows) -- more specifically, those with
> TEXT/BLOB columns.
And VARCHAR/VARBINARY.
Jerem
On Mon, Dec 22, 2003 at 11:05:23AM +0200, Malka Cymbalista wrote:
> We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql
> 3.23.49 on a Sun Solaris machine. Every now and then, one of the
> scripts we are runing gives the following error message:
> null: DBD::mysql::st fetch fail
Zsombor Papp wrote:
Hi,
I would like to have MySQL 4.0.17, Apache, and PHP
with access to MySQL, all this on a Linux server. So
far I have RedHat 8.0 and MySQL 4.0.17 installed. I
would like to know if there are any Apache and PHP RPM
packages that I could install on top of this. I did
try 2.0.40
Hi,
I would like to have MySQL 4.0.17, Apache, and PHP
with access to MySQL, all this on a Linux server. So
far I have RedHat 8.0 and MySQL 4.0.17 installed. I
would like to know if there are any Apache and PHP RPM
packages that I could install on top of this. I did
try 2.0.40 and 2.0.48 on the Ap
Hello List:
This is my first post & you can easily figure out that I am a complete
newbie to mySQL. I have a fresh install of RH9 on a (test) server. It also
has mySQL 3.23 installed (part of RH9). My question is:
1) Considering the above setup, do I upgrade (and How?) from 3.23 to 4.0.??
2) or r
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).
While if I run directly
"SELECT SHOW GRANTS FOR [EMAIL PROTE
Thank you!
That is what I was looking for!
Unfortunatly that command is not SQL 92 or SQL 99 standard, isn't it?
(at least I guess, after I quick search in my ANSI files,
BTW I think if they had put in MySQL documentation a note for each SQL command
where is specified standard compliance that
* Warren Burstein <[EMAIL PROTECTED]> [2003-12-22 15:43 +0100]:
> I tried to create a user by inserting directly into mysql.user. When
> I set user.host to localhost, it works, when I set it to % it doesn't.
> I thought % matched anything, and so should match localhost.
mysqld will ignore rows wi
Hi Heikki,
The basic problem is that I have committed the transaction and then
replicated to another DB. Now I want to rollback the committed transaction.
Is there a way to rollback to a particular point. This requirement is very
similar to rolling back using save points. I guess an option would b
Monica,
I think there was no transaction support in MySQL-2.3.2.
You should use MySQL-4.0 and an InnoDB or BDB type table.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB wh
Russ,
you can also use
mysqldump --single-transaction
to back up InnoDB type tables. The advantage of InnoDB Hot Backup over that
method is that InnoDB Hot Backup takes binary backups of the ibdata files.
Restoring a binary backup is much faster than a table dump.
Best regards,
Heikki Tuuri
In
Karthikeyan,
replication poses no problem here. MySQL does not write to the binlog
transactions which are rolled back. Thus, a replication slave will never
perform the steps in a transaction which is rolled back in the master.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign
This query below is running REALLY slow. The indexes and EXPLAIN result are below.
Last week this query was running in <20 sec, now it takes so long (>20 mins). No I
reloaded all the data from the oe-invoice table over the weekend. as I do every
weekend. I have noticed that sometimes the query p
Will Lowe wrote:
Select User_Account from Users as a, Devices as b
WHERE
a.User_Account = (Select DISTINCT(b.Device_Account) from b.Devices
WHERE b.Device_Name LIKE 'HP%' )
I'm running 3.23.49 which I know is not the most current..it was installed
3.x does not su
Thanks everyone for great advice!
Tom's question below is also interesting.
Also, are there data compatibility/integrity issues moving from Windows/MS
Access to Linux/MySql? I know that Linux is case sensitive and MySql wants
dates to be stored as -mm-dd. Does anyone know of other issues?
Th
> -Original Message-
> From: Tobias Asplund [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 22, 2003 11:21 AM
> To: Jeff McKeon
> Cc: [EMAIL PROTECTED]
> Subject: Re: Replication Question
>
>
> On Mon, 22 Dec 2003, Jeff McKeon wrote:
>
> > Is it possible to have 2 database on one ser
> Select User_Account from Users as a, Devices as b
> WHERE
> a.User_Account = (Select DISTINCT(b.Device_Account) from b.Devices
>WHERE b.Device_Name LIKE 'HP%' )
> I'm running 3.23.49 which I know is not the most current..it was installed
3.x does not support
Hi,
I'm having problems with the syntax of a select statement. I have two
tables linked
together by account number.
The first table (Users) looks similar to this
|User_Account | User_Name | User_Address
|X10010100110 | Michael Smith | 1000 North Main St
|X10010100240 | David Wils
question... does anyone know how it sets up the indexes, security
preferences , relationships..??? I mean does it do this or does it just
create the tables and upload the data???
Thanks Tom T
At 06:01 PM 12/22/2003 +0100, you wrote:
Arthur
Get DBManager Professional (for free) here :
http://w
Hello everybody.
I have a clarification/solution to request. I am currently in the
process of designing a web application with JBoss 3.2.2 and MySQL 4.0.16.
The application is a data centric application with huge list of products
(tens of thousands). Sets of products are grouped into Categorie
Arthur
Get DBManager Professional (for free) here :
http://www.dbtools.com.br/EN/dbmanagerpro.php
There is a wizard which can do this conversion for you
Freddie
> -Ursprüngliche Nachricht-
> Von: Arthur Klimowicz [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 21. Dezember 2003 19:00
>
Hi,
can the auto_increment value be reset back to '1' withou recreate the entire
table again ?? The table would be emptied first, but we would like to reset the
auto_increment value back to '1' without having to drop and recreate the table,
if possible.
MySQL version 4.0.15 Linux
TIA
--
Mike
Mysqlians,
Greetings .. I am at my wits end trying to find a performance
problem with 4.0.16 on solaris 9 with 4 ultrasparc III process (sunfire
v880). I would be much obliged if the Mame's and Sir's out their with this
setup(or similar) would share with me their ">show variables"
On Mon, 22 Dec 2003, Jeff McKeon wrote:
> Is it possible to have 2 database on one server replicating from the
> same Master server?
yes.
> In other words. DB01 is the Master on System01,
> System02 has DB01_rep1 and DB01_rep2, each with their own replication
> from DB01.
Shouldn't be a problem.
Have you run mysql_install_db? Does the mysql user have full
permissions (read, write, execute) on the mysql data directory you
created with mysql_install_db?
- Gabriel
On Dec 20, 2003, at 9:00 AM, Jon Pearse wrote:
... you can tell that this isn't going my way at all ...
I've got mysqld
In my experience, I see about a 2x increase in space required between
MyISAM and InnoDB. I believe this may be documented btw, check the
InnoDB section of the manual.
I have been using InnoDB for a couple years now on databases up to
180GB. InnoDB has been very robust and I have only once come a
Hi Arthur,
Dbtools is a free product and it will do the conversion for you.
http://www.dbtools.com.br/EN/index.php
We have had success converting from MSAccess to MySQL in the past with
it.
Regards,
Matt
-Original Message-
From: Arthur Klimowicz [mailto:[EMAIL PROTECTED]
Sent: Sunday
Is it possible to have 2 database on one server replicating from the
same Master server?
In other words. DB01 is the Master on System01,
System02 has DB01_rep1 and DB01_rep2, each with their own replication
from DB01.
I need to do this to have a development copy of DB01 on System02. I
have prod
Hello,
My HDD is running low and I MyISAM tables are keep crashing... I think that
converting to InnoDB will be more stable, but what about the data files
sizes? convertion to InnoDB will need more or less disk space than MyISAM?
-thanks, Eli
--
MySQL General Mailing List
For list archives: h
Hello,
My HDD is running low and I MyISAM tables are keep crashing... I think that
converting to InnoDB will be more stable, but what about the data files
sizes? convertion to InnoDB will need more or less disk space than MyISAM?
-thanks, Eli
--
MySQL General Mailing List
For list archives:
"Unknown Sender" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> I recently upgraded from MySQL v3.23 to MySQL 4, and converted
> my tables from MyISAM to InnoDB by using the ALTER TABLE
> command. I did this for 16 tables. I know that MyISAM creates
> seperate data/index f
"Mike S" <[EMAIL PROTECTED]> wrote:
> I had an account "mike" to mysql. But somehow I change the password. So now
> I have just one access to the system as root.
> Trying to login to mysql as root with password and without password no
> success. Root password is: 123456.
>
> What I'm doing wrong
I am running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) on RedHat
6.2 (so shoot me, I'm using an old scratch computer so I won't break
anything on the real development machine)
I tried to create a user by inserting directly into mysql.user. When I set
user.host to localhost, it works
Niklas Saers <[EMAIL PROTECTED]> wrote:
>
> I've got a number of users who have their username on the format 'x_n'
> where x is a string and n is a one-decimal number. I want them to have
> full access to one, and only one, database. That means, they should be
> able to do CREATE TABLE but
Plinio Conti <[EMAIL PROTECTED]> wrote:
>
> Is there a way to query the privileges of current user if he hasn't the rights to
> read the mysql system tables (user, db, hosts, etc..)
>
> I mean, I CAN'T give a standard user the chance of read "system tables"!
> But my client app wants to know if
Hi all,
I've got a number of users who have their username on the format 'x_n'
where x is a string and n is a one-decimal number. I want them to have
full access to one, and only one, database. That means, they should be
able to do CREATE TABLE but not CREATE DATABASE. When I give the CREA
* Aleksandar Bradaric
> >> select key, desc, value
> >> from your_table t1
> >> where value = (select max(value) from your_table where desc = t1.desc)
>
> > Anyway, when i execute this query, i get an error near 'select
> > max(value)'... :(
>
> It's because the subselects are supported from ve
Hi,
>> select key, desc, value
>> from your_table t1
>> where value = (select max(value) from your_table where desc = t1.desc)
> Anyway, when i execute this query, i get an error near 'select
> max(value)'... :(
It's because the subselects are supported from version 4.1.
If you use older MySQL
Hey Guys,
I have just a couple of questions regarding the innodb database type
that I'd appreciate any advice with. I'm currently developing a custom
shopping cart / backend and, due to the nature of such a system, would
like to take advantage of transactions - so innodb seems the logical choic
Hi,
> I have already tried the 'rtfm', but it just didn't help.
But it's right there :)
3.5.2 The Row Holding the Maximum of a Certain Column
> ..and I want to get this with a single query:
> +-++--+
> | key | desc| value |
> +-++--+
> | 2 | book|
Tibby wrote:
..and I want to get this with a single query:
+-++--+
| key | desc| value |
+-++--+
| 2 | book| 7 |
| 6 | pen | 7 |
+-++--+
I need to get only one row from col. DESC, the one with the highest VALUE.
With
* Mike S <[EMAIL PROTECTED]> [2003-12-21 23:13 +0100]:
> By mistake I deleted all users in MYSQL. So, how can I login to the mysql?
> Is it possible to add a user to my.cnf file?
Restart mysqld with the --skip-grant-tables option. Then you can log in
again and fix your user table.
For details, pl
Hi ppl,
I have already tried the 'rtfm', but it just didn't help.
I have a table:
+-++--+
| key | desc| value |
+-++--+
| 1 | book| 4 |
| 2 | book| 7 |
| 3 | book| 5 |
| 4 | pen | 4 |
| 5 | pen |
We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql
3.23.49 on a Sun Solaris machine. Every now and then, one of the
scripts we are runing gives the following error message:
null: DBD::mysql::st fetch failed: fetch() without execute() at
/usr/local/lib/perl5/site_perl/local/Cale
61 matches
Mail list logo
