Hardware: 1.8 GHz G5 with 1GB RAM
Panther (Mac OS X 10.3) doesn't have the sudden slowness in the
'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther
is faster than total time for Jaguar (5561.00 secs vs. 6770.00 secs).
'Insert' is faster on Panther than on Jaguar (3316 secs
Hi,
I downloaded Linux semi static binary of
mySQL,mysqlgui-linux-semi-static-1.7.5.tar.gz. Could you please help me,how to install
in my system.My OS is Redhat Linux9.0.
Warm regards,
Renuka Prasad.N
Hello,
I hope someone can help me with the following problem: I have a table
containing integer counters associated with particular datetime like this:
CREATE TABLE `counters` (
...
`when` datetime NOT NULL default '-00-00 00:00:00',
`counter` smallint(5) unsigned NOT NULL default
Renuka,
Put the file into a location such as /usr/local
Gunzip it:
gunzip mysqlgui-linux-semi-static-1.7.5.tar.gz
Unpack it:
tar -xvf mysqlgui-linux-semi-static-1.7.5.tar
create a symbolic link from mysql to mysqlgui-linux-semi-static-1.7.5
under /usr/local/
ln -s
I'm building a financial-like web site (PHP - MySQL). I was requested to
build a search engine for IT.
Everything works OK, w/ the exception of a certain component. The owner of
the web site will write, each day, a report for the customers. I use TEXT
fields to record each section of the report
Man, if you need a full boolean search, ie more than one word, use
fulltext !, it crunches cpu so you need a beasty machine, use like if its
just one string you are searching for in a varchar field, use fulltext if
you are searching in wads of text.
I highly recommend match against though, its
I've set up a new MySQL server on a box with multiple IP addresses, and the
SQL server only binds to ONE of these addresses.
Also, I've been changing some user rights in the SQL setup, and now I get a
cronjob error, related to user rights... My big problem is that I don't
even know where I
Hi Petr,
I hope someone can help me with the following problem: I have a table
containing integer counters associated with particular datetime like this:
CREATE TABLE `counters` (
...
`when` datetime NOT NULL default '-00-00 00:00:00',
`counter` smallint(5) unsigned NOT NULL
HiY'll
I've been using MYSQL for a couple of years now. And can write some
pretty complex WHERE statements. I've become aware that's really only
tip of the iceberg stuff.
Can readers suggest a gentle path to moving onto JOINS and a more
fundamental understanding of DBs
No rude answers please g
From http://www.mysql.com/doc/en/News-4.0.13.html: Added multi-threaded
MyISAM repair optimisation and myisam_repair_threads variable to enable
it.
The variable is also documented in
http://www.mysql.com/doc/en/SHOW_VARIABLES.html: If this value is
greater than one, MyISAM table indexes during
From the documentation: If the temporary file used for fast index
creation would be bigger than using the key cache by the amount
specified here, then prefer the key cache method.
Did I understand correctly that if I always want fast index creation
whenever myisam_max_sort_file_size is set large
In my.cnf:
[mysqld]
key_buffer_size=64M
myisam_sort_buffer_size=512MB
myisam_max_sort_file_size=100
myisam_max_extra_sort_file_size=0
bulk_insert_buffer_size=64MB
...
All variables are set as expected, except myisam_max_sort_file_size,
which is set to 4GB. Only if I choose a value
Anything that breaks a script (unsupported functions, changes, etc.) or that
causes performance problems.
thanks,
Luis
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 4:09 PM
To: Luis Lebron
Cc: Mysql (E-mail); Php-General (E-mail)
The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The
Linux machine was a default SuSE 8.0 installation. ext2 as the
filesystem? No idea about journaling. No SCSI or RAID, just an
internal IDE disk. Both machines are really consumer-level machines,
no heavy-duty server hardware.
Yes I was already pretty sure it was a rights issue. What I'm trying
to do is modify the rights for a particular user so I can log in
remotely. The question is what I should use for the host fields in the
various tables so that I can log in remotely *and* the web server can
log in through
Thanks for posting the comparison, it's something I've been meaning to
do myself.
I was wondering if you had journaling turned on in Panther and not in
Jaguar? I'm not sure if it would have any effect on selects, I would
think it would slow down inserts not selects. You notice the CPU
Hi.
When MySQL reach max connection can root use mysql client program to login
and look for some process that can be kill to release connection.
I had ever seen from some web said that some user with PROCESS_ACL
privileges can do (can login MySQL reserved 1 connection for user who has
Any suggestions of a secure way of storing membership passwords (for a
website) in a mysql database? Should I use sha, aes, des???
thanks,
Luis R. Lebron
Sigmatech, Inc
I was wondering if you had journaling turned on in Panther and not
in Jaguar? I'm not sure if it would have any effect on selects, I
would think it would slow down inserts not selects. You notice the
CPU breakdown is different.
Journaling was turned on in both cases.
JP
--
MySQL General
SQL
mysql
HI, All!
I have a question.
I migrate from 4.0.14 to 4.1.0 but:
the 4.0.14 show me:
mysql desc statname;
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
Luis Lebron wrote on 07.11.2003 15:22
Any suggestions of a secure way of storing membership passwords (for a
website) in a mysql database? Should I use sha, aes, des???
thanks,
Hi Luis,
try md5 encryption for passwords in your application and write
md5-encrypted values to simple
Is there any way to force a Repair by sort rather than a (way to slow)
Repair with keycache when doing an ALTER TABLE t ENABLE KEYS?
The table in question is 6GB large and contains 100M rows. I have set
myisam_sort_buffer_size=512MB
myisam_max_sort_file_size=1MB
For some reason, MySQL treats localhost as a special case (at least that
seems to be the behavior. If you run grant list of rights on
database.* to user@'%' identified by 'password'; will allow login from
anywhere but the localhost. That account must be created seperately.
Curtis
John
Hi all,
I'm using mysql 4.0.11a and I meet a probleme with mysql_real_query().
It retruns a commands out of sync , but my queries are well-ordered.
I found another query command called mysql_send_query().
If I use it, the queries success. But I can't find the difference between
mysql_send_query
Hello,
I just took over a site from a client, he used an Access DB, the Database
contains mostly french text...
I've created a dump file to transfer the DB to MySQL, but when I execute the
code, the é characters are lost.
They're being created as VARCHAR..
I'm not a very experienced MySQL
At 06:29 AM 11/7/2003, you wrote:
HiY'll
I've been using MYSQL for a couple of years now. And can write some
pretty complex WHERE statements. I've become aware that's really only
tip of the iceberg stuff.
Can readers suggest a gentle path to moving onto JOINS and a more
fundamental understanding
I'm a system administrator for a small (200 people) branch of a large
university/medical school. I've worked with MySQL and use it as my database of choice
for web-based dynamic content. I would not consider myself an experienced,
professionally-trained, knowledgeable database administrator,
Paul,
TINYBLOB does seem to hold the value properly.
I can't use a TINYBLOB in a primary key. Is this not allowed?
The ALTER statement complains that I am using a column without a length
specified.
Herb
On Thu, 2003-11-06 at 19:24, Paul DuBois wrote:
At 15:29 -0800 11/6/03, Herb Rubin wrote:
I've searched around on the lists archives and even did some googling, but I'm
having trouble finding the answer to this question.
Given that I have a table with 2 columns (say col1, col2) I want to be able to
search for the value of col1 in the value of col2. Let's say that in one
instance
Hi
I'm attempting to use your mysql control center v. 0.9.3 beta. I want to
load information into a database from a file, but am having problems. Why
don't you have any HELP contents?
Thanks,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
A little explaination:
We've got two servers, e450 (3.23.47) and 1U (4.0.14). These two
machines have a private connection between them (192.168.0.1 and
192.168.0.2).
The e450 is the master server, and the 1U has a copy (no replication)
of some basic data, so it can run server-intensive pages.
Hi Kevin,
I'm a system administrator for a small (200 people) branch of a large
university/medical school. I've worked with MySQL and use it as my database
of choice for web-based dynamic content. I would not consider myself an
experienced, professionally-trained, knowledgeable database
Are the é being replaced by another character?
-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 10:05 AM
To: 1Mysql
Subject: Loosing é characters in DB insertion
Hello,
I just took over a site from a client, he used an Access DB, the
Martijn, thank you very much for your analysis. I hope others will continue to join in.
With regard to your point quoted below, are you referring to PostgreSQL, and would
that be a
stronger competitor to MS SQL Server 2000 than either the current version of MySQL or
MySQL 5?
Thanks, again, for
The è caracter is being changed to a square...
Yves
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: 7 novembre 2003 13:19
To: 'Yves Arsenault'; 1Mysql
Subject: RE: Loosing é characters in DB insertion
Are the é being replaced by another character?
Is anything being logged in the error log?
-Original Message-
From: Eric Anderson [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 11:16 AM
To: [EMAIL PROTECTED]
Subject: Very strange problem
A little explaination:
We've got two servers, e450 (3.23.47) and 1U (4.0.14). These
What operating system does the MySQL server reside? The ASCII representation
for é is 233. Is this the same value for the host machine?
-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 11:27 AM
To: Victor Pendleton; 1Mysql
Subject: RE:
Chris,
You're almost there!
select * from temp where col2 like concat('%',col1, '%');
Andy
-Original Message-
From: Chris A. Mattingly [mailto:[EMAIL PROTECTED]
Sent: 07 November 2003 17:01
To: [EMAIL PROTECTED]
Subject: MySQL query question
I've searched around on the lists
Is anything being logged in the error log?
Nope.
My 'wait_timeout' was set to 120 seconds, I reduced that down to 60
seconds but I don't think that will help because once it gets stuck in
this blocked thread thing, it never recovers.. any subsequent
connections never actually process, until the
Hey folks -
I have an installation of mysql 3.23 from debian stable, installed with apt-get.
I'm trying to create users but I'm running into problems. I'm using phpmyadmin, and
myabe that's the problem, I don't know. Here's something that confuses me:
$ mysql -uanna -p
Enter password:
Welcome
Red Hat 9.
Looking at the data through Webmin, it appears as though the text is correct
in the DB in certain fields, in some others, there are strange characters...
I think the clients db may have had slight errors...
In any effect, the web interface that is run off this DB doesn't display the
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will continue to join in.
So do I :-)
With regard to your point quoted below, are you referring to PostgreSQL,
and would that be a
stronger competitor to MS SQL Server 2000 than either the current version
of MySQL or
The Red Hat client does not display the 233 the same as the MS client. The
underlying data should be the same. Try to dump the decimal values of the
data in question and see if 233 is present where it is supposed to be.
-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]
On Friday, November 7, 2003, at 09:05 AM, David Steinbrunner wrote:
The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The
Linux machine was a default SuSE 8.0 installation. ext2 as the
filesystem? No idea about journaling. No SCSI or RAID, just an
internal IDE disk. Both machines
query your use table and see if the anonymous user is still present. You
will need to delete this account and flush privileges.
-Original Message-
From: Steven Lefevre [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 11:33 AM
To: [EMAIL PROTECTED]
Subject: Stupid permission
Hi List,
I've searched the archives and the web many times in the past for answers to the
following
questions but never really got a complete understanding of what is going on. Hopefully
someone on
the list will be able to take the time to set me straight.
I have a typical php + mysql + linux
On Friday, November 7, 2003, at 03:06 AM, Jan Pieter Kunst wrote:
Hardware: 1.8 GHz G5 with 1GB RAM
Panther (Mac OS X 10.3) doesn't have the sudden slowness in the
'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther
is faster than total time for Jaguar (5561.00 secs vs.
I have the following two tables:
salesinvoiceslysalesinvoices
salesrepidsalesrepid
invamt lyinvamt
I am trying to get a current year and last year sum for each sales rep. The problem
is it looks like it is resuming each file for each
I have not work with it but postgres is supposed to work great in
/BSD/Linux/Unix/solaris environment
Which platform are you using?
:-)
Nestor A. Florez
Martijn Tonies [EMAIL PROTECTED] 11/7/2003 10:08:53 AM
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will
We've been using PHP 4.3.x and MySQL 4.0.x for a few months now on our
production systems and had encountered only one problem unrelated to
PHP (an issue where LOAD DATA FROM MASTER would wipe out all of the
tables in the database, even if it was just using wildcard replication
for a few
Paul DuBois said:
At 15:29 -0800 11/6/03, Herb Rubin wrote:
Paul,
I did try VARCHAR(16) BINARY and it still failed to INSERT in a NOT
NULL column.
The encrypted string seems to be equivalent to the NULL value even
though it visually looks like some kind of data.
Herb
Okay, I investigated
SQL
mysql
Hi, All.
Other question is:
Can I create case sensitive field with right ordering of national
characters.
HI, All!
I have a question.
I migrate from 4.0.14 to 4.1.0 but:
the 4.0.14 show me:
mysql desc statname;
It sounds like a copy and paste from Microsoft, but that is just my
guess. An objective recommendation with show pluses and minuses of
both. It most definitely does not sound like this consultant is
qualified to suggest a database product. What about PostgresSQL,
Oracle, Sybase, DB2? They all
Nestor, thanks for your question.
The platform will actually be dictated by the SQL engine, not the
other way around, which is more typically the case. If we go with
MS SQL Server, we'll build a separate host, NT I would guess, to
host it. I'm only responsible for Unix and Linux boxes here, so
What about MySQL-max/SAPDB? I believe that it was completely omitted in the
consultants report but has many of the features you need.
I would also like to ask a question; do you need stored procedures, triggers or views
for your application? There are a number of high volume, high quality sites
The only language I installed on this box is English... would that be why?
Yves
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: 7 novembre 2003 14:16
To: 'Yves Arsenault'; Victor Pendleton; 1Mysql
Subject: RE: Loosing é characters in DB insertion
The Red Hat
kevin,
i tend to think the consultant really just read something that microsoft
sent him. it doesn't sound like he's qualified to suggest one database
or another.
We've been usinf mysql for a year now. We use InnoDB tables, which give
us primary key/foreign key constraints and transactions.
Hello,
I am having trouble finding a way to tell if a result set field I am looking
at is from a TEXT column or BLOB column since the C API lumps both types
together under FIELD_TYPE_BLOB.
Does anyone have any advice on a method to distinguish between these two
types?
Thanks!
Dave
[Second try, the first one rendered a few hints that didn't help]
I've set up a new MySQL server on a box with multiple IP addresses, and the
SQL server only binds to ONE of these addresses.
Also, I've been changing some user rights in the SQL setup, and now I get a
cronjob error, related to
On Friday, November 7, 2003, at 01:21 PM, Hugh Beaumont wrote:
Hi List,
I've searched the archives and the web many times in the past for
answers to the following
questions but never really got a complete understanding of what is
going on. Hopefully someone on
the list will be able to take
Hello Anders,
NOTE: I am actually using SuSE 8.2 Pro Edition. However, those CRON jobs seem
to be at the same place irrelevant of the distro (RedHat or SuSE).
Therefore, I doubt that SuSE Linux Standard Server 8 has changed that.
If the problem occurs once a day then it is within the script
Are there any help files for MySQL Control Center at this time?
Dennis H. Strickland
SatisFacts Research, LLC
2360 W. Joppa Road., Joppa Concourse Building
Suite 322
Lutherville, MD 21093
Toll Free: 866.655.1490 ext. 103
Fax: 866.655.1491
Local: 410.583.9080
Hello Anders,
Sorry, I did not go through the end of your message.
You also have a problem with psql which is, I think, the equivalent of mysql
for PostgreSQL.
Do you need PostgreSQL? If not, you should deactivate it.
For your problem with mysqladmin, most probably specifying the switch
Hello, World.
I successfully built a 64bit MySQL for SuSE Enterprise Linux Server 8
(SLES8) for Linux on POWER.
The SLES8 gcc implememtation has two separate toolchains for 32 and 64
bit. However, RHEL3 has a biarch gcc implementation, where the -m64 flag
is used to tell the compiler/linker
Paul,
Is there a limitation on having a TINYBLOB as a primary key?
Herb
On Thu, 2003-11-06 at 19:24, Paul DuBois wrote:
At 15:29 -0800 11/6/03, Herb Rubin wrote:
Paul,
I did try VARCHAR(16) BINARY and it still failed to INSERT in a NOT NULL
column.
The encrypted string seems to be
Hi
Using mysql 3.23.54
I'm trying to join three tables.
categories, topics, posts.
I just want the categories to print out, with the number of topics in each
category, and the number of posts in each topic.
ex output:
Category | Topics | Posts
Cat One | 3
[EMAIL PROTECTED] wrote:
You can use addslashes and stripslashes when inserting and selecting
respectively. addslashes will turn your name into O\'connel. and
stripslashes will bring it back to the displayable format.
check out
php.net/addslashes
php.net/stripslashes
An alternative is to use
Sorry for the slow reply. I was battling SCSI controller bugs as well
as database issues. I have given up on the software raid for now
because it is unstable.
Back to the subject at hand: performance.
You are right, the load is meaningless outside the context of a
specific machine...and
how to rename a field name IN to something else..
I could not use
alter table tbl_name change IN NEW mediumtext;
Pl. suggest how to rename particular field name for all the tables in
a database
thanks
M.Karthikeyan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
At 13:21 -0500 07-11-2003, Gabriel Ricard wrote:
[1.8 GHz G5:]
select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys +
0.00 cusr 0.00 csys = 92.68 CPU)
[dual 2.0 GHz G5:]
select: Total time: 146 wallclock secs (42.52 usr 33.74 sys + 0.00
cusr 0.00 csys = 76.26 CPU)
How the select
On Fri, Nov 07, 2003 at 05:03:43PM -0600, William Baker wrote:
Sorry for the slow reply. I was battling SCSI controller bugs as well
as database issues. I have given up on the software raid for now
because it is unstable.
Really? I've run Linux software RAID quite happily on several
On Fri, Nov 07, 2003 at 09:16:03AM -0800, Eric Anderson wrote:
A little explaination:
[snip]
The threads connecting from the 1U (192.168.0.2) all start to block up
as expected, but when the length query on the e450 stops running, the
threads from the 1U stay blocked, and all NEW threads
On Fri, Nov 07, 2003 at 02:00:39PM +0100, Eric Jain wrote:
From http://www.mysql.com/doc/en/News-4.0.13.html: Added multi-threaded
MyISAM repair optimisation and myisam_repair_threads variable to enable
it.
The variable is also documented in
http://www.mysql.com/doc/en/SHOW_VARIABLES.html:
Dear Lists MySQL,
I have just released the site www.DhakaStockExhcnageGame.com which uses
MySQL database and CGICC heavily.
I Like MySQL, cuz, I can twist,turn,roll and whatever I want with its
MySQL C API.
Thank you MySQL, you all are really good. Dont become sooo commercial.
Aftab Jahan
On Thu, Nov 06, 2003 at 01:02:31PM -0800, Mike Brando wrote:
-Original Message-
On Thu, Nov 06, 2003 at 09:59:41AM -0800, Wan, Wenhua wrote:
Hi there,
Both Oracle and Informix use ROWID to uniquely represent the location of
each row of data in a table. ROWID is basically
On Fri, Nov 07, 2003 at 07:59:36AM -0600, Luis Lebron wrote:
Anything that breaks a script (unsupported functions, changes, etc.) or that
causes performance problems.
I'm still not sure what you're looking for. A list of known bugs,
maybe?
It's trivial to do something in MySQL that breaks a
Hi,
Yes, that's what I was gonna say. It's not in 4.1.0 because it was
released *before* 4.0.13.
Matt
- Original Message -
From: Jeremy Zawodny
Sent: Friday, November 07, 2003 6:45 PM
Subject: Re: Can't set myisam_repair_threads
On Fri, Nov 07, 2003 at 02:00:39PM +0100, Eric Jain
I've recently gotten an AMD Opteron 64-bit machine for MySQL testing and
eventual deployment. I have a web server with MySQL and 48 databases of roughly
36GB total, stored as INNODB. The current server is a dual Xeon 2.8Ghz machine
with 4GB RAM. Since it's 32-bit about 1.2GB is the highest I can
I can't figure out if this is actually challenging or if it's a stupid
question. Table1 is a normal old relation that describes a bunch of objects:
Table1 (id INT PRIMARY KEY NOT NULL, Name varchar(255), Size int) etc.
Associated with each Table1 record is a variable-length of 3-byte
alphanumeric
I could have sworn I posted this once before, but apparently it got lost somewhere.
Apologies if you're seeing this twice:
I'm wondering what I can do with MySQL to optimize reads (SELECTs) on a read-only
table where data will never be INSERTed or UPDATEd. Okay, that's not entirely
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Luis, et al --
...and then Luis Lebron said...
%
% Any suggestions of a secure way of storing membership passwords (for a
% website) in a mysql database? Should I use sha, aes, des???
Do you really need to be able to decrypt and get the plaintext
But it I want all records from Table1 that have features 'A01' _and_ 'B02',
clearly
SELECT * from Table1 JOIN Features USING(id) WHERE
Features.FeatureCode='A01' AND Features.FeatureCode='B02' doesn't work.
okay maybe this one is a more stupid and complex solution :)
but i think it should work
SELECT forum_categories.id AS `id` , forum_categories.name AS `name` ,
forum_categories.createdby AS `createdby` ,
forum_categories.order AS `order` ,DATE_FORMAT( forum_categories.created,%m/%d/%y
%l:%i %p ) AS `created` ,
COUNT( forum_topics.id ) AS `topics`, SUM(forum_posts.id) AS
Hi all,
I have a project in hand, where I need to accept and show data in Hindi language,
storage doesn't matter. Is that possible with MySQL, if yes, what do I need to
configure? How do I do it, any help or ideas?
Regards
Nitin
i think you should have a sales person table
that hold unique id for each sales force
such as
salesrep (id,etc..)
| 101 | ... |
| 102 | ... |
so you can alter the query into
select
salesrep.id,
sum(ifnull(salesinvoices.invamt,0)) as curramt,
sum(ifnull(lysalesinvoices.lyinvamt,0)) as lyamt
Right, you should really use a 1-way hashing algorithm like SHA1. If the
user forget's their password, require them to change it.. which is good
practice anyways, since someone else might have found it for them!
The general idea with 1-way hashing algorithms is that you compare the
result of
I am using PHP/MySQL and am having a problem. We have some names and
addresses in the database that have single quotes in them. For
instance. There is a town around here called Lee's Summit. Also names
like O'connel. When I pull from the database it skips these because of
the quotes. I
You can use addslashes and stripslashes when inserting and selecting
respectively. addslashes will turn your name into O\'connel. and
stripslashes will bring it back to the displayable format.
check out
php.net/addslashes
php.net/stripslashes
hth
Jeff
88 matches
Mail list logo