I have a Sun Netra T1 with 512MB of ram and 2 x 9G drives. (One is
exclusively the MySQL 3.23.56 files, and the other is OS, Apache, etc.)
I am also using the default medium (I think) my.cnf.
Currently, the complaints are coming from a php Forum and a php picture
Gallery. From the OS side, I
At 09:10 -0500 on 06/17/2004, gerald_clark wrote about Re: How to
monitor that slave is not working because of use:
The master will be trying to serve binlogs to the old address, but
the slave won't know this.
You could monitor the IP address, and stop and start the slave when
it changes,
but h
Greetings,
Last night I upgraded from 3.23 to 4.0.20 and when I try to start mysqld
it fails. The only entries I have in my error log are:
040620 23:44:19 mysqld started
040620 23:44:19 mysqld ended
I know this isnt' enough info to troubleshoot the problem. How can I
set the log level to giv
Whoops. I was thinking about how I have my isbn table stored. ;) I
prefer to remove all formatting from numbers like this(isbn, phone
numbers, social security numbers, etc) before storing them. Anyway,
here's something that should work. I'm not sure if it is the most
efficient way to do thi
Never Mind:
I set in /etc/my.cnf
max_heap_table_size = 256M
and, all is good.
Van
--
=
http://www.dedserius.com/-Linux rocks!!!
=
Van wrote:
>
Hi Bob,
I think this might be in the wrong direction - my isbn is saved with the
dashes, so I would need it to look like:
select * from test where REPLACE('myvalue','-','') = '12';
which I'm not sure will work. When I get on my machine I'll give some
variations of this a try, thanks for the qui
Hey, All:
I'm getting:
ERROR 1114: The table '#sql-3612_4' is full when trying to convert a MyISAM
table to HEAP with:
ALTER TABLE ns_sum_cats TYPE=HEAP;
mysql> describe ns_sum_cats;
+--+---+--+-+-+---+
| Field| Type | Null | Key | Default | Ex
Oh, I think I know this one.
Copied from my console:
mysql> select * from test;
++-+
| id | myvalue |
++-+
| 1 | 12 |
| 2 | 15 |
| 3 | 3 |
| 4 | 10 |
| 5 | 10 |
| 6 | 10 |
++-+
6 rows in set (0.04 sec)
mysql> select * from tes
Hi everyone,
ok, so I know how to use RLIKE to match regular expressions. However,
let's say I have an isbn number of:
0-06-430022-6
saved in the database but someone wants to search for it by entering:
0064300226
or even
006-430-0226
So the search query needs to have its dashes removed
Greetings:
Does anyone know of a standalone string function in MySQL that can return the
number of occurrences of a string within field? I need this for a CREATE TABLE
/ INSERT FROM exising_table implementation and am trying to keep the number of
parsing functions to a minimum.
Is FIND_IN_SET ap
You cannot do that in the WHERE clause. The WHERE clause determines which
rows to look at. That is, in this case, it determines which rows to count.
How can it choose which rows to count based on the result of the count?
See the problem?
Instead, you need to use the HAVING clause, which filt
Robert A. Rosenberg wrote:
At 13:37 -0400 on 06/19/2004, Michael Stassen wrote about Re:
AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a:
Finally, just to cover all the bases, that really is 87 million
inserts, not
8.7 million, right? I only ask because a MEDIUMINT column runs out a
li
Hi all
how to do this in MySQL? Returning only records with COUNT > 5?
SELECT
`groups`.`groupsDescr`,
`roles`.`roles_Agroup`,
`roles`.`rolesDescr`,
COUNT(`roles`.`rolesDescr`) AS TOTAL
FROM
`roles`
INNER JOIN `groups_roles` ON (`roles`.`rolesID` =
`groups_roles`.`fkrolesID`)
INNER
At 19:02 -0700 on 06/18/2004, Paul Chu wrote about Re: Full Text
Index on Large Tables - Not Answered:
Appreciate any help at all
Thanks, Paul
-Original Message-
From: Paul Chu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Full Text Index
At 13:37 -0400 on 06/19/2004, Michael Stassen wrote about Re:
AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a:
Finally, just to cover all the bases, that really is 87 million inserts, not
8.7 million, right? I only ask because a MEDIUMINT column runs out a little
past 8.3 million.
It goe
Does anybody have any feedback, particularly problems, using CAST to
strip the trailing alpha characters from a string in order to convert
the string to an integer? Is there a better way to do it with MySQL?
(MySQL 4.0.20, Mac OS X 10.3)
Here's my situation:
TABLE_1
id CHAR( 8 )
TABLE_2
id INT(
There is no icon. The best way to run MySQL is as a service. If you have
Windows NT, 2000 or XP you can install MySQL as a service as follows:
1. Open a command prompt.
2. change to the mysql bin directory ("cd \mysql\bin").
3. type "mysqld-nt --install". You should see a message saying "service
i
17 matches
Mail list logo