Hallo,
I'm using MySQL MigrationsToolkit 1.0.23rc and while transfering big
Table (MySQL 4.0.x to MySQL 5.x, 4.000.000 entries) I get this message:
The SQL create statements could not be created (error: 0).
MigrationMysql.dataBulkTransfer :Java heap space
Details:
What can I do?
Best
At 12:31 13.03.2006, Rafal Kedziorski wrote:
Hallo,
I'm using MySQL MigrationsToolkit 1.0.23rc and while transfering big
Table (MySQL 4.0.x to MySQL 5.x, 4.000.000 entries) I get this message:
The SQL create statements could not be created (error: 0).
MigrationMysql.dataBulkTransfer :Java
hi,
after migration from MySQL 4.0.26 to MySQL 5.0.18 I'm missing
auto_increment on MySQL 5 side in appropriates tables.
Best Regards,
Rafal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
we have an J2EE application which ist using MySQL 4.0. There is an
bug, which was fixed in MySQL 4.1. We are using tracactions and
InnoDB is don't use query cache. Now we have to migrate our DB to
MySQL 4.1 for use this feature. In our actual installation we store
our data in one inndodb
At 15:30 23.08.2005, Jason Pyeron wrote:
Would I be correct in assuming you need to minimize down time on a
productions system? Or are you just asking how to upgrade?
Correct, I wan't minimize downtime :)
Regards,
Rafal
On Tue, 23 Aug 2005, Rafal Kedziorski wrote:
Hi,
we have an J2EE
and make it smaller.
Best Regards, Bruce
On Aug 23, 2005, at 6:19 AM, Rafal Kedziorski wrote:
Hi,
we have an J2EE application which ist using MySQL 4.0. There is an
bug, which was fixed in MySQL 4.1. We are using tracactions and
InnoDB is don't use query cache. Now we have to migrate our DB to
MySQL
hi,
At 14:54 25.05.2005, Scott Purcell wrote:
Hello,
I posted last night but did not receive an answer. I am trying to create a
fulltext index, but my table was created as an InnoDB type.
There is quite a bit of data there (1000+ records) and I need to change to
a MyISAM table for the
Hi,
I have a question: which way is better for storing data in InnoDB with
MySQL 4.1.x? File per table or one big file? How is the performance with
file per table?
Best Regards,
Rafal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I'm thinking too about switching to MySQL 4.1.x and if it better to user
file per table.
How much tables and data have you in your db? And which performance you have?
Best Regards,
Rafal
At 09:53 19.05.2005, ManojW wrote:
Dear All,
I am using MySQL 4.0.15 on a Linux (RH9) for the past 18
Hi,
we have the problem, that queries generated by JBoss or our code which
runns under JBoss will be not cached by MySQL. The same query sendet from
an external application or MySQLFront will be cached by the same MySQL.
I'm using JBoss 3.2.5 with JDBC 3.0.16 and MySQL 4.0.23a.
Any idea why?
Hi,
our MySQL server can handle 1000 connections. We have two JBoss instances.
Each configured with max. 100 connections in pool. furthermore we use php
which make on each call a connection to MySQL. After a while (some days) we
get this:
java.sql.SQLException
MESSAGE: Data source rejected
At 11:14 19.04.2005, prasanna a wrote:
Hi
It means that mysqld has received many connect
requests from that host.If the erro on connecting to
But than we should get to many connections.
mysqld exedes the parameter max_connect_errors
How can there be an error?
(Default value is 10).
We change this
with
'mysqladmin
flush-hosts'
I don't have any idea why this happens. We can connect to mysql from
other
computer or directly to make 'mysqladmin flush-hosts'.
Can somebody give me some tips?
Rafal Kedziorski [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com
Hi,
I wrote some weeks ago to the mailinglist with the same problem. The
performance isn't still much better.
I try to find the optimal value for tmp_table_size (now set to 67108864),
cause we have some problems. Sometimes I see, that the result data will be
copied to tmp table:
Copying to
Hi,
our logfile size is not set like:
Set the log file size to about 25% of the buffer pool size
Could we remove the actual log file and set the new or is this important?
Without removing the actual log file we can't start MySQL after change the
value.
Regards,
Rafal
At 22:13 07.04.2005, Gleb Paharenko wrote:
Hello.
According to:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
the temporary result set was larger than tmp_table_size and the thread
But we get max. 10.000 long values in out result set.
is changing the temporary table from in-memory to
At 22:13 07.04.2005, Gleb Paharenko wrote:
Hello.
According to:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
the temporary result set was larger than tmp_table_size and the thread
is changing the temporary table from in-memory to disk-based format to
save memory. I suggest you to play
JBoss connection pool. This are
prepared
statements
- needed from JBoss 450-500 millis
- nedded from normal Java application 15-25 millis
Rafal Kedziorski [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http
connection pool. This are
prepared
statements
- needed from JBoss 450-500 millis
- nedded from normal Java application 15-25 millis
Rafal Kedziorski [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http
|
+-+---+
133 rows in set (0.08 sec)
I tryied an older version of our JBoss application and a newer JBoss. But
without any changes.
Regards,
Rafal
Rafal Kedziorski [EMAIL PROTECTED] wrote:
Hi,
after extending our MySQL 4.0.23a installation to master-slave
configuration two specific queries
Hi,
after extending our MySQL 4.0.23a installation to master-slave
configuration two specific queries sended from our JBoss are 25-30 times
slower.
In our J2EE application which runs under JBoss 3.2.2 we are generating own
queries by using a connection from JBoss connection pool. This are
Hi,
I'm working with JBoss and MySQL 4.0.22 (and 4.0.18 on Testsystem). But
under the load, I get sometimes Exceptions like this:
java.sql.SQLException: Deadlock found when trying to get lock; Try
restarting transaction message from server: Lock wait timeout exceeded;
Try restarting
s2u.setting_id = 150 and u.user_id = s2u.user_id;
Rafal Kedziorski [EMAIL PROTECTED] wrote:
Hi,
If I do this, I get You have an error in your SQL syntax. Check the
manual
that corresponds to your MySQL server version for the right syntax to use
near '(cast(from_unixtime(cast(s2u.value
', '-07:00') from users u,
setting_2_user s2u where s2u.setting_id = 150 and u.user_id = s2u.user_id;
Rafal Kedziorski [EMAIL PROTECTED] wrote:
Hi,
If I do this, I get You have an error in your SQL syntax. Check the
manual
that corresponds to your MySQL server version for the right syntax to use
hi,
I store in a column (varchar(20)) milliseconds. How can I format the value
in a select statement to right timezone?
Regards,
Rafal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
|
++
Rafal Kedziorski [EMAIL PROTECTED] wrote:
hi,
I store in a column (varchar(20)) milliseconds. How can I format the value
in a select statement to right timezone?
Regards,
Rafal
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email
hi,
I have some problmes with MySQL. We have some CHAR columns, which after
CREATE or ALTER TABLE
ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
`media_file_class_id` CHAR(32) NOT NULL
will be VARCHAR. Is this an MySQL bug? We are using MySQL 4.0.18.
Regards,
Rafal
--
MySQL General
thx.
At 13:43 22.03.2004, [EMAIL PROTECTED] wrote:
Rafal Kedziorski [EMAIL PROTECTED] wrote on 22/03/2004 12:36:33:
hi,
I have some problmes with MySQL. We have some CHAR columns, which after
CREATE or ALTER TABLE
ALTER TABLE `traffic_stat` CHANGE `media_file_class_id
At 13:56 22.03.2004, Martijn Tonies wrote:
I have some problmes with MySQL. We have some CHAR columns, which after
CREATE or ALTER TABLE
ALTER TABLE `traffic_stat` CHANGE `media_file_class_id`
`media_file_class_id` CHAR(32) NOT NULL
will be VARCHAR. Is this an MySQL bug? We are
or INTO follows table name an not a function.
Regards,
Rafal
At 17:58 28.10.2003, Rafal Kedziorski wrote:
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I
have problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I have
problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password, status, creation_date,
last_login_date) values
At 15:09 28.10.2003 -0600, gerald_clark wrote:
Rafal Kedziorski wrote:
hi,
I'm using MySQL 4.0.13 and 4.0.14 (4.0.16 I will test tomorrow). And I
have problems with this query:
insert into user(class_id, retail_id, mandant_id, language_id,
user_data_id, nickname, login_name, password, status
hi,
we have problems with import our dumped InnoDB tables.
We get this error message:
Can't create table '.\mmcms_test\media_lock.frm' (errno: 150)
My tables which will be referenced by foreign keys will be dumped in the
inncorect order.
if I set:
SET FOREIGN_KEY_CHECKS=0;
sql script
SET
hi,
I have this table:
CREATE TABLE `category_tree` (
`category_tree_id` BIGINT NOT NULL AUTO_INCREMENT,
`parent_id`BIGINT,
`mandant_id` SMALLINT NOT NULL,
`partner_id` SMALLINT NOT NULL,
`class_id` VARCHAR ( 32) NOT NULL,
`position`
hi,
I'm porting an PostgreSQL script to MySQL. I get an error:
Can't create table '.\mmcms\mandant.frm' (errno: 150)
for this tables:
CREATE TABLE `firm` (
`firm_id` SMALLINT NOT NULL AUTO_INCREMENT,
`name`VARCHAR (40) NOT NULL,
#
PRIMARY KEY (`firm_id`)
) TYPE=InnoDB;
CREATE
KEY (`mandant_id`),
INDEX (`firm_id`),
INDEX (`parent_id`),
FOREIGN KEY (`firm_id`)
REFERENCES `firm` (`firm_id`),
FOREIGN KEY (`parent_id`)
REFERENCES `mandant` (`mandant_id`)
) TYPE=InnoDB;
and it works.
Regards,
Rafal
At 10:43 07.07.2003 +0200, Rafal Kedziorski wrote:
hi
At 17:58 07.07.2003 +0900, Nils Valentin wrote:
2003年 7月 7日 月曜日 17:43、Rafal Kedziorski さんは書きました:
hi,
I'm porting an PostgreSQL script to MySQL. I get an error:
Can't create table '.\mmcms\mandant.frm' (errno: 150)
for this tables:
CREATE TABLE `firm` (
`firm_id` SMALLINT NOT NULL
Hi,
has anybody tested MySQL 4.0.12/13 with InnoDB tables agains PostgreSQL 7.3.x?
Regards,
Rafal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
38 matches
Mail list logo