Hi Rob.
Thank you very much for your answer.
CREATE TABLE `books` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(200) NOT NULL,
`author_name` varchar(100) NOT NULL,
`category_name` varchar(100) NOT NULL,
`description` varchar(200) NOT NULL,
`isbn` varchar(100) NOT
Hi,
My experience shows me that RAM and disk is fundamental for any
database, especially MySQL. As much IO load, much more disk preading you
have to take with.
Personally, i have 2 databases with 11 millions Inserts / day (2GB /
day), so my advise is that you spend as much money as you can in
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
in a 5.0.45 linux master-master replication setup, I see the error
message from the subject every now and then. Sometimes it does not
happen for a couple of months, then it happens a couple of times a day.
I cannot see any network problems otherwise, and a memtest did not bring
up any
hello
i have a message table like this:
created datetime
sender int
recipient int
message text
to get all my messages i would do:
select * from message where sender = $MYID or recipient = $MYID
but how do i make a query that returns the rows of only the NEWEST
messages between myself and my
just to clarify, i want the
1. the newest message between myself and person A
2. the newest message between myself and person B
3. the newest message between myself and person C
4. the newest message between myself and person D
... and so on
--
MySQL General Mailing List
For list archives:
hello
i have a message table like this:
created datetime
sender int
recipient int
message text
to get all my messages i would do:
select * from message where sender = $MYID or recipient = $MYID
but how do i make a query that returns the rows of only the NEWEST
messages between
hi, i posted this clarification just after the original posting.
what i want is:
1. the newest message between myself and person A
2. the newest message between myself and person B
3. the newest message between myself and person C
4. the newest message between myself and person D
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
On 28/04/2008, Martijn Tonies [EMAIL PROTECTED] wrote:
1. the newest message between myself and person A
2. the newest message between myself and person B
3. the newest message between myself and person C
4. the newest message between myself and person D
Still, define newest:
-
On 28/04/2008, Martijn Tonies [EMAIL PROTECTED] wrote:
1. the newest message between myself and person A
2. the newest message between myself and person B
3. the newest message between myself and person C
4. the newest message between myself and person D
Still, define
I am going to assume that you are asking this question because
performance has not improved from this change. Is this correct?
I don't think that your surogate key (id) is useful, but that is
probably minor. I think that your hostings company suggestion is
probably a good idea, but will also
On 28/04/2008, Martijn Tonies [EMAIL PROTECTED] wrote:
select *
from ( select * from msgs order by msgs.created desc ) t
where sender = 1 or recipient = 1
group by sender, recipient
not quite right. first comes all of MY newest messages, then comes all
of THEIR newest messages. for
Hi.
Juan Eduardo Moreno wrote:
Sorry, what is your setting for max_allowed_packet variable?
mysql show variables like %allowed%;
++--+
| Variable_name | Value|
++--+
| max_allowed_packet | 16776192 |
Hi,
I have experienced similar problems to the one you have; the problem you have
is that the time gap between the failure and now is so big that you cannot
resume replication, because of the big data portion you have to replicate.
When this happens to me, increasing the value of the variable
Hi,
This error occur when slave servers could incorrectly interpret an
out-of-memory error from the master and reconnect using the wrong binary log
position.
This was fix in 5.0.48 version. Please, try to update your version ( from
5.0.45) of mysql and try again.
regards,
Juan
On 4/28/08,
Hi Saravanan,
Thanks, once I added this to the my.cnf in the mysqld section it worked!
Regards,
Mark
saravanan-5 wrote:
Use my.cnf to point the data directory and the user details.
[mysqld]
user=mysql50
datadir=/home/mysql50
Saravanan
--- On Mon, 4/28/08, Mark-E
Hi Ian,
Thanks for the reply. I was specifying the new port of 3307. I actually
got it working over the weekend. Turns out I had to add a few entries in the
mysqld section of the my.cnf file and I was able to connect.
Regards,
Mark
Ian Simpson wrote:
Mark,
When you try to log-in
select *
from ( select * from msgs order by msgs.created desc ) t
where sender = 1 or recipient = 1
group by sender, recipient
not quite right. first comes all of MY newest messages, then comes all
of THEIR newest messages. for example:
S R
1 2
1 3
1 5
1 7
2 1
5 1
the
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
http://lists.mysql.com/mysql/212392. I didn't mention it in my posting, but
latin1 is
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 |
On Mon, Apr 28, 2008 at 6:49 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
I am going to assume that you are asking this question because
performance has not improved from this change. Is this correct?
I don't think that your surogate key (id) is useful, but that is
probably minor. I think that
On Mon, April 28, 2008 09:44, Rob Wultsch wrote:
On Mon, Apr 28, 2008 at 6:49 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
I am going to assume that you are asking this question because
performance has not improved from this change. Is this correct?
I don't think that your surogate key (id) is
Exactly.
2008/4/28, Martijn Tonies [EMAIL PROTECTED]:
select *
from ( select * from msgs order by msgs.created desc ) t
where sender = 1 or recipient = 1
group by sender, recipient
not quite right. first comes all of MY newest messages, then comes all
of THEIR newest
I have a question on this script. When you run this, does this create the
mysql and information_schema databases?
I ran this in MySQL 5.0 on a Solaris box and it only created the
information_schema database. I see a data/mysql folder and it put files
under that but somehow it must not have
Hi,
mysql_install_db is a script to create the mysql database which is the database
we need all the time to run mysql server.
Information_schema is not a physical database. It will not come under the data
folder. That database is to keep the details of the current status of existing
databases
Mike wrote:
Hi!
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
Dump the database, restore on the 64-bit box, and all should be well
What is the difference between
On 4/26/08 Mihail Manolov wrote:
Hi!
MyISAM (MERGE; and therefore not an issue). The only exception is
Falcon, which is only available in MySQL 6.0.
While I haven't had a chance to read the wiki link you posted, as I
write this email offline, it should be noted that Falcon previews even
Hi All,
I am using mysql 5.0.41 on debain.
I have 8 processor, 8 GB RAM.
I have atable with 95 Million records, each day there will be about 1.5
Million records deleted, and around 3.5 Million records added using LOAD
FILE script.
Since there would daily deletes happening, there would be lot of
Ananda Kumar schrieb:
Hi All,
I am using mysql 5.0.41 on debain.
I have 8 processor, 8 GB RAM.
I have atable with 95 Million records, each day there will be about 1.5
Million records deleted, and around 3.5 Million records added using LOAD
FILE script.
Since there would daily deletes happening,
31 matches
Mail list logo