matt ryan wrote:
Tobias Asplund wrote:
<>On Tue, 7 Sep 2004, matt ryan wrote:
I forgot, did you have multiple slaves on multiple machines? If so,
do they
have identical hardware/drivers?
Multiple slaves on same machine, one works fine
Do You tried to distribute replication to other machines? Is
mos wrote:
At 01:50 PM 9/4/2004, you wrote:
This is an issue I have seen many people ask over the last year or
two, but I can't say I've ever seen a comprehensive answer (searched
the archives heavily, too).
I realize there are no binaries available directly from MySQL with
OpenSSL support comp
InnoDB doesn't use any *.MYI, only *.FRM. The indexes are in the data
files.
You might check the 4th byte of the .FRM file. x'0C'=InnnoDB, x'09'=MyISAM.
If the InnoDB data files are good, there was a post earlier this year from
Heikki Tuuri about how to get the structure from there.
If the .FR
V. M. Brasseur wrote:
E SA wrote:
gcc -DDEFAULT_CHARSET_HOME=\"/data/MySQL\"
-DDATADIR=\"/data/MySQL/var\"
-DSHAREDIR=\"/data/MySQL/share/mysql\" -DDONT_USE_RAID
-I. -I. -I.. -I./../include -I../include -I./.. -I..
-I.. /data/OpenSSL/include/openssl -O3 -DDBUG_OFF -MT
libmysql.lo -MD -MP -MF .deps
The manual knows all:
http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html
Cheers,
--V
Monet wrote:
I was working on a table, doing some simple update on
table, query is like:
Update temp
SET Q1 = 14,
REVIEWCOMMENTS = CASE WHEN REVIEWCOMMENTS='WHO2'
THEN ''
WHEN REVIEWC
I was working on a table, doing some simple update on
table, query is like:
Update temp
SET Q1 = 14,
REVIEWCOMMENTS = CASE WHEN REVIEWCOMMENTS='WHO2'
THEN ''
WHEN REVIEWCOMMENTS LIKE
'%,WHO2' THEN TRIM(TRAILING ',WHO2' FROM
REVIEWCOMMENTS)
WHE
E SA wrote:
Mr. Brasseur,
"Miss" Brasseur, but you could not have known so no offense is taken.
OpenSSH is installed in the server in its default
location. Still, no luck.
Configure goes on without problems, and then make
gives me the following error message:
gcc -DDEFAULT_CHARSET_HOME=\"/data/My
On Tue, 7 Sep 2004 15:13:25 -0700, Allen Weeks <[EMAIL PROTECTED]> wrote:
> Is this a valid query
>Update Atable set Afield = concat(Afield, "\n", "Some Text") where KeyField
> = 'keydata'
Hi Allen,
I notice that you're using both single- and double-quotes. I'm in the
habit of using on
Mr. Brasseur,
OpenSSH is installed in the server in its default
location. Still, no luck.
Configure goes on without problems, and then make
gives me the following error message:
gcc -DDEFAULT_CHARSET_HOME=\"/data/MySQL\"
-DDATADIR=\"/data/MySQL/var\"
-DSHAREDIR=\"/data/MySQL/share/mysql\" -D
Hi All,
Is this a valid query and will it achieve the result of appending a carriage
return and some text to the current contents of a "text" type field:
Update Atable set Afield = concat(Afield, "\n", "Some Text") where KeyField
= 'keydata'
Thanks in advance.
Allen
--
MySQL General
OpenSSH != OpenSSL. Just because you have one installed doesn't mean
that the other is. Apparently the MySQL compilation using OpenSSL
requires OpenSSH for some reason. You might want to try installing it
and giving the compile another whirl:
http://www.openssh.com/
Also, the exact output of
All,
I already sent this message once, but I got no answer.
Has naybody successfully compiled MySQL with OpenSSL
NOT in /usr/local/ssl?
I can not use stunnel, and I have not found anything
in
google.
Please let me know.
- - - - - - - - - - - - - - - - - - - - - - - - - - -
-
Original post:
The manual is your friend: http://dev.mysql.com/doc/mysql/en/SELECT.html
Pay attention to the portion about the LIMIT clause.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Randy Paries" <[EMAIL PROTECTED]> wrote on 09/07/2004 04:15:28 PM:
>
> Hello,
> I have a table
> M
Sorry, I'm not jumping in becasue I have an answer,
sorry Jeremy.
I posted a few days ago a question and wonder if this
thread , at least Shawn's response has any relevance
to my question.
That is! ; Is there really any difference between
using PHP to parse results back to the program or can
a SQ
On Tue, 07 Sep 2004 15:08:30 -0500, gerald_clark wrote:
>
> Tim McDonough wrote:
>
>> Is there a way to write the results of a query to an output file
>> on a client computer instead of the server? My reference book
>> says MySQL cannot write to a file on the client.
>>
>> Does MySQL not allow the
Hello,
I have a table
Mytable::
int ID
varchar Title
varchar description
Mytable will have many records. In my queries (via web page) I want to
display 10 records at a time.
ID is an auto increment key. But there is a possibility that that record
could be deleted.
So is there are way to get
Tim McDonough wrote:
Is there a way to write the results of a query to an output file on a
client computer instead of the server? My reference book says MySQL
cannot write to a file on the client.
I have a work around by using a PHP script on the user's machine that
does a MySQL query, format
Is there a way to write the results of a query to an output file on a
client computer instead of the server? My reference book says MySQL
cannot write to a file on the client.
I have a work around by using a PHP script on the user's machine that
does a MySQL query, formats the results, and writes
ª?
›L{Ñ!²³k…•%ìû [{l"Sðtb]©H$%åñ–È®¿ ø¹¦u6[rÏW?ûØ’gÒ¼«wÑÆpºðìW8Õ†q1`~\t¡0…ÅF±5q
¿?#Eú¸¿?‚`Ò15ýZlïÍÆX)¢{bcNÉ\eË¡ºïÒœË/™†BpÍOøüÌÓõA†J Šã[úÅ`irƾßíº_Ûqˆ
F‘hvìO\Ü¥¥LQƒ½îÝ•Ž5¦?é(ïhÒæÆÀÚ¸?ŽŽ¬Í{´½.æRÉq¸‘PÆI¸CI›…ïi
?Û$Á1¹WÏÁM¯)¡žjäóï[?ÊíJê`¹1¯
n’B)ê}‘²3]¸oÛ6ÅAqOójñ^?C?HýÃWvñŒ¥¨ÇÅýÃnªäêTûHÇÙ]݆Qå´%˜ÒÒzãÕ
Hi,
We are running MySQL server 4.0.18.0 and it is occasionally crashing with
the following kind of errors. We use InnoDB type of tables. Please let us
know if you have any fix.
Also, when it encounters this error, it tries to restart/recover itself but
fails with a socket "Address already
On Tue, 2004-09-07 at 12:38, Jeremy McEntire wrote:
> Clarification.
>
> I'm using modular arithmetic on a table of recently viewed items. My fields
> are:
>
> user_id, pid0, pid1, pid2, pid3, pid4, inc
>
> user_id is the user's unique identification.
> pid* is the product's unique identifica
You could do it with a UNION:
mysql> SELECT 'key0 ' AS 'header'
-> FROM id_key WHERE id = '10' AND key0 != ''
-> UNION
-> SELECT 'key1 '
-> FROM id_key WHERE id = '10' AND key1 != ''
-> UNION
-> SELECT 'key2 '
-> FROM id_key WHERE id = '10' AND key2 != ''
-> UNIO
You're mixing apples and oranges.
PHP has the metadata available to it in the form of a column name/value
pairs. You scan the results of a query in column order and get the name of
the column (from the recordset, not from the data) that has the data you
want, right?
A native SQL query, as Paul
Tobias Asplund wrote:
<>On Tue, 7 Sep 2004, matt ryan wrote:
I forgot, did you have multiple slaves on multiple machines? If so, do
they
have identical hardware/drivers?
Multiple slaves on same machine, one works fine
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Clarification.
I'm using modular arithmetic on a table of recently viewed items. My fields
are:
user_id, pid0, pid1, pid2, pid3, pid4, inc
user_id is the user's unique identification.
pid* is the product's unique identification.
inc is a number, modulo 5, corresponding to
the last pid col
At 11:24 -0500 9/7/04, Jeremy McEntire wrote:
Let key represent the field name.
Let value reference the data at the 'current' key.
Suppose we have a sample table:
++--+--+--+++
| id | key0 | key1 | key2 | other1 | other2 |
++--+--+--++
I thought I was pretty good at following most questions but Jeremy has
lost me. Jeremy, you were TOO vague (which is good to keep your design
secret but horrible when asking for help).
This is what I understood:
a) You have a table with 5 columns.
b) You want to run a query that doesn't name an
Let key represent the field name.
Let value reference the data at the 'current' key.
Suppose we have a sample table:
++--+--+--+++
| id | key0 | key1 | key2 | other1 | other2 |
++--+--+--+++
| 0 | data | none | none | data | none
On Tue, 7 Sep 2004, matt ryan wrote:
> Still have not got this fixed, I'm all out of idea's, the slave has been
> reloaded again today
I forgot, did you have multiple slaves on multiple machines? If so, do they
have identical hardware/drivers?
--
MySQL General Mailing List
For list archives: h
If all your new "keyword" field will be contain is data that already
exists in its native form in some other field then, IMHO, your are
"overdesigning" your project. A FT index can index your original field
just as well as it could index your "extracted" field.
Unless you are adding new valu
Lee,
why not? That is what ft-search is meant for.
Regards, Thomas Spahni
On Tue, 7 Sep 2004, leegold wrote:
> I asked a ques, in a previous post but maybe I should simplify the
> question. Am I totallly crazy to use FullText for specific keyword
> searchs? Let's say I have a text data type fie
Rob,
use your imagination: this is a case for a quick and dirty shell script.
You don't have blanks in your usernames, do you? Try something like
this: (no guarantee that it works)
#!/bin/sh
# fetch users from a table and create databases
# creates a new table with preliminary passwords for thos
Still have not got this fixed, I'm all out of idea's, the slave has been
reloaded again today
gerald_clark wrote:
We have no idea what you are running, or what you are running it on.
matt ryan wrote:
040901 18:36:21 Error reading packet from server: binlog truncated
in the middle of event (serv
Already tried it.. It is just as faster as the others... And I have already
optimized the table...
The server is a dual processor with 2 GB ram so this should be not a problem
at all...
This table has about 7 fields... The main issue is that it has more than 3
millions records and here is where the
I am sorry to say this but I believe you are confusing one product with
another. In order to connect to a Linux machine, open a user session
(from any platform), and act like a generic user, you need some type of
remote shell utility. I use Cygwin as my remote shell but there are
others, many
Arthur,
What about
select count(category) use index(category) from books where category=1
(don't think this will be faster, but try it)
Then you could try to run "OPTIMIZE TABLE books" (read the manual first if
it's a live system)
Andy
> -Original Message-
> From: Arthur Radules
I asked a ques, in a previous post but maybe I should simplify the
question. Am I totallly crazy to use FullText for specific keyword
searchs? Let's say I have a text data type field and I load it with
keywords (text after all), the couldn't I just use a Fulltext index on
that field then search for
Thanks for the tip! It is much faster now...
But it still takes about 3 seconds which makes about the same thing like
using count() so this still does not solves the problem
Regards,
Arthur
> Arthur,
>
> Is it faster if you do:
> select SQL_CALC_FOUND_ROWS category use index(category) from boo
we currently have a series of machines set up with replication (1 master, 4 slaves)
and we were looking for a way to load-balance the read queries across the slaves, and
came upon c-jdbc. I was wondering if anyone else has experience running c-jdbc in
front of MySQL, and if so, if they can summa
Arthur,
Is it faster if you do:
select SQL_CALC_FOUND_ROWS category use index(category) from books
where category=1 limit 0,10
ie change "*" to "category" (which can be read from the index)?
Andy
> -Original Message-
> From: Arthur Radulescu [mailto:[EMAIL PROTECTED]
> Sent: 07 Septemb
Hi,
I tried to compile Myodbc 3.51.0[67] against mysql4.1, but
while 0.7 doesn't even configure correctly because of undefined
automake macros, .06 fails because it calls int2str() with
three parameters instead of 4 (defined in m_string.h).
What does the 4th parameter mean?
Is MyODBC a dead/unmaint
Hello!
I am having a problem retrieving the number of records matching a certain condition
from the database.
I have a large table of about 3 millions records
A simple query like the one below returns me the results
select * use index(category) from books
where category=1 limit 0,10
This query
Oops, haven't noticed that these are InnoDB tables. The behavior of
optimization and even explain are much different for InnoDB tables.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___
"Mevershosting.nl" <[EMAIL PROTECTED]> wrote:
> Anyone here have any qlue ?
We had a couple of dissatisfactions trying to run MySQL on OpenBSD.
See http://bulk.fefe.de/scalability/
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensi
David Obwaller <[EMAIL PROTECTED]> wrote:
> I have a linux webserver (running apache2 with php4 module), which
> connects to a windows db server (mysql-4.1) for certain pages. There's
> also a db on the linux server. If a php script connects to the local
> mysql server everything runs fine and
Mauricio Pellegrini <[EMAIL PROTECTED]> wrote:
> 040902 21:47:53 mysqld started
> 040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but got
> 126976
>
> Despite that message, everything seems to be working just fine.
>
> Is that error something I should take care of?
>
> what is
On Tue, 7 Sep 2004, Lee Denny wrote:
> Hello,
>
> I need to perform a select that compares two dates
>
> I need to return all records that haven't had date_2 set after a given
> number of days since date_1.
>
... WHERE date_2 < date_1 + INTERVAL X DAY
Where X is the number of days.
Assuming th
"Rob Keeling" <[EMAIL PROTECTED]> wrote:
> Is there a way to create a linked mysql table?
>
> I have one master database, which has a table of data I would like to use
> with three other projects,
> I want to try to avoid copying the data between three databases, or putting
> everything in one da
Balazs Miklos <[EMAIL PROTECTED]> wrote:
> I would like to limit database sizes on my server on a per user basis.
> I haven't really found any information about this in the manual, neither
> in the list archive or on the web.
>
> Is there a way to do this?
No.
--
For technical support con
David T-G <[EMAIL PROTECTED]> wrote:
> % Well, actually, there are 2.878 Meg rows, or 2878k.
>
> FYI, you're both right. Americans write numbers as x,xxx,xxx.xx while
> Europeans typically write them as x.xxx.xxx,xx (dot as thousands
> separator and comma as decimal separator).
But programmers
"Igor Zinkovsky" <[EMAIL PROTECTED]> wrote:
>> Then temporary give a+rw on /root/tmp (don't forget to +x /root)
>> and see what's mysqld_safe gonna write there. Maybe it's a bug in the
>> script.
>> Also please check the environment for TMPDIR.
>
> After this mysql started successfully but it did
If I understand you correctly, I think you want rows with date_2 not greater
than or equal to date_1 plus some number of days, say 30. Then date_2 needs
to be less than date_1 plus 30 days. So, you would use something like:
SELECT * FROM yourtable
WHERE date_2 < date_1 + INTERVAL 30 DAY;
T
Hi
I have had replication working for the past couple of years and have, at
fairly regular intervals, restarted the whole replication process by
distributing new snapshots to slaves, and reseting master and slaves.
Last sunday I started replication from scratch. This time, however, I
noticed tha
Hi all,
Let me first say i am new to this list, but i did search all the
internet for an answer for my problems.
I have the following situation:
OpenBSD 3.4 with Mysql 4.0.20 (It does not matter which version, the
problem is on all)
There is a forum running on this machine dedicated, (2
Hello,
I need to perform a select that compares two dates
I need to return all records that haven't had date_2 set after a given
number of days since date_1.
I'm sure this can be done in one query but I just can't get my head around
this one.
Can anyone help?
Cheers,
Lee
--
MySQL General M
Le mar 07/09/2004 à 11:24, Rob Keeling a écrit :
> Having googled extensively, I can`t seem to find a way to do the following.
>
> I have a mysql table, with around 1200 usernames in it.
>
> What I want to do is programmatically add each user, and create a database
> of the same name
> that that
Having googled extensively, I can`t seem to find a way to do the following.
I have a mysql table, with around 1200 usernames in it.
What I want to do is programmatically add each user, and create a database
of the same name
that that user has access to.
(This is for a school web server, we want
>> Sticking with the May example... I would like to be able to return
>> results for only students named May or Maya, but not Mayra, Jessica-May,
>> or Maylita.
SELECT * FROM students WHERE first_name LIKE 'May_'
_ in like means any single character
% in like means arbitrary number of characters
Hello,
I have a linux webserver (running apache2 with php4 module), which
connects to a windows db server (mysql-4.1) for certain pages. There's
also a db on the linux server. If a php script connects to the local
mysql server everything runs fine and at normal speed. However, if php
connects t
hello everyone,
i have problem running mysqld with particular charset and collation, i test two cases:
I use mysql-4.1.3-beta , and Fedora Core 2 for my tests
1)
./configure --prefix=/usr/local/mysql --with-charset=utf8
--with-collation=utf8_turkish_ci
make;make install ;
in this case mysql_
60 matches
Mail list logo