Re-sending... my mail client or server somehow mangled my original
message... sorry.
--
Hello,
We are having issues with one of our servers sometimes hanging up and when
attempting to shutdown the DB, we get "cannot
I know, all the shell command can do this. Thanks.
2010/8/25 Moon's Father
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will be
> big appreciated.
>
Hello,
We are having issues with one of our servers sometimes hanging up and when
attempting to shutdown the DB, we get "cannot create thread" errors.
This server has 6GB of RAM and no swap. According to some reasearch I was
doing I found this formula for calculating memory size:
key_buffer_s
How are you shutting down the server during the restart.. have you
checked the logs? Might you be issuing a kill and crashing it?
MyISAM doesnot dealwith crashes very elegantly.
Also, what is some reason? Might thereason you need to restart be related?
- michael dykman
On Tue, Aug 24, 2010
Hi.
For example, entering mysql command line client,
mysql> pager more ( or pager md5sum and so on.)
I want to know how many command the 'pager' follows? Any reply will be
big appreciated.
Hi List,
I have a very big size MyISAM table. For some reason I need to restart the
server periodically. But After restarting the server, the table always get
corrupt, and always need to run myisamchk. Don't know what cause the problem.
But it will be very helpful if somebody can give me some ti
Hello everyone!
I am using an MFC unicode project that uses ODBC to access a MySQL
5.1.50 database via the MySQL ODBC 5.1.6 driver.
character_set_connection is set to utf8 (Which I believe is the default
for the driver)
One of the tables contains two LONGBLOB columns, and the table default
charset
Hello everyone!
I am using an MFC unicode project that uses ODBC to access a MySQL
5.1.50 database via the MySQL ODBC 5.1.6 driver.
One of the tables contains two LONGBLOB columns, and the table default
charset is utf-8 (since the application is unicode).
However, when inserting into the LONGBLOB
On Tue, Aug 24, 2010 at 1:43 PM, Peter Brawley
wrote:
> >What I'm trying to accomplish is to order the results such that after
> >stacking the data for all results for a certain category, that the next
> >results to be stacked should be those whose parent = the former category,
> >then move on to
>What I'm trying to accomplish is to order the results such that after
>stacking the data for all results for a certain category, that the next
>results to be stacked should be those whose parent = the former category,
>then move on to the next category, etc. How do I do this?
It's a tree. See
ht
Hi;
I have the following query:
select * from spreadsheets s join products p on p.Item=s.Item join
categories c on p.Category=c.ID where s.Client=%s order by p.category,
c.parent;
mysql> describe products;
+-+--+--+-+-++
| Field | Type
Travis
Thanks for the response. Do you recommend I store the data in this way ?
Or should I look at storing in a separate leagues table, why by I list all
the data in the separate columns for each round and then just compute a
fairly basic query ? What is the recommend way ?
Cheers
Neil
On Tu
I think your match table has all the information necessary to display the
results you want. Since each record contains data for two teams (home and
away), you'd probably need to select each separately and union the results
together before summarizing. Your query might look something like the
foll
The proper way to do this would indeed be a separate table that has (itemID,
property, value) or something like that.
On Tue, Aug 24, 2010 at 4:04 PM, Tompkins Neil wrote:
> The application is still being developed, so I will probably look at
> storing it in separate tables so that it can easi
The application is still being developed, so I will probably look at storing
it in separate tables so that it can easily be computed.
On Tue, Aug 24, 2010 at 3:01 PM, Johan De Meersman wrote:
> Then you're pretty much on your own, I'm afraid. Not a very good way to
> store data :-)
>
> You could
Then you're pretty much on your own, I'm afraid. Not a very good way to
store data :-)
You could maybe build a stored procedure, or do it in the app; but it's
gonna be code either way.
On Tue, Aug 24, 2010 at 3:58 PM, Tompkins Neil wrote:
> Yeah these values are held with a varchar field.
>
>
>
Yeah these values are held with a varchar field.
On Tue, Aug 24, 2010 at 2:56 PM, Johan De Meersman wrote:
> If you're looking at the string "10,23,15,10" in a single field, you'll
> have to do it the hard way. If you have an int field, and four rows with
> those values, you can do a group by th
If you're looking at the string "10,23,15,10" in a single field, you'll have
to do it the hard way. If you have an int field, and four rows with those
values, you can do a group by that field and select the count() of it.
On Tue, Aug 24, 2010 at 3:53 PM, Tompkins Neil wrote:
> Hi
>
> In MySQL is
Hi
In MySQL is it possible to SUM a field which contains like 10,23,15,10. The
result I'd be looking for is
10 = count of 2
23 = count of 1
15 = count of 1
Cheers
Neil
Hi,
I wondered if anyone can offer me some help with regards the following issue
I'm having. Basically, I've the following table structure containing rows
of results between two football teams. The fields are
match_id
seasons_id
week_number
home_team_id
away_team_id
home_goals
away_goals
Based
20 matches
Mail list logo
