Hi All,
I have 10 mysql databases all the tables use MyIsAm mysql storage
engine.
Database names are 1,2,3,4,...10.
When I use mysqldump command with --all-databases option. This gives me
following error:
mysqldump -u myuser -p --all-databases > AllNew_Databases_20100904.sql
ERROR MESSAGE
on the db server? meaning the mysqld log right? THere is really no data for
teh
current error. The last error they said was too much connections and shouldnt
that be logged in mysqld.log?
Thanks,
Mon
From: Ananda Kumar
To: monloi perez
Cc: mysql mailing l
Reklamix.Biz tanıtımınız için gerek duyduğunuz tüm ürünleri ve hizmeti 20
yıllık tecrübeyle birleştirip size sunuyor.
www.reklamix.biz
Ürünlerimizden Bazıları :
Matbaa Ürünleri: Broşür | Katalog | Dergi | İnsert | Afiş | El İlanı | Menü |
Kartvizit | Kitap | Kutu | Çanta | Etiket | Fatura
On 02/09/2010 8:30 p, Hank wrote:
>>
>> Simple question about views:
>>
>>
> Hank,
> Have you tried "running away from the problem :-)" by doing...
>
> CREATE PROCEDURE `combo`(theid INT)
> BEGIN
>(SELECT * FROM table1 WHERE id = theid)
>UNION
>(SELECT * FROM table2 WHERE id
It seems that when your index is PRIMARY on InnoDB tables, it's magic and is
part of the data thereby it is not included in the index_length field.
I have never noticed this. I don't think adding a new index will make a
difference.
You could try moving your log files to a different disk array tha
Hi,
When creating a table in MySQL with a PK it automatically creates an INDEX,
correct?
The Index_Length: 0 is rather strange..I've created a new INDEX on top of my
PK column on my test system and Index_Length shows a big value different
from 0. Do you think this might have any impact?
mysql> s
On 03/09/2010 16:32, Arthur Fuller wrote:
While I agree with the general take on this subject ("Never store totals
without a good reason" and "where there is duplication there is the
opportunity for skew"), I must say that there are exceptions. A couple of
years ago I worked on an inherited datab
I think your MySQL instance is disk bound.
If you look at your iostats, md2, 12 and 22 have a ~10ms wait time before a
request can be processed. iostat is also reporting those disks are 75%+
utilized which means they are doing about all they can do.
Anyway you can add more disks? Add faster disks
Hi,
The DB is working on /var, which is md2 / md12 / md22.
extended device statistics
device r/sw/s kr/s kw/s wait actv svc_t %w %b
md2 0.1 80.00.4 471.4 0.0 1.0 12.2 0 94
md10 0.05.70.0 78.8 0.0 0.1 19.7 0 9
md1
While I agree with the general take on this subject ("Never store totals
without a good reason" and "where there is duplication there is the
opportunity for skew"), I must say that there are exceptions. A couple of
years ago I worked on an inherited database in which the operant principle
was "sum
Very confusing...
Why is index_length zero ?
On top of that, there's only 500K rows in the table with a data size of
41MB. Maybe InnoDB is flushing to disk too often?
What's the output of iostat -dxk 60 ? (run for a minute+ to get 2 output
girds)
--
*Johnny With
Hi Machiel, all!
Machiel Richards wrote:
> Good day all
>
> I am looking for someone that can maybe help me with some info
> regarding the upgrading of MySQL.
>
> We have a MySQL database currently running with a master/slave
> replication setup.
>
> The current version of the dat
On 9/3/2010 6:23 AM, Jangita wrote:
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
...
(I've also tried "UNION ALL" with the same results).
...
Hi,
mysql> SHOW TABLE STATUS LIKE 'clientinfo';
+++-++++-+-+--+---++-+-++---+--++-
What does
SHOW TABLE STATUS LIKE 'table_name'
Say about this table?
-JW
On Fri, Sep 3, 2010 at 8:59 AM, Alexandre Vieira wrote:
> Hi,
>
> I've done some tests with INT(8) vs the VARCHAR(23) on the userid PK and it
> makes a little difference but not enough for the application to run in real
>
Hi,
I've done some tests with INT(8) vs the VARCHAR(23) on the userid PK and it
makes a little difference but not enough for the application to run in real
time processing.
It's a Sun Fire V240 2x 1.5ghz UltraSparc IIIi with 2GB of RAM.
MySQL is eating 179MB of RAM and 5,4% of CPU.
PID USERNA
Ok, so I'm stumped?
What kind of hardware is behind this thing?
-JW
On Fri, Sep 3, 2010 at 4:44 AM, Alexandre Vieira wrote:
> Hi Johnny,
>
> mysql> EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';
>
> ++-++---+---+-+-+--
On 03/09/2010 12:23 p, Machiel Richards wrote:
Good day all
I am looking for someone that can maybe help me with some info
regarding the upgrading of MySQL.
We have a MySQL database currently running with a master/slave
replication setup.
The current version of the database is
On 02/09/2010 6:01 p, karthik kumar wrote:
Wow .. Cool that solved our problem...
Thanks a lott ..
No problem, it took me two weeks to figure out why it takes sooo long to
log in; :-) enjoy!
--
Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com
Skype: jangita | GTalk: jangita.nyag...@gm
If you planing to migrate to a new hardware, then install the new version of
mysql and take dump of the current data and imported into ur new m/c and
test your app. If you all looks fine, then ur done.
regards
anandkl
On Fri, Sep 3, 2010 at 3:53 PM, Machiel Richards wrote:
> Good day all
>
>
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
Where table1 and table2 are very large and identical and have a
non-unique key on field "id"..
wh
Good day all
I am looking for someone that can maybe help me with some info
regarding the upgrading of MySQL.
We have a MySQL database currently running with a master/slave
replication setup.
The current version of the database is as follows:
mysql> select version()
On 01/09/2010 10:29 p, Tompkins Neil wrote:
Hi,
I'm developing a system whereby a manager gets assigned points based a
certain number of factors which are saved alongside a football result.
However, I also want to keep a total for each manager. My question is it
best to just have a query that
On 02/09/2010 6:05 p, Alexandre Vieira wrote:
Hi Jangita,
I'm 15779 innodb_buffer_pool_pages_free from a total of 22400. That's
246MB of 350MB free.
| Innodb_buffer_pool_pages_data | 6020 |
| Innodb_buffer_pool_pages_dirty| 1837 |
| Innodb_buffer_pool_pages_flushed | 673837
Hi Johnny,
mysql> EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';
++-++---+---+-+-+---+--+---+
| id | select_type | table | type | possible_keys | key | key_len
| ref | rows | Extra |
++-
No, don't worry. Default values are only applied when you create a new
object without specifying a value for that setting.
All your MyISAM tables will keep working fine - although finding a good
tuning balance between the two engines might be some work - but every new
table you create, also in the
Hi,
I have one doubt; Please can any one give your view?
I have MYSQL version 5.1.x.
I have some existing Databases in which the tables are created using MYISSAM
storage engine.
Now i have another database which will use INNODB engine.
My question is, If i set default engine as INNODB Whe
27 matches
Mail list logo
