Hi All,
I'm not sure the best design approach for a product table for a number
of different hardware devices. Some devices have IP, Port, CPU, Memory
specs, whilst some don't. Current desing is below.
Products:
product_id
product_name
maker_id
controller_id
product_type_id
Hi,
Thanks for your reply.
What do you mean by right character set ?
The default character set for ver. 4.1 is latin1, right ? This set should
support all western european languages !
Regarding --default-character-set command in chapter 10 is written that a way to
change settings is to
Reni Fournier wrote:
Thanks for the solution. It looks like it would work, but I don't have
MySQL 4.1 (which I believe is required for this to work, since this is
SUBSELECT, isn't it?).
Assuming I have to use two selects, which would you say is faster,
creating a temporary table in MySQL,
I did more investigation and found out that
1) with MySQL 4.1.10-nt both queries executed from Query Browser work fine
(no error) - I haven't chance to test it with my application through ODBC
connection
2) when I set initial statement in MyODBC SET CHARACTER SET 'cp1250'
instead of SET NAMES
Hi! dear all,
(BI encountered a problem with designing SQL statement. For example, I
(Bwant to query population information from a "city" table, and the
(Brecords returned must be ordered according to the population of the
(Bcity. Like this:
All,
I've got a table with about 25mill rows that was victim of a crash recently.
(power-failure).
I've been trying to recover it, but I'm not making much progress.
From the most recent attempts:
myisamchk --safe-recover --force table
- recovering (with keycache) MyISAM-table 'table'
Data
Hi there,
Question: I have a database with names that may contain accented
characters like é or è. My charset collation are the defaults latin1
latin1_swedish_ci.
In my browser all characters come out all right (both in phpMyAdmin and
in my application), but when I open a command console
Hi all,
Over the last couple of days, a MySQL 4.0.21 server of ours has crashed
a couple of times, with the error message listed below. It has
previously been running without problems since being installed (about
150 days so far).
I've not had much luck in tracking down what signal 6 means - the
Per Jessen wrote:
I've got a backup of the table, but I'm not sure what sort of state
it is in.
Correction - no backup is available. This table has got to be recoverable.
--
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Mark Sargent [EMAIL PROTECTED] wrote on 06/03/2005 03:04:23 AM:
Hi All,
I'm not sure the best design approach for a product table for a number
of different hardware devices. Some devices have IP, Port, CPU, Memory
specs, whilst some don't. Current desing is below.
Products:
product_id
Hello.
Most probably you should set the correct character sets. Search
on the list similar problems are often met there. See:
http://dev.mysql.com/doc/mysql/en/charset-defaults.html
What output does the following statement produce:
show variables like '%char%';
Send the output of:
Hello.
Switch to the latest release 4.1.12 (or 4.0.24).
It is strongly recommended to use official binaries.
Andrew Hill [EMAIL PROTECTED] wrote:
Hi all,
Over the last couple of days, a MySQL 4.0.21 server of ours has crashed
a couple of times, with the error message listed
Hello.
REPAIR TABLE ... USE_FRM helps in difficult cases. See:
http://dev.mysql.com/doc/mysql/en/repair-table.html
Per Jessen [EMAIL PROTECTED] wrote:
All,
I've got a table with about 25mill rows that was victim of a crash recently.
(power-failure).
I've been trying to
Hello.
Regarding --default-ch aracter-set command in chapter 10 is written that a
way to change settings is to recompile...
Is there another less painful way to do this ?
You may specify default character sets using options when you start
mysqld. See:
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 03 June 2005 12:29
To: mysql@lists.mysql.com
Subject: Re: Out of memory, mysqld got signal 6;
Switch to the latest release 4.1.12 (or 4.0.24).
It is strongly recommended to use official binaries.
Sure,
SQL My wrote:
(B
(B Hi! dear all,
(B I encountered a problem with designing SQL statement. For example, I
(B want to query population information from a "city" table, and the
(B records returned must be ordered according to the population of the
(B city. Like this:
(B
well - that was what I tried first - but that does not work because that
returns the latest date for which the task_id has a record as Assignment.
(It is like it picks up the max date from all records that have
name_rec_type as Assignment)
But I wanted was if the date corresponding to the
[EMAIL PROTECTED] writes:
You have a sort because you did an order by.
If you had an index with the desired order by, it may be used.
Try as you usage of covering indexes.
Hi Mathias,
Along with your suggestion, a little more thinking about the problem
and some experimenting seems to have
try
REPAIR TABLE 'tablename'
Gleb Paharenko wrote:
Hello.
REPAIR TABLE ... USE_FRM helps in difficult cases. See:
http://dev.mysql.com/doc/mysql/en/repair-table.html
Per Jessen [EMAIL PROTECTED] wrote:
All,
I've got a table with about 25mill rows that was
Hello.
This could be not exactly 4.0.21 issue, but issue of a compiler, say, if
you've built MySQL manually.
Sure, can do - but is this a known issue with 4.0.21? I wasn't able to
find anything in the bug tracker...
TIA,
--
Andrew Hill
Software Developer
m3 Media
I am running mysql 4.0.18 on Windows 2003 server which also hosts my
apache tomcat server. My applet makes a connection to the mysql database
on the server as well as a socket connection to a service on the same
server. In the lab with only a hub between the client and server, the
application
Celona, Paul - AES [EMAIL PROTECTED] wrote on 06/03/2005 01:03:18
PM:
I am running mysql 4.0.18 on Windows 2003 server which also hosts my
apache tomcat server. My applet makes a connection to the mysql database
on the server as well as a socket connection to a service on the same
server. In
Hello,
Anyone here run mysqlhotcopy? I've read the docs on it but they are
basicly just a howto and don't go too in depth. I've got a DB that is
the back end to a 24/7 application. I ususally do backups from a
replicated db by shutting down the Replicated DB then doing a tar are
all the db
I run 24/7 applications also. Use mysqlhotcopy to do exactly what you're
doing by hand now. Run mysqlhotcopy on a slave server. It does exactly
what you think. Lock and flush the tables, tarball them, and unlock them.
No shutdown required.
- Original Message -
From: Jeff McKeon
I am having problems with MySQL inconsistently choosing the wrong index, or no
index at all, for queries on tables with 20 million rows. Would it be a good
idea for me to set max_seeks_for_key to 1 (or something less than 4 billion),
in order to force MySQL to use an index? We are using
Am I right in assuming that while mysqlhotcopy is running, nobody else
can write to or update the DB?
Jeff
-Original Message-
From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED]
Sent: Friday, June 03, 2005 2:24 PM
To: Jeff McKeon; mysql@lists.mysql.com
Subject: Re: mysqlhotcopy
I
Celona, Paul - AES wrote:
I am running mysql 4.0.18 on Windows 2003 server which also hosts my
apache tomcat server. My applet makes a connection to the mysql database
on the server as well as a socket connection to a service on the same
server. In the lab with only a hub between the client and
Hi,
you can use a hint to force specific index usage :
http://lib.hutech.edu.vn/ebookonline/ebook1/0596003064/hpmysql-CHP-5-SECT-4.html
But this is not a good idea since data change and index selectivity can become
bad.
Also, if the index scan + the table scan is bigger than a full table scan,
Yep.
- Original Message -
From: Jeff McKeon [EMAIL PROTECTED]
To: Jeremiah Gowdy [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, June 03, 2005 12:11 PM
Subject: RE: mysqlhotcopy
Am I right in assuming that while mysqlhotcopy is running, nobody else
can write to or update the
Jeff McKeon wrote:
Am I right in assuming that while mysqlhotcopy is running, nobody else
can write to or update the DB?
Yes. That's why it's better to run it on a slave.
--
Keith Ivey [EMAIL PROTECTED]
Smokefree DC
http://www.smokefreedc.org
Washington, DC
--
MySQL General Mailing List
For further clarification, what we are observing is that pull down lists
(which are already built on the GUI) take a long time to complete
processing. The processing we are performing upon user selection is
taking the selected element, updating 1 database column in 1 table with
the value, and
Is there a way to tell mysql 4 to defaul to the old style passwords instead
of having to run this every time we add a user?
SET PASSWORD FOR mailto:'user'@'localhost' 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don't seem to work with the
new
On Friday 03 June 2005 03:36 pm, Joey wrote:
SET PASSWORD FOR mailto:'user'@'localhost' 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Why not recompile php to work with 4.1?
--old-password
Jeff
pgpEctk2PnMK1.pgp
Description: PGP signature
I took a couple of days vacation last week and naturally the /data partition of
my database server filled up because of something I was running and had
forgotten about. So my backup guy, thinking to help out, gzipped all my .bin
logs. Now I am noticing replication seems to have stopped on my
Joey wrote:
Is there a way to tell mysql 4 to defaul to the old style passwords instead
of having to run this every time we add a user?
SET PASSWORD FOR mailto:'user'@'localhost' 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don't seem to
I am stumped with this compile problem with 4.0.24 src. Not sure what
is causing it. Can anyone provide some insights? Last time I compiled
on the same environment was 4.0.20 source. And all was ok.
gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/ms/svc/mysql/4.0.24\
-DDATADIR=\/ms/data/mysql/4.0.24\
Hi all,
I'm new to MySQL and I'm trying to write a program that among other things
monitors database usage. I would like to write an SQL query to retrieve info
like session id, user name, cpu usage. Is there any MySQL system tables that
gives me this sort of information?
To be more precise,
In the last episode (Jun 03), Ana Leite said:
I'm new to MySQL and I'm trying to write a program that among other
things monitors database usage. I would like to write an SQL query to
retrieve info like session id, user name, cpu usage. Is there any
MySQL system tables that gives me this sort
Hi,
I have been noticing following error when trying to connect mysql.
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
or
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
What could be reason?
Is there any way I can connect to
39 matches
Mail list logo