Comments - MariaDB support
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
we configured mariadb 11.4.2 to move tmpdir from folder "/tmp" to external mount data disk "/newdisk/tempfolder". mariadb reflected new path as well in show variables. This was done to execute alter table sql example. "ALTER TABLE jpdbname.test1 ROW_FORMAT=DEFAULT, CONVERT TO CHARACTER SET DEFAULT COLLATE DEFAULT;" which is 500gb data and should able to execute fast. however we found that mariadb used /tmp of jpdbname data disk instead of "/newdisk/tempfolder". also found that /tmp was utilising very low memory. This alter sql executed at a speed of 5% per hour, which is very slow. Kindly provide proper guidance. FYI, we have added 500gb external disk as well. 220gb RAM for main mysql disk. kindly reply.
I want to use the msi installer to install mariadb on a system as a service, quietly so its as Automatic as possible, creating the database from a supplied SQL file, create a user if possible and install as a service.
Can this be done using the command line options for the installer?
I am using mariadb 10.3. I have one table having 10 million records in it and it can be grow to 50 million records in upcomming 2 or 3 months.
On this table I have around 32 columns and have prssilbe search on around 22 columns. This table have contact related information and it will have dynamic filtering option like below.
select feilds from table where first_name='ABC' and group='Gold' and phone_number='xxxxxxxxxx' and (city="Surat" or (state="Panjab" and city='Hariyana')) and status in ("progressive","Not interested");
So sequece of fields can be changed base on client need.
Also this table have select and update operations. It is running this select query on every minute and update can be done based on need. So mostly update is done on every second or in part of second.
Please suggest me how to make indexing dynamically on this.
I do had already applied indexing on some fields but if sequnce of value is getting changed then it is taking much time to execute query.
Thanks in advance.
I suggest contacting MariaDB Corporation directly for support details: https://mariadb.com/about/contact
не работает HandlerSocket версия MariaDB 10.1.11-MariaDB-1wheezy-log
like the mariadb jira board is it for community purposes or enterprise purpose