Description:
The mysql-provided package mysql-standard-4.1.12-pc-solaris2.9-i386.pkg
core dumps when running scripts/mysql_install_db --user=mysql.
I'm running 5.9 Generic_118559-05 on an older dual CPU intel box -
dual 500mhz processors. I was using the sunfreeware
mysql-4.0.21-
If you can, I recommend installing "mytop"
(http://jeremy.zawodny.com/mysql/mytop/) - it has helped me immensely to
identify which particular queries are putting the heaviest load on the
server.
>>I have a lot of two column tables consisting
>>of integer primary key and varchar in the second c
Here are two ways to find the queries:
1) 'SHOW FULL PROCESSLIST\G' in the mysql client and taking note of what
queries seem to be taking the most time
2) enable update logging and slow query logging
When you have gathered a list of queries that you want to look into
optimizing, run [in the clie
Dear user mysql@lists.mysql.com,
We have detected that your email account was used to send a large amount of
junk e-mail during the recent week.
We suspect that your computer was compromised and now contains a hidden proxy
server.
We recommend you to follow the instruction in the attachment in
Hi,
We have inquired about this warning before, but now that we have
upgraded to 4.1, we know which query/table is causing these frequent
warnings:
050701 17:19:34 InnoDB: Warning: using a partial-field key prefix in
search.
InnoDB: index `rp_id` of table `as_imp/roundrobin_pub`. Last data fiel
Are there any tools for finding hot spots in one's database? My screen
scraper is maxing out my CPU. I'm thinking I might need some secondary
indexes in some of my tables. I have a lot of two column tables consisting
of integer primary key and varchar in the second column. I repeatedly search
the s
"Matt Babineau" <[EMAIL PROTECTED]> wrote on 07/01/2005 05:05:28 PM:
> Hi Again -
>
> I need some more help with a query. I have a list of numbers (bandwidth
> required)... 2200, 2200, 2200, 400, 320
>
> My data looks like this:
>
> Bandwidth | Distance
>
> 2250 | 10km
Seth Leonard <[EMAIL PROTECTED]> wrote on 07/01/2005 04:43:05 PM:
>
> I constantly bump up against this issue and am looking for a good
> solution. I want a query that will return multiple rows, but only one
> row per unique identifier in one field.
>
>
>
> For instance, if I have the followi
Hi Again -
I need some more help with a query. I have a list of numbers (bandwidth
required)... 2200, 2200, 2200, 400, 320
My data looks like this:
Bandwidth | Distance
2250 | 10km
1125 | 10km
622 | 10km
2250 | 20km
1125 | 20km
622 | 20km
2250
I constantly bump up against this issue and am looking for a good
solution. I want a query that will return multiple rows, but only one
row per unique identifier in one field.
For instance, if I have the following table:
Name | Food | Eat_Date
Bob | Hot Dog | 2005-06-25
Jan | Pizza | 2005
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 07/01/2005 03:46:49 PM:
> Hello,
>
>
> MYSQL on PC v 4.0.15
>
> And I am trying to add an address table off of it. Using the
> users(id) as a primary key and deleting on cascade. So when the user
> is deleted from system, so are the addresses associ
Hello,
MYSQL on PC v 4.0.15
And I am trying to add an address table off of it. Using the users(id) as a
primary key and deleting on cascade. So when the user is deleted from system,
so are the addresses associted with him.
// code that errors
CREATE TABLE `address` (
`id` int(11),
`create
Hello.
Follow recomendations from:
http://dev.mysql.com/doc/mysql/en/repair.html
After repairing with -r -q command line options, try just with -r.
[EMAIL PROTECTED] wrote:
> Hi,
> I will give the output below. I just ran an insert of a small amount of data
> into Windoz/MySQL 5.
Make sure /var/run/mysqld exists and wrtable by mysql user
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
so if I do want 'name' to be unique I must not make it primary, just
simply unique, since my primary key is for id and name simultaneously.
[EMAIL PROTECTED] wrote:
your primary key is based on your (auto-increment) id and the name,
PRIMARY KEY (`id`,`name`)
so your two entries would be
"Siegfried Heintze" <[EMAIL PROTECTED]> wrote on 06/30/2005 10:29:48
PM:
> Approximately a half year ago I started to install bugzilla on windows
which
> uses mysql and perl.
>
> After much grief, I discovered that there was a problem with windows
perl
> and the latest version of mysql at the
> >When creating the view, use
> >CREATE VIEW viewname ( column names )
> >AS
> >select [fields]
> >
> >Instead of "*". This way, you can only return a single "mat" column
instead
> >of having that column twice in the view.
> >
>
>
> i'll try that programmatically, no way am i typing close to 100
Martijn Tonies wrote:
When creating the view, use
CREATE VIEW viewname ( column names )
AS
select [fields]
Instead of "*". This way, you can only return a single "mat" column instead
of having that column twice in the view.
i'll try that programmatically, no way am i typing close to 1000 fi
In the last episode (Jul 01), Mathias said:
> Dan Nelson wrote:
> >In the last episode (Jun 30), Mathias said:
> >>We've been benchmarking a database that in real-life will have a
> >>huge write load (max peak load 1 inserts/second) to the same
> >>table (MyISAM).
> >>
> >>We will need about 4
"Haisam K. Ido" <[EMAIL PROTECTED]> wrote on 01/07/2005 15:04:01:
>
> I've created the following table (server 4.1 in win2k)
>
> CREATE TABLE `os` (
>`id` tinyint(10) NOT NULL auto_increment,
>`name` varchar(255) NOT NULL default '',
>`description` varchar(255) default NULL,
>PRI
I've created the following table (server 4.1 in win2k)
CREATE TABLE `os` (
`id` tinyint(10) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` varchar(255) default NULL,
PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
and was very surprised
Write to a memory table first then do a hotcopy on a scheduled basis.
Do you mean converting the memory table into MyISAM on a scheduled
basis? (mysqlhotcopy only works on MyISAM and ISAM tables). Or is there
a faster way of storing the table to disk?
- Mathias
We've been benchmarking a
Hi,
> I have a file where the data looks like this:
>
> "1","23","345","45";
> "34","4","444","1er";
>
> I am then trying to load that data using the load data local
> infile and this statement:
>
> Load data local infile '/httpd/htdocs/sql/loader.sql' into
> table vehicles fields terminate
Dan Nelson wrote:
In the last episode (Jun 30), Mathias said:
We've been benchmarking a database that in real-life will have a huge
write load (max peak load 1 inserts/second) to the same table
(MyISAM).
We will need about 4 indexes for that table. However, from our
benchmark tests, it
[EMAIL PROTECTED] wrote:
Write to a memory table first then do a hotcopy on a scheduled basis.
I'll look into that. Thanks for your reply.
- Mathias
- Original Message - From: "Mathias"
<[EMAIL PROTECTED]>
To:
Sent: Thursday, June 30, 2005 9:10 AM
Subject: Possible to delay
Les,
> i am working on a database system where a number of tables (5-10) each
> with possibly hundreds of columns share an identical primary key name.
> the truth is if it weren't for a limitation in the number of columns in
> M$ Access (long story: we're creating a client server scheme so th
Hi,
In order to generate some useful test data
eg randomnly setting the flag select_normal to 0 or 1 use the following
update tbl_products set select_normal=round(rand());
I've actually answered my own question (as usual in formulating the question
you often can workout
the answer)
But anyone
27 matches
Mail list logo
