wangxu wrote:
>Can i get a technology standard?
>
>It include database capability,table capability,row number limit in table,blob
>object capability etc...
>
Hi,
A good read of the manual at
http://dev.mysql.com/doc/refman/5.0/en/index.html would give you almost
all of the information that you r
Hi Mysql Users,
Have not used mysql for years and was trying to install new version.
Error = Package failed due to
Coreutils and tibpthread.so.0 not installed.
How do I fix this problem?? Thanks in advace.
As I said it will tack me a few days to get back up to speed.
Andrew
Can i get a technology standard?
It include database capability,table capability,row number limit in table,blob
object capability etc
Where are your .frm files, are you not including them in your directory
listing or are they missing? If they're missing, that's most likely your
problem right there.. :)
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Wed, 4 Jan 2006, Simon Faulkner wrote:
> An old server died during
Hi James,
I have found similar - slowdown - effects for queries.
However, it is not always clear what causes the lack of speed.
For example, I have a table with more than 9 million rows,
including a non-unique indexed item myKey (tinyint).
The query "Select myKey, count(*) from myTable Group By my
firstly,I don't use utf8,then maybe this will help you,first dump out your in
sql form,then find a mysql 4.1 with phpmyadmin 2.5* computer,or make one,then
deploy your sql in the latin mode,then dump out it again,redeploy it on your
web host,i think it will do,and no matter how you modify phpmya
Hi,
The error message (errno: 13) indicates a permissions problem. Check the
permissions of the user that is running the backups or, alternatively,
check the permissions that are set for this file.
Regards
---
** _/ ***
Follow is my preform and result:
-
mysql> backup table ht_detail to '/';
+++--+--+
| Table | Op | Msg_type | Msg_text |
+-
Hey,
As per you config in my.cnf there has to be two logs
> log_error = /var/log/mysql_error.log
> log-slow-queries = /var/log/mysql_slow_queries.log
We have to have that info in error log to hunt down the issue. Also if
possible obtain the messages from /var/log/messages (these are kern
Chris Guo wrote:
Chris,
We are using mysql as backend database for one of the application in our
company server, and there are too many data in the Mysql database. So I
wonder how I create a database on different location.
How do you define too much data in the MySQL database?
Do you want to
What is it you are looking for in the application? I use DBVisualizer free
version for most of my mysql and oracle use. You can give it a try and see
if you like it or not.
On 1/2/06, Dan Rossi <[EMAIL PROTECTED]> wrote:
>
> Hi there i am looking for an alternative gui app than navicat for osx.
>
If you are knowledgeable about the application and know which tables are
frequently accessed during the time of crash, you can send the create
statements used to create those tables. Also any indexing and how many rows
are in the table will also help.
In my opinion over a hundred tables for an app
Thanks, but I don't think replace will help me, since my time_sec
column is not DATE. Here's the table def (well, the part that matters):
CREATE TABLE history (
id int(10) unsigned NOT NULL auto_increment,
time_sec int(10) unsigned NOT NULL default '0',
time_msec smallint(5) unsigned NOT
Try this
SELECT replace(left(history.time_sec,7),'-','') AS month
FROM history
WHERE history.account_id = 216
GROUP BY month
ORDER BY history.time_sec DESC;
This is what I get on 1 of my tables with no index on perm_user_ID , 80,000
rows in the table and 7,000 rows where perm_user_ID = '
I have entries in my slow query log for identical queries but, as you can see
from the log entries below (including one irrelevant query), the number rows
examined and returned varies. The tables are _not_ being updated.
The query cache is 'on demand', so I'm also not sure why the subsequent que
Thanks Peter, for the quick reply.
>>> Peter Brawley <[EMAIL PROTECTED]> 1/4/06 11:44 AM >>>
Ed,
>Can someone tell me why this fails? I'm using v4.1.11
>Select IF(((Select 1+1) <> Null) and ((Select 1+1) <> 0), (Select 1+1),
>'WRONG')
>I would expect a result of 2.
NULL is neither equal nor un
I have a query that takes a long time even though it is only examining the
index file. Is this normal? I would have thought that MySQL would be much
quicker to get the unique values from an index.
select distinct date_id from data_table;
# returns 89 rows in 23 seconds
- simple index on date_i
Hello,
I have a table called (history) containing thousands of rows. Each
row is UNIX time-stamped, and belong to a particular account.
I would like to know which months a particular account has been
active. (For example, maybe one account has been active since June
2004, so the SELECT shou
RE: Calendar table workaround>
>A table of dates to which to join other tables,
>ensuring reports that reflect days for which no
>data is available.
I forget the query but I know it can be done. But can't you just have a table
(called calendar?) with each entry having it's own row with a date co
The explain resuts were from on the mac.
I knew about the where clause optimization but that
wouldn't explain why the server crashes when I issue
the update statement. It is an interesting situation
however.
I agree that you're probably correct about the
import/CHECK TABLES.
Cheers,
Tripp
---
Jonathan,
I understand what you mean by a calendar table, but like Rhino I've no
idea
what you're asking. How to link the calendar table to other tables
depends on
your other tables. For a fairly simple & generic example of a
calendar table see http://www.artfulsoftware.com/queries.php#20.
Ed,
>Can someone tell me why this fails? I'm using v4.1.11
>Select IF(((Select 1+1) <> Null) and ((Select 1+1) <>
0), (Select 1+1), 'WRONG')
>I would expect a result of 2.
NULL is neither equal nor unequal to anything including itself.
To get the result you expect, write
Select IF(((Selec
> I have no idea what you are asking, which may explain why no one has
replied
> to your question yet.
>
> I've been working with relational databases for 20 years and I've never
> heard the term "calendar table". What are you trying to accomplish? If you
> describe clearly what you are trying to d
Your import or CHECK TABLE sound like your best bets.
Interesting about your SELECT statement conversion though, under the
optimization section, it suggests you may still have a problem. Can you
run your "EXPLAIN SELECT" on your MAC for comparison?
7.2.4. How MySQL Optimizes WHERE Clauses
Early d
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Sent: Wednesday, January 04, 2006 1:25 PM
Subject: Re: Calendar table workaround
>
> - Original Message -
> From: "Jonathan Mangin" <[EMAIL PROTECTED]>
> To:
> Sent: Wednesday, Jan
Can someone tell me why this fails? I'm using v4.1.11
Select IF(((Select 1+1) <> Null) and ((Select 1+1) <> 0), (Select 1+1), 'WRONG')
I would expect a result of 2.
- Thanks
Oops, I meant to post this on the mailing list, not send it to the original
poster.
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Sent: Wednesday, January 04, 2006 1:25 PM
Subject: Re: Calendar table workaround
- Origina
An old server died during the holidays.
I had a database with 2 tables on it on an old version of MySQL
(circa Redhat 7?)
I have the latest backup of the files but not a dump (kick himself)
I put the files in the correct /var/lib/mysql/gallery and restarted
MySQL. It shows the gallery databas
John Hoover wrote:
I need some advice re my choice of a storage engine for transaction-safe
processing and including tables that are not transaction-safe within
transactions.
The problem: We need to insert related records into several different tables
and be sure that all the insertions succ
The query fails instantly so I don't think it's a
timeout issue.
The wait_timeout and interactive_timeout variables are
set to 28800.
The server seems to be crashing and auto restarting
because as you suggested the uptime is small when I do
a show status right after attempting the query.
The sc
Hello All!
I have noticed that MySQL does not distribute a static linked binary of
MySQL x86_64. I ran into the pthread_rwlock_wrlock hang with nptl bug
on an earlier install of Fedora Core 2. The MySQL binary version I am
using now is mysql-pro-4.0.26-unknown-linux-gnu-x86_64-glibc23.tar.gz
wh
Hi,
Maybe your problem is linked to phpmyadmin?
I was having issues when trying to use an 'old' version (2.5.7) because the
interface itself of phpmyadmin was set up as iso-8859-1, and that was
causing all my data to be entered as isolatin even if the tables were
declared as utf8.
By updating t
On Tuesday, January 3, 2006 1711, [EMAIL PROTECTED] wrote:
>
>You are going to need to setup your own application-level
>locking scheme and rollback procedures if you don't want to use
>or cannot use the locking and transaction support built into
>InnoDb.
Well, I WANT to use InnoDB, but I guess t
I would suggest looking at the slow query log first and figure out
what queries were taking long when the crash occurs at heavy
concurrent usage, and then try to optimize those queries, it might a
world of difference, also since you have only 1GB ram , try decreasing
the sort_buffer_size, read_buff
I've also checked the error log and there isn't anything that indicates
where these aborted_client connections are coming from. I checked today and
I have 100 more of these.
-James
dave
I believe group is a reserved word. change to grp.
david
-Original Message-
From: Dave M G [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 04, 2006 8:55 AM
To: mysql@lists.mysql.com
Subject: Re: Exporting utf-8 data problems
Thank you for the advice.
In order
Thank you for the advice.
In order to isolate the problem, I have checked to see if the text file
that I have exported from the MySQL server on my virtual host is, in
fact, in UTF-8.
By opening it in OpenOffice and selecting UTF-8 encoding, it displays
correctly.
N
I created a calendar table (date only), but all
where clauses include a uid. Is the following a
sane workaround to get a usable calendar table?
Anything else I can do?
my $sth = $dbh->prepare("
create table $temp_tbl
(date date,
uid varchar(14))
select date,
? as uid
from calendar
where date betw
Hi there,
With the help of the people at CoreLab, we found out this problem:
> After long testing we detected source of the problem. It's
STRICT_TRANS_TABLES
> flag in sql-mode my.ini variable.
> This variable affects only CREATE TABLE and CREATE PROCEDURE statements.
>
> Even if you simplify scr
What are your wait_timeout and/or interactive_timeout values set to?
Does the server crash and auto restart? Check server's up time.
Do both servers have the exact table schema? Same column datatypes and
indexes to be specific.
Although your data volumn may be similar, can the actual data be
probla
Hi Alex
There are over a hundred tables for the site, and those that are
related to this query are probably about 15-30. Do you want the CREATE
TABLE syntax for all of them?
Funnily enough, the file /var/log/mysql_error.log doesn't exist ..
I'm using myISAM tables, yes.
On 04/01/06, Alex <[EMA
I'm inclined to think this is a database config issue in MailScanner.
Double check the Port setting that MailScanner is using and check that
against the port that your MySQL server binds to. It is normally 3306,
and they should match. If you don't know how to check, can you send me
the output of:
>I refer a question about "sql security" option of create procedure syntax
>at 2005-12. But i can't quite understood with that answer.
>Can you give me a example to describe the effect of set "sql security"
>option ?
CREATE PROCEDURE
...
SQL SECURITY INVOKER
...
SQL SECURITY (compliance with SQL2
the table type whether it is myisam or innodb. create table statements are
preferred when you have slow query issues.
--Alex
On Wed, 04 Jan 2006 15:57:06 +0530, Jonathan Chong <[EMAIL PROTECTED]>
wrote:
Sorry
I also forgot to ask - when you say the tables, did you want the table
structu
Hi,
Please provide the log extracts from /var/log/mysql_error.log in your
box when the crashes occurred and also you havent mentioned the table
types thats you are using. MyISAM tables are the deafult for your
configuration. This table type is not recommeded for highly concurrent
usag
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
> Any reason why this happens? Should I be worried?=20
You have an old MySQL version (4.1.8), upgrade to the latest release.
Jørn Dahl-Stamnes wrote:
> I have been using mysql client for some time when I got this er
Hello.
>However, when viewing the web pages where content is dynamically called
> from the database, all the Japanese text appears on my home machine as
>a series of question marks.
You should localize the problem. Check with the text editor that files,
which you have got from phpMyAdmin r
Hello.
In my opinion, a good description can be found here:
http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html
"wangxu" <[EMAIL PROTECTED]> wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET
Sorry
I also forgot to ask - when you say the tables, did you want the table
structure? There are quite a few tables, perhaps I should just send
the tables that are read and written to often when a user hits a page?
On 04/01/06, Alex <[EMAIL PROTECTED]> wrote:
> Hi,
>
>Please provide detail
Hi Alex
Thanks for this, and sorry for the late reply.
That was the entire my.cnf file in my last email. This is from SHOW
VARIABLES in mysql.
+-+--+
| Variable_name | Value
Jørn Dahl-Stamnes wrote:
> This is perhaps a bit off-topic, but...
>
> I tried to install and configurate phpAdmin on an
> internal web-server. I copied a default config file and
> created my own config.inc.php file. In this I set
>
> $cfg['Servers'][$i]['host'] =
> 'sql.dahl-stamnes.net
Dave,
what is the result of
prompt> set | grep LANG
? I suspect your problem is not within MySQL. Did you look at your
testfile using a editor?
Thomas Spahni
On Wed, 4 Jan 2006, Dave M G wrote:
> MySQL List,
>
> I have recently switched over from Windows to Ubuntu Linux, in order to
> e
This is perhaps a bit off-topic, but...
I tried to install and configurate phpAdmin on an internal web-server. I
copied a default config file and created my own config.inc.php file. In this
I set
$cfg['Servers'][$i]['host'] = 'sql.dahl-stamnes.net';
a 'host sql.dahl-stamnes.net' shows
Hi,
> Hello.
>
> This should be fixed in 5.0.18. See:
> http://bugs.mysql.com/bug.php?id=13909
17.2.1. CREATE PROCEDURE and CREATE FUNCTION
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
says ...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
As of MySQL 5.0.
54 matches
Mail list logo
