Jacob Friis wrote:
Is it possible to append rows to a table packed by myisampack?
No, RTFM, Compressed storage format is a read-only format that is
generated with the myisampack tool.
http://dev.mysql.com/doc/mysql/en/Compressed_format.html
--
MySQL General Mailing List
For list archives:
I have a table with lots of text data, and would like to compress this
in order to save space.
I would either compress the whole table with myisampack or just the text
data with COMPRESS().
When I SELECT from this table, would it be equally fast to use
UNCOMPRESS() for text data or use a
Jason Lixfeld [EMAIL PROTECTED] wrote on 03/12/2004 03:32:32:
I'm very new to mysql and replication. I've got a case where I have 2
servers, each have database A and database B. I want server 1 to be
master for database A and slave for database B and I would like server
2 to be slave for
I just upgrade my MySQL from 4.0.20 to 4.1.7, however
i found new things here, password() function
in 4.0.20 - password(xxx) result in 5336eb751494bdb1
in 4.1.7 - password(xxx) result in *3E5287812B7D1F947439AC45E739353
how to get backward compatibility for this function ? since i use
password()
Thanks,
however why this mailing list doesn't have Reply-To field :-(
SciBit MySQL Team wrote:
Hi Ady,
See your OLD_PASSWORD MySQL option in your MySQL Docs. Or the following
articles:
http://dev.mysql.com/doc/mysql/en/MySQL_4.1_Nutshell.html
http://forum.scibit.com/viewtopic.php?t=195
Kind
Hi Ady,
See your OLD_PASSWORD MySQL option in your MySQL Docs. Or the following
articles:
http://dev.mysql.com/doc/mysql/en/MySQL_4.1_Nutshell.html
http://forum.scibit.com/viewtopic.php?t=195
Kind Regards
SciBit MySQL Team
http://www.scibit.com
MySQL Products:
Hi Luciano,
Not that this reply will solve your problem, but let it serve as a notice. It
is NEVER a good idea to use a FLOAT/BLOB column in your where clause as MySQL
can not uniquely identify the record. Especially not with floats because of
the inherent floating point error made between
Hello.
I've taken this information from documentation at
http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html
Did it solve your problem? If didn't, send me you my.cnf file and information
about version of MySQL and operating system.
matt_lists [EMAIL PROTECTED] wrote:
Gleb
Hello.
Use Perl, DBI :)
Frederic Wenzel [EMAIL PROTECTED] wrote:
On Tue, 30 Nov 2004 19:24:05 +0200, Gleb Paharenko
[EMAIL PROTECTED] wrote:
The first impression is that you forgot to convert character
columns. See:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
Hello.
In most cases, if A,B,.. are in different charsets you'll get an error.
Use SET NAMES, CONVERT() or CAST() functions, introduced to
convert everything to the same single charset. Because in other case
you'll get results converted to character_set_results,
except it was set to NULL.
Hello.
You may use _utf8 0xXX form of input, where is 0x - hexademical
representation of your japanese string (each unicode character has it's own
hexademical value). For an example see:
http://dev.mysql.com/doc/mysql/en/Charset-literal.html
hi
i want to do a insert query
Hello.
Try to connect as root (use -u root) or another user which has privilege to
create new databases.
I would like to try out MySQL on my UNIX account (Solaris).
I DO NOT HAVE root privilieges in UNIX. I only have a normal user
privilege.
I have installed MySQL on my user UNIX
Hello.
The value of wait_timeout is initialized from wait_timeout variable or
from the global interactive_timeout variable, depending on the type of client.
Put interactive_timeout=10 in your config file. See:
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
Andrew
Hello.
Did you read all promptings at:
http://dev.mysql.com/doc/mysql/en/Full_table.html
Manish [EMAIL PROTECTED] wrote:
I am trying to execute this query and it is failing with Table is full error
(I know I can make temp tables big).
update t1, t2
set t1.XXX=1
where
No.
Compressed storage format is a read-only format that is generated with
the myisampack tool. See:
http://dev.mysql.com/doc/mysql/en/Compressed_format.html
Jacob Friis [EMAIL PROTECTED] wrote:
Is it possible to append rows to a table packed by myisampack?
Thanks,
Jacob
Hello.
Install MySQL and read lists.mysql and try to find answers by yourself,
using books, google, everything you want! And, of course, feel free to
ask here - we are glad to provide an answer. :)
Eve Atley [EMAIL PROTECTED] wrote:
I am an web designer / php programmer /
Dear all,
I was using mysql 4.1.0, all table use utf8. I can use php to store and
display utf8 character without any problem.
Yesterday I upgraded 4.1.0 to 4.1.7.
I use mysql-control-center and I can see the data in 4.1.7 are utf8
characters.
However, when I use my php program to display it,
Does this silence mean that nobody knows?!? :)
I've been trying to find what privilege is needed to 'REPAIR TABLE'. I
couldn't find any usefull hint on the net or in the archives. Could
anyone help me out?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
In article [EMAIL PROTECTED],
Jigal van Hemert [EMAIL PROTECTED] writes:
Two tables (simplified, because other fields are not used in query; indexes
other than primary key removed):
CREATE TABLE `msg_content` (
`msg_id` int(14) NOT NULL auto_increment,
`subject` varchar(255) NOT NULL
TAG wrote:
I have an application that reads files converts them and then inserts
them into a database. It has 2 columns that I need help with.
First is the OFFSET column - this stores the datafile offset ..
In C it is a UNSIGNED LONG and looks like : 0x2528
the second colun is a CRC for the
Hi,
I have this weird things happens.
kaspia:/var/lib/mysql# mysql --version
mysql Ver 12.22 Distrib 4.0.21, for pc-linux-gnu (i386)
mysql show grants for root@localhost;
+-+
| Grants for [EMAIL PROTECTED]
thanks ;)
On Fri, 03 Dec 2004 13:18:53 +0100, Roger Baklund [EMAIL PROTECTED] wrote:
TAG wrote:
I have an application that reads files converts them and then inserts
them into a database. It has 2 columns that I need help with.
First is the OFFSET column - this stores the datafile
Walt,
- Original Message -
From: kernel [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, December 02, 2004 11:01 PM
Subject: Re: MySQL/InnoDB-5.0.2 is released
MySQL to return wrong results if a SELECT uses two indexes at the same
time
Does mysql 5.0.x have the
I had the same stuff going on for 4.0.7g on windows.
Olivier
Hi,
I have this weird things happens.
kaspia:/var/lib/mysql# mysql --version
mysql Ver 12.22 Distrib 4.0.21, for pc-linux-gnu (i386)
mysql show grants for \root\@\localhost\;
Hi all-
I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported -
I'm hoping someone can provide a quick alternative for me.
I have a simple table Z with 3 columns, k1, k2, and total_amt, where k1 and k2
make up the primary key. I want to create a report that lists the the
I've been trying to implement full text searches.
Genreally I use either LIKE or REGEXP for searches but wanted to try
some Full Text Searches.
It's wonderfully fast and is working well for full words, however I have
not found a way to add wildcards in a search.
For example if in my text
Rick Robinson wrote:
Hi all-
I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported -
I'm hoping someone can provide a quick alternative for me.
I have a simple table Z with 3 columns, k1, k2, and total_amt, where k1 and k2
make up the primary key. I want to create a
I'm trying to create a table, and ultimately a graph, out of some syslog
data.
I have a table with the following info in it:
Time (unixtime stamp), bytes rcvd and bytes sent
I want to create a sql statement that group the data over a certain period
of time, and produces the following
Rick Robinson wrote:
I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported -
I'm hoping someone can provide a quick alternative for me.
I have a simple table Z with 3 columns, k1, k2, and total_amt, where k1 and k2
make up the primary key. I want to create a report that
Hi Roger-
Thanks for responding. It's what I was afraid of - I essentially have to a
write what amounts to a mini-batch process to get the info I want. In my
specific case, it looks like I'd have to:
1)- Create a temp result table
2)- Get a list of distinct k1
3)- For each distinct k1, select
On Fri, Dec 03, 2004 at 10:30:25AM -0500, Michael J. Pawlowsky wrote:
I've been trying to implement full text searches.
Genreally I use either LIKE or REGEXP for searches but wanted to try
some Full Text Searches.
It's wonderfully fast and is working well for full words, however I have
Jim Winstead wrote:
For example:
SELECT record FROM table
WHERE MATCH (record) AGAINST ('resident*' IN BOOLEAN MODE)
(Using 'IN BOOLEAN MODE' requires MySQL 4.0 or later.)
I guess it is time to upgrade from 3.23, I'm using RedHat Linux and have
upgraded on some machines but it is a pain to
James Nunnerley wrote:
I'm trying to create a table, and ultimately a graph, out of some syslog
data.
I have a table with the following info in it:
Time (unixtime stamp), bytes rcvd and bytes sent
I want to create a sql statement that group the data over a certain period
of time, and
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: 03 December 2004 16:03
To: [EMAIL PROTECTED]
Cc: James Nunnerley
Subject: Re: sum queries
James Nunnerley wrote:
I'm trying to create a table, and ultimately a graph, out of some syslog
data.
I have
Hi Roger-
Thanks for responding so quickly.
Hmm. I like it. It would get a bit hairy if I wanted top 50 or top 100. And
if I wanted the top # to be dynamic, I'll need to construct the query on the
fly...but that may be very workable. I need to play with it a bit to see how it
will perform. I
-Original Message-
From: James Nunnerley [mailto:[EMAIL PROTECTED]
Sent: 03 December 2004 16:13
To: 'Roger Baklund'; '[EMAIL PROTECTED]'
Subject: RE: sum queries
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: 03 December 2004 16:03
To: [EMAIL
Don't bother. This is a very expensive solution. You get nearly a
Cartesian product on each JOIN. I've got a 40 row test table with 20 values
in each of 2 groups. The top 3 version of this examines 2302 rows to
produce the 3 values for each of the 2 groups. The top 10 version has been
James Nunnerley wrote:
* Roger Baklund:
select date_format(ts,%Y-%m-%d %H) period,sum(rcvd),sum(sent)
from mytable
group by period;
So the below query above will allow me to group by hour - which is quite
useful - is there anyway of grouping by say 3 hour periods?
Not using the date_format()
Michael Stassen wrote:
Don't bother. This is a very expensive solution. You get nearly a
Cartesian product on each JOIN. I've got a 40 row test table with 20
values in each of 2 groups. The top 3 version of this examines 2302
rows to produce the 3 values for each of the 2 groups. The top
After installing MySQL 5.0.2 on MDK10.0 mysqld doesn't start with error:
Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)
I think it's a problem with innodb, if I add skip-innodb on my.cnf
mysqld starts up:
041203 14:04:01 mysqld started
041203 14:04:01 [Warning] Asked for 196608
I think Roger was actually on the right track with his initial suggestion
that this is a groupwise maximum problem as described in the manual page he
referenced. Try this:
CREATE TEMPORARY TABLE topten (k1 CHAR(1), total_amt int);
LOCK TABLES Z AS x READ, Z AS y READ;
INSERT INTO topten
You could do something like this, not sure what your intent is if among
the top total_amt is a single exact amount that occurred 30 or 40
times...are you implying the top 10 items or the top 10 distinct items?
select *
from table_z a
where 10=(select count(*)
from table_z b
Hello,
Sorry for the cross post, I didn't get any response from the internals
list... I'm trying to compile mysql 4.1.7 from source on SLES 8, running on
os390. I'm having a problem that others have seemed to have:
http://lists.mysql.com/internals/17577
Michael Stassen wrote:
Michael Stassen wrote:
Don't bother. This is a very expensive solution. You get nearly a
Cartesian product on each JOIN. I've got a 40 row test table with 20
values in each of 2 groups. The top 3 version of this examines 2302
rows to produce the 3 values for each of
I am kinda new to SQL, and am having a problem trying to get something done.
I'm trying to search for usernames in one of my tables. The name is
stored as firstname lastname.
I wrote my query as
select Cust_ID, Cust_Name
from mailings
where ucase(Name) = ucase(Cust_Name)
When it runs, I get a
Hi there,
I have had good success with gentoo (full source
install/compile) and MySQL's binaries on Opteron systems.
We're running 2 opteron boxes (1 with 16 gigs of RAM,
1 with 32 gigs of RAM) with no problems.
We are running at about 1000-2000 queries per second
(mostly inserts).
Cheers,
This all started when one of the 16 byte binary primary keys kicked out
a duplicate key error. It seems mysql does not store the last byte of
the binary value if it is a space. That is, ascii 32 or hex 20.
How do I force it to store the space? Thanks!
create table testtable ( id binary(16) NOT
What if we used the MySQL-specific feature group-wise auto_increment ?
http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html
For MyISAM and BDB tables you can specify AUTO_INCREMENT on a secondary
column in a multiple-column index. In this case, the generated value for
the
Your sample query is not valid SQL. What tool/language are you using to
run this query? There must be something interpreting what you entered and
mis-representing your query to the MySQL server. Without that piece of the
puzzle I am completely in the dark.
It would also help to know what
Hello,
As you may know, the mambo (open source CMS) table names
begin with a # character. How does one describe a table that
begins with #?
-DK
Daniel Kemper
Lead Programmer
Intellisys, Inc.
I am writing this by hand, and is being used within Coldfusion.
MySql is v 4.1.7 and I am connecting via ODBC.
Steve
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Your sample query is not valid SQL. What tool/language are you using to
run this query? There must be something
Alejandro,
- Original Message -
From: Alejandro D. Burne [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 03, 2004 7:20 PM
Subject: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)
After installing MySQL 5.0.2 on MDK10.0 mysqld doesn't
In the last episode (Dec 03), Mark Maunder said:
This all started when one of the 16 byte binary primary keys kicked out
a duplicate key error. It seems mysql does not store the last byte of
the binary value if it is a space. That is, ascii 32 or hex 20.
How do I force it to store the
Thing is I don't want a dynamic table for performance reasons. I'm
storing an MD5 hash which is 16 bytes. As a workaround I'm only using 8
bytes of the hash and storing it in a bigint(20) column for now. So I
guess eighteen quintillion, four hundred forty six quadrillion, seven
hundred forty four
At 14:10 -0600 12/3/04, Dan Nelson wrote:
In the last episode (Dec 03), Mark Maunder said:
This all started when one of the 16 byte binary primary keys kicked out
a duplicate key error. It seems mysql does not store the last byte of
the binary value if it is a space. That is, ascii 32 or hex
[EMAIL PROTECTED] wrote:
What if we used the MySQL-specific feature group-wise auto_increment ?
I was thinking of a similar idea, with user variables, also MySQL-specific.
What do y'all think?
I think it should work, but only Rick can tell... :)
--
Roger
--
MySQL General Mailing List
For list
So what you're saying is that BINARY isn't binary because it chomps
spaces off the end, thereby corrupting the binary data. Sounds like a
bug. Should I report it?
On Fri, 2004-12-03 at 12:30, Paul DuBois wrote:
I agree about using the TINYBLOB to avoid trailing space truncation, but
BINARY and
Mark,
- Original Message -
From: Mark Maunder [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 03, 2004 10:52 PM
Subject: Re: if last binary byte is space (ascii 32) mysql drops it
So what you're saying is that BINARY isn't binary because it chomps
spaces off
It looks like when mysql coerces character strings into integers, it
turns them into signed int's. Obviously if the column is unsigned, this
is a problem. Don't use quotes you say. Problem is that the perl DBI API
seems to put quotes around everything. So when I grab a really really
large integer
At 16:34 -0800 12/3/04, Mark Maunder wrote:
It looks like when mysql coerces character strings into integers, it
turns them into signed int's. Obviously if the column is unsigned, this
is a problem. Don't use quotes you say. Problem is that the perl DBI API
seems to put quotes around everything.
Thanks very much Paul. My day has just improved.
On Fri, 2004-12-03 at 16:53, Paul DuBois wrote:
At 16:34 -0800 12/3/04, Mark Maunder wrote:
It looks like when mysql coerces character strings into integers, it
turns them into signed int's. Obviously if the column is unsigned, this
is a
I'm running into some performance problems with a table of time
intervals. I'd like to look up the record that covers/overlaps a
given instant, and I was hoping that someone might help me out.
Consider these tables:
create table items (
item_id integer auto_increment not null,
myisampack will result in a smaller table. The only downside is that
the table becomes read only.
On Fri, 03 Dec 2004 09:31:22 +0100, Jacob Friis [EMAIL PROTECTED] wrote:
I have a table with lots of text data, and would like to compress this
in order to save space.
I would either compress
Try enclosing it in backticks like this. `#table`
Here is the url for reference:
http://dev.mysql.com/doc/mysql/en/Legal_names.html
On Fri, 3 Dec 2004 13:37:38 -0600, Daniel Kemper [EMAIL PROTECTED] wrote:
Hello,
As you may know, the mambo (open source CMS) table names
In the last episode (Dec 03), FFF FFF said:
I'm running into some performance problems with a table of time
intervals. I'd like to look up the record that covers/overlaps a
given instant, and I was hoping that someone might help me out.
Consider these tables:
create table items (
Isn't that technically multiple queries?
In mysql an insert inserts into one table. That's it.
-Eric
On Wed, 1 Dec 2004 15:50:15 +0100, ***ADI*** [EMAIL PROTECTED] wrote:
in MS SQL u can do it by the following query:
declare @transool varchar(20)
set @transool = 'opcofficelink'
begin
If you change the update to a select you can use explain to see it's
execution path just like you would with a normal select. The rows
returned are the rows that would be matched by the update query.
Example:
explain select * from t1, t2 where t1.YYY=t2. and t2. like '%X%';
Optimize the
I can grant another previleges, but not replication slave and
replication clients. How do I fix this? Thank you in advance.
I checked my mysql.user table, and I just found out that it didn't have
Repl_slave_priv and Repl_client_priv columns. How is this possible?
mysql select * from
Steve Grosz wrote:
I am using the MySql Administrator tool to schedule weekly backups on my
databases. I have defined the databases I want backed up and how often,
plus where to store the data. I ran a sample, but it appears that just
the structure is being backed up, not the data in the
Does Name exist as a column in your table, or is it a ColdFusion variable?
I know very little about how ColdFusion works, but it does parse the
query, and alter it, before it gets sent to ODBC. Just looks like it's
using ucase(Name) as a coldfusion function, then replacing it in the query.
Just
70 matches
Mail list logo