: Problem with CREATE TABLE/DROP TABLE
I'm having the issue with CREATE TABLE described by Bug #30513
(http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously existed, and then is dropped
by DROP TABLE IF EXISTS, becomes randomly unable to be recreated. Here
is my comment
The official table's data.
++---+-+
| id | title | body|
++---+-+
| 1 | MySQL Tutorial| DBMS stands for DataBase ...
Hi,
I have a problem with the migration of a table that has a column with BLOB data.
The source server is MySQL version: 4.0.16 and the destination server is MySQL
version: 5.0.45
I tried with mysqldump and SELECT INTO but when import the data on the destination server, the
BLOB data
Dave schrieb:
Hi all,
I've been trying to optimize some of our queries against a large database
and come up against an index problem I haven't been able to find any
documentation on. I've cut the query down to the bare minimum, and found
the following --
explain Select iname,domain,serv,time
up against an index problem I haven't been able to find any
documentation on. I've cut the query down to the bare minimum, and found
the following --
explain Select iname,domain,serv,time from log where date between
'2008-05-10' and '2008-05-30
Hi all,
I've been trying to optimize some of our queries against a large database
and come up against an index problem I haven't been able to find any
documentation on. I've cut the query down to the bare minimum, and found
the following --
explain Select iname,domain,serv,time from log where
] wrote:
Hi all,
I've been trying to optimize some of our queries against a large database
and come up against an index problem I haven't been able to find any
documentation on. I've cut the query down to the bare minimum, and found
the following --
explain Select iname,domain,serv,time from log
Hello list,
I have a problem dumping a database. The problem is that the database uses the
swedish charset (historical, hosting provider didn't have all sets). The data
itself is Arabic (windows-1256), and although I have no idea how it is stored
inside the database's files, the website's
נור דאוד schrieb:
Hello list,
I have a problem dumping a database. The problem is that the database uses the swedish charset (historical, hosting provider didn't have all sets). The data itself is Arabic (windows-1256), and although I have no idea how it is stored inside the database's files
On May 15, 2008, at 4:30 AM, rustam ershtukaev wrote:
I have been trying to write a trigger in mysql, but can't get it to
work. It's really simple,i just need my trigger to add varchar value
to
a table on insert if postcode = 1000.
Where does postcode come from? Your SELECT statement
|
+-+--+--+
(All other lines are as same as first two.)
Is there an InnoDB expert who can tell me whether this is indicating a
problem?
Regards,
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
That is fine.
On Thu, May 8, 2008 at 4:51 PM, Neil Tompkins [EMAIL PROTECTED]
wrote:
Perfect. It worked just how I wanted.
Thanks for your help.
Neil
Date: Wed, 7 May 2008 19:54:39 +0200 To: [EMAIL PROTECTED]
Subject: Re: Order Problem From: [EMAIL PROTECTED] Hi, You should
look
Hi,
I have installed MySQL on an Opteron 64bit with operating system Scientific Linux CERN SLC release
4.6 (Beryllium)
by an archive TAR, under the directory /opt/local/mysql50.
The problem is that I want to install drivers DBD to use MySQLBenchmark but i
run
perl Makefile.PL --mysql_config
I have been trying to write a trigger in mysql, but can't get it to
work. It's really simple,i just need my trigger to add varchar value to
a table on insert if postcode = 1000.
this is how i did it:
delimiter |
drop trigger testdep|
create trigger testdep
before insert on departements
On Thu, May 15, 2008 at 2:30 AM, rustam ershtukaev [EMAIL PROTECTED] wrote:
I have been trying to write a trigger in mysql, but can't get it to
work. It's really simple,i just need my trigger to add varchar value to
a table on insert if postcode = 1000.
this is how i did it:
delimiter |
Perfect. It worked just how I wanted.
Thanks for your help.
Neil
Date: Wed, 7 May 2008 19:54:39 +0200 To: [EMAIL PROTECTED] Subject: Re:
Order Problem From: [EMAIL PROTECTED] Hi, You should look at the
`FIND_IN_SET` function here:
http://dev.mysql.com/doc/refman/5.0/en/string
Hi All,
I've the following query :SELECT ProductID FROM Products WHERE Enabled= ' Yes'
AND ProductID IN(varProductID)
This query works fine. However the query result is in a different order to
what I passed in varProductID.
How can I order the results based on my list like
I am trying to display results from one or the other part of the
query, however, at the moment it is showing results from both parts.
The Replace part of the query works fine in that it chooses the
correct data to display, but the content relevant to /8/ always
displays even when I select,
Hi Sulo,
Open the file you are importing as it is probably that it contains
references of another character set in the table creation. If so replace
that character set for '' or 'utf8'.
I hope it helps,
Leandro
sulochan acharya wrote:
Hello all,
here is my problem:
I am trying to set
is CP-1252. I couldn't get that to work, either.
I don't know how it would apply directly to your situation, but I think you
are running into a similar kind of problem. I also can't guarantee that my
conclusions were entirely correct.
Perhaps someone else can add to this.
Regards,
Jerry Schwartz
On Mon, 28 Apr 2008, Jerry Schwartz [EMAIL PROTECTED] wrote:
A week or so ago I explored this in depth because I was having the
same problems. (It was affecting an English file that had some
Windows (CP-1252) characters that didn't directly map to UTF-8. That
message is at
Well, if latin1 is not CP-1252, then that explains why it didn't fix my
problem; but here's what 5.0.45-community-nt says:
mysql show character set;
+--+-+-++
| Charset | Description | Default collation | Maxlen
Hello all,
here is my problem:
I am trying to set mysql to unicode character, so that i can get my
dictionary application to look at words in Nepali.
here is my setting:
mysql charset: utf-8 unicode
when i make a new database:
mysql connection collation is utf8-general-ci
and my new database
liaojian_163 schrieb:
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql select id,classid,newstime from phome_ecms_zhichang where classid=41
and id 2500 order by id desc limit 10;
+--+-+-+
| id | classid
, 2008 2:11 PM
Subject: Re: a strange problem
liaojian_163 schrieb:
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql select id,classid,newstime from phome_ecms_zhichang where classid=41
and id 2500 order by id desc limit 10
liaojian_163 schrieb:
thank you Sebastian!
I have re-created the table.there are not any problems in the table.
if the table is new,need to rebuild de indexes?
no
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql select id,classid,newstime from phome_ecms_zhichang where classid=41
and id 2500 order by id desc limit 10;
+--+-+-+
| id | classid | newstime
Not knowing your msqyl version, perhaps it's the form of your LIMIT clause.
try LIMIT 0,10 instead.
Phil
2008/4/22 liaojian_163 [EMAIL PROTECTED]:
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql select id,classid,newstime from
I don't think that the limit cause the stange problem.
thank you anyway.
- Original Message -
From: Phil [EMAIL PROTECTED]
To: liaojian_163 [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, April 23, 2008 3:46 AM
Subject: Re: a strange problem
Not knowing your msqyl version
17:34
CC: mysql@lists.mysql.com
Asunto: RE: Performance problem
On Fri, 18 Apr 2008, Francisco Rodrigo Cortinas Maseda
[EMAIL PROTECTED] wrote:
im new on the performance tuning of this database (MySQL 5.0.45,
rpm-based installation), and i have one performance problem on our
new
I`ve resolved my problems without hardware manipulation.
Thanks to all.
-Mensaje original-
De: Francisco Rodrigo Cortinas Maseda
Enviado el: miércoles 16 de abril de 2008 18:57
Para: mysql@lists.mysql.com
Asunto: RV: Performance problem
Hi all,
im new on the performance tuning
On Fri, 18 Apr 2008, Francisco Rodrigo Cortinas Maseda
[EMAIL PROTECTED] wrote:
im new on the performance tuning of this database (MySQL 5.0.45,
rpm-based installation), and i have one performance problem on our
new installation:
...
We are experiencing problems about the performance
Hi all,
Iam having the one table name called AccessDetails and data inside that
tables is following,
DateTime UserName SiteName
ScanType Status Virus_Category
| 2008-04-16 | 13:05:31 | 172.16.1.22 | - | www.veer.com
|C | A
It's possibly a DNS problem (reverse DNS exactly).
You know, I'm feeling a bit stupid here... That was indeed the problem,
as the new server hadn't been moved on DNS yet.
I put the IP address into the windows hosts file on the DB server, and
the problem cleared up immediately.
Thanks!
-Doug
On Wed, Apr 16, 2008 at 4:35 AM, sivasakthi [EMAIL PROTECTED] wrote:
Hi all,
Iam having the one table name called AccessDetails and data inside that
tables is following,
[snip=schema]
In that , I need to calculate the number of total sites , number of
total Accessed Sites,number of
Hi all,
im new on the performance tuning of this database (MySQL 5.0.45, rpm-based
installation), and i have one performance problem on our new installation:
- The radius servers (that are written on perl) we have are writing the auth
and acct log to one mysql database. The conn we have
It's possibly a DNS problem (reverse DNS exactly).
Best regards.
I have a table, eo_name_table, that has exactly 860 unique titles in it.
Each record also has a date field, eo_pub_date:
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
Hi Everyone,
I am attempting to use this command: load data infile '/volumes/raider/
elks.test.txt' into table elksCurrent fields terminated by '\t' lines
terminated by '\n';
My table is created as such:
| elksCurrent | CREATE TABLE `elksCurrent` (
`FName` varchar(40) default NULL,
On Mon, Apr 14, 2008 at 10:29 AM, Jason Pruim [EMAIL PROTECTED] wrote:
Hi Everyone,
I am attempting to use this command: load data infile
'/volumes/raider/elks.test.txt' into table elksCurrent fields terminated by
'\t' lines terminated by '\n';
My table is created as such:
|
On Mon, Apr 14, 2008 at 10:47 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
It is probably trying to insert a string of no length into the not null
field.
Try it with:
SET SQL_MODE = '';
Above should read into an int field, while the server is in strict mode.
--
Rob Wultsch
[EMAIL PROTECTED]
Hi Jerry,
I think the problem is that NULL is not less than or greater than your
prod_published date. So you probably have eo_pub_date set to NULL in 56
of your rows.
so for
eo_name_table.eo_pub_date prod.prod_published
or
eo_name_table.eo_pub_date = prod.prod_published
mysql
From: Bill Newton [mailto:[EMAIL PROTECTED]
Sent: Monday, April 14, 2008 2:09 PM
To: Jerry Schwartz
Cc: 'Mysql'
Subject: Re: LEFT JOIN problem
Hi Jerry,
I think the problem is that NULL is not less than or greater than your
prod_published date. So you probably have eo_pub_date set to NULL in 56
I've found yet another oddity with this situation. If I leave the date test
off of both JOINs they give the same number of rows, but they give me the
wrong number! Neither one of them gives me 860 rows returned. I must not
understand how a LEFT JOIN works.
By the way, the EXPLAIN for both of my
On Apr 14, 2008, at 2:01 PM, Rob Wultsch wrote:
On Mon, Apr 14, 2008 at 10:47 AM, Rob Wultsch [EMAIL PROTECTED]
wrote:
It is probably trying to insert a string of no length into the not
null field.
Try it with:
SET SQL_MODE = '';
Above should read into an int field, while the server is in
Hi again everyone,
After taking the advice of someone offlist I tried the IGNORE 1
LINES and that didn't help... Same result. I've tried a tab delimited
file, and a comma separated file. Same result with both. Any other
ideas? :)
On Apr 14, 2008, at 1:29 PM, Jason Pruim wrote:
Hi
On Mon, Apr 14, 2008 at 1:29 PM, Jason Pruim [EMAIL PROTECTED] wrote:
Hi Everyone,
I am attempting to use this command: load data infile
'/volumes/raider/elks.test.txt' into table elksCurrent fields terminated by
'\t' lines terminated by '\n';
[snip!]
The error that I'm getting is:
|
On Mon, Apr 14, 2008 at 3:33 PM, Jason Pruim [EMAIL PROTECTED] wrote:
On Apr 14, 2008, at 3:29 PM, Daniel Brown wrote:
That's because it's attempting to insert the name of the columns
from your CSV into MySQL --- and 'Record' is not a valid INT.
Replaced field name with 0 and had
.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Monday, April 14, 2008 11:26 AM
To: 'Mysql'
Subject: LEFT JOIN problem
I have a table, eo_name_table
On Apr 14, 2008, at 3:29 PM, Daniel Brown wrote:
On Mon, Apr 14, 2008 at 1:29 PM, Jason Pruim [EMAIL PROTECTED]
wrote:
Hi Everyone,
I am attempting to use this command: load data infile
'/volumes/raider/elks.test.txt' into table elksCurrent fields
terminated by
'\t' lines terminated by
On Mon, Apr 14, 2008 at 3:45 PM, Daniel Brown [EMAIL PROTECTED] wrote:
Does your file actually have the characters \t \t \n at the end of
each row like that?
Send it to me as an attachment off-list and I'll help you figure
it out and then post back here for the MySQL archives.
On Apr 14, 2008, at 4:37 PM, Daniel Brown wrote:
On Mon, Apr 14, 2008 at 3:45 PM, Daniel Brown [EMAIL PROTECTED]
wrote:
Does your file actually have the characters \t \t \n at the end of
each row like that?
Send it to me as an attachment off-list and I'll help you figure
it out and
(although I'm not sure that I'm convinced). We've
ruled out any apache or PHP issues causing a problem, as the
configurations and build options are identical.
Any thoughts of a performance number or configuration option that would
make any differences?
Thanks much in advance - I'm scratching my head
Hi,
I am trying to optimize our DB server. We have one table which has 1.3M
entries, and the keys are GUIDs (so the key space is large). However, I
have it all indexed. The performance was iffy, though, so I increased
memory allocation, and the searches on the indexed fields seem to
Are you using MyIsam or InnoDB? Or something else?
In either case the speed to get a COUNT() is largely down to the speed
if your disks and size of disk caching. A COUNT() forces the system to
read every row in order to count them, and any large table is probably
larger than your caches.
On Fri, April 11, 2008 06:47, Ben Clewett wrote:
Are you using MyIsam or InnoDB? Or something else?
In either case the speed to get a COUNT() is largely down to the speed
if your disks and size of disk caching. A COUNT() forces the system to
read every row in order to count them, and any
Hi,
Can you please post your query? I also need to know your table type as
different settings effect different table types?
You are right that a SELECT COUNT(*) WHERE field = 'value' should hit
the index, but does depend on your query.
You might also try EXPLAIN before your query, which
On Fri, Apr 11, 2008 at 6:47 AM, Ben Clewett [EMAIL PROTECTED] wrote:
A COUNT() forces the system to read every row in order to count them...
That is not strictly the case.
A count(field) can use an index scan rather than a sequential scan,
which may or may not be faster. Also some count(field)
First of all, my bad -- I forgot to mention that I use MyISAM.
mysql show table status from example like 'leads'\G
*** 1. row ***
Name: leads
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows:
Dave M G schrieb:
PHP List, MySQL List
In my PHP environment, I have Magic Quotes turned off, and I use the
mysql_real_escape_string() function clean strings of SQL syntax before
inserting them into my database.
So the data stored in my database does not have escape characters in it.
Richard, Jed,
Thank you for replying.
Richard said:
It's possible that there is an .htaccess file in phpMyAdmin that has
Magic Quotes on that is messing you up...
The .htaccess file for phpMyAdmin says php_flag magic_quotes_gpc Off,
so I guess that means I'm okay there.
Other than that,
It's possible that there is an .htaccess file in phpMyAdmin that has
Magic Quotes on that is messing you up...
Other than that, it's specific to phpMyAdmin, so maybe ask those guys
what they did...
On Sat, March 1, 2008 7:38 pm, Dave M G wrote:
PHP List, MySQL List
In my PHP environment, I
statements, and they have
to be escaped.
I would take phpMyAdmin out of the equation and just use mysqldump. You
should have no problem doing something like creating a scratch table,
dumping it, and re-importing from the dump.
mysql create table B like table A;
mysql insert into table B
PHP List, MySQL List
In my PHP environment, I have Magic Quotes turned off, and I use the
mysql_real_escape_string() function clean strings of SQL syntax before
inserting them into my database.
So the data stored in my database does not have escape characters in it.
Particularly, double and
I get incorrect result when searching for the norwegian character 'å'
using LIKE. I get rows with 'a' in it, and visa versa if I search for
'a', I get results which has 'å' in it in addition to the ones with 'a'.
Make sure that your table has:
charset=utf8
collation=utf8_norwegian_ci
And
('%å%');
which returns correct results, but this disables me from letting the
user do case sensitive searches.
Am I doing something wrong or stupid? Could this be a MySQL bug?
How do I know this isn't a problem with other utf-8 characters in other
languages?
I've searched in bug reports
, any
recommendations are much appericated!
PS: I posted this question on Java section but no replys :(
Ray
--
View this message in context:
http://www.nabble.com/jdbc-connection-pool-problem%2C-help%2C-thanks%21-tp15673813p15673813.html
Sent from the MySQL - General mailing list archive
I have the following table:
--
-- Table structure for table 'media'
--
CREATE TABLE media (
id int(10) unsigned NOT NULL auto_increment,
user_id int(10) unsigned default NULL,
title varchar(255) NOT NULL,
description text NOT NULL,
`hash` varchar(255) NOT NULL,
length float(9,2) NOT
Hi,
On Wed, Feb 20, 2008 at 7:23 PM, Tanner Postert
[EMAIL PROTECTED] wrote:
I have the following table:
--
-- Table structure for table 'media'
--
CREATE TABLE media (
id int(10) unsigned NOT NULL auto_increment,
user_id int(10) unsigned default NULL,
title varchar(255) NOT
Hello everyone!
Hopefully somone can enlight me, i am hanging on this vor a few hours now :/
i have this stored procedure:
CREATE PROCEDURE additems ()
BEGIN
DECLARE grammatures VARCHAR(128) DEFAULT '7,12,1,13,2,5,14,21';
DECLARE newids VARCHAR(128);
SELECT
:[EMAIL PROTECTED]
Sent: Friday, February 15, 2008 5:28 AM
To: mysql@lists.mysql.com
Subject: Stored Procedure problem
Hello everyone!
Hopefully somone can enlight me, i am hanging on this vor a few hours now :/
i have this stored procedure:
CREATE PROCEDURE additems ()
BEGIN
DECLARE
`,
`Profiles`.`Status`,
`Profiles`.`ID` as pID
FROM `Messages`
LEFT JOIN Profiles ON Messages.Sender = Profiles.ID
WHERE Recipient = 5 ORDER BY `Date` DESC;
The problem is that the ORDER BY `Date` DESC is generating random
results?
If I run this same script interactively in an sql window
Hello mysql list,
As is very often the case, five minutes after I posted this, I found
the problem or solution, not sure it was the problem as I am not
convinced that mysql ought to get confused so easily. I changed
DATE_FORMAT( `Messages`.`Date`, '%D %M %Y' ) AS Date,
DATE_FORMAT( `Messages
I've got MySQL 5.0.55a running on a Windows XP system. All tables in the
active database on the system are innodb. The startup log says that innodb
recovery completed and that connections are available. Meanwhile, mysql is
writing to the hdd at around 2MB/sec according to process explorer.
I
Hi,
On Feb 6, 2008 4:47 PM, Olaf Stein [EMAIL PROTECTED] wrote:
Hi All
I am trying to run this query:
update minpheno set TMP_ados_version='0' where ident=898;
On below table:
And get error 1136
ERROR 1136 (21S01): Column count doesn't match value count at row 1
How can that be
Hi All
I am trying to run this query:
update minpheno set TMP_ados_version='0' where ident=898;
On below table:
And get error 1136
ERROR 1136 (21S01): Column count doesn't match value count at row 1
How can that be (obviously ident=898 exists)?
I am going nuts
Thanks
Olaf
Hi Martin,
On 1/31/08, Martijn Tonies [EMAIL PROTECTED] wrote:
Hi,
By default, InnoDB tables aren't stored in the database folder, but rather
in it's own table space files.
In fact when I try to drop the database, the server recognizes
innodb tables. For example, T1 and T2 are INNODB tables
Hi,
I have 2 database folder that being copied directly from a remote
server and sent to me. That databases contains both MYISAM and INNODB
tables.
After I received the data, I try to restored it by copying that
folders to my server. The problem is, only MYISAM tables are being
recognized
Hi all,
I have 2 database folder that being copied directly from a remote
server and sent to me. That databases contains both MYISAM and INNODB
tables.
After I received the data, I try to restored it by copying that
folders to my server. The problem is, only MYISAM tables are being
recognized
Hi,
By default, InnoDB tables aren't stored in the database folder, but
rather
in it's own table space files.
In fact when I try to drop the database, the server recognizes
innodb tables. For example, T1 and T2 are INNODB tables in database
DB1. Then when I try to drop DB1, it issues
Hi Rick,
Thanks... I think I found the answer from your direction. This article
seems the solution to my problem :
http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html
Thanks !
Feris
On 1/31/08, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
moving an innodb table is trickier than moving
Hi Martin,
You are correct. That's the same error that I got.
Looks like this article is the solution =
http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html
Thanks !
Feris
On 1/31/08, Martijn Tonies [EMAIL PROTECTED] wrote:
Hi,
By default, InnoDB tables aren't stored in the database
This is correct.Thank you very much.
But I also why I wrote is wrong on linux and right on windows.
You can tell me answer if you have time.thanks.
On Jan 19, 2008 12:47 AM, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
On Jan 18, 2008 3:50 AM, Moon's Father [EMAIL PROTECTED] wrote:
My test
My test is as follows:
mysql select g_id from t group by g_id order by g_id desc limit 0,1;
+--+
| g_id |
+--+
|6 |
+--+
1 row in set (0.00 sec)
mysql select g_id from t group by g_id order by g_id desc limit 0,1 into
@tmp_id;
Query OK, 1 row affected (0.00 sec)
mysql select
Hi,
On Jan 18, 2008 3:50 AM, Moon's Father [EMAIL PROTECTED] wrote:
My test is as follows:
mysql select g_id from t group by g_id order by g_id desc limit 0,1;
+--+
| g_id |
+--+
|6 |
+--+
1 row in set (0.00 sec)
mysql select g_id from t group by g_id order by g_id
% or 33% overall)
and it's leaving about 14% (of 200% - so 7% overall) of the system
idle.
The remainders are I/O waits etc (your numbers look pretty good
there,
but IO wait can spike and so may be misleading without using other
tools.
You may be encountering a thrashing problem with the amount
simplified the example down to just 3 tables but the problem
exists
at this point.
Table 'contacts' - Does not matter what the fields are, still the
same
problem. I am not using TEXT fields though. Most are int's or
varchar's
account_num
first_name
last_name
Table 'address
pretty good there,
but IO wait can spike and so may be misleading without using other
tools.
You may be encountering a thrashing problem with the amount of memory
left or any number of things, but I would look at memory use on this
box, because your load is pretty high and your performance
pretty good there,
but IO wait can spike and so may be misleading without using other
tools.
You may be encountering a thrashing problem with the amount of memory
left or any number of things, but I would look at memory use on this
box, because your load is pretty high and your performance
I am attempting to left join several tables. This was working at one time
but has seemed to stop just recently. I have checked and installed the
lastest version of mysql via Debian Etch apt-get. I am running version
5.0.32.
I have simplified the example down to just 3 tables but the problem
Hi All
I have the following data example
UID Timestamp
123456 20071201 12:00:01
123456 20071201 12:00:06
987654 20071201 12:00:01
987654 20071201 12:00:09
etc
I need :
UID Timestamp secs
123456 20071201 12:00:01
At 6:47a -0500 on 08 Jan 2008, Gunnar R. wrote:
Concerning slow queries, it seems there's a couple of different queries
that's being logged.
I haven't tried it yet, but this recently went by on debaday.debian.net:
mytop: a top clone for MySQL
Mark, is the 'secs' column the offset from the minimum value of the
timestamp column?
If so, you might try something like this:
SELECT UNIX_TIMESTAMP(MIN(timestamp)) INTO @min_timestamp FROM my_table;
SELECT uid, timestamp,
UNIX_TIMESTAMP(timestamp) - @min_timestamp AS secs
FROM my_table
ORDER
At 3:51p -0500 onGunnar R. wrote, On 01/08/2008 03:51 PM:
That tool tells me 100% of the data is read from memory, not a byte from
disk... would there still be any point in getting more memory?
Any suggestions to where to go from here?
I dunno. My hunch is that could do some query
I have the following 2 tables:
CREATE TABLE media (
id int(10) unsigned NOT NULL auto_increment,
user_id int(10) unsigned default NULL,
title varchar(255) NOT NULL,
description text NOT NULL,
`hash` varchar(255) NOT NULL,
length float(9,2) NOT NULL,
created timestamp NOT NULL
, and
MySQL (5.0.45) seems to be the problem. It's almost constantly running
at
99.9% CPU (measured using 'top').
I know the hardware isn't too hot, but either way I am a bit confused by
the
fact that I can't seem to get MySQL to run smoothly. Is this just too
big
a
database for this kind of box
@lists.mysql.com
Subject: Performance problem - MySQL at 99.9% CPU
Hello,
I am running a community site mainly based on phpBB. It has about 9.300
registered users, 650.000 posts and about 200.000 visitors/month (12
mill
hits). The SQL database is about 700MB.
It's all running on a couple
On Jan 3, 2008 4:23 PM, Tanner Postert [EMAIL PROTECTED] wrote:
When I try to add a force index (PRIMARY) after the media table to try and
make is use PRIMARY, rather than TYPE, the optimizer switches and uses no
key at all.
It usually knows better than you do about indexes.
I've tried to
there,
but IO wait can spike and so may be misleading without using other
tools.
You may be encountering a thrashing problem with the amount of memory
left or any number of things, but I would look at memory use on this
box, because your load is pretty high and your performance is
suffering
Gunnar R. wrote:
I am thinking about buying a new dual core box (with IDE disks?), but
I have to make sure this really is a hardware issue before I spend
thousands of bucks.
I think you've got an application problem somewhere which you should
look into first. Hardware-wise I think you're
601 - 700 of 8646 matches
Mail list logo