Good Morning Community!
I have a problem with 4.1.3 that I not had with 4.0.20.
Here is my table:
CREATE TABLE url_cat_copy (
id int(11) NOT NULL auto_increment,
url varchar(100) default NULL,
domain varchar(100) default NULL,
bytes bigint(20) default NULL,
hits bigint(20) default
We have MySQL and MySQL-MAX on a RH8 release. The server specs is as follows:
Dual Xeon CPU 2.8GHz
2G DDR Memory
215GB HDD storage SCSI U160 HDD
When a report (large one) runs I've noticed the following through tops.
mysqld-max = 97.2 - 99.9 %CPU with 1.2% memory usage
In the top of tops I've
try this query
SELECT
bytes,
bytes_priv,
bytes_bus,
hits,
hits_priv,
hits_bus,
bytes - ( bytes_priv + bytes_bus ),
hits - (hits_priv + hits_bus)
FROM url_cat_copy
WHERE
(bytesround(bytes_priv+bytes_bus,0))
or
(hitsround(hits_priv + hits_bus,0))
i think its got something to do with the decimal
I have a questions about varchar columns change to CHAR columns
automatically.
See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html
In addition to that - it doesn't really matter as the CHAR datatype
isn't properly implemented in MySQL and behaves the same as
the
Hello, Is there someway to specify which domain one would like to connect
from in the mysql console. When connecting on my server I always get
connected through localhost. I would like to connect through my DNS name.
quasi example : mysql -u [EMAIL PROTECTED] -p
regards
/Jonas
--
MySQL
maybe u can try:
mysql -u [EMAIL PROTECTED] -p -h dnsbasedhostname
--- Jonas Ladenfors [EMAIL PROTECTED]
wrote:
Hello, Is there someway to specify which domain
one would like to connect
from in the mysql console. When connecting on my
server I always get
connected through localhost. I
Hello,
today one of our caching nameservers failed. Although a second
nameserver was listed in /etc/resolf.conf and mysqld was started with
--skip-name-resolv, mysql struggled and took very long to accept new
connections. It's obvious, that mysql is doing reverse-dns lookups
against what
Jesse,
mysql SHOW INDEX FROM mytable;
gives you all indexes for `mytable`; you can process the results with
perl.
Thomas Spahni
On Mon, 23 Aug 2004, Jesse Sheidlower wrote:
I have a database where, most of the time, I'm bulk-loading
data into new tables from an external source, several
Hi,
Here i am again. I can select particular record by using
LIMIT 9,1
But e.g. if i want to delete this record then how shall i do ? I tried to use
Delete from table name Limit 9, 1
But i am getting erorr. pls can anybody let me know the exact syntax for this ?
regards
Manisha
On Monday 23 August 2004 11:08, Manisha Sathe might have typed:
Hi,
Here i am again. I can select particular record by using
LIMIT 9,1
But e.g. if i want to delete this record then how shall i do ? I tried to
use
Delete from table name Limit 9, 1
Said record is probably keyed in some
Manisha Sathe [EMAIL PROTECTED] wrote on 23/08/2004 11:08:10:
Here i am again. I can select particular record by using
LIMIT 9,1
But e.g. if i want to delete this record then how shall i do ? I
tried to use
Delete from table name Limit 9, 1
But i am getting erorr. pls can
if you dont want to add an auto-increment column,
you can probably specify ALL columns and their
values in WHERE clause and end with LIMIT 1.
eg:
DELETE FROM Table WHERE Column1=Value1 AND
Column2=Value2 ... LIMIT 1
--- Manisha Sathe [EMAIL PROTECTED] wrote:
Hi,
Here i am again. I can
An existing database table structures has changed, I
want to create the same database with new table
structures. I do not want to lose any data.
How can I do this? do a backup how?
regards
___ALL-NEW
select name
from mytable a
where changedate
(select changedate
from mytable b
where a.name=b.name
and a.changedate != b.changedate);
or:
select name
from mytable a
where exists
(select * from mytable b
I believe the syntax is
Delete from MyTable Where MyCriteria LIMIT HowMany.
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
-Original Message-
From: Manisha Sathe [mailto:[EMAIL PROTECTED]
Sent:
Hi there,
after a system-crash I got the following problem.
Some seconds after starting mysql (v4.0.20) a process will stay
there taking all cpu-time it can get (99.9% ;)) ... and it can't be
terminated,
just killed completely.
mysqlcheck ran through without any problems, the logs tell nothing.
I
Dear Friends,
We want to use MySQL compiled with Intel Compiler to get superior
performance. Our server is a rack mounted HP DL 380 server with
Redhat Enterprise Linux Advanced Server 3.0.
We have used mysql-standard-4.1.3-beta-pc-linux-i686-icc.tar.gz. But
we are getting the following
On Tue, 24 Aug 2004 11:57:42 +0100, A Z wrote:
An existing database table structures has changed, I
want to create the same database with new table
structures. I do not want to lose any data.
How can I do this? do a backup how?
Sure.. There are several ways to accomplish this.
1.
Do you have anything in the show processlist? Are you using innodb table
types and a rollback is occurring?
-Original Message-
From: Thomas - Lists
To: [EMAIL PROTECTED]
Sent: 8/24/04 6:49 AM
Subject: runaway process eating all cpu-time?
Hi there,
after a system-crash I got the
Hi Victor,
thanks for your reply.
Victor Pendleton wrote:
Do you have anything in the show processlist? Are you using innodb table
types and a rollback is occurring?
mysql show processlist;
Hello.
My company is using mysql as a backed to Bugzilla.
However, recently, as the number of users that are logging bugs increased we
are experiencing frequent table corruption and loss of data.
The actual error message we get is:
SELECT query FROM namedqueries WHERE userid = 4 AND
I'm learning SQL from Access program.
Since each category vary in how they are monitored:
-Tracked by hours only
-Tracked by qty, hours and qty/hours.
-Tracked by pages, orders, hours, pages/hours and orders/hours.
I'm trying to figure out a way to select mrcategories.id during SELECTION
Can't change to run as user 'mysql' ; Please check that the user exists!
man useradd
_
Steve Poirier
-Original Message-
From: Santhanam [mailto:[EMAIL PROTECTED]
Sent: August 24, 2004 8:02 AM
To: [EMAIL PROTECTED]
Subject: MySQL with Intel Compiler
Sorry, didn't see you already had a mysql user.
David has a better english than mine:
It looks like your MySQL server process is hitting a problem when
it tries to change its user id to that of the user 'mysql'.
There are two possible reasons for this:
1. You're starting the server process as
No, there is no option to control the client's apparent hostname.
Considering that restricting the allowable connecting hosts is part of
mysql's access control mechanism, this makes sense.
Whether your client hostname is localhost or a domain name/ip address is
controlled by your connection
Howdy all,
Quick question about foreign keys. If I have a
database with foreign keys setup, then drop one of the
tables (which is referenced by many of the others) and
re-add the table, will the existing FKs work?
I'm seeing errors in SHOW INNODB STATUS under the
LATEST FOREIGN KEY ERRORS
Hello,
Can someone advise me of the best/easiest way to move an entire DB (Tables
and data) from sql2000 (my client) to mySQL (my System)?
I need to advise someone on how I wish the data sent to me.
Any help would be appreciated.
Thanks,
Tim
--
MySQL General Mailing List
For list archives:
I'm trying to move my binary log files onto a different drive than our main data drive
to get a little performance boost.
the drives are set up like so:
drive 1 (sda):
swap
/boot
/usr
drive 2 (sdb):
/
mysql is installed in /usr/local/mysql and its data directory is /usr/local/mysql/var
I
Are you wanting to move Foreign keys, Triggers, Stored procedures and the
like as well or just the data?
-Original Message-
From: Tim Winters
To: [EMAIL PROTECTED]
Sent: 8/24/04 10:36 AM
Subject: sql2000 to mysql
Hello,
Can someone advise me of the best/easiest way to move an entire DB
At 11:27 -0400 8/24/04, Michael Stassen wrote:
No, there is no option to control the client's apparent hostname.
Considering that restricting the allowable connecting hosts is part
of mysql's access control mechanism, this makes sense.
Whether your client hostname is localhost or a domain
I converted the only innodb-table to myisam so the innodb-engine is no
longer used.
The problem has vanished since then.
Pity that there seems to be no simple way to diagnose the problem in innodb.
check table has showed no problems. Seems like I have to stay away from
innodb for the time
being
Hi!
On Aug 24, Santhanam wrote:
Dear Friends,
We want to use MySQL compiled with Intel Compiler to get superior
performance. Our server is a rack mounted HP DL 380 server with
Redhat Enterprise Linux Advanced Server 3.0.
We have used
I need to connect to a remote MySQL database from a PC using SSL. I would
prefer to connect using perl DBD. Does anyone have a suggestion how I can
accomplish this task or an alternative solution?
Thank You
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi,
I have a quick question, which I did not find answerd by the manual:
Given this sample query:
SELECT COUNT(ID)
FROM mytable
WHERE property=value
FOR UPDATE
Which rows in 'mytable' are locked after this query?
Every row with property=value, because these rows were used to calculate
COUNT(ID).
Does anyone know whether it is possible to override the MySQL connection
variables used in a PHP script? I use Plesk and want it to use a
database that is located on an external server, but I cannot edit the
variables as Plesk is closed source?
Joel Moss
HomepageUniverse.com
--
MySQL General
I know the major differences between Innodb and MyIsam.
-table locking versus row locks
-foreign key support
I know there are more but those are the ones that stick out in mind.
I think Innodb requires a bit more storage space but I could be wrong.
In some cases foreign key support would be a
Victor Pendleton wrote:
Are you wanting to move Foreign keys, Triggers, Stored procedures and the
like as well or just the data?
definitely!!
so you make relations in your codes for projects...
If not use Triggers, not use Stored procedures then, You move database,
table and data with a small
InnoDb doesn't support full text indexes on text columns so if you need to search text
fields you may want ot use MyISAM. It is perfectly ok to have a mixture of InnoDB and
MyISAM in a single database so you can make your decision on a table by table basis.
Joe
Stuart Felenstein [EMAIL
Hi Victor,
Just Tables and Data.
Ideally scripted to create the tables and insert the data. will sql2000
product something similer to a .sql file which can simple be run as a script?
Thx
At 12:45 PM 24/08/2004, Victor Pendleton wrote:
Are you wanting to move Foreign keys, Triggers, Stored
I need to connect to a remote MySQL database from a PC using
SSL. I would
prefer to connect using perl DBD. Does anyone have a
suggestion how I can
accomplish this task or an alternative solution?
What about stunnel or ssh tunnels and then use DBD::mysql on top.
ISTR that DBD::mysql
I know the major differences between Innodb and MyIsam.
-table locking versus row locks
-foreign key support
I know there are more but those are the ones that stick out in mind.
Well, how about transaction support?
I think Innodb requires a bit more storage space but I could be wrong.
You can try SQLyog's ODBC Import feature. SQLyog can
be found at http://www.webyog.com
Regards
Karam
--- Tim Winters [EMAIL PROTECTED] wrote:
Hi Victor,
Just Tables and Data.
Ideally scripted to create the tables and insert the
data. will sql2000
product something similer to a .sql
Hi,
We have recently upgraded to MySQL 4.0 (binary) from 3.23.50, and we
are seeing *all* MySQL queries freeze up every morning for about 25
seconds. I don't believe this is the standard run-of-the-mill MyISAM
locking problem people tend to run into, as queries in separate
databases
Right, I have set up some tables with text columns that will need full text searching,
In those cases I chose myisam.
Is there any danger in changing table types on the fly ? Not including the loss of any
foreign keys that may have been set up (innodb to myisam). I'm wondering more about
data
Any thoughts? What kind of internal locks might be generated? Is there
another command I can run to get the status of those queries that are
hanging? It shows 'None' for the state (NULL), I've never seen a
Aha.. So I had a brainstorm while driving to lunch. Is it possible
this is
MySQL Administrator 1.0.10 has been released and is available for
download. This is the second generally available and stable release
and contains bugs fixed since the previous public release.
MySQL Administrator is a GUI management console for MySQL, with support
for tasks such as managing
In the last episode (Aug 24), Stuart Felenstein said:
Right, I have set up some tables with text columns that will need
full text searching, In those cases I chose myisam. Is there any
danger in changing table types on the fly ? Not including the loss of
any foreign keys that may have been
If you have DTS you can export the data to a CSV format. If you have MyODBC
installed you could export directly to MySQL.
-Original Message-
From: Tim Winters
To: Victor Pendleton; '[EMAIL PROTECTED] '
Sent: 8/24/04 11:34 AM
Subject: RE: sql2000 to mysql
Hi Victor,
Just Tables and Data.
I have checked the TODO list and cannot find any mention of an automatic
failover feature. In Jeremy's High Performance MySQL book, he makes mention
of it being some sort of a plan for the future. Also, in a section of the
manual centered on replication, there is also mention of it. I also
I'm wondering if there is a better way to select the
values of a ENUM field. I have a ENUM field called
greeting that has 'Mr.','Mrs.','Ms.','Dr.' in it. I
need to put these in a HTML select.
Right now I'm doing a SHOW COLUMNS FROM global_lead
LIKE 'greeting' and then parsing out the response for
I am selecting two columns each of type DateTime from a mysql table from
perl.
my $sth = $dbh-prepare(SELECT End_Date_Scheduled, End_Date_Actual FROM
Table1 WHERE ID='10' );
$sth-execute();
while (my $ref = $sth-fetchrow_hashref()) {
printFound: end date scheduled =
At 11:51 -0700 8/24/04, Michael Pawlowsky wrote:
I'm wondering if there is a better way to select the
values of a ENUM field. I have a ENUM field called
greeting that has 'Mr.','Mrs.','Ms.','Dr.' in it. I
need to put these in a HTML select.
Right now I'm doing a SHOW COLUMNS FROM global_lead
LIKE
Hi, all:
I use root login to create a new databse in the existing server.
Then I use the existing user name in the mysql user table as user name,
add the database and username .. info into mysql db table. Then
mysqladmin to load the table. When I login the database using the
existing user
How fast is this query?
SELECT id
FROM msg_body
WHERE MATCH(body) AGAINST( 'WORD')
If it's fast , you may have to re-state your query so that you are not FT
searching and joining tables in the same statement. The optimizer can only
use 1 index at a time from any table. We may be running into
I still see what you want as a crosstab query. The only difference, as you
say very well, is that you want to pivot on the date type values and not
the ID values.
The only other thing you need to decide in order to make a crosstab report
is what information goes in the position for the row
C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote:
I have a table that has a PartNumber and the Quantity of Items sold for
each partNumber, that is:
PartNumber
Qty
I need to get its sales raking given its PartNumber, that is. So if I
order the table by Qyt in descending order the first
record
We've seen this problem too. In our case we definitely had a mysql
user, and the mysql user definitely existed. From one prompt we could
start the gcc-compiled MySQL correctly, but not the Intel-compiled
MYSQL.
We were able to fix the problem by setting LD_LIBRARY_PATH=/lib.
-JF
I found the solution to my own problem...
the log-bin option is a specific filename. so when you set:
log-bin=/logging
mysql must have ownership of the / folder, as it is trying to create /logging.001 and
/logging.index
easily fixed by adding the file-name to the path...
Trying to figure out how this gets done. Let me
explain first. By the way I hope this is not off topic
as perhaps it is more towards application then core db
.
I have a table:
Count[int][auto-increment], MemberID[int],
Title[varchar], TitleYear[int]
In my organization members can have or have
Anyone else getting a MYSQL [FAILED]
when it starts up with Fedora Core 2.
The funny part is that it is started and accepting connections.
It's just the message comming back as failed either at boot up or when
doing a /etc/init.d/mysqld start
Regards,
Mike
--
MySQL General Mailing List
For
Jon Miller wrote:
We have MySQL and MySQL-MAX on a RH8 release. The server specs is as follows:
Dual Xeon CPU 2.8GHz
2G DDR Memory
215GB HDD storage SCSI U160 HDD
When a report (large one) runs I've noticed the following through tops.
mysqld-max = 97.2 - 99.9 %CPU with 1.2% memory usage
In the
I don't know if it is a bug, but I repeated did:
DROP TABLE IF NOT EXISTS company;
Create table company {
...
...
};
create name_idx on company (name(32));
The server hangs at create name_idxthe first couple of them were
really quick.
Any idea?
Thanks a lot!
Haitao
--
MySQL General
Hi,
This is a question about optimization of mysql's InnoDB performance ...
quoting the doc's
The default value is 8. If you have low performance and |SHOW INNODB
STATUS| reveals many threads waiting for semaphores,
you may have thread thrashing and should try setting this parameter
lower or
Hi all,
I though it is impossible to do that but I like check
with you guys in case it is just because I never heard
it.
I have a table with a text column. Is there any way I
can append some word into this field when I update the
table?
For instance,
Table temp, column ReviewComments, data type
Hey Everyone,
I can you some assistance on this query.
I have three tables one is called ranking and the other is called
routes and finally the users table. The users table is not really
important.
The ranking table looks like this:
id rating
1 5.0
2 5.1
3 5.2
4 5.3
65 matches
Mail list logo
