I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I
can access the database from my JSPs with no problem except for one
small issue. After a long delay (usually overnight), when someone first
tries to access the database, I would get the following error:
Communications link
Hello.
We had an INNoDB table of very large size of 47 GB. Recently we deleted a
lot of rows from the table in order to reduce the size. The number of rows
now stands at 164,000+, however, the disk usage remains the same. I tried
OPTIMIZEing the table; but the optimize fails after running for abou
On Jan 31, 2006, at 9:54 PM, Grant Giddens wrote:
Since changing these tables, I've noticed some large files in my /
var/lib/mysql directory. This is on my test server and I'm running
gentoo linux.
The files in this directory look like:
/var/lib/mysql/gentoo1-bin.01 (1 Gig in size)
/v
--- Gleb Paharenko <[EMAIL PROTECTED]>写道:
> Hello.
>
> I usually put this statement after mysql_connect().
> It is difficult for me to say is your site is Ok,
> because my knowledge is limited only to English,
> Russian, Ukrainian and
> elementary German. Check that you can get the
> correct dat
Devananda,
>Definitely not. The first LEFT JOIN, with the clauses
>"ON
pt.login_id=pab1.login_id ... WHERE pab1.login_id IS NULL",
> does not
make sense.
?!? It's a standard JOIN replacement for NOT IN (...).
>There is not a 1to1 relationship,
These joins neither find nor assume 1:1 rela
Hi you could try:
1. disable autocommit while inserting those records, then commit after
finished.
2. You could try insert multiple column like this
insert into tableX values (a,b,c), (c,d,e), (e,f,g) ...
CMIIW
Vinay wrote:
I am using mysql5.0 on Hp-UX. IT took about 14 hours to in
Hi
If you really sure that your MySQL is not in read only option, better
you give us the my.cnf configuration
also mount result for all filesystem partition so we sure that the data
MySQL is not mounted read-only
Thx
BÁRTHÁZI András wrote:
Hi,
I get these errors:
[31-Jan-2006 17:25:
Hi Gleb
Thanx a lot for explanation, make sense.
I haven't try with INSERT INTO Y (t_y_time,and so on) SELECT
(t_x_time, ... and so on) FROM X
excluding t_y_id
The table should not be locked, right :D
Thx
Gleb Paharenko wrote:
Hello.
It seems that the problem is in the t_y_id auto_in
Hi,
I recently converted some of my tables to innodb from myisam. I don't need
transactions or rollback capability, I switched because I needed row-level
locking. These are large tables with many rows and lots of INSERTS and UPDATES.
Since changing these tables, I've noticed some large fi
Paul DuBois wrote:
At 20:41 -0500 1/30/06, Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 18:03 -0500 1/29/06, Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, re
I've been trying to get my new mysql-5.0.18-servers running as slaves of our
production systems to check if all our applications work fine with mysql 5 and
to do some tests and tuning on the new servers.
The old servers are all P4s, 3GB RAM running debian-linux, 2.4-kernel and
official mysql 4
On Jan 31, 2006, at 11:01 AM, Adrian Bruce wrote:
Thanks for the reply
yep mysqldump also causes the service to crash.
i have a few innodb tables mixed in amongst the myisam, it seems
that it is the innodb tables that may be causing the problems but i
am not sure why ???
If it's InnoDB c
Devananda,
OK, get the diescription in ordinary language right, and the query
ought to write itself. Your schema is like this? ...
and you want the paytable rows
(i) for which there is an offers row matching paytable.offer_id, and
(ii) for which there is no pab row where
pab.login_
Hi,
I get these errors:
[31-Jan-2006 17:25:59] PHP Fatal error: The MySQL server is running
with the --read-only option so it cannot execute this statement
query: INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES
('22177a73e9b93b88e376c2226d000f7b', 0, '68.142.250.172', 113872475
Hello.
It seems that the problem is in the t_y_id auto_increment field. InnoDB
puts special AUTO-INC table lock, and prevent other threads from
inserting into Y. See:
http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html
Ady Wicaksono wrote:
> Below is the SQL to create tabl
Hello
I use mysql 4.1 and php4.3.10 and phpmyadmin2.6 and apache-2.0.53 on
FreeBSD5.3
I add any text as data with phpadmin on web. it works well. But I have a
problem.
As example if I add a text to mysql table with phpadmin.
My text contains as below;
"Halid 's car is expensive"
I will see abo
Imran Chaudhry <[EMAIL PROTECTED]> wrote on 01/31/2006 12:44:17 PM:
> > I am using mysql5.0 on Hp-UX. IT took about 14 hours to insert 1.7
> millin records. How do I make >my insert run faster.The table has
> three foreign key references and the referencing columns are
> >indexed . Is that impac
> I am using mysql5.0 on Hp-UX. IT took about 14 hours to insert 1.7 millin
> records. How do I make >my insert run faster.The table has three foreign key
> references and the referencing columns are >indexed . Is that impacting the
> insert statement performance.
Just thought I'd add a little
Indexes slow down inserts, updates (if the indexed column is being updated),
and deletes.
If this is a data-refresh, consider dropping the indexes, importing the data,
and then indexing the table.
You haven't mentioned how you are getting the data into the database? Is this a bulk-load? Insert
"Vinay" <[EMAIL PROTECTED]> wrote on 01/31/2006 11:42:51 AM:
> I am using mysql5.0 on Hp-UX. IT took about 14 hours to insert 1.7
> millin records. How do I make my insert run faster.The table has
> three foreign key references and the referencing columns are indexed
> . Is that impacting the in
the indexes would significantly slow down the inserts, also are you doing
the insert from a sql script, if so you couldtry this
Wrapping your very long insert script in as follows
set autocommit = 0 ;
begin ;
[[thousands of inserts here]]
commit ;
If you use the *mysqldump* option --opt, you g
Hi,
> First thank all you who replied to my question. I should be more specific
> with my question.
>
> In mysql database table, there is some thing like in the 'create table
> syntax':
>
> fieldname enum('yes','no') default null
>
> and
>
> fieldname datetime default null
>
> I have no idea abo
> -Mensagem original-
> De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>
> "pedro mpa" <[EMAIL PROTECTED]> wrote on 01/31/2006 12:49:48 AM:
>
> > Greetings.
> >
> > I need help on the following query.
> > I get an error like "Unknown/Invalid column total_price [...]" when I
> try
> > fil
I am using mysql5.0 on Hp-UX. IT took about 14 hours to insert 1.7 millin
records. How do I make my insert run faster.The table has three foreign key
references and the referencing columns are indexed . Is that impacting the
insert statement performance.
Thanks for the help
Vinay
All,
Is there another list I can post this question to? I'm stuck in the water with
Solaris. I have my application working correctly on HP 64bit and AIX 64bit,
but having the below trouble on Solaris. I thought it might have been a bad
MySQL download so we reinstalled the client libraries an
Hi, folks
First thank all you who replied to my question. I should be more specific
with my question.
In mysql database table, there is some thing like in the 'create table
syntax':
fieldname enum('yes','no') default null
and
fieldname datetime default null
I have no idea about the first on
Hello
I use mysql 4.1 and php4.3.10 and phpmyadmin2.6 and apache-2.0.53 on FreeBSD5.3
I add any text as news with phpadmin on web. it works well. But I have a
problem.
I see the line as ( '' test ) on web (internet explorer) When I add a text
which contains ( ' test ) character with phpmyadm
Thanks for the reply
yep mysqldump also causes the service to crash.
i have a few innodb tables mixed in amongst the myisam, it seems that it
is the innodb tables that may be causing the problems but i am not sure
why ???
Imran Chaudhry wrote:
On 1/31/06, Adrian Bruce <[EMAIL PROTECTED]> w
On 1/31/06, Adrian Bruce <[EMAIL PROTECTED]> wrote:
> HI
>
> MySQL 5.0 (windows XP)
>
> I have a problem where i think some of my tables have somehow been
> corrupted, if i try to run a check table command against some tables the
> mysql service crashes and i have to restart it. I am not sure how
Rhino wrote:
First and foremost, thank you very much Michael for correcting my
mistakes; I _was_ a bit sloppy in my reading of the syntax for the
statements and that caused some unnecessary errors in my reply to Scott.
However, your corrections are not _quite_ right even now. See below
where
Hello.
In case you want to automate the process of migration have a look here:
http://dev.mysql.com/doc/migration-toolkit/en/index.html
There is a specific forum as well:
http://forums.mysql.com/list.php?61
Xiaobo Chen wrote:
> Hi, folks
>
> I am trying to convert some Mysql database into
Could your error be as simple as forgetting to separate ALL of your
indexes/constraints with commas?
CREATE TABLE (
...
PRIMARY KEY (...) ,
UNIQUE(...) ,
INDEX (...),
KEY(...),
FOREIGN KEY (...) REFERENCES othertable (other column)
) ENGINE=INNODB .
"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 01/31/2006 09:45:00 AM:
> Hi, folks
>
> I am trying to convert some Mysql database into Oracle. But their types
> are not exactly match. Could any one give a hint?
>
> Thanks in advance!
>
> Xiaobo
>
>
> --
> Faculty of Computer Science
> Dalhousie
Hi,
> I am trying to convert some Mysql database into Oracle. But their types
> are not exactly match. Could any one give a hint?
What types do you need to convert?
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upsc
First and foremost, thank you very much Michael for correcting my mistakes;
I _was_ a bit sloppy in my reading of the syntax for the statements and that
caused some unnecessary errors in my reply to Scott.
However, your corrections are not _quite_ right even now. See below where I
explain this
Hi, folks
I am trying to convert some Mysql database into Oracle. But their types
are not exactly match. Could any one give a hint?
Thanks in advance!
Xiaobo
--
Faculty of Computer Science
Dalhousie University
Halifax, Nova Scotia
Canada
--
MySQL General Mailing List
For list archives: htt
First of all I would check for file system corruption.
IIRC there is a command line tool for repairing MyISAM tables, so you can use
that without needing the MySQL database server. I'm sure there are full details
in the manual:
http://dev.mysql.com/doc/refman/5.0/en/
Good luck!
James Harvard
Oops - I too forgot the list!
- Forwarded by Shawn Green/Unimin on 01/31/2006 09:19 AM -
Shawn Green/Unimin
01/31/2006 09:06 AM
To
Jacques Brignon <[EMAIL PROTECTED]>
cc
Subject
Re: Trans.: Re: Finding the row number satisfying a conditon in a result
set
Thank you for your respons
"pedro mpa" <[EMAIL PROTECTED]> wrote on 01/31/2006 12:49:48 AM:
> Greetings.
>
> I need help on the following query.
> I get an error like "Unknown/Invalid column total_price [...]" when I
try
> filter by total_price.
> How can I do this correctly?
>
> SELECT receipts.*,
>(SELECT SUM(rece
- Message transféré de Jacques Brignon <[EMAIL PROTECTED]> -
Date : Tue, 31 Jan 2006 13:52:16 +0100
De : Jacques Brignon <[EMAIL PROTECTED]>
Adresse de retour :Jacques Brignon <[EMAIL PROTECTED]>
Sujet : Re: Trans.: Re: Finding the row number satisfying a conditon in a
result se
HI
MySQL 5.0 (windows XP)
I have a problem where i think some of my tables have somehow been
corrupted, if i try to run a check table command against some tables the
mysql service crashes and i have to restart it. I am not sure how this
damage has occurred but has anyone got any suggestions
I keep forgeting to "reply all". Sorry
- Message transféré de Jacques Brignon <[EMAIL PROTECTED]> -
Date : Tue, 31 Jan 2006 13:33:22 +0100
De : Jacques Brignon <[EMAIL PROTECTED]>
Adresse de retour :Jacques Brignon <[EMAIL PROTECTED]>
Sujet : RE: [SPAM] - Trans.: Re: Finding the
Hello.
Most probably you have to upgrade when you need one of the new features
of MySQL 5.0. See:
http://dev.mysql.com/doc/refman/5.0/en/mysql-5-0-nutshell.html
suomi wrote:
> Hi listers
> i have been looking around quite a bit for info on
> - when do i need to upgrade to mysql 5.x (because su
Hello.
In case mysql4 is mysql4.0 there should be a server system variable
default_character_set. If it is 4.1 see:
http://dev.mysql.com/doc/refman/4.1/en/charset-syntax.html
http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html
OKAN ARI wrote:
> How can I set the characterset to la
Well under Linux I re-installed apache which overwrote the
directory and deleted the pid of a currently running apache!
My workaround was to do:
$ netstat -l -t -p
as root user from the command line.
This gave me the running daemon processes that were
listening to tcp ports, and their assoc
Hi,
I am currently experiencing trouble getting my new mysql 5-servers
running as slaves on my old 4.1.13-master.
Looks like I'll have to dump the whole 30GB-database and import it on
the new servers :( At this moment I
do no see any oppurtunity to do this before the weekend since the
longest
Adam Alkins wrote:
Hi,
There's a mysqld startup option --datadir=/path/to/data which you can
use to alter your data directory. Simply adjust your startup scripts
to suite.
Regards,
-Adam
On 1/31/06, Scott Johnson <[EMAIL PROTECTED]> wrote:
Hi All,
I am trying to find out how to change th
Hi,
There's a mysqld startup option --datadir=/path/to/data which you can
use to alter your data directory. Simply adjust your startup scripts
to suite.
Regards,
-Adam
On 1/31/06, Scott Johnson <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am trying to find out how to change the location of the dat
Hi All,
I am trying to find out how to change the location of the data files. I have
not yet found a generic entry for the my.conf file to set a data and log
location.
Can I move the exiting data directory form the mySQL tree and put a soft
link to a new location on another partition?
thanks,
S
Hi, there!
I would like to know whether mysql has built-in capabilities/config options in
order to limid a database size or a table size.
I want a table to grow up to a limit and, when reached, for a new row to be
inserted the oldest one be deleted. Has mysql got this
functionality built-in? If
50 matches
Mail list logo
