hi All,
Last month, one of the our server got stuck but We could n't find the
reason. Here I have attached the OS(Red Hat Enterprise Linux AS relese 4)
message log. I think issue may be in MySQL.
We are using MySQL Server version: 5.1.12-beta MySQL Community Server (GPL)
So if you can please send
Christian Parpart wrote:
Hi all,
i would like to replicate just tables beginning with a certain prefix
while the replication slave host's database name also differs.
i remember i once read something about it, but can't really find it on the net
anymore, so does anyone have a hint for me here,
I'm sure there must be an accepted technique for this, but it's
something I haven't tried before, so if anyone can point me in the
right direction I'd be grateful.
I'm writing a search facility for a site where the data is stored in
several tables - let's say 5 for this example - and I want
Chris Sansom wrote:
I'm sure there must be an accepted technique for this, but it's
something I haven't tried before, so if anyone can point me in the right
direction I'd be grateful.
I'm writing a search facility for a site where the data is stored in
several tables - let's say 5 for this
At 11:01 -0400 10/9/07, Baron Schwartz wrote:
I've built similar systems with a series of UNION queries. Each UNION has a
column for relevance, which can be a sum of CASE statements, such as
IF(name matches, 1, 0) + IF(text matches, 1, 0) AS relevance...
The entire UNION can then be ordered by
At 11:01 -0400 10/9/07, Baron Schwartz wrote:
The entire UNION can then be ordered by relevance. You could also
just add in an arbitrary number in each UNION, to get the effect of
ordering by where in the hierarchy the match is found.
Actually, your pointing me towards UNION may have done
Hello all,
I want to suggest one thing relating to MySQL Tools for 5.0(Administrator,
Query browser etc.) -
A new feature can be added to use command line options to synchronize
structure and data, data transfer in many formats and scheduling above tasks
on windows/linux and other OS.
If these
Hi MySQL'ers --
I run multiple HIPAA compliant databases and a lot of very secure patient
information in my MySQL databases.
However, I am a bit of a security phreak and want to go a step further and
encode the data INSIDE the database so that, in the very unlikely event that
someone can
Chris Sansom wrote:
At 11:01 -0400 10/9/07, Baron Schwartz wrote:
The entire UNION can then be ordered by relevance. You could also
just add in an arbitrary number in each UNION, to get the effect of
ordering by where in the hierarchy the match is found.
Actually, your pointing me towards
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 5.1.3 RC, a new release candidate of the Type-IV pure-Java
JDBC driver for MySQL has been released.
Version 5.1.3 is suitable for use with any MySQL version including MySQL-4.1,
MySQL-5.0, MySQL-5.1 beta or the MySQL-6.0
Hello,
I have a table, currently holding 128,978 rows... In this table, I have a
section column (int) and a price column (int). Every row has a section of 1
currently, every row has a price, ranging from 1 to 10,000.
I have an index on both columns separately.
Have a look at these two
Hi,
You can actually unpack them using some fairly cryptic stuff. I would
only use this to unpack them once to re-store them as INT. Here's an
example:
CREATE TABLE ip (packed CHAR(4));
INSERT INTO ip (packed) VALUES (0xB16212C);
mysql SELECT * FROM ip;
++
| packed |
++
|
Hi Chris,
Chris Hemmings wrote:
Hello,
I have a table, currently holding 128,978 rows... In this table, I have a
section column (int) and a price column (int). Every row has a section of 1
currently, every row has a price, ranging from 1 to 10,000.
I have an index on both columns
Jeremy Cole wrote:
Hi Chris,
Chris Hemmings wrote:
Hello,
I have a table, currently holding 128,978 rows... In this table, I
have a section column (int) and a price column (int). Every row has
a section of 1 currently, every row has a price, ranging from 1 to
10,000.
I have an index on
Chris, a couple of thoughts -
First, your index on the section is doing you no good (at this time) since
all the values are the same. You may already know that, but thought I'd
mention it.
Second, my theory on why query #1 is faster - if all your prices range from
1 up, and you're querying for
Dan Buettner wrote:
Chris, a couple of thoughts -
First, your index on the section is doing you no good (at this time) since
all the values are the same. You may already know that, but thought I'd
mention it.
Second, my theory on why query #1 is faster - if all your prices range from
1 up,
Hi Chris,
Chris Hemmings wrote:
Dan Buettner wrote:
Chris, a couple of thoughts -
First, your index on the section is doing you no good (at this time)
since
all the values are the same. You may already know that, but thought I'd
mention it.
Second, my theory on why query #1 is faster - if
Baron Schwartz wrote:
Hi Chris,
Chris Hemmings wrote:
Dan Buettner wrote:
Chris, a couple of thoughts -
First, your index on the section is doing you no good (at this time)
since
all the values are the same. You may already know that, but thought I'd
mention it.
Second, my theory on why
Hello Listies,
Given: MySQL 4.0.12, I need to implement a pageview log with a
resolution of 1 day.
I propose this table:
CREATE TABLE `pageviews` (
`id` int(11) NOT NULL auto_increment,
`date` date NOT NULL default '-00-00',
`url` char(120) NOT NULL default '',
`views` mediumint(9)
Thank you for your replies. I attempted to restore again and most
oddly, mysql complained that it couldn't restore to a particular
table because it wasn't in the database, which, of course, it had to
be because the restore itself had just recreated it. So I blew away
the entire mysql directory
Hi all,
Starting Wednesday night, we observed several weird errors indicative
of data corruption shortly before a CPU spike and complete crash on
our master db server (opera.oursite.com). opera.oursite.com had
crashed twice with signal 11 in recent weeks, but we had never
observed any data
You can do it as long as there is only a single record with the max
value. If there is more than 1 record with the same max value, there
isn't a single record to pull.
To do it, you would need to join on the results of the max query, and
part of the join condition would be the max value
I have two tables, one called RMAs and the other called rma_line_items. The
first one has the general details of the RMA (Return Merchandise
Authorization) , the second holds the details of each item being returned.
What I want is a listing of the RMA ids (which are unique in the RMAs table)
23 matches
Mail list logo