* Reindl Harald [121031 17:22]:
>
>
> Am 01.11.2012 01:54, schrieb Tim Johnson:
> > * Reindl Harald [121031 08:12]:
> >> you MUST NOT use "localhost" if you want to connect to
> >> a different mysqld-port because "localhost" is unix-socket
> >>
> >> mysql -h 127.0.0.1 --port=3307 -u -p
> > I
Am 01.11.2012 01:54, schrieb Tim Johnson:
> * Reindl Harald [121031 08:12]:
>> you MUST NOT use "localhost" if you want to connect to
>> a different mysqld-port because "localhost" is unix-socket
>>
>> mysql -h 127.0.0.1 --port=3307 -u -p
> I get "access denied" when I do that.
> thanks
d
* Reindl Harald [121031 08:12]:
>
>
> Am 31.10.2012 16:34, schrieb Tim Johnson:
> > * Johan De Meersman [121031 07:10]:
> >
> >> Given the different location of the datafiles and assuming the
> >> actual drupal does work, I'm starting to suspect that whatever
> >> installer you used created
personally i use ONLY vmware-guests for any production
servers because HA/Failover and unified managmenent and
a really easy way to resize drives for /var/log, /vbar/cache, /tmp
and hwatever mountpoint holds data - all seperated from /boot and rootfs
so it is no problem to use a own DISk for /tmp
Oh, another issue...
If you have your disk partitioned, and the tmpdir is pointing to a "small"
partition, you could run out of room for that reason.
I sometimes find a tiny boot partition (not a terrible idea), plus partitions
for /tmp, /var /usr, and maybe others. (Or C:, D:, etc, if you are
Hey,
I'm looking to combine the benefits of the MySQL Thread Pool Plugin and
Percona-Server. All the benchmarks show that the Thread Pool Plugin handles
higher concurrency much better then just setting innodb_thread_concurrency.
Alas Percona server has many tweaks that improve performance.
Does a
Am 31.10.2012 19:47, schrieb walter harms:
> thx for your help. I have found the root cause that was not related to immodb.
> It was that tmpdir was pointing to the same space. This were no problem for a
> long
> time then something happended, the system was optimizing and was running out
> of
1. Secondary indexes (but not the PRIMARY KEY) requires additional disk space.
A secondary index implicitly includes copies the field(s) of the PRIMARY KEY;
this is how it can get to the actual data row. Finding a row via a secondary
key involves two BTree lookups -- one in the secondary inde
Am 31.10.2012 17:31, schrieb Rick James:
> The 2 (possibly more) iblog files are necessary for the inner workings of
> InnoDB. They do not change in size. They should not (normally) be removed
> or otherwise tampered with. No useable data is stored there -- that is, they
> cannot be used fo
The 2 (possibly more) iblog files are necessary for the inner workings of
InnoDB. They do not change in size. They should not (normally) be removed or
otherwise tampered with. No useable data is stored there -- that is, they
cannot be used for any form of disaster recovery.
Tunable things fo
Am 31.10.2012 16:34, schrieb Tim Johnson:
> * Johan De Meersman [121031 07:10]:
>
>> Given the different location of the datafiles and assuming the
>> actual drupal does work, I'm starting to suspect that whatever
>> installer you used created a second instance of mysql. Your drupal
>> config
* Johan De Meersman [121031 07:10]:
> Tim Johnson wrote:
>
> >* Ananda Kumar [121030 09:48]:
> >> why dont u create a softlink
> > From /opt/local/var/db/mysql5/ to /opt/local/var/db/mysql5/ ???
> >
> > I can try that, but I am doing things to MySQL that I have never
> > done before and I am re
* Johan De Meersman [121031 07:10]:
> Given the different location of the datafiles and assuming the
> actual drupal does work, I'm starting to suspect that whatever
> installer you used created a second instance of mysql. Your drupal
> configfile should hold the necessary data to connect to it
By default, the mysql users/privileges tables are MyISAM, not ndbcluster.
ndb_mgm backup won't backup anything other than ndbcluster tables. The
--restore-privilege-tables only works if you've converted those user and
privileges tables to ndbcluster.
>From the manual:
>http://dev.mysql.com/do
14 matches
Mail list logo
