Hi mysql-listers
mysql> select version();
++
| version() |
++
| 4.1.7-standard-log |
++
1 row in set (0.10 sec)
mysql>
[EMAIL PROTECTED]:~> uname -a
Linux rosetta 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i686
i686 i386 G
On Friday 11 February 2005 09:15, Terry Riley said something like:
> Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk,
> that had an apparently unusable XP SP2 OS on it, I decided to wipe
> the disk and install my first Linux instead, using an ancient RedHat
> 7.3 distribution.
Fi
Hi All,
I had to do an alter table on a very large InnoDB
table (100 million rows avg. row size 300 bytes
inclusive of index length). This table is on a 200G
disk and the server has 4G RAM. I also archived 50
million rows to another table. So the total table size
is now 1/2 of its original.
S
You may want to read this section of the manual:
http://dev.mysql.com/doc/mysql/en/innodb-auto-increment-column.html
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
> -Original Message-
> From: Rishi Daryanani [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 11, 2005
http://dev.mysql.com/doc/mysql/en/innodb-auto-increment-column.html
Rishi Daryanani wrote:
Hi,
My database is mostly made up of MyIsam tables, and some InnoDB tables.
One particular Innodb table works fine with an auto increment field.
The table is updated often, records being added and deleted at
Hi,
My database is mostly made up of MyIsam tables, and some InnoDB tables.
One particular Innodb table works fine with an auto increment field.
The table is updated often, records being added and deleted at pretty
much the same rate.
So, there are only a very few records in the table at any giv
zzapper wrote:
On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote:
Tom adapting your script,
create table test (txt varchar(255)) Type=MyISAM;
insert into test values('Some Text\nand some more');
update test set txt = replace(txt,'\n','');
BTW
\n = null
\0 seems to be something else
Turns out my
> -Original Message-
> From: John Berman [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 11, 2005 16:22
> To: 'Tom Crimmins'
> Cc: mysql@lists.mysql.com
> Subject: RE: Remove spaces
>
> The error is simply:
>
> [JGSGB 4.1 Host] ERROR 1064: You have an error in your SQL
> syntax; ch
The error is simply:
[JGSGB 4.1 Host] 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 'update mc_census set surname = trim(surname)' at line 6
John B
-Original Message-
From: Tom Crimmins [
Please post the error because this looks correct.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
> -Original Message-
> From: John Berman [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 11, 2005 16:05
> To: 'Homam S.A.'
> Cc: mysql@lists.mysql.com
> Subject: RE: Rem
It should work fine. These should execute fine on your
server:
create table yourtable(yourfield varchar(256));
insert into yourtable(yourfield)
values (' This needs to be trimmed ');
update yourtable set yourfield = trim(yourfield);
select * from yourtable;
I'm running version 4.1.9, but I thi
Thanks for this
I did this:
update mc_census set surname = trim(surname)
however it fails with a syntax error ?
I'm on 4.1
Regards
John B
-Original Message-
From: Homam S.A. [mailto:[EMAIL PROTECTED]
Sent: 11 February 2005 21:29
To: mysql@lists.mysql.com
Subject: Re: Remove spaces
update your_table
set your_field = trim(your_field)
--- John Berman <[EMAIL PROTECTED]> wrote:
> Hi
>
> I have a table with a number of fields
>
> The table is already populated, however some entries
> have got spaces both
> before and after the data.
>
> Future imports into the table will ha
Hi
I have a table with a number of fields
The table is already populated, however some entries have got spaces both
before and after the data.
Future imports into the table will have the spaces removed, however im still
stuck with my extra spaces.
I have checked the Mysql manual but could not f
Asad Habib <[EMAIL PROTECTED]> wrote on 02/11/2005 04:03:32 PM:
> Does anyone know where I can find a list of characters that cannot be
> inserted into a MySQL database as part of a string? I know that MySQL
does
> not accept single and double quotes and that these have to replaced by
> their nam
Thanks to all who replied - food for thought...
Cheers
Terry
- Original Message -
> Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, that
> had an apparently unusable XP SP2 OS on it, I decided to wipe the disk
> and install my first Linux instead, using an ancient Red
Does anyone know where I can find a list of characters that cannot be
inserted into a MySQL database as part of a string? I know that MySQL does
not accept single and double quotes and that these have to replaced by
their name code equivalents. Are there any other characters that are
unacceptable?
On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote:
Tom adapting your script,
create table test (txt varchar(255)) Type=MyISAM;
insert into test values('Some Text\nand some more');
update test set txt = replace(txt,'\n','');
BTW
\n = null
\0 seems to be something else
Turns out my rotten cha
select test, max(audit_date)
from your_table
where device = 1
group by test
order by 1
--- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> I need to get the aggregate data from various tables
> for a report.
>
> The idea is that we audit devices daily on a
> schedule, and also allow users
> to audi
On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote:
Tom adapting your script,
create table test (txt varchar(255)) Type=MyISAM;
insert into test values('Some Text\nand some more');
update test set txt = replace(txt,'\n','');
BTW
\n = null
\0 seems to be something else
Turns out my rotten cha
> -Original Message-
> From: Daevid Vincent
> Sent: Friday, February 11, 2005 14:32
> To: mysql@lists.mysql.com
> Subject: Need help with historic aggregation of data
>
> I need to get the aggregate data from various tables for a report.
>
> The idea is that we audit devices daily on a s
"Hannes Rohde" <[EMAIL PROTECTED]> wrote:
>
> innodb_data_file_path=ibdata1:2G:autoextend
>
> innodb_buffer_pool_size=1200M
> innodb_additional_mem_pool_size=20M
>
>
May not solve the replication issue, but if this is a 4GByte server that is
dedicated to MySQL (ie you aren't using memory for an
"Hannes Rohde" <[EMAIL PROTECTED]> wrote:
>
> innodb_data_file_path=ibdata1:2G:autoextend
>
> innodb_buffer_pool_size=1200M
> innodb_additional_mem_pool_size=20M
>
>
May not solve the replication issue, but if this is a 4GByte server that is
dedicated to MySQL (ie you aren't using memory for an
I need to get the aggregate data from various tables for a report.
The idea is that we audit devices daily on a schedule, and also allow users
to audit the devices by choosing certain tests to run. It is also the case
that new tests are added daily. So the scheduled test today has more tests
than
Why MySQL insists on ignoring the query cache whenever
I use the same query repeatedly to populate a temp
table?
So I have:
create temporary table MyTable
select SQL_CACHE * from SomeTable WHERE (A bunch of
criteria) limit 1000;
SomeTable is a read-only table.
If I issue the query without the t
Looking at your my.cnf files I don't see where you've told the slave what
server to connect to. The slave needs to know what server is the master.
This is usually accomplished by including a couple of lines in my.cnf.
If the file master.info is in the data directory it will override the my.cnf
set
I'd have to agree with Hassan here, with MySQL having the binaries built,
it's quite easy if you can set PATHs and make some symbolic links (for
"service mysql start" to work).
Michael
-Original Message-
From: Hassan Schroeder [mailto:[EMAIL PROTECTED]
Sent: Friday, February 11, 2005 2:
Terry Riley wrote:
install my first Linux instead, using an ancient RedHat 7.3 distribution.
Having done that successfully, and increased the memory from 256 to 768Mb,
I think I'm now ready to install the latest MySQL on it. All my previous
MySQL experience, unfortunatley, has been on WinNT, usua
Harrison,
Taking your suggestion and building a combined key of member_id
and pts_awarded the query took 17 mins
create table pts_sumC_snap
select member_id, count(1) count, sum(pts_awarded) points
from pts_awarded_snap
group by member_id;
Query OK, 12488780 rows affected (16 min
Dear [EMAIL PROTECTED]
Please configure your email client to stop sending auto reply messages in
reply to posts to the mysql mailing list.
Filters are your friends to achieve this.
Thank you in advance
With kind regards
Andy
--
---
Registered Linux user number 379093
---
--
MySQL Genera
On Fri February 11 2005 19:15, Terry Riley wrote:
> Now the question: If I'm only using this as a database (no development) on
> RH7.3, which is the preferred download? I am confused by the plethora of
> options available for Linux. Just need something that is relatively simple
> to install (either
Harrison Fisk <[EMAIL PROTECTED]> writes:
>The difference between the count(*) and the other query is that the
>real query has to use the datafile to retrieve the data when you are
>involving the actual columns. With the count(*) query it is using an
>Index only read, meaning that it doesn't
This wasn't an upgrade,...brand new laptop,...clean installs of
everything which is why I was surprised things didn't go as smoothly
as I expected,...I did not compile php myself,...used a package
installer made by Marc Liyanage (entropy.ch) who typically has very
well put together stuff for Ma
Jeff,
When you upgraded to the 4.1 version of MySQL did you run the
mysql_fix_privilege_tables script? I just upgraded a 3.23 server to the 4.1
and ran that script and my php seems to work fine using the 3.23 client. I
had to "fix" other instances where I had used the password('pass') me
Hi!
Am Fr, den 11.02.2005 schrieb Scott Pippin um 18:55:
> What knid of performance difference can I expect between 2 xeon 3ghz
> 32bit compared with 2 IBM Power5 64bit processors if memeory and
> everything else is the same?
As for the raw CPU power, I have no figures. You probably know that a
Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, that
had an apparently unusable XP SP2 OS on it, I decided to wipe the disk and
install my first Linux instead, using an ancient RedHat 7.3 distribution.
Having done that successfully, and increased the memory from 256 to 768Mb,
The 64-bit, as far as MySQL is concerned, would give you better performance.
MySQL is built for 64-bit.
Michael
-Original Message-
From: Scott Pippin [mailto:[EMAIL PROTECTED]
Sent: Friday, February 11, 2005 12:56 PM
To: mysql@lists.mysql.com
Subject: 32 bit vs. 64 bit
What knid of per
You need to rebuild PHP (./configure --with-mysql, make, make install), etc.
Don't know everything offhand, but it will build the libraries you need and
use the new client to connect.
Michael
-Original Message-
From: Jeff Mao [mailto:[EMAIL PROTECTED]
Sent: Friday, February 11, 2005 11:
What knid of performance difference can I expect between 2 xeon 3ghz
32bit compared with 2 IBM Power5 64bit processors if memeory and
everything else is the same?
Thanks,
Scott Pippin
[EMAIL PROTECTED]
Thanks,...that's the info I needed to help me know where to look for
a solution,..I'll direct my work on the php side of things!
Jeff
At 9:07 AM -0800 2/11/05, Hassan Schroeder wrote:
Jeff Mao wrote:
I'm back,...I've removed MySQL completely and reinstalled it using
the binaries for Mac OS X 10.
Jeff Mao wrote:
I'm back,...I've removed MySQL completely and reinstalled it using the
binaries for Mac OS X 10.3+ from the mysql website. I still have a
Client API version of 3.23 in the phpinfo() while I see 4.1.9 from the
command line.
This has *nothing* to do with the MySQL you've installed,
You should try to do a :
mysql_connect($host, $user, $password) or die(mysql_error());
to have an error message. It will be easier to find an answer from that I
think.As I told you if it's the password problem you will have "Client does
not support authentication protocol" for example.
From: Je
HI All,
I'm back,...I've removed MySQL completely and reinstalled it using
the binaries for Mac OS X 10.3+ from the mysql website. I still have
a Client API version of 3.23 in the phpinfo() while I see 4.1.9 from
the command line.
I can get things to work using the Old_Password suggested earlie
The clients are backwards compatible. Meaning if you put a 4.1 client
on the machine it will work for both 4.1 and 4.0 installations. The
only real trick to running two instances of mysqld on the same machine
is to specify the datadir on startup as in mysqld_safe
--datadir=/path/to/instance/one
in
Kevin,
I am pleased to hear this is probably possible. Now to give it a go and
see what happens.
Regards,
Ben.
Kevin Cowley wrote:
If your libraries/executables in your autonomus portable directories are
from the later version you shouldn't have problems - they're generally
backwards compatible.
If your libraries/executables in your autonomus portable directories are
from the later version you shouldn't have problems - they're generally
backwards compatible.
You're also better off since you're running two 4.n.x versions. The
problems really occur if you have 4.n.x and 3.n.x installed on t
Thanks for the documentation, there are some interesting things in there.
I may however have to go further than this and have true autonomous
MySQL. Not sharing any /etc/my.cfg. Running everything from some '~'
directory:
~/etc/mysql.conf
~/bin/mysql*
~/libexec/mysqld
~/logs/
~/var/
~/mysql.so
Normally I do not reply to myself but I just realized that in my previous
response I confused COUNT(*) (which is slow for InnoDB because it always
does a table scan to resolve the version lock of each and every row) with
SHOW STATUS (which computes table sizes based on the average of 1 random
p
Hi List,
I am having a strange problem on Linux Fedora Core 3 with MySQL 4.1.7 ( offical
mysql rpms). The data was originally stored in MySQL 3.something and was placed
into the database via a MySQLDump file. It is too late to reload the data.
I have a table called fees:
CREATE TABLE `fees` (
Hey Tom,
Thanks for giving me a hand.
I think I solved the problem, a bit painful:
ok, i think i solved the problem...
if i want the chart layout to be like this on a page:
project | state_a | state_c | state_d | state_e
1 - - Y-
2 - Y
AS I read the Mysql-multi stuff it works if you have multiple instances
of the same version but not different version instances.
With different version instances you (may) have differences in
mysqld_safe, mysqld itself, and more than likely in the libraries
themselves so you need to use the mysqld_
YES, I need a LOT more information. Please provide ALL the information I
asked for in my previous post (especially questions 1, 2, and 3). To
compare with my "automobile" analogy: You told me that your auto is towing
a lot of identical trailers and that if you use a different vehicle on a
diff
This site may actually help out more:
http://dev.mysql.com/doc/mysql/en/mysqld-multi.html
-Original Message-
From: Kevin Cowley [mailto:[EMAIL PROTECTED]
Sent: Friday, February 11, 2005 9:58 AM
To: mysql@lists.mysql.com
Subject: RE: Two versions of MySQL on same machine
You need to inst
You need to install each version into its own directory/path structure -
if you have a default install of Mysql then you also need to take this
into account.
For each version you need to setup a my.cnf and if you want full
separation different database directories. In the my.cnf you specify
diffe
Hi..
I encountered some problems with character sets.
On the 4.0 version I stored UTF-8 strings. When upgraded to 4.1, I saw
the default character set was 'latin1', so I converted to UTF-8 using this:
ALTER TABLE my_table CONVERT TO CHARACTER SET 'utf8', DEFAULT CHARACTER
SET 'utf8';
When viewi
HI,
i give some more information about my application.
1) i have 41 million records , and this records are in 10 tables.so
each table contains arrounds 4 million records.
2) Each table contains same columns definition . Total column is 61
and total number of the indexes column is 6.ok
3)now i fir
Dear MySQL,
I require two versions of MySQL on the same machine.
[Specifically part of an HACMP array where services are portable and
move from server to server, using AIX 5.1].
The machine I have will have to support MySQL 4.0.11 and 4.1.8.
I have three questions:
1. Are there any server libs?
I
matt_lists wrote:
Anybody have any recommendations for a stored procedure editor/debugger?
We are developing a test program with 5.x.x and procedures to see if
it'll work for us
stuck trying to get variables sorted out, and without a proper
debugger it's extremely hard
thanks in advance
Nobody
Thanks, that looks something like I was looking for. Quickly looking
through it, it doesn't look like it handles attachments. But thanks,
it's a jump start.
On Feb 11, 2005, at 7:28 AM, Thomas Spahni wrote:
Brent,
see below:
On Thu, 10 Feb 2005, Brent Baisley wrote:
I am looking to store all inc
Well, the answer is "no"--there's no magic way to have an auto_increment do
what you want.
You could use a GUID--basically a pseudo-random number such the expected
time to pick a duplicate is on the order of the lifetime of the universe.
But GUID's are big and ugly, and it would be nice to just ha
Brent,
see below:
On Thu, 10 Feb 2005, Brent Baisley wrote:
> I am looking to store all incoming emails into a MySQL database. I've
> looked into dbmail, but can't get it to compile under Mac OSX (I posted
> a message on that list). I was wondering if anyone could point me in
> another direction
What about the following?
mysql> create table test (txt varchar(255)) Type=MyISAM;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values('Some Text\0and some more');
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
*** 1. row **
>
> Nevertheless you should be aware that the information is travelling
> unencrypted between the mysql client and server unless you're using SSL
> tunneling or similar techniques.
>
Sorry, since mysql 4.0, SSL is of course possible.
(I'm still using 3.23)
bh
pgp7GAhKO8td6.pgp
Description: PGP
On Friday 11 February 2005 11:52, love wrote:
> There is not some thing secret to be stored but the idea is to encrypt
> customer credit card information so it is not avilable to unauthorized
> users but key cannot be stored in source code as any body who can hack
> databases to pull out the inform
yeah, after long time,
thanks for answering.
at least i can reset password.
1. i continue what i did but set password to ''(it
doestn work if you set to other password). and restart
server normally(not with skip-grant-tables).
i can login to server. and set root password.
thanks
fred.
--- Gl
There is not some thing secret to be stored but the idea is to encrypt
customer credit card information so it is not avilable to unauthorized
users but key cannot be stored in source code as any body who can hack
databases to pull out the information can also hack key from source
code, so make
Hello.
I didn't have a practice with the KDEvelop. But I'll give you
some general rules. My suggestion, is that you use gcc compiler.
mysql_config just produces a list of libraries which you have to
add. Usually you can specify them in the environment variable $LDFLAGS
or similar. Run config
Hello.
If you mentioned an AES_ENCRYPT(), see:
http://dev.mysql.com/doc/mysql/en/encryption-functions.html
You specify your password in your queries. The database doesn't contains
the password by itself. Your application can ask a user for a password
each time, and you don't have to stor
Hello.
You should use:
service mysql start
instead of 'restart'. If it doesn't start, look into the error log,
which is usually located in the data directory. See:
http://dev.mysql.com/doc/mysql/en/error-log.html
http://dev.mysql.com/doc/mysql/en/starting-server.html
Helena
Hello.
Use OPTIMIZE NO_WRITE_TO_BINLOG syntax. See:
http://dev.mysql.com/doc/mysql/en/optimize-table.html
"Mike Debnam" <[EMAIL PROTECTED]> wrote:
> I issued a optimize table statement on my master which failed with a "lock
> wait timeout" message due to some competing queries runnin
Hello.
Please send us an output of the following statement:
SHOW VARIABLES LIKE '%char%';
See:
http://dev.mysql.com/doc/mysql/en/charset-conversion.html
Bruce Dembecki <[EMAIL PROTECTED]> wrote:
> Hi! We have a problem converting our 4.0 text columns from a Hong Kong
> database
Hello.
The outputs of the following statements would be helpful, if you want that
somebody helps you:
SHOW MASTER STATUS;
SHOW SLAVE STATUS;
SHOW STATUS;
Execute them on the master and the slave.
"Hannes Rohde" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
>We use MySQL as a
Hello.
Try --complete-insert command line option for mysqldump. See:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
[EMAIL PROTECTED] wrote:
> Hi,
>
> I just tried to upgrade from mysql 3.23.57 (SPARC/Solaris) to 4.1.9
> (i386/Linux) using mysqldump but when importing the dump on
Hello.
Can you reproduce a problem on the official binary?
Sergey <[EMAIL PROTECTED]> wrote:
> úÄÒÁ×ÓÔ×ÕÊÔÅ
>
> After upgrading mysql server from 4.1.3beta to 4.1.9 (FreeBSD 4.8,
> mysql is installed from ports) I sometimes have the following problem:
> when some perl client t
Hello.
What is in the error log? See:
http://dev.mysql.com/doc/mysql/en/error-log.html
yoge <[EMAIL PROTECTED]> wrote:
> [-- multipart/alternative, encoding 7bit, 1 lines --]
>
>[-- text/plain, encoding 7bit, charset: us-ascii, 21 lines --]
>
> In Linux , when I start mysql us
Hello.
>mysql stop automatically, and in process tab on task
> manager there is no any process name mysqld*.
You may find errors in the error log. See:
http://dev.mysql.com/doc/mysql/en/error-log.html
> my next question is can we address this problem by
> installing 4.1.9. and/or del
[EMAIL PROTECTED] mysql-debug-4.1.9-pc-linux-gnu-i686]$ perror 5
Error code 5: Input/output error
See:
http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html
http://dev.mysql.com/doc/mysql/en/error-handling.html
http://dev.mysql.com/doc/mysql/en/perror.html
Hello.
Please send us an output of SHOW MASTER STATUS ans SHOW SLAVE STATUS.
Can you reproduce the problem using official binaries?
Tierney Thurban <[EMAIL PROTECTED]> wrote:
> Hi all. Sorry if you get this twice -- it was posted to
> mysql-replication earlier, but it doesn't look lik
Hello.
The entity of the user in MySQL consists of two parts: the user name
and the host from which user connects to MySQL server (can be a '%"
- it means any host). Look like your user table doesn't have an entry
for user 'root'@'host_from_you_are_connecting'. You should manually add the
Hello.
See:
http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
Probably, you should carefully read the parts of manual related to the character
sets. See:
http://dev.mysql.com/doc/mysql/en/charset.html
Eli <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm running a qu
It means you have a problem with the way either your tables, columns,
database, or connection
Firstly do a show create table and check that the character set for the
table(s) concerned are the same and that any 'character' column has the
same set as the table.
If you set the default char set at
In Linux , when I start mysql using below command
MYSQL_HOME=`pwd`
./bin/mysqld_safe --defaults-file=$MYSQL_HOME/my.ini
--socket=$MYSQL_HOME/mysql.sock --tmpdir=$MYSQL_HOME/tmp --port=13306
--user=root &
I get a message mysql ended and
server gets shutdown
It happens in RedHat linux.
MySql V
I think you meant "select session from users where
user_id = 'X'". Anyway, it doesn't matter how big your
table is as long as you build an index on (user_id,
session). This way MySQL doesn't have to touch the
table for this query.
--- Scott Haneda <[EMAIL PROTECTED]> wrote:
> I build a few logi
Brent Baisley wrote:
I am looking to store all incoming emails into a MySQL database. I've
looked into dbmail, but can't get it to compile under Mac OSX (I
posted a message on that list). I was wondering if anyone could point
me in another direction to use MySQL as an email message store. I
don
On Thursday 10 February 2005 19:00, love wrote:
> Has any body implemented Aes encryption while storing critical data in
> mysql? I want to know the logic you are implementing to store your
> passwords to encrypt/decrypt data.
>
> Love Kumar
>
> Love Kumar wrote:
I think this question could not be
85 matches
Mail list logo
