Michael Lai wrote:
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:
yes it is mysql 4.0 how can I set i to latin 5 or how can I set the server
to latin 5?
os: centos 4.2
Thank you
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, January 31, 2006 1:40 PM
Subject: Re: charset
Hello.
In case mysql4
from linux Fedora, FC4:
[EMAIL PROTECTED] ~]# yum -y groupinstall 'MySQL Database'
Setting up Group Process
Setting up repositories
base 100% |=| 1.1 kB00:00
Setting up repositories
Reading repository metadata in from local files
Passing package
Got it started:
[EMAIL PROTECTED] ~]# service mysqld start
Initializing MySQL database: Installing all prepared tables
Fill help tables
ERROR: 1064 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 '' at line
Ok, I logged on to the GUI Administrator as:
root
localhost
/var/lib/mysql/mysql.sock
from my linux user account. Tad confusing, as to which root is being
referred to. If I, for instance, restart they system I'll need to
manually restart the database? Or, if for some other reason the
When I perform a particular query using a join the number of rows counted as
hits exceeds the number of rows returned. I think I know why but don't know
how to interrogate the database to confirm (and remedy) my suspicion.
The basic database structure is two tables. Each table contains an email
Hello.
The table should not be locked, right :D
Most probably it will be locked. If you are not running in strict SQL
mode, any column not explicitly given a value is set to its default
(explicit or implicit) value. For example, if you specify a column list
that does not name all the columns
Hello.
mysqld has a --default-character-set=name command line option. Put
latin5 instead of 'name'. It should be possible to specify this variable
through the configuration file or environment variable. You can check
if your server supports latin5 with:
show variables like 'character_sets';
Hello.
If you're not using per-file tablespace, the OPTIMIZing of the table
most probably won't decrease the size of ibdata files. See:
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
about how to decrease the size of the tablespace. OPTIMIZE table
is mapped to ALTER TABLE for
Hello.
trying to write a query to find out whether there are any email
addresses in the first table that do not have a counterpart in the second.
It seems like a job for a LEFT JOIN. To see the records which are
present in table A and not present in table B use this query:
SELECT A.* FROM A
Gurus,
We have recently installed beta version of our application on IBM - Pentium
Xeon - dual processor, 1 GB RAM, 80 GB HDD on Fedora Core 3 OS. The kernel
version which I currently have is: 2.6.9-1.667 and Mysql Server version:
4.0.20-standard.
I have noticed that mysql processes (using
Thanks for your quick response. Another question:
So, what you are saying is that sum of the memory (RES - 20m) of all the
mysql processes shown with the 'top' command is not total memory occupied by
mysql server? Like 22 threads*22m = 440MB?
Also, any idea why this keeps increasing?
As I already wrote I try do get a replication running from a mysql-4.1.13
(32bit) master to a 5.0.18 (64bit) slave. It only runs for a few minutes and
then a query hangs.
I think I now found out why:
I modified a multi-table-update that hung to a select. The same query on the absolutely
Ware,
Thanks so much for your help.
This is what I'm planning on doing, please let me know if you see any problems
here. This is on my test server, so losing data isn't the end of the world.
This is what I plan on doing in order:
1. Backup the database via mysqldump
2. Purge the
Rohit Peyyeti wrote:
Thanks for your quick response. Another question:
So, what you are saying is that sum of the memory (RES - 20m) of all the
mysql processes shown with the 'top' command is not total memory
occupied by mysql server? Like 22 threads*22m = 440MB?
Also, any idea why this
Hi,
I am trying to use mysql_real_escape_string() C API for escaping
the special characters. When I tried to compile the program using the
Visual Studio, I am getting the following link error
error LNK2001: unresolved external symbol _mysql_real_escape_string
fatal error LNK1120: 1
Devananda,
I have to support Peter on this one. What he submitted to you is a
perfectly appropriate solution. It seems as though you rejected his
assistance before even trying to see if it would work. There have been and
continue to be SQL-driven databases around that have not had and do not
Jan Kirchhoff [EMAIL PROTECTED] wrote on 02/01/2006 06:31:20 AM:
As I already wrote I try do get a replication running from a
mysql-4.1.13 (32bit) master to a 5.0.18 (64bit) slave. It only runs
for a few minutes and then a query hangs.
I think I now found out why:
I modified a
Jan,
While my query has a cardinality of 23,124*1=23,124 on mysql4,
it has
6,412*34,341=220,194,492 on mysql5 - and takes forever and makes
me
think everything hangs?!
Yep, MySQL improved the SQL compatibility of its join syntax beginning
with 5.0.12, see
Dear All,
I need your suggestions please.
have to large tables with these schemas:
Table: traffic_log
Create Table: CREATE TABLE `traffic_log` (
`recipient_id` int(11) NOT NULL default '0',
`retry` smallint(4) NOT NULL default '0',
`mobile_retry` tinyint(1) NOT NULL default '0',
`orig`
I've been trying to google to no avail for English dictionary (with
definitions) in any format that I can download and import into MySQL.
Do anyone know where I can find it?
Thanks in advance,
Scott
--
Power to people, Linux is here.
--
MySQL General Mailing List
For list archives:
I thought I found the reason for my problems with the change in
join-behaviour in mysql 5, but Iwas wrong :( there is more trouble :(
my replications hangs with simple queries like insert into table
(a,b,c) values (1,2,3) on a myisam-table.
It just hangs forever with no cpu-load on the slave.
On Feb 1, 2006, at 6:35 AM, Grant Giddens wrote:
This is what I'm planning on doing, please let me know if you see
any problems here. This is on my test server, so losing data isn't
the end of the world. This is what I plan on doing in order:
1. Backup the database via mysqldump
We've
Comma separated JOINS strikes again!!!
[...]
Here is where you will find this change documented in the manual:
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
I read that page over and over again... probably too late at night.
thanks for that info. Thanks to Peter, too.
This is wishful thinking, but I figured I'd ask anyway: the
manual states:
Starting from MySQL 4.1, the --tmpdir option can be set
to a list of several paths that are used in round-robin
fashion.
Are these directories promotable at all? In other words, if
I specify an 8G partition and a
Two days ago, a system that has been running fine started crashing...It could
be for a variety of reasons which I am researchinig. However (running mysql
5.0.18) I notice the following from netstat:
tcp0 0 iepm-bw.slac.stanford.:1000 iepm-bw.slac.stanford:38672
ESTABLISHED
tcp
That's exactly right (the few writes part, not the
knowing what I'm doing part): this particular machine only
runs reports a few times a day.
Eamon Daly
- Original Message -
From: Jan Kirchhoff [EMAIL PROTECTED]
To: Eamon
Must the RPM be manually downloaded, or can the query browser be installed
from yum? I've tried search 'mysql-query-browser' and no
result--perhaps I need to add a repository?
[EMAIL PROTECTED] ~]$ mysql-query-browser
bash: mysql-query-browser: command not found
[EMAIL PROTECTED] ~]$ ll
No I don't think this indicates orphaned sockets, having many sockets for
mysql in the state TIME_WAIT state is quite normal, as a socket has to be
created for every connection and once a connection is established the socket
goes into a TIME_WAIT state( i am not sure for how long though), the
Hi all,
I really need your help.
I have two tables:
table1:
id1|1|2|3|4|
000+a+b+c+d
001+e+f+g+h
.
.
.
and
table2:
id2|col1|col2|col3
1+val1+val2+val3
2+val4+val5+val6
3
4
.
.
.
columns (1,2,3,4,...) in table1 are rows (id2) in table2. I want to query
rows in table2 such that
I'd like to know too if posible :)
On 01/02/06, Scott Hamm [EMAIL PROTECTED] wrote:
I've been trying to google to no avail for English dictionary (with
definitions) in any format that I can download and import into MySQL.
Do anyone know where I can find it?
--
MySQL General Mailing List
For
JC [EMAIL PROTECTED] wrote on 02/01/2006 01:15:00 PM:
Hi all,
I really need your help.
I have two tables:
table1:
id1|1|2|3|4|
000+a+b+c+d
001+e+f+g+h
.
.
.
and
table2:
id2|col1|col2|col3
1+val1+val2+val3
2+val4+val5+val6
3
4
.
.
.
columns
Peter of Pedsters Planet [EMAIL PROTECTED] wrote on 02/01/2006
01:27:45 PM:
I'd like to know too if posible :)
On 01/02/06, Scott Hamm [EMAIL PROTECTED] wrote:
I've been trying to google to no avail for English dictionary (with
definitions) in any format that I can download and import
[EMAIL PROTECTED] wrote:
Must the RPM be manually downloaded, or can the query browser be
installed from yum? I've tried search 'mysql-query-browser' and no
result--perhaps I need to add a repository?
[EMAIL PROTECTED] ~]$ mysql-query-browser
bash: mysql-query-browser: command not found
Hadi,
But it's very slow.
Do you have any suggestions to fast it?
Your query calls no aggregate functions, so what do you mean to achieve
by GROUP BY ... HAVING? For example this bit of logic extracted from
your query ...
SELECT * FROM table
GROUP BY pkcol
HAVING pkcol=MAX(pkcol)
is
Have you had a look for aspell check?
For example in eventum:
http://lists.mysql.com/eventum-users/2683
This may be usefull...
For example in php there are some function for aspell
http://mx2.php.net/aspell
Regards!
Edwin.
-Mensaje original-
De: Scott Hamm [mailto:[EMAIL
Check http://dict.org/
Cheers,
-Dana
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 01, 2006 12:39 PM
To: Peter of Pedsters Planet
Cc: Mysql
Subject: Re: Dictionary
Peter of Pedsters Planet [EMAIL PROTECTED] wrote on 02/01/2006
01:27:45
[EMAIL PROTECTED] wrote:
Devananda,
I have to support Peter on this one. What he submitted to you is a
perfectly appropriate solution. It seems as though you rejected his
assistance before even trying to see if it would work.
On the contrary, I have tried his suggestions and they do not
سيد هادی راستگوی حقی [EMAIL PROTECTED] wrote on 02/01/2006
11:07:49 AM:
Dear All,
I need your suggestions please.
have to large tables with these schemas:
Table: traffic_log
Create Table: CREATE TABLE `traffic_log` (
`recipient_id` int(11) NOT NULL default '0',
`retry`
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
I can be sure, because usually these inserts are working well. And all
the
Try searching on www.dict.org
Teddy
- Original Message -
From: Peter of Pedsters Planet [EMAIL PROTECTED]
To: Mysql mysql@lists.mysql.com
Sent: Wednesday, February 01, 2006 8:27 PM
Subject: Re: Dictionary
I'd like to know too if posible :)
On 01/02/06, Scott Hamm [EMAIL PROTECTED]
You are correct, that the situation you describe was not clearly presented
in your previous reply. I humbly apologize for any offense.
Using the EXPLAIN you posted in your latest reply, you can translate your
subquery into the following JOINed query
SELECT p.offer_id
FROM paytable p
LEFT JOIN
Dear All,
I am trying to store (using the C API) a long field in a longblob table
field. The size of the sentence is 2361408 Bytes and when using the
function mysql_real_query it returns an error saying that the MySQL
server has gone. However, if I reduce the data to be stored in a factor
of
What you are looking for is called a Word List.
I would search for something like the following:
word list spellcheck
DanB
Scott Hamm [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I've been trying to google to no avail for English dictionary (with
definitions) in any format that I
Hi
I am doing investigation to determine whether we can use MySQL in our
project.
But I got error message when I try to install MySQL on Unix server.
Could you
please help me?
First I uncompress with gunzip, then I use pkgadd to install, and I got
the following
error message:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, I'm trying to develop my own book database, and I have a question
about ISBN: Is that number linked to a book or to a title? That is, can
one title (say, Huckleberry Finn) have several ISBNs associated with it
through several book releases?
Just as there's MySQL Query Browser for queries and table design, is
there a similar GUI front end for data entry? I'm not building
anything complex, just a simple database to muck with. Is it easier
to do data entry on a spreadsheet, then import the spreadsheet? Seems
a bit silly, but it seems
On 2/1/06, THUFIR HAWAT [EMAIL PROTECTED] wrote:
Just as there's MySQL Query Browser for queries and table design, is
there a similar GUI front end for data entry? I'm not building
anything complex, just a simple database to muck with. Is it easier
to do data entry on a spreadsheet, then
You can also install MyODBC and then hook an Excel spreadsheet into your
database. Editing the spreadsheet will update data in your database.
This isn't a good solution if you are going to be creating new tables
often. But for manipulating data in a known set of tables it's great.
-Ryan
--
Well I have just done a google.co.uk search for
english dictionary downloadable
and got the following results:
Web Results
1 - 10 of about 1,290,000 for english dictionary downloadable.
They may not be in the correct format to import directly.
But I'm sure it is possible to write a script
John,
An ISBN is linked to a published book, sometimes just to a particular
edition.
PB
John Meyer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, I'm trying to develop my own book database, and I have a question
about ISBN: Is that number linked to a book or to a title? That is,
I think you will find a book ISBN is a reference
to a particular publisher's version of a particular book.
So in answer to your question, if several different
publishers, or even the same publisher have published
several different books all entitled 'Huckleberry Finn' then
to avoid ambiguity
I have just caught the end of this topic, so hope I'm not
repeating something already mentioned.
What I do is enter my data into a plain text file, like
this;
The questions are a bit dumb, just for testing purposes of
course!
/* file: general-quizdata.sql */
/* data to populate general
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table', I see 17203 - a difference of 130.
On Wednesday, 1 February 2006 at 15:01:15 -0600, Hong Li wrote:
Hi
I am doing investigation to determine whether we can use MySQL in
our project. But I got error message when I try to install MySQL on
Unix server. Could you please help me?
group name wheel not found in group table(s)
Dan Trainor wrote:
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table', I see 17203 - a
Hi -
Anyone else get the following message with *ever*single*post* to the
list? Anyone have a procmail filter established already? ;)
Thanks
-dant
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED]
If you really intend for this to get to me, remove the 'no' in the eMail address
above I'll send
Dan Trainor wrote:
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table', I see 17203 - a
According to the manual the value of key_len enables you to determine how
many parts of a multiple-part key MySQL actually uses.
However, it doesn't specify quite how one can determine that. It _looks_ like
the number of bytes in the key (or key part) that is used - is that correct?
TIA,
I suppose this is an inherent limitation of transactional tables - you might
see x rows, but at the same time a use who has just inserted some rows will see
x+y rows.
However I don't see that the numbers are going to be hugely inaccurate. After
all, if the table was MyISAM and you get an exact
James Harvard wrote:
I suppose this is an inherent limitation of transactional tables - you might
see x rows, but at the same time a use who has just inserted some rows will see
x+y rows.
However I don't see that the numbers are going to be hugely inaccurate. After
all, if the table was
Thanks for the prompt reply, Augusto -
I completely understand what you're saying. To have anything such as a
real-time measurement to the exact number of tables would be an
incredible preformance degration, not to mention overhead and the like.
I think I'm willing to accept the fact that
Hi,
I am trying to use mysql_real_escape_string() C API for escaping
the special characters. When I tried to compile the program using the
Visual Studio, I am getting the following link error
error LNK2001: unresolved external symbol _mysql_real_escape_string
fatal error LNK1120: 1
Thanks for your suggestion,
I forget to tell that each message in traffic_log may has at least 2 status
in status_log and I use to columns recipients_id and mobile_retry
to uniquely find each message's statuses.
May be I have to change my tables structure. I don't know.
It's really important for
Another question is that if I run such CREATE TEMPORARY statements in my
query, is MySQL really can do it fast?
Cause this query may be run periodically !
On 2/2/06, سيد هادی راستگوی حقی [EMAIL PROTECTED] wrote:
Thanks for your suggestion,
I forget to tell that each message in traffic_log may
65 matches
Mail list logo