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 MySqld ended".
Does anyone know what the problem is ...??
Devang.
--
MySQL General Mailing List
F
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 '5b58234a5
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 colu
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 ar
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
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 \\.\PHYSICALDRIVE. Hard disk numbers st
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 Ağustos 2003 Perşembe 11:32:47
To: [EMAIL PROTECTED]
Subject: Re: PHP mysql_connect randomly failing
Antony
Hi Victoria,
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 logfile but ju
> 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
> becomin
-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 starti
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 st
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
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, 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 data
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 ...
http://www.mysql.com/d
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]
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, track
>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 Wed, Aug 20, 2003 at 03:08:59PM -0500, Tom O'Neill (MySQL User) wrote:
> Is there any difference in speed between the following select statements?
>
> SELECT yada,yda FROM test WHERE id IN(1,2,3)
>
> OR
>
> SELECT yada,yda FROM test WHERE (id =1 or id = 2 or id =3)
Often times, no.
But it
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 th
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
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 a
"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
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
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 Backu
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 com
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
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...
>
>
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:
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: htt
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 prob
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
| 03082
Ich bin vom 06.08.2003 bis 25.08.2003 außer Haus.
Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.
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 *
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 VARIA
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 connecti
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 preallocat
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 ...
http://www.mysql.com/d
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 space
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 a
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 mu
* 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
>
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
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 searchresult.t
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
101 - 145 of 145 matches
Mail list logo
