Hi,
I am pretty new in optimizing tables with index and may need some help.
This is my query:
EXPLAIN SELECT timestamp
FROM Meting_INT_COPY
WHERE blockid = '200811252000'
ORDER BY timestamp DESC
LIMIT 1
If I have an index(blockid),
EXPLAIN will return the following information:
type possible_ke
Recently I noticed a changed behavior in how linux utilities (ps ans
pstree) report mysql usage.
Previously a ps output would list all active mysql threads, and a
pstree would list the number of mysql threads currently running.
Now I merely see a pstree output such as:
├─mysqld_safe───mysq
they write to the slave or do I have to change
something before in the mysql slave configuration?
thanks
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Am Freitag, 29. April 2016, 14:49:57 schrieb william drescher:
> On 4/28/2016 5:20 PM, Thomas wrote:
> > Hi,
> >
> > I have setup an master slave replication.
> > This works fine.
> > I have running an Apache webserver and some other programms accessing the
&
:(.
thomas
Victor Pendleton wrote:
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
rows in set (0.01 sec)
Regards
Thomas L.
tis 2006-05-30 klockan 15:46 +0200 skrev Gilles MISSONNIER:
> Hello
>
> I could not find the answer through the online "Search the MySQL manual".
> I run MySQL 4.1
>
> In astronomy, RA and DEC are widely used coordinate
Hi,
I am using Java to maintain a MySQL database. I have a table in the
database created by:
"CREATE TABLE track_char ("
+ "id INT UNSIGNED NOT NULL AUTO_INCREMENT,"
+ "PRIMARY KEY (id),"
+ "name CHAR(40),"
Right...the thing is that they are supposed to be INTs, but I can only
successfully perform an update query if I use doubles for the fields...?
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 1:59 PM
To: Thomas Amundsen; mysql@lists.mysql.com
E name = 'Tom'"
but that wouldn't work. And yes, I have made sure that it isn't a
problem with the parseInt() method by using hard-coded values...only
hard-coded doubles work, hard-coded ints wouldn't.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROT
It seems to work with INTs when I do it from the MySQL commandline. I
guess something is weird with the JDBC connector or something...
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 2:26 PM
To: Thomas Amundsen; mysql@lists.mysql.com
Subject
mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 2:38 PM
To: Thomas Amundsen; mysql@lists.mysql.com
Subject: RE: INT wants a float/double?
[snip]
It seems to work with INTs when I do it from the MySQL commandline. I
guess something is weird with the JDBC connector or something...
[/snip]
Ma
Is there any way to find the time of the most recent update for a row?
I'm running MySQL server 5.0...???
mysql> mysqldump --help;
ERROR 1064 (42000): 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 'mysql
dump --help' at line 1
-Original Message-
From: J.R. Bullington [mai
t1.id = t2.id
and t1.id = t3.id
and t1.id = 3
Maybe you can do something like that?
Regards,
Thomas L.
ons 2006-06-21 klockan 17:16 +0800 skrev Song Ken Vern-E11804:
> Hi,
>
> I'm trying to build a query in using SQL instead of doing it in Perl.
>
> I am trying
fre 2006-06-23 klockan 01:52 -0400 skrev Michael Stassen:
> Thomas Lundström wrote:
> > Not sure what you're aming for here and how your data is structured but
> > why not use a join and alias and fetch all info in one select and then
> > solve what you need in your
Hi.
Working with mySQL 3.23.58 on Linux, I get this error when trying to
start mysqld:
060716 03:07:21 mysqld started
060716 03:07:21 /usr/local/mysql/libexec/mysqld: Table 'mysql.host'
doesn't exist
060716 03:07:21 mysqld ended
-
This Linux machine ha
only two files:
--
-rw-rw 1 mysql root0 may 30 2005 func.MYD
-rw-rw 1 mysql root 8877 may 30 2005 tables_priv.frm
Where are 'host.frm', 'host.MYD' and 'host.MYI'?
On 7/16/06, thomas Armstrong <[EMAIL PROTECTED]>
Hola.
With mySQL 4.0.27 I'm trying to create this table
--
CREATE TABLE `test`.`user` (
`user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`email` TEXT CHARACTER SET COLLATE NULL ,
`firstname` TEXT CHARACTER SET COLLATE NOT NULL ,
)
--
but I get this error:
--
#1064 - You have an
Hi.
My Linux server has just restarted due to memory problems.
Browsing mySQL logs, I've found out 5,000 lines like these in less
than one hour:
--
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't open file:
'my_table.MYI' (errno: 145)
060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't o
Hi.
I've got three tables (users, books and news), and I would like to
crete a web interface
to manage their data (create items, modify items, delete items).
Is there any PHP script to create it automatically (in the same way
phpMyAdmin does, but
with less functionalities)?
Thank you very much.
Hi.
There's a lot of '/tmp/ibE3FYj2' files inside my Linux server, created
by mysqld.
Does anybody know how to delete them after being used?
Thank you very much.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
TAB=' '
WHITESPACE="${BLANK}${TAB}"
DATE=$(cat mydatafile.csv | sed \
-e "3 !d" \
-e "s/^[$WHITESPACE]*//" \
-e "s/.*/'&'/")
DATA=$(cat mydatafile.csv | sed \
-e "/[A-Z]/ d" \
-e "
Hello all...
And thanks ahead of time for the help...
I'm having an issue with a locked table...
I have about 27 tables in MySQL Db that i am working with with multiple
MS Access front ends.. The problem is one of my tables is locked, but
only the first 400 records, the rest is fine... Any id
gt; select id, name from tableName where name like 'a%' or name like 'b%' or
> name like 'c%';
no. You have to use LIKE.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the contents of CHAR, VARCHAR and
TEXT columns. In case of parse errors it should return the unchanged
string as a default.
What do others think? Any comments are welcome.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
gers
You want to normalize your database to least 1NF. Read
<http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html>
if you are unsure of what 1NF means.
Applying indexes on the resulting scheme may improve your performance
significantly.
/Thomas
--
MySQL General Mai
One thing to remember about *nix, is that disk space is not released until all
processes that had a
file open have closed it. For example, if a process has a 2Gb file open, and
another process rm's
the file, an ls will show that file as gone but the disk space is not released
until the firs
Hi suomi,
it can be done with a temporary table. See the following example.
Regards,
Thomas Spahni
USE test;
CREATE TABLE duprows (
id INT NULL AUTO_INCREMENT PRIMARY KEY,
content VARCHAR(255)
) TYPE=MyISAM;
INSERT INTO duprows VALUES(NULL, 'some text'),(NULL, &
Hi.
Working on Linux Fedora Core 2.
I'm programming an application which requires version 14 of the MySQL Client
libraries. Now I've got version 10:
---
[EMAIL PROTECTED] mysql_config --libs
-L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm
[EMAIL PROTECTED] locate mysqlclient
/
Hi.
Using MySQL 4.1.9 on Linux FedoraCore2 (kernel 2.6.9),
I'm suffering several memory problems ('Out Of Memory'
problem) on my server.
Playing around with my server:
SHOW PROCESSLIST
Id | User | Host | db | Command | Time | State | Info
20138 | user1 | localhost | user1_db | Slee
Hi.
Using MySQL 4.1.9 on Linux FedoraCore2 (kernel 2.6.9),
I'm suffering several memory problems ('Out Of Memory'
problem) on my server.
I've noticed that '/var/log/mysqld.log' is 2Mb, and
'/var/log/mysqld.log.1', 'mysqld.log.2', .. are empty.
Is 2Mb to high to be handled? Thank you very much.
Hi Merlin,
you can create your own stopword file (one word per line) and activate it
in my.cnf like this:
# The MySQL server
[mysqld]
set-variable= ft_stopword_file=/etc/my.stopwords
HTH,
Thomas
On Fri, 28 Oct 2005, Merlin wrote:
> Hi there,
>
> as mysql docs describe, there
well I know this is the wrong list to ask this question -
why kswapd is running when no swap device is configured and why there are some
processes using swap memory (see top output)?
Kind regards,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
ld become something like
const char *ft_boolean_syntax="+ =><()~*:\"\"&|";
Then recompile and try your luck. You have to rebuild your indexes.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
decent machine spec? ("Decent"
being mostly undefined, but lets say that it should be capable of
handling some medium size website.)
thanks,
Thomas
--
N.J. Thomas
[EMAIL PROTECTED]
Etiamsi occiderit me, in ipso sperabo
--
MySQL General Mailing List
For list archives: http://lists.
Dave,
what is the result of
prompt> set | grep LANG
? I suspect your problem is not within MySQL. Did you look at your
testfile using a editor?
Thomas Spahni
On Wed, 4 Jan 2006, Dave M G wrote:
> MySQL List,
>
> I have recently switched over from Windows to Ubuntu Linux,
alternative (better) solution?
thanks,
Thomas
--
N.J. Thomas
[EMAIL PROTECTED]
Etiamsi occiderit me, in ipso sperabo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tions to a known good state?
thanks,
Thomas
--
N.J. Thomas
[EMAIL PROTECTED]
Etiamsi occiderit me, in ipso sperabo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
*** 2. row ***
table: t2
type: ALL
possible_keys: locktwo
key: NULL
key_len: NULL
ref: NULL
rows: 5
Extra: Using where
This looks quite good for t1 but does not use any index for t2.
How should I set up my index to improve this situation?
Any help is appreciated.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e following:
SELECT reference.uid FROM reference
INNER JOIN ref_cat ON reference.ref_cat_id = ref_cat.ref_cat_id
INNER JOIN subject_name ON ref_cat.sub_id = subject_name.sub_id
WHERE subject_name.sub_id = 45
AND ref_cat.ref_cat_id = 3;
HTH
Thomas Spahni
--
MySQL General Mailing Li
;studied" your query, my guess would be: double rows. UNION
eliminates those; if you need them, use "UNION ALL". Just a guess though...
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
--
MySQL General Mailing List
For list archives: h
p database replication including a
failover solution (e.g. heartbeat).
You could in general do something similar with your webserver and other
systems.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
--
MySQL General Mailing List
For list archives: http:/
access to the replication user password on SLAVE and
has no access to MASTER (otherwise mysql -h MASTER -e "SHOW MASTER
STATUS," would do the trick).
Any other way to make the SLAVE tell me what is's replicating?
TIA
Thomas Spahni
--
MySQL General Mailing List
For list archive
ans that the query result is not cached. It does not mean
that the cache is not used to answer the query.
You may use RESET QUERY CACHE to remove all queries from the cache and
then your next query should be slow again. Same effect if you change
the table, because this makes all cached queries in
On Mon, 9 Mar 2009, Sven wrote:
Hi folks
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB.
kind regards
Sven Aluoor
Hi
What about 'mysqladmin ping' ?
Regards,
Thomas Spahni
--
MySQL
perfectly valid information in many cases.
Cheers
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi
How can I specify 'unprintable' characters is a MySQL regexp ?
Query is (example only):
SELECT something FROM table WHERE column REGEXP 'Ã\\xA0';
I'm looking for an equivalent of the search part of a sed expression like
this:
s/Ã\xA0/à/g
which means I want to include a character with co
On Wed, 8 Apr 2009, Pete Wilson wrote:
Hi everyone --
I'm a MySQL noob. I have MySQL queries in my C code and I was surprised
to find I'm getting a success return from:
mysql_query(pmysql, "select * from usrs where(usr=\"illegal name\"");
In this table called "usrs," "usr" is the primary k
://dev.mysql.com/doc/refman/5.0/en/join.html,
"Join Processing Changes in MySQL 5.0.12".
Best to avoid this issue is to not mix implicit and
explicit joins, as Gerald pointed out.
Ciao,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
José I. Merino schrieb:
The main question is:
Will Oracle permits a cheaper DB in his portfolio with almost the same
reliability than his main and expensive DB?
It already has, it's called "Oracle Express Edition".
Ciao,
Thomas
--
MySQL General Mailing List
For list
file? Will
this improve results for users?
Any insight is welcome.
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
index the crcval column.
From my understanding, a TRIGGER might do exactly what Thunder needs.
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
Ciao,
Thomas Pundt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
Hi Scott
You may use the script below to reload replication if you can ensure that
the master db doesn't change during the dump operation. Otherwise you may
set a lock on the master manually.
Regards, Thomas
#!/bin/bash
#
# replicate-reload
#
# This is free software. There is no war
larger MAC addresses eventually.
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
_size=20971520
sort_buffer_size=20971520
read_buffer_size=2097152
write_buffer_size=2097152
What's wrong here?
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Wed, 17 Jun 2009, Johan De Meersman wrote:
Aren't those options defined in megabytes ?
On Tue, Jun 16, 2009 at 4:59 PM, Thomas Spahni wrote:
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk
on any
table I get the following warnings:
Wa
On Tue, 16 Jun 2009, Thomas Spahni wrote:
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk on any
table I get the following warnings:
Warning: option 'key_buffer_size': unsigned value 18446744073709551615
adjusted to 4294963200
Warning: option 'read_buffer_
On Sat, 19 Sep 2009, b wrote:
I'm trying to select all members who have not registered for an event. I
have tables 'members', 'events', and 'events_members', the latter a join
table with event_id and member_id columns.
The closest I've gotten is with this query:
SELECT m.id, m.first_name, m.
2) What is the proper location (Full path please) for host.frm
3) It would be easier to debug this if your error messages included the
full path!
not something like ./ which provides no help in identifing where a file
is required.
Thomas Dineen
110331 18:40:10 mysqld started
110331 18:40:10 [
Gentlemen:
- Keep in mind that I have approximately 50 hours into this Mysql
server install and still no
results!
- Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz
- When installed and started with the following command:
/usr/local/mysql/bin/mysqld_safe --user=mysql &
The
Got It; Thank You, Thank You, Thank You
On 4/1/2011 11:28 PM, Claudio Nanni wrote:
Hi Thomas,
Did you run the post install script?
http://kae.li/iiikj
Claudio
On Apr 2, 2011 2:20 AM, "Thomas Dineen" <mailto:tdin...@ix.netcom.com>> wrote:
to go?
Thanks a lot for your ideas!
Best,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi.
I'm suffering a severe slowness of my server (mySQL 3.23), and want to
detect Slow Queries.
I installed mySQL on '/usr/local/mysql', and works ok. But if I insert
this line into '/etc/my.cnf':
-
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long_query_time = 5
-
it won't re
I also tried with:
---
set-variable=long_query_time=5
--
mySQL starts ok, but all queries within the file are:
# Query_time: 0 Lock_time: 0 Rows_sent: 119 Rows_examined: 238
The aren't slow queries, are they?
On 10/4/07, thomas Armstrong <[EMAIL PROTECTED]> wrote:
&g
root[root] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 20
This is not a slow query, is it?
On 10/4/07, Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote:
> On Thursday 04 October 2007 14:06, thomas Armstrong wrote:
> > Hi.
> >
> > I'
2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata7:500M:autoextend
The OS is Linux X 2.4.21-40.ELsmp #1 SMP Thu Feb 2 22:22:39 EST 2006
i686 i686 i386 GNU/Linux
4 x Intel(R) Xeon(R) CPU 5140 @ 2.33GHz with 4Go
is anybody has got a documentation about this...
Thanks all
Thomas Raso
There is no way whitout stopping mysql ?
for information it is a version 4.1
2007/10/29, Dan Nelson <[EMAIL PROTECTED]>:
>
> In the last episode (Oct 29), Thomas Raso said:
> > i don't understand the size of the ibdata7
> >
> > -rw-rw1 mysqlmys
ok thanks,
this mysql has got a replication slave...
On the slave the ibdata has got a size close to 15Go (ie the master's size
is 22Go)
have you got an idea about this ???
thanks
2007/10/29, Dan Nelson <[EMAIL PROTECTED]>:
>
> In the last episode (Oct 29), Thomas Raso sai
Hi all,
on a replication architecture, with the same server, the same Mysql version
(4.1.21) and the same configuration, the same database.
I have a difference between two ibdata file size
innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;i
Thanks a lot for this explanation,
yeah we are doing many massive update and insert in our databases.
--
Thomas Raso
2007/10/30, Augusto Bott <[EMAIL PROTECTED]>:
>
> One possible explanation (possibly not the only one): if you do a
> massive update on the master, that transac
Hi.
Working on Linux, I've got installed MySQL 3.23.58, but I'm
experiencing some problems. For instance, I suffer "too many
connections" error but I cann't set 'max_connections' parameter to a
value bigger than 250.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed My
Hi Tiago. Thank you very much for your answer.
> > I decided to migrate to MySQL 5.0, and I've got some questions:
> > - I installed MySQL from sources on '/usr/local/mysql'. Is it as easy
> > as installing it again on '/usr/local/mysql5'?
>
> Yep. Just change the '--prefix' com './configure' time
> Make sure you use the mysqldump from version 5 and not version 3. Also
> recheck all your application queries once you have restored the data the
> list of changes SQL syntax might haunt you.
But can I use '/usr/local/mysql5/bin/mysqldump' to dump data of MySQL 3?
--
MySQL General Mailing List
+
| wait_timeout | 28800 |
+---+---+
1 row in set (0.00 sec)
Can you explain me why this operation don't work ???
ie: I useed the root account...
Thanks
Thomas Raso
Hi.
Using MySQL on Linux, I'd like to analyze the performance and know how
resources (memory, threads) are used during a period of time.
Do you know any tool to carry it out? Thank you very much.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
Hi all,
just a simple question :
Does the query ANALYZE position reads and/or writes locks ?
I read these two pages but I didn't find the answer...
http://www.mysql.com/news-and-events/newsletter/2003-04/a000155.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html
Thanks a
Hi
Using MySQL 4.1.19 on Linux, my server's CPU load is very high. I want
to cut it down but I don't know which parameters I might modify to do
it.
These are my server's data:
back log50
basedir /usr/
bdb cache size 8,388,600
bdb home/var/lib/mysql/
bdb log buffe
Hi.
I've installed 'mytop' on my Linux server and would like to log the
data provided in order to store it for future situations.
Does anybody know how to perform it? Thank you very much,
--Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi.
I've been finding some queries by using 'mytop' which takes +200
seconds to be executed. It wastes tons of CPU resources on my server
and would like to detect them automatically and kill them.
Does anybody have experience with this issue? Thank you very much,
--Thomas
--
Hi all,
how mysql manage the query_cache TimeToLive (live) and how can I change it ?
Thanks
Hi.
I've got mySQL 4.1.22 installed from sources on Linux
---
./configure --prefix=/usr/local/mysql
and PHP 4.4.2 installed from sources
---
./configure --prefix=/usr/local/php --with-mysql=/usr/local/mysql
I want to upgrade mySQL from 4.1.22 to 5.0.5 by doing:
1) export DB
2)
Hi all,
I want to know the main differences between mysql 5.0.41 and MySQL
5.0.51a(last GA release)
I read this page :
http://dev.mysql.com/doc/refman/5.0/en/mysql-nutshell.html but there is
nothing about the developments made by such update...
thnaks all...
hi list,
how can I rename a database with full innodb tables ?
The version is 4.1
Thnaks all
hi list
I don't understand what happen in mysql 4.1.22 ! ! ! ! ! (the same in
version 5.0)
-bash-3.00$ mysql -e "show variables like 'wait_timeout%'"
+---+---+
| Variable_name | Value |
+---+---+
| wait_timeout | *30*|
+---+---+
-bash-3.00$ my
+
2 rows in set (0.02 sec)
mysql>
Ciao,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
columns (D, E, F) from table_2 if the columns don¹t exist in
| Table_1.
select a, b, c, null as d, null as e, null as f
from table_1
union
select a, b, c, d, e, f
from table_2
should do it.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
--
MySQL General M
ags. When
> it tries to save the text to the table in the database, I get the error,
> "#HY000Got error 139 from storage engine". Does anyone know what this is and
> how to fix it?
prompt> perror 139
MySQL error code 139: Too big row
Seems you are exceeding some limit
you using? I found some issues with InnoDB
regarding this error. Please check the .err log of mysqld as well.
Regards, Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If one has a large number of records per month and normally searches for
things by month, yet needs to keep things time coded, does anyone know
if it make sense to use datetime or separate date and a time columns?
Thanks,
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
I have data that is broken into anything from 30 sec to 15 minute time
series (with a DATETIME field). I need to transform all of this into 15
minute data. Does anyone know off the top of their head if there a way I
could use GROUP BY to make this happen? Nothing I have tried thus far
has worke
Hi.
Using mySQL v4.1.9 on Fedora Core 2, I'm suffering a shutdown everyday
around 04:30. These are the contents of 'mysqld.log':
/usr/sbin/mysqld: ready for connections.
Version: '4.1.9-standard-log' socket: '/var/lib/mysql/mysql.sock'
port: 3306 Source distribution
070201 4:29:40 [Note]
--+--+
4 rows in set (0.00 sec)
i.e. row 3 of atable should be updated 2 times, adding 6 and 7, as there
are 2 rows in btable where column a is = 3.
How can I do this? Any help is apreciated.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
--
I created a '
Hi.
Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
--
I created a '
Fixed:
[]# kill `cat /usr/local/mysql/var/server.pid`
[]# /usr/local/mysql/bin/mysqld_safe --skip-grant-tables&
[]# /usr/local/mysql/bin/mysql
mysql> update user set password = password('xxx') where user =
'root' and host='localhost';
On 2/20/07, thoma
Hi.
Using mySQL 3.23.58, I'm trying to log slow queries and I made:
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long-query-time = 5
(into my '/etc/my.conf' file)
However, I get this error message:
unrecognized option `--long-query-time=5'
Is this parameter supported in mySQL 3?
--
I also tried with long_query_time = 5
but got the same error :(
On 7/12/07, thomas Armstrong <[EMAIL PROTECTED]> wrote:
Hi.
Using mySQL 3.23.58, I'm trying to log slow queries and I made:
log-slow-queries = /usr/local/mysql/log/slow-queries.log
long-query-time = 5
(into my '/e
is
wrong?
Thank you for any help.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi.
I've got this table in mySQL:
item 1:
-- firstname: John (Johnie)
-- phone: 555-600-200
item 2:
-- firstname: Peter
-- phone: 555-300-400
I created this SQL query to find 'johnie':
SELECT friends.id FROM friends WHERE ((friends.firstname LIKE '%
johnie %' OR friend
cords in here,
> that's going to kill you.
You're right, but I didn't find another better way. What do you think
it's better?
>
> - michael
>
>
> On 9/19/07, thomas Armstrong <[EMAIL PROTECTED]> wrote:
> > Hi.
> >
> > I've got t
1 - 100 of 669 matches
Mail list logo
