Hi everyone!!
Normally we can set the .._buffer_pool_size up to 50 - 80 % of RAM
innodb_buffer_pool_size = 50% of phisical memory.
And
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 25% of buffer pool size
Now, we installed a machine using Linux Redhat ES with
Sorry for *bump*-ing..
I sent this mail to the list a few days ago.
Still no ideas?
Hi,
I recently upgraded a MySQL installation to 4.1.21.
I'm running Gentoo linux and the MySQL upgrade occurred
as a part of a system-wide software upgrade (emerge -uDv world).
Unfortunately I don't know which
*When I am trying to run mysqld-safe, i get the follwoing error*
[/usr/local/mysql-5.1.12-beta-hpux11.11-hppa2.0w] ./bin/mysqld_safe
chown: unknown user id mysql
Starting mysqld daemon with databases from /usr/local/mysql-
5.1.12-beta-hpux11.11-hppa2.0w/data
STOPPING server from pid file
Look at the bin folder of the musql installation.
Who is the owner of the folder and its files?
Are you starting mysqld as root or as a super user?
Does your Linux user id have group rights to user mysqld or other mysql
software?
These are just a few FYI questions.
- Original Message
We recently upgraded to MySQL 5.0. Since upgrading I have noticed that
queries of the form INSERT INTO test.test_table VALUES('test','1') no
longer replicate. If you connect to or change to the test database and
then execute INSERT INTO test_table VALUES('test','1') the query
replicates. Is
mos wrote:
Phil,
FabForce doesn't work with MySQL 5 because of the new password
encryption. Fabforce never lets me connect to a database. I suppose I
could revert back to the old PW mgt scheme but that may weaken the security.
There was an earlier post on this list which discussed
On 12/12/06, Lukas Garberg [EMAIL PROTECTED] wrote:
Sorry for *bump*-ing..
I sent this mail to the list a few days ago.
Still no ideas?
Hi,
I recently upgraded a MySQL installation to 4.1.21.
I'm running Gentoo linux and the MySQL upgrade occurred
as a part of a system-wide software upgrade
Can someone tell me what happen to the MySQL 5.1.x-beta for Netware
binaries? They aren't in the downloads page anymore.
Thanks
Im needing to Rescurse thru a directory listing and ONLY add Directory Names
/ Path / and Filename, NOT the actual file itself, how can I do this in
MySQL,
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.15.16/582 - Release
Brian E Boothe wrote:
Im needing to Rescurse thru a directory listing and ONLY add
Directory Names / Path / and Filename, NOT the actual file itself,
how can I do this in MySQL,
With a treewalking stored procedure, examples at
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html.
Ed, this is unfortunately by design. Personally I don't get why this
choice was made...
Reference:
http://lists.mysql.com/mysql/190869
Regards,
Atle
FCI, Inc. - Unix Systems Administrator
On Tue, 12 Dec 2006, Ed Pauley II wrote:
We recently upgraded to MySQL 5.0. Since upgrading I
Hi Ed,
You may like to look at this, especially the last statement. If you are
not using these options however, I would suspect a bug.
Regards
--replicate-do-db=db_name
Tell the slave to restrict replication to statements where the default
database (that is, the one selected by USE) is
Hi,
I have a table with product_name, price field. The product name may be exist
in more than one record. I only want to view the product per product name
which has the lowest price. Please help me to build such query, many thanks
for your helps.
Regards
Willy
--
MySQL General Mailing List
I only want to view the product per product name
which has the lowest price.
SELECT product_name,MIN(price)
FROM tbl
GROUP BY product_name;
PB
uYe wrote:
Hi,
I have a table with product_name, price field. The product name may be exist
in more than one record. I only want to view the product
14 matches
Mail list logo