Hello all,
here is my problem:
I am trying to set mysql to unicode character, so that i can get my
dictionary application to look at words in Nepali.
here is my setting:
mysql charset: utf-8 unicode
when i make a new database:
mysql connection collation is utf8-general-ci
and my new database
Hi.
My hosting provider recommended me to optimize my 200,000 record table in
order to save resources.
I do _always_ this query:
SELECT * FROM books WHERE isbn='foo' LIMIT 1
The primary key of this table was 'id', and 'isbn' was and INDEX field.
I've modified this:
ALTER TABLE books DROP
On Sun, Apr 27, 2008 at 3:59 AM, Charles Lambach
[EMAIL PROTECTED] wrote:
I do _always_ this query:
SELECT * FROM books WHERE isbn='foo' LIMIT 1
The primary key of this table was 'id', and 'isbn' was and INDEX field.
This sentence could have been better written. If you have a primary
key
I have setup a mysql50 instance on a system where mysql4.0.20 already exists.
So that I can run both instances together, I setup a new user called
mysql50. The mysql50 files are owned by this mysql50 user and mysql50 is in
the path. I setup a link, /usr/local/mysql-5.0 which points to the mysql50
Hi,
I'm storing some ascii codes in a table. When I do a dump using mysqldump from
the server and then restoring it on another station, the ascii codes in the
table has changed.
But if i'm accessing the table from another station the code is good. Even if
I insert it from a station, it
Use my.cnf to point the data directory and the user details.
[mysqld]
user=mysql50
datadir=/home/mysql50
Saravanan
--- On Mon, 4/28/08, Mark-E [EMAIL PROTECTED] wrote:
From: Mark-E [EMAIL PROTECTED]
Subject: User Issue
To: mysql@lists.mysql.com
Date: Monday, April 28, 2008, 12:05 AM
I
Hi,
I'm configuring a PowerEdge 2950III, and trying to decide what will
provide the best bang-for-buck. The server will be used strictly as a
MySQL database server running atop Red Hat Linux. Two large databases,
each about 2GB, heavy on both Inserts and Selects.
Up until recently, I had
Okay, the previous subject was too narrow, what I am really looking
for are opinions on general disk/memory/cpu configurations,
manufacturer notwithstanding...
As stated previously, I'm configuring a PowerEdge 2950III, and trying
to decide what will provide the best bang-for-buck. The
I've created some improved templates and scripts for monitoring MySQL
servers with Cacti.
Overview:
http://www.xaprb.com/blog/2008/04/27/improved-cacti-monitoring-templates-for-mysql/
Homepage where you can help improve and maintain it more yourself (hint, hint):
So anyone had ever had any problem with database cache? :)
2008/4/25 Sergio Belkin [EMAIL PROTECTED]:
Hi, I am using zabbix (monitoring software) with mysql. zabbix goes
zombie and complains with messages suggesting that Database cache
perhaps is corrupted. How can I check and fix it? I am
Can you send us the exact zabbix error?
On Sun, Apr 27, 2008 at 6:18 PM, Sergio Belkin [EMAIL PROTECTED] wrote:
So anyone had ever had any problem with database cache? :)
2008/4/25 Sergio Belkin [EMAIL PROTECTED]:
Hi, I am using zabbix (monitoring software) with mysql. zabbix goes
11 matches
Mail list logo