I would run the DB on a RAMDisk
http://www.ibiblio.org/mdw/linuxfocus/English/November1999/article124.html
Anyone else?
Martin
- Original Message -
From: Kayra Otaner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 3:56 PM
Subject: MySQL 4.0.13 Memory problem
At 15:18 -0700 8/20/03, Michael S. Fischer wrote:
This is trivial to benchmark yourself. Try:
BENCHMARK(10, SELECT yada, yada FROM test WHERE id IN(1,2,3))
And compare to
BENCHMARK(10, SELECT yada,yda FROM test WHERE (id =1 or id = 2 or id
=3))
See
HI
from the command line run
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON database_name.*
TO [EMAIL PROTECTED]
IDENTIFIED BY 'password';
(you may want to give more restrictive privileges)
that should fix it - you don't have privileges set for the
At 17:00 -0300 8/20/03, Dyego Souza do Carmo wrote:
Hello guys !!!
I have MySQL/InnoDB on Windows 2000 and i want to create a RAW
PARTITION to use InnoDB tablespace...
In Linux the configurarion is:
innodb_data_file_path = /dev/hda1:32Gnewraw
innodb_data_home_dir =
and in Windows 2000
Paul DuBois [mailto:[EMAIL PROTECTED] writes:
At 15:18 -0700 8/20/03, Michael S. Fischer wrote:
This is trivial to benchmark yourself. Try:
BENCHMARK(10, SELECT yada, yada FROM test WHERE id IN(1,2,3))
And compare to
BENCHMARK(10, SELECT yada,yda FROM test WHERE (id =1 or
id
Hi MySQL Fans ;-),
This time I am using 4.0.13-max (tar format from www.mysql.com) on Redhat 9.
When I issue the command mysqlbinlog it does not show me the whole
binary logfile but just the first line or so (below).
mysqlbinlog baby-bumble-bee-bin.09
# at 4
#030814 14:38:17 server id 1
In the last episode (Aug 20), Dathan Vance Pattishall said:
I've notice that when grown defects (bad blocks on the disk caused by
usage over time) that my dedicated mysql server is adversely
effected.
Affected how? The grown defect list is usually reserved for blocks
that were discovered to
At 9:54 -0400 8/19/03, Luc Foisy wrote:
Would anything happen to the database if I ran myisamchk --silent
/usr/data/mysql/*/*.MYI when I havent run FLUSH TABLES first?
Yes, you may have unflushed changes still in the server's buffers.
Running myisamchk in that case can make the tables
In the last episode (Aug 20), Kayra Otaner said:
I want to get your opinions on how to increase available/free memory and
performance on a heavy volume database server.
I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using
same MySQL version.
Recently our master database
At 17:24 -0700 8/20/03, Michael S. Fischer wrote:
In a word, no. The way MySQL organizes its datafiles is trivial by
comparison: one directory per database, two files per table (table.MYI
and table.MYD), one is the datafile, the other is the index file. MySQL
also does not preallocate space for
Switching to another database isn't really an option. I didn't write the
package and I'm not good enough to port it to another database or to rewrite
it for a multiple machine architecture.
Probably the only non-RAID option I have (assuming I want to keep more than
3 months worth of data) would
bruce wrote:
Hi...
A mysql/Apache issue:
I get the following when I'm trying to run a test web site on an Apache
2.0/RH8.0 setup.
Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in
/var/www/html/dbid/mysql/database.php on line 17
I am setting up a dedicated MySQL server with some pretty heavy usage. I am
not much of a sys admin (mostly a programmer). I have some questions about
the best drive configuration.
I have 4 SCSI drives currently.
I would like to have 1 drive run the OS,
1 drive to be the MySQL data directory
I have this query which does a left outer join and it takes forever (like
half a day). Here are the results of an explain analysis.
mysql explain SELECT count(searchresult.title) AS number,
campaigntrack.title, tracknum, trackid FROM campaigntrack LEFT OUTER JOIN
searchresult ON
In my opinion, the discussion is moot.
Unless you're running MySQL in a read-only environment, you should never
restart the daemon automatically, because an improper shutdown is likely
to yield table corruption, and if the tables are corrupted, attempting
to write additional data can cause even
* Scott Haneda
What would be a good way to deal with the following...
I have a form that has 5 checkboxes on it, lets say the
checkboxes are for categories, and more than one can be
selected.
For example:
please tell is what brochure you want
[] car
[] boat
[] truck
[] SUV
[] beetle
It's quite possible you're using the wrong tool for the job. Since this
is a write-intensive environment, you may get better performance by
using another database such as PostgreSQL or Oracle. Alternatively,
consider the option of re-architecting the application to distribute the
writes across
The database does write the data to disk when an UPDATE or INSERT is
sent, but not synchronously. (IOW, it doesn't call fsync() after each
write.) So there is no guarantee that the data will be in the tables
when a power failure occurs. This is a tradeoff MySQL makes for speed
because it's not
Hi all,
I want to get your opinions on how to increase available/free memory and
performance on a heavy volume database server.
I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using same
MySQL version.
Recently our master database server (2 AMD Cpu + 2Gb memory + 2Gb swap
Jeremy Zawodny wrote:
On Tue, Aug 19, 2003 at 01:52:26PM -0700, Sanya Shaik wrote:
I am unable to find any information about master-master replication.
I need to replicate 1 mysql server over to other as a standby master
server.
It's named circular master-slave ...
In the last episode (Aug 20), Michael S. Fischer said:
In a word, no. The way MySQL organizes its datafiles is trivial by
comparison: one directory per database, two files per table (table.MYI
and table.MYD), one is the datafile, the other is the index file. MySQL
also does not preallocate
Keep in mind that Linux will allocate nearly all of its free RAM to the
buffer cache as the kernel opens and reads files to increase filesystem
performance (cat /proc/meminfo and look at the buffers row) So, lack
of free RAM may not mean what you think it means.
As for the too many
Hello MySQL Fans,
This time I am using 4.0.13-max (tar format from www.mysql.com) on
Redhat 9.
I have an understanding question why would the command SHOW VRAIABLES
give me once the real output and once the symlink ouput for directory
names ?
Sample (datadir and basedir) :
mysql SHOW
Thanks for the valuable tips
sanjay
- Original Message -
From: Rob A. Brahier [EMAIL PROTECTED]
To: Roger Baklund [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: sanjay gupta [EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 11:15 PM
Subject: RE: scroll problem
If you are using *nix, fire up
Ich bin vom 06.08.2003 bis 25.08.2003 außer Haus.
Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.
Check your ownerships and permissions.
On Thu, 21 Aug 2003 00:27:05 +0800, Jon Miller used a
few recycled electrons to form:
| I've tried moving the database from one partition to another and now I'm getting the
following error:
| # Starting mysqld daemon with databases from /data/mysql
|
On Wed, 20 Aug 2003 18:44:04 -0500, Miguel Perez used a
few recycled electrons to form:
|
| Hi list,
|
| Does any know how to do differential backups or does exist a tool
| that do this kind of backups.
|
| I have mysql 4.0.12 and use innodb tables, mysql is running on
| redhat 7.3
You are
That's not entirely correct. InnoDB currently supports a single tablespace
(comprised of multiple datafiles).
Heikki Tuuri (the developer and maintainer of InnoDB) also mentioned that
multiple-tablespace support might be in InnoDB this fall (September 2003
according to the TODO list at InnoDB:
Antony Dovgal wrote:
On Tue, 19 Aug 2003 14:36:15 -0700
Jon Drukman [EMAIL PROTECTED] wrote:
Approximately 1% of the time it just fails, for no stated reason:
Warning: mysql_connect() [http://www.php.net/function.mysql-connect]:
in /var/httpd/htdocs/pi/pi.php on line 3
mysql connect failed:
In linux it says it is untested. I don't think it is even an option for
windows yet.
-Jackson
On Wednesday 20 August 2003 3:00, Dyego Souza do Carmo wrote:
Hello guys !!!
I have MySQL/InnoDB on Windows 2000 and i want to create a RAW
PARTITION to use InnoDB tablespace...
In
On Wed, 20 Aug 2003 10:52:35 -0700
bruce [EMAIL PROTECTED] wrote:
I have added the mysql user/password to the php file. I can access mysql
using the user/password from the linux command line.
What login pass do you use in PHP and what login pass do you use in command line?
Hmm..let me guess:
it doesnt work i tried it, case of follow the sheep :D
Paul DuBois [mailto:[EMAIL PROTECTED] writes:
At 15:18 -0700 8/20/03, Michael S. Fischer wrote:
This is trivial to benchmark yourself. Try:
BENCHMARK(10, SELECT yada, yada FROM test WHERE id IN(1,2,3))
And compare to
On 2003-08-20, Miguel Perez wrote:
Hi list,
Does any know how to do differential backups or does exist a tool
that do this kind of backups.
I have mysql 4.0.12 and use innodb tables, mysql is running on
redhat 7.3
Hi Miguel,
take a look in the MySQL manual 4.4.1 Database Backups:
Hi everyone,
Is there any easy way to duplicate a row in a table with auto increment
column, that shouldn't of course be copied. I tried a query NSERT INTO
table SELECT * FROM table but it caused an error due to the auto
increment column. I succeeded with listing all required fields in the
query,
Nils Valentin [EMAIL PROTECTED] wrote:
This time I am using 4.0.13-max (tar format from www.mysql.com) on Redhat 9.
When I issue the command mysqlbinlog it does not show me the whole
binary logfile but just the first line or so (below).
mysqlbinlog baby-bumble-bee-bin.09
# at 4
Jack Coxen wrote:
I had originally planned to use syntax similar to:
DELETE * FROM table_name WHERE `dtime` [90 days ago]
delete * from table_name where to_days(now())-to_days(dtime) 90
After the DELETE runs, I plan on running MYISAMCHK on the affected table.
Then I'll repeat both steps for
gord barq wrote:
I have this query which does a left outer join and it takes forever
(like half a day). Here are the results of an explain analysis.
mysql explain SELECT count(searchresult.title) AS number,
campaigntrack.title, tracknum, trackid FROM campaigntrack LEFT OUTER
JOIN searchresult
Jackson Miller wrote:
I am setting up a dedicated MySQL server with some pretty heavy usage. I am
not much of a sys admin (mostly a programmer). I have some questions about
the best drive configuration.
I have 4 SCSI drives currently.
I would like to have 1 drive run the OS,
1 drive to be
Description:
We're running our current TTS application with MySQL (on Unix). All database,
table and column names are in lower-case. However, we need to access this
database with a new application which (for some reason) converts all
table and column names in its SELECT statements to uppercase.
On Thu, Aug 21, 2003 at 01:03:16AM +, gord barq wrote:
I have this query which does a left outer join and it takes forever (like
half a day). Here are the results of an explain analysis.
mysql explain SELECT count(searchresult.title) AS number,
campaigntrack.title, tracknum, trackid
Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html
Saqib Ali
-
http://www.xml-dev.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jeremy Zawodny wrote:
On Tue, Aug 19, 2003 at 01:52:26PM -0700, Sanya Shaik wrote:
I am unable to find any information about master-master replication.
I need to replicate 1 mysql server over to other as a standby master
server.
It's named circular master-slave ...
On Wed, Aug 20, 2003 at 10:41:54PM -0500, Dan Nelson wrote:
In the last episode (Aug 20), Michael S. Fischer said:
In a word, no. The way MySQL organizes its datafiles is trivial by
comparison: one directory per database, two files per table (table.MYI
and table.MYD), one is the datafile,
VR What is the output of SHOW GRANTS for the users that can show list of all
databases?
Here it is:
Grants for [EMAIL PROTECTED]
GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
'guru'@'localhost' IDENTIFIED BY PASSWORD '5b58234a58cd6a22'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP,
On Wed, 20 Aug 2003 21:31:48 -0700
Jon Drukman [EMAIL PROTECTED] wrote:
mysql_error is not set when mysql_connect fails, because there is no
actual mysql resource to get the error message from.
yes, there is no mysql resource at this moment.
just don't specify it and mysql_error() will tell
My company has an opening for a senior DB engineer with a strong development
background and would like to make it available to the list. Development experience
with MySQL is a plus.
Some background ... The company is a well-funded early stage startup and currently
generating revenue. It was
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 20 Aug 2003, Adam Nelson wrote:
We were affected by the power outage last week and I think people should
be aware - I'm not sure if it's fixed (I'm virtually certain it is not),
but the default rpm install of 4.0.12 has mysql starting
I've notice that when grown defects (bad blocks on the disk caused by
usage over time) that my dedicated mysql server is adversely effected.
Since the action of Grown defects does not flush the table with a write
lock-that the block marked as bad will effect prior to that block
becoming a
Hi Victoria,
2003 8 21 16:09Victoria Reznichenko :
Nils Valentin [EMAIL PROTECTED] wrote:
This time I am using 4.0.13-max (tar format from www.mysql.com) on Redhat
9.
When I issue the command mysqlbinlog it does not show me the whole
binary logfile but just the first line or so
If you reach to maximum mysql connection limit or link limit, mysql_connect will fail.
Check limits and current fullness.
---Original Message---
From: Jon Drukman
Date: 21 Austos 2003 Perembe 11:32:47
To: [EMAIL PROTECTED]
Subject: Re: PHP mysql_connect randomly failing
Antony
Dyego,
I have tested raw partitions in Windows, and others have tested them in
Linux.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/base/createfile.asp
When opening a physical drive, x, the lpFileName string should be of the
form \\.\PHYSICALDRIVEx. Hard disk numbers
bruce wrote:
We have the following setup in our httpd.conf file. We've tried to
give what's related to the issue. We're trying to set up a virtual
host for a test project. The behavior that we're seeing is that we
can type:
http://foo.com but the url that gets displayed is
http://12.x.x.x
hi Nils!
can u show me how to change the long_query_time
using sql statement or by using mysqladmin.
the set long_query_time=xyz; does not work or is this
a valid command.
i am using mysql 3.23.52
--- Nils Valentin [EMAIL PROTECTED] wrote: Hi
Prem,
Which version are you
Hans Maurer [EMAIL PROTECTED] wrote:
Description:
We're running our current TTS application with MySQL (on Unix). All database,
table and column names are in lower-case. However, we need to access this
database with a new application which (for some reason) converts all
table and column
Vladimir Trebicky [EMAIL PROTECTED] wrote:
VR What is the output of SHOW GRANTS for the users that can show list of all
databases?
Here it is:
Grants for [EMAIL PROTECTED]
GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
'guru'@'localhost' IDENTIFIED BY PASSWORD '5b58234a58cd6a22'
Hi,
I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website.
I have installed it on Mac OS X 10.1.3.
When i am starting the MySql, it starts and ends with the message
030821 time MySqld ended.
Does anyone know what the problem is ...??
Devang.
--
MySQL General Mailing
Nils Valentin [EMAIL PROTECTED] wrote:
2003? 8? 21? ??? 16:09?Victoria Reznichenko :
Nils Valentin [EMAIL PROTECTED] wrote:
This time I am using 4.0.13-max (tar format from www.mysql.com) on Redhat
9.
When I issue the command mysqlbinlog it does not show me the whole
binary
VR User has some privileges on the global level (CREATE
VR TEMPORARY TABLES, LOCK TABLES). That is why user can see list of
VR all databases.
All right! :) It works, thanks! :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Ich bin vom 08.08.2003 bis 24.08.2003 außer Haus.
Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.
Hi,
i'm struggling with updating session expire times in my login table.
Can you tell me, how to correctly add an amount of seconds (after that
the session expires) to a datetime field?
when i do the insert for a new login, or an update, the expire field
will alway end up containing zeros
Ich bin vom 15.08.2003 bis 01.09.2003 außer Haus.
Ich werde Ihre Nachrichten nach meiner Rückkehr beantworten.
Während dieser Zeit erreichen Sie meine Vertretung Fr. Renate Trummer unter:
Tel. 0316/8056-514
Fax 0316/8056-400
E-Mail [EMAIL PROTECTED]
Just a quick note to Ed and Amer,
You two were right on, with this. I took the plunge and re-thought my db as
you both suggested. Sage advice, as successive queries and relationships
have been much easier to achieve with the new allocation table. It's clear
to see that this method also will offer
- Original Message -
From: Jon Drukman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 9:28 PM
Subject: [EMAIL PROTECTED] Re: apache/mysql errors
grant select on *.* to [EMAIL PROTECTED] identified by 'yourpasswordhere';
[...]
you
Hi,
I've created some fulltext indexes and would like to
know the size in bytes of each one.
Someone would please help me on that?
Thanks in advance!
Cleber Melo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Devang Panchalia [EMAIL PROTECTED] wrote:
Hi,
I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website.
I have installed it on Mac OS X 10.1.3.
When i am starting the MySql, it starts and ends with the message
030821 time MySqld ended.
Does anyone know what the problem is
It may be that you did not give the mysql user ownership of the Data
folder?
Check your permissions first by typing:
[KieranMac:~] kieran% ls -al /usr/local/mysql/
this shold show data folder as something like this:
drwxr-x--- 13 mysql wheel 442 Aug 19 19:52 data
Type this on the
M. Bader wrote:
Hi,
i'm struggling with updating session expire times in my login table.
Can you tell me, how to correctly add an amount of seconds (after that
the session expires) to a datetime field?
when i do the insert for a new login, or an update, the expire field
will alway end up
Hi,
You're adding 2 different type elements.
Try just doing
SELECT NOW() + SEC_TO_TIME(6000);
and check the result:
mysql select NOW() + sec_to_time(6000);
+---+
| NOW() + sec_to_time(6000) |
+---+
|20030821159528 |
Hi Victoria,
2003 8 21 20:20Victoria Reznichenko :
Nils Valentin [EMAIL PROTECTED] wrote:
2003? 8? 21? ??? 16:09?Victoria Reznichenko :
Nils Valentin [EMAIL PROTECTED] wrote:
This time I am using 4.0.13-max (tar format from www.mysql.com) on
Redhat 9.
When I issue the
This is my differential backup script. I've put it into cron so it runs
every hour automatically. I've a master sql dump files in
'/master/DBNAME' and I compare this file to the most recent dump and
calculate diff.
Basically it mysqldumps database without buffering (-q), by adding ' to
table and
I like using either raid 0+1.. it really cooks, or if you can'y spare the
disks, raid 1 ...Something pushing that many queries, should probably
be protected from disk failure.
On Wed, 20 Aug 2003, Jackson Miller wrote:
I am setting up a dedicated MySQL server with some pretty heavy usage.
I'm struggling with speed issues on some queries that
I would have expected to be relatively fast. Perhaps
even more frustratingly, when I've tried to break
these down into their components, they still execute
very slowly. I've looked over all the relevant suggestions
for optimization and so
Jackson,
Jackson Miller [EMAIL PROTECTED] writes:
I have 4 SCSI drives currently.
Well, is you want Redundancy you don't have a choice. Mirror them. 2x 2
drives.
You might want to put OS and write-ahead-log on one and
InnoDB/MyISAM-data on the other.
I would like to have 1 drive run the
I have a concatenation problem and I was wondering if somebody might be
able to offer some help :-)
I have the following table structure holding product long descriptions:
Part No (pn)Sequence (seq) Long Description (long_desc)
--- ---
On Thu, Aug 21, 2003 at 11:34:00AM -0400, Jesse Sheidlower wrote:
I'm struggling with speed issues on some queries that
I would have expected to be relatively fast. Perhaps
even more frustratingly, when I've tried to break
these down into their components, they still execute
very slowly.
I am sure if it's possible to do that, but I want to use mysqldump to backup
my databases. However, there is only one large table I want to exclude. Can
this be easily done?
Thanks.
Jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Thursday 21 August 2003 2:23, Jon Drukman wrote:
if you're mostly running SELECTs then i would recommend a mirrored
configuration.
I would say I am running about %50 SELECTS, 30% UPDATE, 20% INSERT. However I
don't know how to find that out for sure.
Would that affect how I set up the
What is the value of sort_buffer_size, may be you could increase the value for
having faster ORDER BY (all in memory intead of using temporary file on disk).
Marc.
-Message d'origine-
De : Jesse Sheidlower [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 21 août 2003 17:34
À : [EMAIL PROTECTED]
Jesse Sheidlower wrote:
I'm struggling with speed issues on some queries that
I would have expected to be relatively fast. Perhaps
even more frustratingly, when I've tried to break
these down into their components, they still execute
very slowly. I've looked over all the relevant suggestions
for
Dear Friends
i´ve just download mysql 4.0.14
where i can find an mysqlclient.lib for borland c++compilers, the one on
windows download page is for version 3.23.xx
Regards
Luiz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Ich bin vom 05.08.2003 bis 28.08.2003 außer Haus.
Ich bin vom 06.08.03 bis einschließlich 28.08.03 auf Urlaub.
In dringenden Fällen wenden Sie sich bitte an meine Kollegen in der MPS.
Frau Juric, DW 212
Frau Sommer,DW 631
Herr Zwischenbrugger, DW 635
Herr Kessler, DW 217
Ab 28.08.03 stehe ich
* Nick Heppleston
I have a concatenation problem and I was wondering if somebody might be
able to offer some help :-)
I can try. :)
I have the following table structure holding product long descriptions:
Part No (pn)Sequence (seq) Long Description (long_desc)
---
Hi again,
From: Diana Soares [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 4:05 PM
| NOW() + sec_to_time(6000) |
That i allready tried, and it's leading to wrong results,
as same as
From: Cybot [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 3:42 PM
UPDATE
* Roger Baklund
[...]
SET @a=;
SELECT @a:=CONCAT(@a,' ',long_desc) FROM YourTable;
SELECT @a;
Sorry, my test table only contained records for a single product... you
would need something like this:
SELECT @a:=CONCAT(@a,' ',long_desc)
FROM YourTable
WHERE pn = HL1450
ORDER BY seq;
I
I say go with RAID 5, on a controller card.
Mirroring just gives you backup, and you lose half your diskspace. It offers
no performance benefit, and actually the computer might have to work harder
to make sure the drives are in sync.
Disk striping makes things *fast*, BUT THERE IS NO PROTECTION.
[already posted to mailing.database.mysql newsgroup but not to list; sorry
for cross-post]
I found a way to do this before, but I didn't write down how I did it, so I
don't remember it now. And I've searched http://www.mysql.com/doc/ in
vain.
What's the command to show all current locks on a
On Thu, Aug 21, 2003 at 05:59:54PM +0200, Mechain Marc wrote:
What is the value of sort_buffer_size, may be you could
increase the value for having faster ORDER BY (all in memory
intead of using temporary file on disk).
I had previously tried that--I sometimes have big GROUP BY
queries as
Group,
I have been working with Mysql for about 5 years - mainly in LAMP shops. The
tables have been between 20-100 thousand records size. Now I have a project
where the tables are in the millions of records.
This is very new to me and I am noticing that my queries are really
sloww!
What
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000) is about
2,000 records per hour. We're running on the following:
P4 (1.5 Ghz),
Ich bin vom 13.08.2003 bis 08.09.2003 außer Haus.
Ich werde Ihre Nachrichten nach meiner Rückkehr beantworten.
3Ware makes reasonably priced ATA and SATA RAID-5 cards (IDE, not SCSI). You
can get hot-swappable enclosures so that when a drive fails, you swap it
without shutting down the machine.
We are gradually adding this hardware to our webservers, etc so that we
don't have to rebuild them when a drive
On Thu, Aug 21, 2003 at 03:30:11PM +, Nick Heppleston wrote:
I have a concatenation problem and I was wondering if somebody might be
able to offer some help :-)
Hi Nick,
Your problem is a formatting problem, not a concatenation problem; i.e.
SQL concatenation wasn't intended to solve
* Creigh Shank
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000)
is about
2,000 records per hour. We're running on the following:
If you read http://www.mysql.com/doc/en/Maintenance_regimen.html they say something
interesting that would contracdict other places in the documentation
They actually recomend running myisamchk on a running instance of mysqld. The method
on that page (a method they use themselves) would not even
At 01:02 PM 8/21/2003, you wrote:
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000) is about
2,000 records per hour. We're running
Luc Foisy unknowingly asked us:
Would anything happen to the database if I ran myisamchk --silent /usr/data/mysql/*/*.MYI when I havent run FLUSH TABLES first?
As it states in the documentation:
If mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and ensure that no
At 14:37 -0400 8/21/03, Luc Foisy wrote:
If you read http://www.mysql.com/doc/en/Maintenance_regimen.html
they say something interesting that would contracdict other places
in the documentation
They actually recomend running myisamchk on a running instance of
mysqld. The method on that page (a
On Thu, Aug 21, 2003 at 06:01:31PM +0200, Cybot wrote:
Jesse Sheidlower wrote:
I'm struggling with speed issues on some queries that
I would have expected to be relatively fast. Perhaps
even more frustratingly, when I've tried to break
these down into their components, they still execute
Roger Baklund unknowingly asked us:
What would be a good way to deal with the following...
I have a form that has 5 checkboxes on it, lets say the
checkboxes are for categories, and more than one can be
selected.
For example:
please tell is what brochure you want
[] car
[] boat
[] truck
[] SUV
Hi,
I need to change the stop word file used by the MySQL in fulltext seach.
The documentation (www.mysql.com/doc/en/Fulltext_Fine-tuning.html)
explains how to inform to MySQL the new stop word file through the
ft_stopword_file variable.
But I could not find any reference to the layout of this
1 - 100 of 154 matches
Mail list logo